Login failed for user with state 58? Newer SQL Server versions give better details in the ERRORLOG. Here is how to FIX Error 18456 when you see this state.
SQL SERVER – Huge Transaction Log (LDF) for Database in Availability Group
A reader’s database in an AlwaysOn availability group grew a Huge Transaction Log of 230 GB with error 9002, AVAILABILITY_REPLICA. Here is what to check.
Send the Payload, Skip the Meeting: Async Updates That Save Hours
Async updates save hours when each message carries everything the reader needs. This post shows the five fields of a clean update, a made-up example and a default action that keeps work moving. It also says when a meeting still wins.
SQL SERVER 2016: Creating Simple Temporal Table
Want to see what your data looked like on a past date? Here is how to create a simple Temporal Table in SQL Server 2016, with its history table made for you.
Finding Out Who Changed That Row
Investigate who changed data using existing audit evidence, transaction log limits, and the distinction between logins and individual users.
SQL SERVER – How to Connect Using NT AUTHORITY \ SYSTEM Account?
SSMS will not let you type in Windows credentials. Here is how to connect using NT AUTHORITY\SYSTEM account with PsExec from Sysinternals.
Interview Question of the Week #057 – What is GO Statement in SQL SERVER?
Learn what the GO statement really does in SQL Server, why a variable vanishes after it, and the simple rules every script writer should know.