Posted in Database

The Hub and Spoke model of policy-based management for SQL Server Always On Availability Groups

In this 34th article on SQL Server Always On Availability Groups, we will explore policy-based management features for the AG’s. Introduction to policy-based management Policy-Based…

Continue Reading... The Hub and Spoke model of policy-based management for SQL Server Always On Availability Groups
Posted in Database

SQL SERVER – PREEMPTIVE Waits – Simple Definition

Recently a client asked me during  Comprehensive Database Performance Health Check what does it mean to see more preemptive waits on their system. Let us…

Continue Reading... SQL SERVER – PREEMPTIVE Waits – Simple Definition
Posted in Database

Run SSIS packages in Azure Data Factory

In the previous articles, we showed how to copy data between different data stores, located in an on-premises server or in the cloud and how…

Continue Reading... Run SSIS packages in Azure Data Factory
Posted in Database

SQL SERVER – 16 CPU vs 1 CPU : Performance Comparison

Recently I was with a client helping them improve the performance of their SQL Server when I was working on Comprehensive Database Performance Health Check, …

Continue Reading... SQL SERVER – 16 CPU vs 1 CPU : Performance Comparison
Posted in Database

Transform data using a Mapping Data Flow in Azure Data Factory

In the previous articles, Copy data between Azure data stores using Azure Data Factory and Copy data from On-premises data store to an Azure data…

Continue Reading... Transform data using a Mapping Data Flow in Azure Data Factory
Posted in Database

SQL SERVER – Multiple Optimize Hint for a Query

Let us see today a very simple but interesting question asked by one of my clients of Comprehensive Database Performance Health Check. The question was…

Continue Reading... SQL SERVER – Multiple Optimize Hint for a Query
Posted in Database

Export data from Azure SQL Database to Azure Data Lake Storage

In this article, you will learn how to export data from Azure SQL Database to Azure Data Lake Storage using Azure Data Factory. Introduction Azure…

Continue Reading... Export data from Azure SQL Database to Azure Data Lake Storage
Posted in Database

SQL SERVER – Distinct and ORDER BY

I received quite a few questions after I made comment in my yesterday’s SQL in the Sixty Seconds Video SQL SERVER – TOP and DISTINCT…

Continue Reading... SQL SERVER – Distinct and ORDER BY
Posted in Database

How to provision Azure SQL Database using Ansible

In this article, you will learn about writing a playbook with Ansible to provision the Azure SQL database. In addition, you will also learn about…

Continue Reading... How to provision Azure SQL Database using Ansible
Posted in Database

SQL SERVER – TOP and DISTINCT – Epic Confusion

Recently during  Comprehensive Database Performance Health Check I was caught in a very interesting scenario where two of the DBAs from the client’s organization ended…

Continue Reading... SQL SERVER – TOP and DISTINCT – Epic Confusion