An attached database showed read-only and SET READ_WRITE failed with OS error 5, Access is denied. Here is how to FIX Error 5120 with file permissions.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Displaying SQL Agent Jobs Running at a Specific Time
A client’s server froze every morning at the same time. The cause was a background job, so here is a query for displaying SQL Agent Jobs running at a set time.
PowerShell – Script to Listing all Backups Taken with SQL Server
A handy PowerShell script for listing all backups taken for each database on your SQL Server, one I keep on my USB drive for customer visits.
Fastest Way to Display Code of Any Stored Procedure – Interview Question of the Week #094
What is the fastest way to display code of any stored procedure? It is not always clicking Modify in SSMS. Here is the age old interview question and my answer.
PowerShell – Tip: How to Format PowerShell Script Output?
Raw PowerShell output is hard to read. Here are three common ways to format PowerShell script output, starting with Format-Table, so results make sense.
PowerShell Scripts – get-process with SQL Server process
I was playing with the get-process cmdlet in PowerShell. Here is how to use get-process with SQL Server to find the sqlservr process and its details.
SQL SERVER – How to Avoid Triggers for Multiple Row Operations in a Table
A late-night mail from an old customer about an application error led to this lesson: how to avoid triggers causing trouble with multiple row operations.
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.