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 …
Read More »
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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »