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 →

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 →

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 →

Running A DIP Script in Teradata

Note: The following was run on a Teradata Express 15.10 VM. Problem: Teradata Support’s response to correcting a problem we were having with calendar functions was “running DIPCAL should successfully … 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 →

Error Number 825 Alert that was followed by Clean CHECKDB

Problem: Received an e-mail alert for one of my SQL Servers: SQL Server Alert System: ‘Error Number 825’ occurred on < my SQL Server > DESCRIPTION:   A read of the … Continue Reading →