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 →
SQL Server Audit: Error: 25725, Severity: 16, State: 1
Recently I received the following error from one of my SQL Servers: Audit: Server Audit: 65536, State changed from: STARTED to: SHUTTING_DOWN Error: 33059, Severity: 16, State: 1. An error … Continue Reading →
Teradata chk_node VS nodecheck
Teradata systems have a couple of command-line utilities to verify the health of a Teradata node. Both these command-line utilities are good to run when looking for something like hardware … Continue Reading →
node.check Utility in Teradata
The “node.check” utility has been been around for a while with Teradata. Recently I was working with Teradata’s Hardware Support team, and watched them use this utility to uncover a … Continue Reading →
Teradata – Convert Timestamp to the Month of the Year
This one also surprises me that someone has not already posted. The TD_Month_Of_Year function returns an integer value that need to converted to string value. Careful when using this on … Continue Reading →
Teradata – Convert Timestamp to the Day of the Week
This surprises me that someone has not already posted this. The TD_Day_of_Week function returns an integer value that need to converted to string value. Careful when using this on a … Continue Reading →
Errorlog Configuration Problem When Upgrading SQL Server
Problem: This morning when working with one of my SQL Server servers, I went looking for an error log from last August. After finding that I was only able to … Continue Reading →
Windows Server Uptime
There are times I need to know if a scheduled server reboot has occurred. Below works on both Windows Server 2012 & Windows Server 2016. 1. On the server, right … Continue Reading →
Collect Statistics Spool Space Error in Teradata
Recently I received an e-mail alert that my collect statistics job had a spool space error (“Failure 2646 No more spool space in…”) for one of the statements it ran … Continue Reading →
Unable to Connect to Teradata from Toad DataPoint with an Active Directory Account
A user was unable to connect to Teradata from Toad DataPoint using a Microsoft Active Directory account. When I looked at the user account in Teradata, it was showing as … Continue Reading →
Cannot Alter the Schema – Msg 15151, Level 16, State 1, Line 1
A rookie developer reached out to me requesting help to move a couple of tables to a new schema. Thinking the developer did not have permissions to the one of … Continue Reading →