All Things Awesome and MidnightDBA-y – 12/2/2010

I’ve got to figure out a good way to present a regular summary of what we do every week. Until...

Presenting to the PASS Database Administration Virtual Chapter

I will be giving a presentation and demo to the PASS Database Administration Virtual Chapter on Wednesday, December 8 2010...

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