perfcollect

This is one of my most closely held DBA secrets.
Do you use PAL? You should.
Clint Huffman is a golden god...

Your online security is only as good as the weakest link

Over the weekend I received an email supposedly from Microsoft Live wanting me to verify my account and provided a...

More Thoughts on the Mac Air

I’ve been living with my Mac Air for a few weeks now, thought I’d share some quick thoughts:
I miss the...

PASS Summit 2012 Countdown Begins !!!

All roads lead to Seattle!

If you are a SQLServer professional, then you don’t want to miss this event.
Over 190 technical...

Decoding first, root, and FirstIAM in Sysindexes

Have you ever looked at the first, root, and FirstIAM columns in sysindexes and wondered…
“What do these values mean?”
Recently, I...

Master Data Services (MDS): Miscellaneous tips

I have come across a number of tips while using MDS.  These are tips not big enough for their own...

SSIS Tips & Tricks

For your convenience, below is a download link to get the presentation and relevant materials for the SSIS Tips & Tricks...

2,560

Two Thousand Five Hundred Sixty. Seems like such a random and unassuming number, however, I can say this was the...

PASS DBA Virtual Chapter Trimming Indexes, Getting Your Database in Shape

Hello Dear Reader!  Tomorrow at 12 noon eastern I’ll be presenting for the PASS DBA Virtual chapter, click here to...

I can connect to my instance locally but not remotely

Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down. ...