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...

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,...

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...

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...

You need to run DBCC CheckDB regularly

You never know when you’ll encounter corruption. It can happen at any time, usually due to some sort of hardware...

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...

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...

Blogging Tools: BlogDesk Review

As a blogger, you have several options available to you when it comes to writing posts.  You can write them...

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...

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...