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 →


SSMSinstallComplete

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 →


SSMSqueryWindow

Increasing the Font in SSMS on the Fly

Recently, I have learned a neat trick to quickly increase or decrease the font size.  This something I found with a different database product, but was happy to see work … Continue Reading →


2014Enterprise010

Upgrade SQL Server 2014 Standard to Enterprise

This blog is about upgrading SQL Server 2014 Standard Edition to the Enterprise Edition.  This blog looks & sound much like my October 2013 post, “Upgrade SQL Server 2012 Standard … Continue Reading →


sys.dm_tcp_listener_states

dm_tcp_listener_states DMV Altered to be Readable

The sys.dm_tcp_listener_states DMV was introduced in version SQL Server 2012. This is a great DMV because the SQL Configuration Manager does not have to opened to find these values.  However … Continue Reading →


SQL Server 2012 SP1 – Standard Edition – 11.0.5058.0

Upgrade SQL Server 2012 Standard to Enterprise with Different Service Packs

In October 2013, I wrote about how to “Upgrade SQL Server 2012 Standard to Enterprise“.  Recently in the comments section, Leo asked “Is this impacted by service packing?”.  This is … Continue Reading →