A client’s SQL Server would not start with Error 17190: initializing the FallBack Certificate failed. Here is how we found the cause on a call and fixed it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Too Many SQLDump Files Consuming a Lot of Disk Space. What Should You Do?
SQLDump files are SQL Server’s stress signal, and a client had so many they filled the disk. Here is what causes them and what you should do about it.
SQL SERVER – SQLCMD Error – Failed to Load Resource File SQLCMD.rll
Running SQLCMD gave me this SQLCMD error: Failed to load resource file SQLCMD.rll. Here is how I used Process Monitor to find the missing file.
SQL SERVER- Msg 22004, Level 16 – xp_readerrorlog – Failed to Open Loopback Connection. Please See Event Log for More Information
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
What is WorkTable in SQL Server? – Interview Question of the Week #146
What is a WorkTable in SQL Server? Run a simple CROSS JOIN with STATISTICS IO on and you will see one. Here is what it is and why SQL Server creates it.
SQL SERVER- New DMF in SQL Server 2017 – sys.dm_os_file_exists. A Replacement of xp_fileexist
SQL Server 2017 adds a new DMF, sys.dm_os_file_exists, a replacement of xp_fileexist that suits both Windows and Linux. Here is how to use it.
SQL SERVER – Msg 3013 – Cannot Create Worker Thread. BACKUP LOG is Terminating Abnormally
Msg 3013, cannot create worker thread, on a log backup. What the worker thread limit really is, and when raising it is the wrong fix.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.