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

Updated Thoughts on Antivirus on SQL Servers

I hate running antivirus on SQL Servers. I agree antivirus is a necessary evil on most systems, but I don't...

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