Solving puzzle is something everyone would love. IHere is the puzzle which they wanted me to solve for Error 112.
SQL SERVER – Network Name resource fails to come online in a Windows Server 2008 R2 Failover Cluster
After adding a new disk, a client’s cluster Network Name resource would not come online in a Windows Server 2008 R2 Failover Cluster. Here is what we found.
SQL SERVER – Drive Space Full Due to MDMP Files
A client’s C drive kept filling up, and the transaction log was not to blame. SQL dump files were. Here is what caused this Drive Space Full issue.
SQL SERVER – InMemory OLTP Migration Assistant Powershell Script
Is your application ready for In-Memory tables? A client upgrading from SQL Server 2005 asked me, so here is the InMemory OLTP Migration Assistant script.
SQL SERVER – Identifying Database Default Locations for Data and Logs
Going back to basics can still teach you something new. Here are ways to identify the Database Default Locations for data and log files in SQL Server.
SQL SERVER – Huge Transaction Log in Snapshot Replication!
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.