@LearningTree: 2108 SQL Server 2012 Database Administration

This past week my international adventures have continued. As some of you know, for the past couple of years, I...

Command Line Prompts for Checking Active Directory Membership

Using Active Directory groups are a great way to manage and maintain security for a solution.  Think about if you...

T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore

T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore

This blog entry is participating in T-SQL Tuesday #31, hosted this month...

SQL Server 2005 Diagnostic Information Queries (June 2012)

Here is the latest version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements, including...

T-SQL Tuesday #31 – Logging

This month’s T-SQL Tuesday is hosted by Aaron Nelson (@SQLvariant | Blog). The topic is about logging. Many will talk about...

Using PowerPivot to Monitor Reporting Services

PowerPivot is a powerful new tool from Microsoft that has been improved even more in the 2012 release, which you...

T-SQL Tuesday #31 – Logging

It’s T-SQL Tuesday time again, and this month Aaron Nelson (blog | @sqlvariant) is hosting. The topic is logging, and if...

T-SQL Tuesday 31: SSIS 2012 Logging

Topic for this month’s T-SQL Tuesday, hosted by Aaron Nelson (@SQLVariant) is Logging.
I like to think of logging as a...

SQL Saturday Pensacola presentation file downloads

I had a great weekend at my fourth annual visit to Pensacola for SQL Saturday, which had many great sponsors,...

SQL Server : Moving System, resource and User Databases to New SAN disk

In my earlier post I have explained the steps that we have followed to move the MSDTC and Quorum drive...