Stopping & Starting Teradata Viewpoint Services

Stopping & Starting the services for Teradata Viewpoint are the same in Teradata Express as they would be on an actual Teradata Viewpoint server.  Recently I needed to do this … Continue Reading →

Is Trace Flag 8001 still relevant

After reading an old article about the SQL Server DMV sys.dm_os_wait_stats running on SQL Server 2005.  I learned about the undocumented trace flag 8001, which enables all the wait types … Continue Reading →

TERADATA ERROR – DROP DATABASE Failed. 3552:

When attempting to drop a database that I created for temporary use, I received the following error when I ran the “DROP DATABASE < database name >” command: DROP DATABASE … Continue Reading →

ORA-00600: internal error code, arguments: [723], [140432], [960048], [memory leak]

Recently, I was notified of this error in the alert log of one of my Oracle 12.1.0.2 databases: ORA-00600: internal error code, arguments: [723], [140432], [960048], [memory leak], [], [], … Continue Reading →

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 →