Logging Schema-changes in a Database using DDL Trigger
Explains how to use DDL Triggers in SQL Server to log database schema changes for troubleshooting, contrasting it with formal SQL Auditing for security.
Explains how to use DDL Triggers in SQL Server to log database schema changes for troubleshooting, contrasting it with formal SQL Auditing for security.
Explains Accelerated Database Recovery (ADR) in SQL Server 2019/Azure SQL, a feature designed to drastically reduce transaction rollback and database recovery times.
Explores the new Shortest Path algorithm support in SQL Server 2019's Graph Engine, a key feature for graph database functionality.
A guide to using the Tedious driver for Node.js to connect to Microsoft SQL Server, including a sample phone book application.