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

Microsoft releases SQL Server 2014 CTP2

Microsoft has released SQL Server 2014 CTP2 (download):
What’s new in SQL Server 2014 CTP2?
New Mission Critical Capabilities and Enhancements
Enhanced In-Memory...

Architecture Reasons for Putting BLOBs in the Database

I was participating in a Twitter Chat looking at what suggestions and recommendations for developer on how to make the...

MDX #32 – Vincent Rainardi’s blog

I came across Vincent Rainardi’s blog, and thought I’d share it with the readers.
Sherry Li and Tomislav’s 2012 MDX Cook...

SQL #52 – set statistics xml on

When tuning SQL queries, I find that I use the following three SET options quite often. 

set showplan_xml on
When showplan_xml...