The log kept growing and sys.databases showed REPLICATION as the reuse wait. Here is how I found why the transaction log in snapshot replication was not reused.
SQL SERVER – What is DBCC TRACEON and DBCC TRACEOFF messages in ERRORLOG?
A client asked about DBCC TRACEON and DBCC TRACEOFF messages in the ERRORLOG. Here is what they mean, using trace flag 1222 for deadlock logging as an example.
SQL SERVER – How to Change SQL Server Collation on Microsoft Azure VM (IaaS)
Azure gallery VMs install SQL Server with SQL_Latin1_General_CP1_CI_AS. Here is how to change SQL Server Collation on such a VM by rebuilding system databases.
SQL SERVER – Who Changed the Password of SQL Login? – Interview Question of the Week #065
Who changed the password of your SQL Login? It is a real world question every DBA faces one day. Bookmark this post, here is how to find the answer.
SQL SERVER – FIX: Could not connect because the maximum number of 1 user connections has already been reached
A client changed one setting, restarted and nobody could connect: the maximum number of 1 user connections has already been reached. Here is how we got in.
SQL SERVER – Finding If Status of Bulk Logging Enabled or Not From Logs
A friend’s SSIS jobs switch a database to Bulk-Logged and back again. Here is how to find which of his log backups ran with Bulk Logging Enabled.
SQL SERVER – How to Query Active Directory Data Using ADSI / LDAP Linked Server
A client wanted the email address and phone number of every user from Active Directory. Here is how to query Active Directory data with an ADSI linked server.