Quick Tips–SQL Prompt Aliases for Every Table

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...

SQL PASS Performance Palooza 2014 Wrap-Up

Today I presented a fun session for the SQL PASSPerformance Virtual Chapter’s “Summer Performance Palooza 2014” entitled “Infrastructure Tuning for...

T-SQL Window Functions – Part 4: Analytic Functions

This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...

5 Tips for Finding SQL Server System Data

Regardless of the type of development (application or reporting) that you are performing on SQL Server.  There are 5 items...

Building the SQLSaturday Orlando Marketing Plan-Part 25

Just the chart today. We’re considerably ahead of previous year registrations for the same number of weeks out. I’m looking...

Challenge Accepted

There seemed to be some question whether my comfort level with my own masculinity would prevent me from wearing these:

Oh...

Cumulative Update – 11 for SQL Server 2012 Service Pack 1 Is Now Available !

The 11th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 11 contains all the hotfixes...

Cumulative Update – 11 for SQL Server 2012 Service Pack 1 Is Now Available !

The 11th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...

My Visit to Redmond

Last week, I had the pleasure of attending the EBC in Redmond. If you don’t know what EBC is, that’s...

SQL Server 2012 with SP2 Slipstream ISO images fixed

Microsoft fixed SQL Server 2012 with SP2 Slipstream ISO images do not install SP2 issue. The new ISOs have been posted on their respective release channels (MSDN…) and are...