Resolutions found with SQL Server and other types of databases
Microsoft SQL Server database system
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 →
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 →
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 →
Working with some new monitoring software, I need to locate the directory of the SQL Server’s Errorlog. This location is not standard and differs by each version of SQL Server. … Continue Reading →
Probably the fastest way to enable Query Store for a database is run the “ALTER DATABASE” command in a query window. First check that the database is not already have … Continue Reading →
When applying a hotfix update to SQL Server 2012, the step where “Check File In Use” produced the following error: The ‘fdhost.exe’ process is not controlled by the update wizard. … Continue Reading →
Problem: This was a compound problem I had on a production SQL Server 2014 instance. First was someone who scheduled a couple of load jobs at the same time which … Continue Reading →