Creating a Sequence in SQL Server 2012

Sequences are a new object in SQL Server 2012 that generate just what the name implies: a sequence of numbers....

How to Configure Database mail

In my daily job as a SQL Server consultant I go to a lot of places, many days on the...

Thank God I Chose SQL Server part II: How to Improperly Install Oracle 11gR2

As part of my ongoing effort to teach by bad example and pass on what little I’ve learned about programming...

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