This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your SQL Server 2008R2 instances. Congratulations! But are you taking advantage of everything that your new instances have to offer? Unless you did a review of all of…

Read More Modernizing Your T-SQL: The Sequence Object

This month, Jess Pomfret (blog | twitter) is trying to beat the winter motivation slump by exploring, and asking us to share, our lifehacks that make daily life a little easier. So here we are, the first Tuesday of February. I personally always find February to be the month where my motivation is a little…

Read More T-SQL Tuesday #123: Lifehacks to Make Your Day Easier

This is the first of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your SQL Server 2008R2 instances. Congratulations! But are you taking advantage of everything that your new instances have to offer? Unless you did a review of all…

Read More Modernizing Your T-SQL: Splitting Strings