SSIS Pivot on bad data

The pivot transform in SSIS is already a pain to use. When you have bad data it makes it even...

Change in SQL 2012 SSMS grid output behavior

It’s one of those things that always aggravated me but not really enough to complain about. When you run a...

SQL PASS Summit 2013 – Simply Amazing

This past week I attended my third SQL PASS Summit in Charlotte, North Carolina. All I can say is – WOW....

Review: SQL Server Transaction Log Management

Book Details:
SQL Server Transaction Log Management 
Davis, Tony and Shaw, Gail 
Simple Talk Publishing, October 2012.
Free PDF download

Do I Recommend This Book?
Yes,...

My PASS Summit 2013 Presentations

I had the honor to speak for the first time at this past PASS Summit 2013 in Charlotte, NC. It...

IT Pro Camp Tampa 2013

This year I was honored to sponsor and speak at IT Pro Camp Tampa 2013. Like always, it is a...

Reblog: October 18 to October 24

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

Understanding the PIVOT function

The PIVOT function is very useful but not easily understood at first. I thank Itzik Ben-Gan, Dejan Sarka and Ron...

SQL Server Inetrview FAQ 3

1.       How to find the maximum no of connection allowed in SQL Server?
 Select@@MAX_Connections
2.       How to select top 2 rows without...

SQL Query Formatting – Putting Lipstick On A Pig

“Psssst….”
“Hey buddy! Yeah, you there in the propeller hat. You’re a SQL nerd, right? Can you help me tune this...