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...

T-SQL Tuesday #100!

The monthly blog party is back and we’ve reached the mythical number 100. The host of this month is the...

Using Stored Procedures in SQL Server For Better Performance

Intoduction to Stored Procedures in SQL Server
SQL Server uses Different types of stored procedures. They are the quickest method of accessing and manipulating database on the server. SPs are...

Using Stored Procedures in SQL Server For Better Performance

Intoduction to Stored Procedures in SQL Server
SQL Server uses Different types of stored procedures. They are the quickest method of...

Crystal Balls

In the centenary edition of the monthly blogging party that is T-SQL Tuesday, Adam Machanic asks us to look forward...