SQL Server is Microsoft’s main data platform. It is one of the best operational database management system (ODBMS). This article lists all the official builds

To encrypt drives for AlwaysOn, I would suggest these steps: – Do encryption during low usage hours. – encrypt drives on SECONDARY first. Without taking

Problem Summary Deadlocks are a common problem handled by SQL Server automatically. Nevertheless, you have to make sure that you minimize deadlocks as much as

Real sample The query plan below was extracted from a  stored procedure that was found during database Assessments. It was causing a high number of

Real sample Here what can be done during a session of SQL performance tuning. This query was running for a long time, causing a blocking

Problem Summary: Queries take a longer time than usual in processing. Suddenly, the queries that were fast before became slower. There are many reasons why

Problem Summary: The client was experiencing severe SQL Server performance issues; Multiple queries were taking 1, 5, 10 minutes or longer or timing out; The

Problem Summary: Finding the right high availability option can be difficult. Which choice is right for you can depend on the following: Budget – first and

Problem Summary: One of the biggest challenges in creating an Azure Managed Instance is determining the resource limits. In this case study, we use the

If you are a DBA, you understand the importance of having a robust Database Maintenance Solution. Ola Hallengren has developed an excellent maintenance implementation using

Microsoft is grouping all the options for SQL running in the Azure platform into one portfolio.  A family of managed products, making it easier to

Backing up your SQL Server database is essential for protecting your data. When databases come bigger, you’re going to run out of time to do a full