Install SQL Server Management Studio (SSMS) 2016 Without Internet Access: One of my frustrations with SQL Server 2016, is that the SQL Server Management Studio (SSMS) is no longer included with the database instance installation. It is now has its … 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 →
ALTER LOGIN WITH PASSWORD causes error Msg 15151, Level 16, State 1, Line 4
Problem: A user that was not part of the sysadmin role attempted to change its own password using the SQL syntax, “ALTER LOGIN WITH PASSWORD”. Returned is the following error: … 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 →
Flash NIC Light on SUSE Linux – Teradata Server
Problem: I needed to know the ethernet device name of an unused port on a NIC (network interface card) on my Teradata server. Using the “ethertool” utility, I was able … Continue Reading →
Unlock a Teradata User Account
1. Determine if the account is locked by failed password attempts. When the failed attempts equals the max logon attempts set in the user’s profile, the user will be displayed … Continue Reading →