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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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 Management Studio – Why I am Seeing White Icon Instead of Green or Red?
SSMS showed a white icon instead of green or red for SQL Server and Agent status, and Start and Stop were disabled. It comes down to your Windows account and WMI.
Creating and Running an SQL Server Unit Test – Best Ways to Test SQL Queries
Testing SQL code matters as much as writing it. I show how to create and run a SQL Server Unit Test with tSQLt, the free open source framework.
SQL SERVER – Database going to Recovery Pending Automatically and Coming Back
A client’s production database kept going into Recovery Pending on its own and coming back. The ERRORLOG showed OS error 32, file in use by another process.
When was Domain Account Password Changed in SQL Server? – Interview Question of the Week #093
Error 1069, logon failure, often means the service account password changed in the domain. Here is how to find when a Domain Account Password was last changed.
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.