MSSQL

What is Automatic Tuning in SQL Server? Automatic Tuning is announced with SQL Server 2017. Automatic Tuning is a database feature that identifies potential performance problems, makes recommendations for solving …

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 …