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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →