Main concept of SQL Server locking
In this post, we will discuss the SQL Server lock mechanism and how to monitor SQL Server locking...
Migrating SQL Server Database to Azure SQL (PaaS)
In this article, we will highlight SQL Server Data migration to Azure SQL (PaaS). You can find different approaches for this...
Choosing Azure SQL Purchase Model and Service Tier
When we are beginning to think of migrating our on-premises databases to Azure SQL, we have to decide on a proper purchase model, a service...
Configuring Azure SQL Long-term Backup Retention
Backup is the most important case for database administration because it provides business...
How to Handle Errors in SQL Server Nested Transactions
In this article, we will explore SQL Server Nested Transactions, a transaction block with one or several transactions. The image describes...
Azure SQL Geo-Replication and Failover Groups
Azure SQL offers different types of business continuity solutions. One of these solutions is Geo-Replication that provides an asynchronous...
SQL Server Database Scoped Configurations and Automatic Plan Correction
In this article, we will examine Database Scoped Configurations and SQL Server 2017 Automatic Plan...
Monitoring Azure SQL Database with Azure SQL Analytics
The most important and challenging responsibility of a database administrator is monitoring performance metrics. Because monitoring...
Azure SQL Database Automatic Tuning
Microsoft has recently announced an incredible new feature – automatic tuning in Azure SQL Database. To be honest, I am thoroughly...
SQL Server Table Partitioning and Partitions Tutorial
Problem In this article, we will focus on the demonstration of table partitioning. The simplest...
