Truncate Table Pitfalls
Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly. If you want the speed without the face-palm moments, here’s a practical, interview-ready guide to...
       2025-10-29 (first published: 2025-10-08)
 616 reads
           Disable the sa login in SQL Server (and sleep better)If you run SQL Server in 2025 and your sa login is still usable, you’re giving attackers a giant, blinking...
       2025-10-23 (first published: 2025-10-21)
 42 reads
            DBAs should never run SSMS under their everyday Windows account
If you open SSMS under the same Windows identity you use for email, browsing, and chat, you bring all that...
       2025-10-22 (first published: 2025-10-07)
 1,387 reads
            Why you should connect resiliently to SQL Server
Transient failures happen — in the cloud (Azure SQL) and on-prem. A resilient connection strategy lets your app recover gracefully instead of...
       2025-10-14 (first published: 2025-10-13)
 78 reads
           SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been...
       2019-03-18 (first published: 2019-03-05)
 14,553 reads