September Performance Contest

This month SafePeak is sponsoring a contest centered around improving performance in SQL Server. The host of the contest is my friend Robert Pearl.  You can read the announcement...

SQL Server Wait Types in SQL 2008

While working on an assignment of troubleshooting performance issue few month back I have come across a situation where I...

SQL University: SQL Server Editions for Small Businesses

In our last session we talked a little bit about the different options you have in regards to SQL Server...

SSIS Variables and Expressions Webinar Recording

Thank you to everyone who attended my free webinar hosted by Pragmatic Works yesterday (September 20, 2011) on SSIS Variables...

The Ten Thousand Year Clock

Ran across this in my reading about the Ten Thousand Year Clock, a project funded by Jeff Bezos. Awesome dream....

What Should I Carry in My Laptop Bag

I have a tendency to carry more than I need, the equivalent of the Batman Utility Belt. I just went...

What Will Be The Shared Experience at Summit 2011?

Last year it was the Tina Turner impersonator. Was it last year or the year before where the servers spun...

Who says you cannot mix business with pleasure?

There is an advice out there that says never to mix business with pleasure. It is not true in all...

24 Hours of PASS: Answer questions…

I will try my best to answer some of the questions after the Standard Operating Procedure webcast for 24 Hours...

Analytic Functions – CUME_DIST / PERCENT_RANK

This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.

Analytic Functions in SQL...