T-SQL Tuesday #69: Round Up

This month’s T-SQL Tuesday topic was about Encryption and since August tends to be a busy month, at least for me, I was not all that shocked when the participation was a little light. Never fear, the participation may have been… Continue Reading


T-SQL Tuesday #69: Encryption

It’s the first Tuesday of the month, and you know what that means! It’s time to reveal the topic for this month’s edition of T-SQL Tuesday. If you’re new to T-SQL Tuesday, this is a blogging event started by Adam… Continue Reading


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