To Enable Instant File Initialization for data files, I check the Windows service identity and volume-maintenance privilege. Eligibility still matters.
SQL SERVER – How to Listen on Multiple TCP Ports in SQL Server?
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.
Event ID 7034: MSSQLSERVER Service Terminated Unexpectedly
Event ID 7034 reports that the MSSQLSERVER service terminated unexpectedly. The Application log held an APPCRASH entry with exception code 0xC0000005, an access violation. A clean restart of the server cleared the problem.
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.