Category: 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…
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…
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…
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, …
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…
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…
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…
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…
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…
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…
Recent Comments