When provisioning Azure SQL Database, you’re presented with two purchasing models: vCores and DTUs. Choosing the right model impacts performance, scalability, control, and cost-efficiency. Each purchasing model targets specific workload types, and...

The Microsoft Azure SQL family has a rich set of database offerings, each suitable for a different type of workload and pricing tier There are many reasons to migrate to the cloud, including…

Microsoft released the new version of SQL server 2025, on November 19, 2024, during the Microsoft Ignite conference. With this release (currently preview), SQL server has now become an AI-ready database. Along with adding new AI capabilities - the ne...

A distributed availability group (AG) is a special type of availability group that spans two separate availability groups. Distributed availability groups are available starting with SQL Server 2016. This article describes the distributed availabili...

Microsoft SQL Server is a popular database solution chosen by organizations because of its performance, scalability and enterprise-ready features. When you need to migrate or create a Microsoft SQL Server project to Azure, there are three different o...

Microsoft SQL Server is a popular database solution chosen by organizations because of its performance, scalability and enterprise-ready features. When you need to migrate or create a Microsoft SQL Server project to Azure, there are three different o...

The landscape of data management has dramatically shifted from rigid, siloed systems to flexible, integrated platforms designed to handle the unprecedented volume, variety, and velocity of modern data. This evolution is driven by the increasing deman...

SQL in Azure excels with the presentation of Microsoft’s industry-leading database product. New features from the latest versions of SQL Database Server are also implemented in the Azure product with even greater results than single-server implemen...

Microsoft Azure offers the Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Similar to the SQL Server Agent job Wizard in SQL Server Management Studio, Azure Elastic Jobs Manager s...

There are three Azure SQL products with so many different deployment options, service tiers, and compute tiers that it can get quite confusing when choosing the right option for your workload. So, I thought I would write this blog to help out a bit....

As enterprises continue their digital transformation journeys, migrating on-premises databases to Microsoft Azure Cloud has become one of the most impactful modernization initiatives. Azure provides a scalable, secure, and cost-efficient data platfo...

To ensure SQL Server Service Packs are applied correctly and the impact of their application is minimized for both end users and your business, it’s important you know about and can implement SQL Server patching best practices and SQL Server cluste...

The idea behind starting this blog was to help people who are interested in data engineering as a career. The reason this blog is named Azure Data Engineering is because my experience is mostly with Microsoft Technologies.

The idea behind starting this blog was to help people who are interested in data engineering as a career. The reason this blog is named Azure Data Engineering is because my experience is mostly with Microsoft Technologies.

The idea behind starting this blog was to help people who are interested in data engineering as a career. The reason this blog is named Azure Data Engineering is because my experience is mostly with Microsoft Technologies.