
SQL Server Locks: A Performance and Deadlock Cheat Sheet
SQL Server uses locks to protect data while concurrent sessions read and modify it. Locks preserve...
Tag archive

SQL Server uses locks to protect data while concurrent sessions read and modify it. Locks preserve...
If you have ever watched an import job stall after AddRange and SaveChanges, you already know the...
Originally published at SQL & Cloud Lab. SQL Server Agent runs the jobs that keep a database...
Originally published at SQL & Cloud Lab. Database corruption is rare, but when it happens, the...
Originally published at SQL & Cloud Lab. If you are moving a SQL Server workload to Azure, the...

We moved this site's database to a new SQL Server, and the first time I tried to connect from my own...
Loading 80,000 Excel Records into SQL Server Using Microsoft Copilot Introduction Recently, I faced...
Originally published at migrationparity.com. The inventory script finished at two in the morning...
Back up a SQL Server database in SSMS to a .bak file, break it, then restore it back — that is this...

TL;DR: I built a free, open-source SSMS 21 & 22 extension that plugs a locally-hosted 7B model...
You connect Visual Studio to SQL Server three ways — Server Explorer for a design-time connection,...

Surprisingly many .NET developers still don't know SQL Server runs natively in Docker containers....