RegEdit

Problem Patching a SQL Server Cluster

Problem: I was working with a SQL Server 2014 two node cluster in our test environment.  After the cluster had been setup, I was asked to change the drive letters … Continue Reading →



Verify4029

Trace Flag for Troubleshooting Lost or Dropped Connections in SQL Server

Problem: About once a month, I get support ticket regarding SQL Server dropping an application’s or user’s connection.  The problem is SQL Server does not just randomly drop a connection … Continue Reading →


SQL_Linux_Install_Error

E: Unable to locate package mssql-server – Ubuntu SQL Server Installation Error

Problem: With the new install of Ubuntu 16.04.3 LTS (GNU/Linux 4.4.0-87-generic x86_64), different attempts at installing SQL Server resulted in the error: “E: Unable to locate package mssql-server”. Resolution: On … Continue Reading →


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 →


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 →


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 →


Emailed DBCC CHECKDB Output

Email the results of DBCC CHECKDB

Situation: We had a very busy SQL Server, that could not have “DBCC CHECKDB” run during business hours with out impacting others.  I was being asking for the output from … Continue Reading →