SQL Server – Writing to a File
Posted 3/29/2020 — Edited 3/30/2020 to fix a couple of copy and paste errors, and to clarify a couple of items. Thanks Charlie for your… Read More »SQL Server – Writing to a File
SteveStedman
Stedman Solutions – Open for Business
Stedman Solutions, LLC is open for business during the Covid-19 pandemic and growing our team. This week the Stedman Solutions team grew by adding our… Read More »Stedman Solutions – Open for Business
Severity 20 – Fatal Error
SQL Server Alert System: ‘Severity 20 – Fatal Error In Current Process’DESCRIPTION: SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection… Read More »Severity 20 – Fatal Error
Update Statistics
Is there any safe way to ‘update statistics’ without causing major slow downs? As far as a safe way to update statistics. It is best… Read More »Update Statistics
Bulk Update Database Mail Password
Database mail is a critical part of getting notifications from your SQL Server when things go wrong. The problem comes when you have a database… Read More »Bulk Update Database Mail Password
SQL Server Alert System: ‘ERROR 824’
Part of good server monitoring it to have alerts enabled for a number of different errors to know when things go bad. The problem is… Read More »SQL Server Alert System: ‘ERROR 824’
sp_readerrorlog – Msg 22004, Level 16, State 1, Line 0 – Failed to open loopback connection. Please see event log for more information.
Recently while working on a SQL Server for a client I came across the following error when I attempted to view the SQL Server logs… Read More »sp_readerrorlog – Msg 22004, Level 16, State 1, Line 0 – Failed to open loopback connection. Please see event log for more information.
Steve Stedman Blog Posts from 2019
Finding Serializable QueriesDecember 3, 2019 Serializable, and some of the other isolation levels can have performance implications. Recently I came across a case where I… Read More »Steve Stedman Blog Posts from 2019
Finding Serializable Queries
Serializable, and some of the other isolation levels can have performance implications. Recently I came across a case where I needed to find queries that… Read More »Finding Serializable Queries
November 2019 Release of Database Health Monitor
Thanks to the successful funding campaign on Indiegogo I was able to fund the November 2019 release of Database Health Monitor. Here are the release… Read More »November 2019 Release of Database Health Monitor