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 am honored to say that have been selected to present this year.  I'll be giving a talk on my...

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

SSAS Event Type Calculation Dimension

Calculation dimensions in SSAS are used to store calculations that can be applied to any measure in the cube.  For...

SSIS 2012 Deployment Fail

(Update: Part 2 focuses on clearing out the SSISDB by creating new stored proc based on the one used by the maintenance job. If your Maintenance Job is taking...

The Bicentennial SQLSaturday–#200 Philadelphia

When Andy Warren (b | t | Li)started SQL Saturday with #1 in Orlando, we weren’t sure it would succeed. After a...