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