Planting a Debug Flag in T-SQL
Are you looking for a way to debug stored procedures in SQL Server? Keep reading for a technique that’s worked for me and countless others.
SQL
Required SQL Indexes
If you talk to any data professionals about query performance, they’ll bring up indexes in the first few minutes. For good reasons, Indexes are critical … Read more
Generate Random Dates In T-SQL
Have you ever needed to create a random date in SQL over a group of rows? Whenever I build a dataset for demos or testing, … Read more
SQL Server Learning Resources
Do you feel overwhelmed by the volume of SQL Server resources? Where do you start? In this article, I offer a few of my favorite … Read more
Benefits of SQL Stored Procedures – Maintainability
Are you trying to convince developers to use Stored Procedures rather than inline SQL or an ORM, say Entity Framework? It may seem futile, but … Read more
Pausing Dedicated SQL Pools with Synapse Pipelines
Do you forget to pause Azure resources? If you answered yes, you’re not alone. Implementing the process below will save time and money. A Microsoft article on … Read more