Can SQL Server listen on multiple TCP Ports? Yes, and here are the Configuration Manager steps I shared when a senior DBA asked me during a Health Check.
Startup Stored Procedures in SQL Server: Uses and Risks
Startup stored procedures run every time SQL Server starts, which makes them useful and easy to forget. This post covers good uses, the risks, a wait that gives up instead of looping forever, and how to list and remove the startup stored procedures already on a server. The setup steps are in a separate post.
SQL SERVER – Event ID:7034 – MSSQLSERVER Service Terminated Unexpectedly. It has Done this 6 time(s)
Recently, I came across a strange issue. I noticed that the SQL Server service terminates and restarts automatically and doesn’t restart.
SQL SERVER Analysis Services – Unable to Start Service. Error: The Filename, Directory Name, or Volume Label Syntax is Incorrect
SQL Server Analysis Services would not start: the filename, directory name, or volume label syntax is incorrect. Here is what the event log showed and the fix.
SQL SERVER – SQL Server Agent Not Starting – Failed to Initialize SQL Agent Log (Reason: Access is Denied).
SQL Server Agent would not start in my lab: Failed to initialize SQL Agent log (reason: Access is denied). Here is what I found in the log folder and the fix.
SQL SERVER – Setup / Installation Error – Updating Permission Setting for File ResumeKeyFilter.Store Failed
A new SQL Server 2016 install failed at the end: updating permission setting for file ResumeKeyFilter.Store failed. Here is how I fixed this setup error.
SQL SERVER – Databases Going to Recovery Pending State Randomly
A client’s databases kept going to recovery pending state randomly. The ERRORLOG showed why. Here is how I found the cause and fixed it.