Click here to Skip to main content

Submit your article

SQL-Server-2016

SQL-Server-2016

Great Reads

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

by Jesus Carroll

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.

Always Encrypted Feature in SQL Server 2016

by Manjuke Fernando

Always encrypted feature in SQL Server 2016

Building a Basic Test Data Generator for Books in SQL

by Haroon Ashraf

This article helps beginners to generate over million records of random test data for a database object like books in SQL.

DROP IF EXISTS in SQL Server 2016

by Suvendu Shekhar Giri

Enhancement on dropping an object with check for existence in SQL Server 2016

Latest Articles

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

by Jesus Carroll

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.

Always Encrypted Feature in SQL Server 2016

by Manjuke Fernando

Always encrypted feature in SQL Server 2016

Building a Basic Test Data Generator for Books in SQL

by Haroon Ashraf

This article helps beginners to generate over million records of random test data for a database object like books in SQL.

DROP IF EXISTS in SQL Server 2016

by Suvendu Shekhar Giri

Enhancement on dropping an object with check for existence in SQL Server 2016

All Articles

SQL-Server-2016

DROP IF EXISTS in SQL Server 2016

by Suvendu Shekhar Giri

Enhancement on dropping an object with check for existence in SQL Server 2016

How to Create and Use a Self-referencing Hierarchical Table

by E. Scott McFadden

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

Select Statement to HTML Table

by Luca Astolfi

User defined procedure for make an HTML table from T-SQL Select statment

SQL Server 2016 Helps Us to Protect the Sensitive Data

by Krishna KV

Dynamic masking using SQL Server 2016

SQL Server: Find Table Order/Generation And Relation Details

by DiponRoy

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

SSMS 2016: Enhanced Scrollbar

by Suvendu Shekhar Giri

Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016

UkrGuru.SqlJson Your Link Between SQL Server and .NET 5

by Oleksandr Viktor (UkrGuru)

Minimally simple UkrGuru.SqlJson package for modern data manipulation