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.
SQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks
How do you find which table has a transaction lock and what lock type it is? Imran Mohammed explains it for SQL Server 2000 and 2005, and how to avoid locks.
SQL SERVER – Fix : Error : 1326 Cannot connect to Database Server Error: 40 – Could not open a connection to SQL Server
If you are receiving the following error related to connection to SQL Server, this blog is for you.
Protecting an Instance You Cannot Patch Any More
Protect an Instance You Cannot Patch with isolation, least privilege, disabled features, tested backups, and a firm retirement date.