Discovering Binary Pages In Sys.Indexes

In a previous post, we looked at how to take the the binary page values in sysindexes and convert the...

WIT Wednesday

On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...

SQLTreeo now supports SQL Server 2012

New version of SQLTreeo SSMS Add-In was released. We fixed few bugs and include also one major change – SQL Server...

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