Crazy Data Science

I am pretty hyped to be able to finally announce a new project of mine that I have been working on for...

T-SQL Tuesday #100: What’s New With Scalability Groups in SQL Server 2026

Welcome to T-SQL Tuesday #100. In a community filled with ADD people like the SQL community (myself included), who would...

T-SQL Tuesday #100: Looking Forward

The future, 100 months from now: It’s Monday, 6 July 2026. It’s been quite a week since SQL Server Update...

Revisiting catch-all queries

I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code. It turned into the 3rd most popular post ever...

Revisiting catch-all queries

I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code....

Looking Forward for T-SQL Tuesday #100

It’s T-SQL Tuesday #100. Amazing. I can’t believe this has been going for so many years. I’m proud that I...

SQL Server 2026: BAGI Edition (#TSQL2SDAY 100!)

It’s T-SQL Tuesday’s 8 year birthday (or close enough), and Adam Machanic has challenged us with the question: what will the world be like when T-SQLTuesday turns 16? Not...

Getting Started With R In SQL Server 2017

Prior to SQL Server 2016, running R on Microsoft platform required an installation of the R Language and its environment...

Allowing Azure Service to Connect to your Azure SQL server.

Allowing Azure Service to Connect to your Azure SQL server.

In this video David will look at the impact of allowing...

A look back from the future. – TSQL Tuesday #100

The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact...