February 2020

Severity 20 – Fatal Error

by SteveStedman
February 11, 2020November 30, 2022
SQL Server

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

by SteveStedman
February 10, 2020November 30, 2022
Performance

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

by SteveStedman
February 9, 2020November 30, 2022
1 Comment
SSMS

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’

by SteveStedman
February 6, 2020November 30, 2022
SQL Server

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’