The limitations of using Always Encrypted feature in SQL Server 2016 is well documented in the below article.
Saravanan V
Kerberos authentication provides a highly secure method to authenticate client and server entities (security principals) on a network.
Deepak
Contrast between SQL table variable and temporary table
Bryian Tan
JSON vs XML Performance Comparison.
Jim Lorinser
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.
Subash
SQL Server Encryption: Always Encrypted
Step by Step Configuring a Dedicated Network for Availability Group
Nathan Russell
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.
How to clone a SQL Server login and password from server A to server B.
Capturing Baselines on Production SQL Servers.
Performance comparison between SQL Server and SQL Server v.Next
This article describe on how to change the linked server password
This link refers to very basic fundamental concept where programmers have to deal with multiple data types comparison.
Tapan Patel
Basic understanding about joins with examples.
I came across some very useful SQL Server features, which I felt like must be shared.
Jasminder Singh
Here in this link is the list of queries which we use regularly and how these sql queries can be optimized for better performance.