TimeDateToMillisecondsForStoredProcedure

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 →

DIP_Menu

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 →

SQLerrorlog_IOerror

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 →

AtRisk

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 →

RolesWithCreateUID

Teradata Finding Which User is the CreateUID

Problem: Looking at the dbc.roles table, I want to find which user created a role.  There is the 4-byte column in the table called CreateUID, which identifies the user that … Continue Reading →

TruncateInTeradata

Truncate Table in Teradata

Coming from SQL Server & Oracle, I wanted a quick way in Teradata to truncate all the records from a table.  The issue is the word TRUNCATE is not a … Continue Reading →

IdentityColumnsResults

List All Identity Columns in a Database in SQL Server

Problem: Received a request for a list of all identity columns existing in a database.  The example is from the SQL 2016 sample database: WideWorldImporters SELECT o.name as ‘OWNER’, t.name … Continue Reading →

ListFilestreamDatabases

List FILESTREAM databases in SQL Server

Problem: Received a support ticket requesting help with the FILESTREAM database for a SQL Server.  Was given only the server name.  This server had over 50 databases in the SQL Server … Continue Reading →

logonevent

Teradata Viewing Failed Logon Information

In Teradata, there is a way to view the reason that a username is not authenticating.  Teradata is good about collecting information at the time of authentication.  It can be … Continue Reading →

teradata_password_change02

Changing a Password in Teradata

There are a couple ways to change a user’s password in Teradata.  Two methods covered here are using a SQL statement in Teradata’s SQL Assistant, and the other is using … Continue Reading →