Moving from PostgreSQL to SQL Server? Learn the key differences between timestamp, timestamptz, datetime2, and datetimeoffset, including preci...
I went looking for Azure SQL Database in a recent coding agent benchmark, honestly unsure whether Microsoft SQL would show up. Armature ran a ...
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...
Newsletter
A curated digest of community blogs, product news, videos, and podcasts — delivered without the noise.
