Free SQL Server Learning - Get a six month training plan for the Accidental DBA

solving sql server problems for millions of dbas and developers since 2006

Top SQL Server Tools

SQL safe backup

SQL compliance manager

SQL Server performance monitoring that makes prioritizing simple

Data Quality Components for SQL Server

SQL Developer Bundle

Edwin Sarmiento

Edwin Sarmiento works as a SQL Server DBA for The Pythian Group in Ottawa, ON in Canada. Prior to joining Pythian, he was a senior systems engineer/DBA for Fujitsu Asia Pte Ltd in Singapore and is responsible for maintaining 200+ servers and databases for a global client in 10 countries. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases. He lives up to his primary mission statement - "To help people grow and develop their full potential as God has planned for them". He wants the whole world to know that the FILIPINO is a world-class citizen and brings JESUS CHRIST to the world.

AlwaysOn Availability

Auditing and Compliance

SQL Server 2008 TSQL Auditing Commands for SELECT statements (12/30/2008)

Backup

Check for full SQL Server database backups before creating other backups (11/10/2009)
SQL Server backup and restore of the Resource database (7/21/2008)

Clustering

Configuring Volume Mountpoints on a SQL Server 2008 Failover Cluster running on Windows Server 2008 (2/14/2012)
Fix SQL Server Agent on Windows Failover Cluster (1/19/2012)
Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1 (2/13/2009)
Install SQL Server 2008 on a Windows Server 2008 Cluster Part 2 (3/2/2009)
Install SQL Server 2008 on a Windows Server 2008 Cluster Part 3 (3/17/2009)
Install SQL Server 2008 on a Windows Server 2008 Cluster Part 4 (4/2/2009)
Installing SQL Server 2012 on Multi-Subnet Cluster Part 2 (7/26/2012)
SQL Server 2012 Multi-Subnet Cluster (7/11/2012)
SQL Server 2012 Multi-Subnet Cluster Part 3 (8/13/2012)
SQL Server 2012 Multi-Subnet Cluster Part 4 (9/6/2012)

Compression

Exploring Database Backup Compression in SQL Server 2008 (6/5/2008)
Implementing Data Compression in SQL Server 2008 (9/12/2008)

Database Administration

Configuring Windows Instant File Initialization for SQL Server 2005 (8/28/2008)

Database Consistency Checks DBCCs

Check DBCC CHECKDB Last Execution using PowerShell (5/2/2013)

Database Mail

An alternative to SQL Server email alerts (11/12/2008)

Database Mirroring

Disaster Recovery

Disaster Recovery Procedures in SQL Server 2005 (10/1/2008)
Isolating Critical Objects for SQL Server Disaster Recovery Procedures (10/27/2008)
SQL Server Partitioned Tables with Multiple Filegroups for High Availability (11/6/2008)
Using Page Level Restore as a Disaster Recovery Procedure in SQL Server 2005 (12/12/2008)

Encryption

Implementing Transparent Data Encryption in SQL Server 2008 (5/28/2008)

Express Edition

Automate SQL Server Express Backups and Deletion of Older Backup Files (4/28/2008)

Language Integrated Query LINQ

Creating LINQ to SQL Object Models using SqlMetal (8/27/2009)
Introduction to Language Integrated Query (LINQ) (5/20/2008)
Querying SQL Server databases using LINQ to SQL (7/7/2008)
Reading XML documents using LINQ to XML (6/24/2008)
Using Stored Procedures with LINQ to SQL (7/17/2008)

Log Shipping

Automate Restoration of Log Shipping Databases for Failover in SQL Server (6/10/2008)

Microsoft Excel Integration

Introduction to PowerPivot for Excel and SQL Server (6/27/2011)

Policy Based Management

Evaluate and Implement Policies in Multiple SQL Server Instances (5/7/2008)

PowerShell

Backup SQL Server Databases with a Windows PowerShell Script (10/20/2009)
Check SQL Server Virtual Log Files Using PowerShell (10/9/2012)
Check the Last SQL Server Backup Date using Windows PowerShell (7/1/2009)
Checking SQL Server Agent jobs using Windows PowerShell (7/21/2009)
Connect to SQL Server via Windows PowerShell with SQL Server authentication (2/22/2010)
Disable or Enable SQL Server Agent Jobs using PowerShell (10/17/2012)
Find SQL Server Instances Across Your Network Using Windows PowerShell (5/20/2010)
Generating SQL Scripts using Windows PowerShell (9/22/2009)
Introduction to Windows PowerShell for the SQL Server DBA Part 1 (2/4/2009)
Introduction to Windows PowerShell for the SQL Server DBA Part 2 (3/9/2009)
Retrieve a List of SQL Server Databases and their Properties using PowerShell (5/26/2009)
Retrieve Default SQL Server Backup Folder using PowerShell (4/15/2010)
Using PowerShell with SQL Server Management Objects (SMO) (5/6/2009)

Reporting Services Installation

Install SQL Server Reporting Services 32 bit on a 64 bit Windows Server (11/13/2009)

Reporting Services Network Load Balancing

Build a Scale Out SQL 2008 R2 Reporting Services Farm using Windows NLB Part 3 (11/1/2011)
Building a Scale Out SSRS 2008 R2 Farm using Windows NLB Part 4 (11/8/2011)
Scale Out SQL Server 2008 R2 Reporting Services Farm using NLB Part 1 (3/24/2011)
Scale Out SSRS R2 Farm using Windows Network Load Balancing Part 2 (3/28/2011)

Reporting Services Performance

Highly Available, Scale-Out SQL Server 2008 R2 Reporting Services Farm (11/15/2011)

Scripts

Recursive Queries using Common Table Expressions (CTE) in SQL Server (6/16/2008)

Security

Extend the REVERT statement using the WITH COOKIE clause in SQL Server (1/6/2009)

Sharepoint

Rename SharePoint Content Database (5/14/2013)
Renaming the SharePoint Admin Content Database to Follow SQL Server Naming Conventions (6/14/2012)

SQL Server Configurations

Installing SQL Server 2012 on Windows Server Core Part 1 (3/27/2012)
Installing SQL Server 2012 on Windows Server Core Part 3 (6/28/2012)
Installing SQL Server 2012 on Windows Server Core Using PowerShell (5/24/2012)

Stored Procedures

Switching Stored Procedure Execution Context in SQL Server using the REVERT clause (9/9/2008)

Surface Area Configuration Manager

Using the SQL Server Surface Area Configuration Command Line Tool (1/29/2009)

Triggers

Using the EventData() Function with DDL triggers in SQL Server 2005 (8/27/2008)

Upgrades and Migrations

Slipstream Service Packs and Cumulative Updates on a SQL Server 2008 Installation (12/16/2009)

Windows Internal Database

Administering your Windows Internal Database MICROSOFT##SSEE instance (9/5/2008)

Sponsor Information

Find and fix SQL Server problems before they happen - SQL diagnostic manager now with predictive analysis!

NEW! Top 5 hard-earned lessons of a DBA from Grant Fritchey & the DBA Team. Read it now

What grade do you think your SQL Servers get? Find out with a SQL Server Health Check consultant in the USA.

The COMPLETE Performance Solution for SQL Server - SQL Sentry

Optimizing SQL Server performance can be a daunting task. Or is it?

Copyright (c) 2006-2013 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | user groups
Some names and products listed are the registered trademarks of their respective owners.

Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com