Revisiting an Azure Managed Instance
![Azure Managed Instance](https://i0.wp.com/sqlsavior.com/wp-content/uploads/2023/07/Benefits-of-SQL-Stored-Procedures-768-×-402-px-9.png?fit=768%2C402&ssl=1)
If you’re considering moving to Azure from an on-prem SQL Server and need a complete SQL PasS offering, a Managed ...
Read more
Planting a Debug Flag in T-SQL
![Debug Flag](https://i0.wp.com/sqlsavior.com/wp-content/uploads/2022/08/Benefits-of-SQL-Stored-Procedures-768-×-402-px-8.png?fit=768%2C402&ssl=1)
Are you looking for a way to debug stored procedures in SQL Server? Keep reading for a technique that’s worked ...
Read more
Required SQL Indexes
![Required SQL Indexes](https://i0.wp.com/sqlsavior.com/wp-content/uploads/2022/05/Benefits-of-SQL-Stored-Procedures-768-×-402-px-6.png?fit=768%2C402&ssl=1)
If you talk to any data professionals about query performance, they’ll bring up indexes in the first few minutes. For ...
Read more
Delete Duplicate Rows in T-SQL
![Delete Duplicate Rows](https://i0.wp.com/sqlsavior.com/wp-content/uploads/2022/05/Benefits-of-SQL-Stored-Procedures-6.png?fit=1200%2C628&ssl=1)
We don’t live in a perfect world, which means duplicate rows occasionally show up. Sometimes you just need to delete ...
Read more
Storing Big Ugly Tables
![Storing Big Ugly Tables](https://i0.wp.com/sqlsavior.com/wp-content/uploads/2022/02/generate-random-dates-in-T-SQL-2.png?fit=1280%2C720&ssl=1)
Have you ever had a big ugly table? A table with millions or even billions of rows. Perhaps you wanted ...
Read more
Did You Google That?
![Did you google that?](https://i0.wp.com/sqlsavior.com/wp-content/uploads/2022/01/generate-random-dates-in-T-SQL-1.png?fit=1280%2C720&ssl=1)
One of my first jobs out of college was working in tech support. Comparable to retail, but customers were often ...
Read more