Many DBAs use sp_readerrorlog or xp_readerrorlog to read ERRORLOG files in SQL Server. SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location
SQL SERVER – Database Files Initial Size Changing Automatically
Database files initial size changing automatically every night? A client hired me to solve this mystery, and here is how I investigated it.
SQL SERVER – SQL Agent Not Starting. The EventLog Service has Not Been Started
After a server hardening script, a client’s SQL Agent would not start because the Eventlog Service had not been started. Here is how we traced and fixed it.
SQL SERVER – Unable to Start SQL When Service Account is Removed From Local Administrators Group. Why?
When the service account is removed from local Administrators group, SQL Server may not start. Here is why, and the minimal permissions it needs.
SQL SERVER – Error Installing Microsoft Visual Studio 2010 Shell
A SQL Server patch failed while installing the Visual Studio 2010 Shell. The VC10 redist log showed the cause, and here is how I fixed it.
SQL SERVER – Clustered SQL Resource Not Coming Online
Clustered SQL resource stuck in online pending, yet the service started fine from services.msc. The cluster log showed a login failure. Here is the fix.
SQL SERVER – Unable to Add Server Name SQLAUTH-LISTENER to Transport Device NetBt_If4 Status 2 – Windows Cluster
An availability group listener would not come online. The cluster log said unable to add server name to transport device NetBt_If4, status 2.