A guide to preventing SQL injection for ADO.NET, ASP. ColdFusion, COM, C#, Delphi, Entity Framework, and many other languages.

I have collected some links of SQL Server Tutorials which may be helpful to the beginners and students.

This link takes you to an article which describes temporal tables and how they help you to audit data changes

The article is dedicated to configuring disk space for SQL Server databases to increase system reliability and performance.

The article describes PIVOT, UNPIVOT, and Reverse PIVOT Statements, as well as shows how they can be applied in SQL Server on particular examples

The article provides a demonstration of table partitioning, namely dividing large tables into small ones, as well as describes its benefits.

The article is dedicated to some best practices of T-SQL queries that can help to avoid performance and I/O problems.

The article describes the example of using temporary data, as well as temporary tables and stored procedures in SQL Server.

The limitations of using Always Encrypted feature in SQL Server 2016 is well documented in the below article.

Kerberos authentication provides a highly secure method to authenticate client and server entities (security principals) on a network.

Contrast between SQL table variable and temporary table

JSON vs XML Performance Comparison.

Free ebook: Microsoft Azure Essentials Migrating SQL Server Databases to Azure

SQL Server Unit Testing in Visual Studio

SSRS Audit: Query the ReportServer.dbo.ExecutionLog table to determine which reports have been executed in the past month and which have not.

SQL Server Encryption: Always Encrypted

Step by Step Configuring a Dedicated Network for Availability Group

This article shared three ways of enabling trace flags behaviors in SQL server: at startup, with the QUERYTRACEON query hint, and with the DBCC TRACEON/TRACEOFF commands.