Here are some videos, tips, and interesting links we have viewed at Procure SQL.

Comparing NULLS

Struggling to compare many columns that contain null values? Here is a great way to do so before SQL 2022; here is a newer way with SQL Server 2022.

Azure SQL Database Limiting Resources

Like life with Azure SQL Databases, you get what you pay for. Here is an overview of why the Azure SQL Database team has resource governance around providing a balanced service. Are you being throttled down due to your tier of Azure SQL Database?

Optimized Locking with Azure SQL Database

Aaron Bertrand writes about long-running transactions leading to fewer lock escalations with optimized locking enabled with Azure SQL Database.

Tesla’s caught out in the cold.

Who knew you needed a high-availability plan for using your car? Not all batteries like subzero temperatures.

Christmas Tree Closet

Is Daniel McCutchen the only one to slide his Christmas tree in and out of his closet?

Finding Changes with Cumulative Updates

John describes why cumulative updates are needed. You can also see why he predicts that external data governance sources will come to SQL Server 2022 soon!

Free Azure and SQL Server Training in Austin, Texas!

On Saturday, March 9, 2024, SQL Saturday will be coming to Austin, Texas. This is a free day of training around SQL Server, Azure, and the Microsoft Data Platform. If you would like lunch to be provided, it’s $20. We will also have two all-day deep dive training classes on performance tuning and Microsoft Analytics on Friday, March 8, 2024, for $125.

Need a Data Architect?

Have you got questions? Need some help? Are you curious to know the cost of procuring a Remote Data Architect?