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 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.