SQL Spackle

I previously mentioned how SQL Server Central was listing ideas for articles, primarily for short, quick, pointed articles that they...

Clustered index vs Non clustered index

AdvertisementsClustered index vs Non clustered index structure
Clustered and Non clustered indexes are stored in a B – tree structure .
Clustered...

Worn Out and Maybe Burned Out

Ever feel worn out and/or burned out?  Don’t worry you aren’t alone.  As a matter of fact most people have...

The Next 24 Hours of PASS

Calling for Presenters!PASS has announced the next 24 Hours of PASS and it will be on March 15 and 16. ...

Salary Averages

I saw this posted on Twitter, yet another reason to have a variety of people you follow. Some very interesting...

December Question: What does it mean to be a Proactive DBA?

One of the things I promote in all my presentations is the importance of being a proactive DBA. Unfortunately, the...

SQL Craft Fair

Have you ever been “dragged” to a long weekend afternoon at a craft fair? Did it look something like this?

This...

Processing a Measure Groups Index Using SSMS

As I had mentioned in a previous blog (Creating and processing an Analysis Services partition), instead of processing an entire...

iPad Update

I updated the iPad tonight to iOS 4.2. I had no particular reason to upgrade, but I saw a few...

LiveWriter 2011

I recently upgraded to LiveWriter 2011 while upgrading to the final version of LiveMesh. After the upgrade I noted the...