Good software design principles apply inside the database too. See how decomposition, encapsulation, statelessness, and clear contracts can ma...
Schema changes are inevitable, but downtime doesn’t have to be. Learn a phased approach to safely evolve a production SQL schema while applica...
When you need to move an entire database or move the objects in a database, bacpac and dacpac files often come up because of all of the toolin...
Microsoft.Data.SqlClient includes configurable retry logic for SqlConnection and SqlCommand, giving .NET applications built-in resilience for ...
Bob Ward and I recently released a series of videos, read more in the original blog post or go directly to the series on YouTube. The Azure SQ...
If you’ve been building local prototypes, internal tools, web backends, or lightweight services on SQL Server Express, you know the routine: i...
Writing and maintaining SQL is easier when you can eliminate repetitive steps and keep your scripts cleanly formatted. With the MSSQL extensio...
Hybrid search is usually described as combining keyword search with vector search. Microsoft SQL does that, for sure, but we do quite a bit mo...
Why production AI retrieval depends on more than vector index performance. It’s easy to think of AI retrieval as a vector search proble...
BlockOnPossibleDataLoss can frustrate developers, but it's one of the most important safeguards in database deployment. Here's how to keep you...
Newsletter
A curated digest of community blogs, product news, videos, and podcasts — delivered without the noise.
