Using Keyboard Query Shortcuts in SQL Server Management Studio

This is something that I wish I had discovered years ago.  I have put together my nine most used queries, functions, or system stored procedures that I use most everyday. … Continue Reading →


Cannot Generate SSPI Context – Connection Problem

Problem: When I attempted to logon to one of individual node for my AlwaysOn Availability Group, I received the connection error shown below. TITLE: Connect to Server Cannot connect to … Continue Reading →


E: Unable to locate package mssql-tools – error install the command line tools for SQL Server on Ubuntu

Problem: When attempting to install the command line tools for SQL Server on Ubuntu 16.04.3, I would get the error: “E: Unable to locate package mssql-tools” Resolution: Note: SQL Server … Continue Reading →


Problem Patching a SQL Server Cluster

Problem: I was working with a SQL Server 2014 two node cluster in our test environment.  After the cluster had been setup, I was asked to change the drive letters … Continue Reading →



Trace Flag for Troubleshooting Lost or Dropped Connections in SQL Server

Problem: About once a month, I get support ticket regarding SQL Server dropping an application’s or user’s connection.  The problem is SQL Server does not just randomly drop a connection … Continue Reading →


E: Unable to locate package mssql-server – Ubuntu SQL Server Installation Error

Problem: With the new install of Ubuntu 16.04.3 LTS (GNU/Linux 4.4.0-87-generic x86_64), different attempts at installing SQL Server resulted in the error: “E: Unable to locate package mssql-server”. Resolution: On … Continue Reading →


DateTime to the Millisecond in a Filename

My goal was create a filename with the DateTime format to the millisecond to be used in a stored procedure. First was to get the DateTime format I wanted without … Continue Reading →


Troubleshooting – Error: 17189, Severity: 16, State: 1

Troubleshooting the following Error: 2017-06-01 18:00:00.000 Logon        Error: 17189, Severity: 16, State: 1. 2017-06-01 18:00:00.000 Logon        SQL Server failed with error code 0xc0000000 to spawn a thread to process a … Continue Reading →