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 – Error: 26014, Severity: 16. Unable to Load User Specified Certificate
After a client changed the SQL Server certificate, the service would not start: Error 26014, unable to load User Specified Certificate. Here is how we fixed it.