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

Listing server and database roles for all logins and users in SQL Server – Part 3 – Using SSRS Reports to Monitor and Fix security problems

Finally the epic conclusion to my three part series about listing server and database roles. In this post I will...