Changing DB_CHAIN Can Clear the Plan Cache

If you make changes to the settings of a database, it can cause the procedure cache to be cleared. Microsoft...

Generate restore script automatically by backup history table

I wrote a store procedure which could generate restore script automatically by backup history table. it can help you select...

Less Energy through Better Design

When I attended SQL Saturday #131 at the Chandler Gilbert Community College, I was struck by a few design elements...

Locked out of SQL Server.

This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql...

SQL Saturday #131 Recap

This past weekend I attended a SQL Saturday in the desert. SQL Saturday #131 was held in Phoenix, AZ

It’s April,...

SQL Server – Four-part object names

Generally it is considered good practice using two-part names for objects. It make the code more readable and avoids confusion...

SQL Server 2008 Diagnostic Information Queries (May 2012)

Since tomorrow is May 1, I think it is time to publish the latest set of SQL Server 2008 Diagnostic...

SQL Server 2012: Biggest Little Core-house

You sure do got a 'purty motherboard...
Now that SQL Server 2012 is generally available to the public, many companies are...

SSAS File System Error

I received this error the other day when trying to process a particular SSAS cube:
Error      18           File system error: The...

There is awesomeness to be had at #SQLRally

Two days of precons.
60 regular sessions over two days.

The now-famous Women in Technology luncheon.

Open access to Microsoft Customer Service and...