PASS Election Results Posted

Congratulations to Wendy Pastrick, James Rowland-Jones, and Sri Sridharan on winning a two year term on the PASS Board of...

SQL Server Database Backup Report using T-SQL

Today, I am going to share few very useful scripts which will report us on Database Backup from different view...

Windows Server 2008 Cluster: Understanding the Cluster Log Behavior

In any system, logs are very important to troubleshoot the issue. In the case of windows cluster, cluster logs are...

PASS 2012 Countdown – 3 Weeks To Go

Another week down and there are now 3-weeks until this year’s PASS Summit.  Take a moment and register now if...

Indexing Book Winner

Back on October 3, I put up a post about a free indexing book.  And specifically about Expert Performance Indexing for...

Lost in Translation – Deprecated System Tables – sysfulltextcatalogs

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...

SQL In The City: Seattle

If you missed all the great speakers on the five city tour of SQL in the City, don’t despair. Many...

Inserted and Deleted are One Table?

Inserted and deleted tables are 2 pseudo tables preseting the before and after images of modified rows. They can only...

Querying database usage

A question that a DBA will often be asked is what databases are actively being used on my SQL Server?...

Another Stop-Gap Solution for the SQL Server 2012 Identity Crisis

                I haven’t seen this many fake ID’s since I was in college.

                Back on April 26, Grant Fritchey (of execution...