SSMS is the first thing I open every day. Here is how to configure the Startup Options in SQL Server Management Studio so it opens the way you work.
Error: Msg 1904 The statistics on table has 65 columns in key list
SQL SERVER – Fix: Error: Msg 1904 The statistics on table has 65 columns in the key list. Let us learn how to fix in this blog.
SQL SERVER – FIX Error 5120 – Database is in Read Only Mode After Attaching Files
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 – 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.