New Dmw sys.dm_db_log_stats in SQL Server 2017 To understand SQL Server architecture, you must understand the architecture of the SQL…
What is Automatic Seeding? Automatic Seeding is a feature introduced with SQL Server 2016. We need to add SEEDING_MODE =…
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…