Renaming or disabling the sa login requires a dependency inventory, tested alternate admin access, and monitoring after the change.
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.
SQL SERVER – 2008 – Interview Questions and Answers Part 7
SQL Server 2008 Interview Questions and Answers Part 7: how to rewrite sub-queries with joins or a CTE, what CLR is, and more answers with examples.
SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server – Fix Connection Problems of SQL Server
Still stuck on Error 40, could not open a connection to SQL server? Here are more suggestions to fix connection problems, beyond my first two articles.
SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log
Why does an LDF file keep growing even with hourly log backups? Imran Mohammed explains what goes on behind the scene of the Transaction Log and shrinking.
Finding the Client IP Address of a Connection
Find the client IP address of a SQL Server connection with DMVs and CONNECTIONPROPERTY, and understand proxy and local transport limits.