SQL Server Tips & Blog
SQL Server Tips & Insights
Practical guides, tips, and best practices for SQL Server developers and DBAs.
Deployment
How to Catch Missed Deployments Before They Hit Production
The most common cause of "it works in test but not production" is a schema change that never got deployed. Here's a repeatable process to catch it every time.
Read Article →SQL Tips
How to Compare Two Tables in SQL Server Using T-SQL
Sample T-SQL statements to find differences between two tables — rows that exist in one but not the other, and rows where data has changed.
Read Article →Azure
Comparing On-Premise SQL Server with Azure SQL: What You Need to Know
As teams migrate to Azure, keeping hybrid environments in sync becomes a real challenge. Here's how to approach it without manual headaches.
Read Article →