How To Find All Access Rights In Teradata

The problem with the table DBC.AccessRights is that the data is not something easily readable.  Many of the columns use a 4-byte IDs. By joining a couple of tables to … Continue Reading →



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 →


Teradata Error: Cannot Find Terasso Library

Problem: Setting up a new computer with the 16.10 Teradata Tools And Utilities & other Teradata programs.  When I went to setup the ODBC Connection to the using the Teradata … 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 →