SQL Server 2016

Create powerful REST API with just few lines of C# code using MsSql.RestApi package

A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format

SQL script that dynamically generates the DR scripts for failing over/back all Log Shipped databases. While it makes even a single database failover/failback a more streamlined process, it's most helpful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc.

SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.

Minimally simple UkrGuru.SqlJson package for modern data manipulation

This article explains how to create and use a self referencing key in a SQL Server Table.

Analysis and troubleshooting a database performance bottleneck

A utility query to find table generations in SQL Server relational database