Installing sqlcmd and bcp on Windows starts with the current Microsoft command line utilities, then PATH and version checks.
Handing Over a Database to Another Team
Handing over a database should include a current map, tested recovery path, access transfer, open risks, and a defined support period.
Seeing What Is Running Right Now
See what is running right now in SQL Server with request DMVs, statement text, plans, waits, and blocking details in one reusable query.
Renaming or Disabling the sa Login
Renaming or disabling the sa login requires a dependency inventory, tested alternate admin access, and monitoring after the change.
Exploring the System Catalog With Queries
Exploring the system catalog with queries reveals SQL Server objects, columns, indexes, and dependencies without relying on stale diagrams.
Responding to a SQL Server Security Bulletin
A SQL Server Security Bulletin should trigger exposure checks, ordered patching, verified recovery, and a clear management update.
SQL SERVER – Guidelines and Coding Standards Complete List Download
My coding standards complete list for SQL Server, cut to what people follow: naming, formatting, and the rules that prevent real bugs.