Windowing using OFFSET-FETCH

Last week for T-SQL Tuesday #65 the topic was learn something new and then blog about it. I looked at some of the new features in SQL Server 2012 and decided to learn about the new replacements for the FMT_ONLY… Continue Reading


T-SQL Tuesday #65: FMT_ONLY Replacements

So, it’s the second Tuesday of the month and you know what that means! That’s right; T-SQL Tuesday #65 is upon us. This month’s topic is “Teach Something New” and is brought to us by Mike Donnelly (B|T). This T-SQL… Continue Reading


Query Tuning Using A CTE

I’ve been doing a lot of research around Common Table Expressions, or CTEs, for a presentation that I will be giving to my developers. Joe Sack points out in one of his PluralSight courses that CTEs do not inherently increase… Continue Reading


SQL Saturday #331 Weekend Review

This past weekend was SQL Saturday #331 Denver. I always enjoy SQL Saturdays, but I was especially looking forward to this weekend because I was going to attend a SQL Saturday Pre-Con for the first time! The pre-con was fantastic! The Denver SQL… Continue Reading


An attendee’s view on the PASS Summit submission process.

I have debated with myself for the past several days as to whether or not I was going to write this, and I decided I might as well weigh in on the subject. The subject in question is the PASS… Continue Reading