Category: MSSQL

How To Create Basic Availability Group in SQL Server Standart Edition

What is Basic Availability Groups? As of SQL Server 2016, we can create Always ON Availability Groups in Standard Edition

What is Dynamic Data Masking? Dynamic Data Masking is a feature announced in SQL Server 2016. With Dynamic Data Masking,

What is Row Level Security in SQL Server? Row-Level Security is a feature introduced in SQL Server 2016 that allows

You can find information about creating SQL Database in Azure in this article. If you are creating a Stretch Database,

In Azure, you can create a virtual machine to manage SQL Server databases. In this article, I will explain how

What is Stretch Database? If you want to archive your old data to Azure, all you need is StretchDatabase. You

What is PolyBase? With PolyBase, we can bridge between SQL Server and Hadoop, PDW, Azure Blob Storage, or Azure Data

Tempdb is a very important system database for heavily used systems. If it is not configured correctly, it can cause

With SQL Server 2016, we are now able to use parallelism in the query using INSERT INTO… SELECT with WITH

What is Live Query Statistics Live Query Statistics is a feature that we can use with SQL Server 2016 Management