MSSQL

What is GraphDB? GraphDB introduced in SQL Server 2017. We will examine GraphDB with examples in this article. At the end of the article, we will learn the architecture of …

What is Resumable Index? When rebuilding indexes online, index rebuild process could be fail for reasons such as failover, disk failure, manual stop (PAUSE). In such cases, you must mark …

New Dmw sys.dm_db_log_stats in SQL Server 2017 To understand SQL Server architecture, you must understand the architecture of the SQL Server Transaction Log file. Transaction Log file is also one …

What is Automatic Seeding? Automatic Seeding is a feature introduced with SQL Server 2016. We need to add SEEDING_MODE = AUTOMATIC when creating the Availability Groupor or alter the existing …

What is Basic Availability Groups? As of SQL Server 2016, we can create Always ON Availability Groups in Standard Edition with some limitations. You should read the article  “SQL Server …

What is Dynamic Data Masking? Dynamic Data Masking is a feature announced in SQL Server 2016. With Dynamic Data Masking, you can restrict unauthorized access to your data. Microsoft introduced …

What is Row Level Security in SQL Server? Row-Level Security is a feature introduced in SQL Server 2016 that allows each user to see only their own data. So users …

You can find information about creating SQL Database in Azure in this article. If you are creating a Stretch Database, you must first create a SQL Database on Azure. You …

In Azure, you can create a virtual machine to manage SQL Server databases. In this article, I will explain how to create this virtual machine with the simplest configuration. Go …

What is Stretch Database? If you want to archive your old data to Azure, all you need is StretchDatabase. You can then query as you wish your old data from …