On how to Googlify your SQL statements for future searching

For sake of future generations, let’s begin to reduce typing and reuse code we’ve built. I think we can all...

PASS Summit 2013 is Looking Cloudy

No, this isn’t some complaint about PASS or the Summit. This is an announcement that not only will I be...

Presenting 2 sessions at SQLPASS

I’m truly honored to be chosen to speak at PASS Summit 2013. The honor is compounded as I have been...

Security Questions: Grant Permissions to All Stored Procedures

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...

Speaking at PASS Summit 2013

I’m happy to announce that I have been selected to present

at the SQL PASS Summit in Charlotte, North Carolina this...

Speaking at PASS Summit 2013!

I’m happy to officially announce that I’ll be presenting at this year’s PASS Summit in Charlotte, NC! I’ll be presenting...

Speaking at PASS Summit 2013!

I am honored to say that have been selected to present this year.  I'll be giving a talk on my...

Speaking At the PASS Summit!

I’m Speaking at The PASS Summit 2013!
Hello Dear Reader!  Big news.  I’ve been selected as a speaker for the SQL...

SQL Server index related dynamic management views and functions (Part 3)

With the release of SQL Server 2005 and later releases, Microsoft introduced set of new dynamic management view and function...

SQL Server Transactions and Locking (Part 1)

In many situations, data modification requires several steps. For example, you may need to change the values ??in two separate...