Resolutions found with SQL Server and other types of databases
When troubleshooting from SSMS, I need to know which Windows server my clustered instance is running on. Surprised that this query is not already on the first page of the … Continue Reading →
Sadly I have not found a better way to view the available OLE DB Providers on a server. Even though I am using an out of support Windows Server 2012 … Continue Reading →
Working with large sql statements, I find it is easier to have line numbers in the query window. Enabling “Line numbers” process is the same with every version of SQL … Continue Reading →
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 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 →
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 →
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 →
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 →
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 →
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 →