Cloud and Azure

Azure SQL, Fabric, Managed Instance, migrations, Arc, hybrid scenarios, Snowflake

What’s New in Azure Database Migration Service Hub (September 2025)

Introduction On September 17, 2025, Microsoft announced the Azure Database Migration Service (DMS) Hub Experience【Microsoft TechCommunity†source】—a new centralized landing page that brings together everything you need to plan and manage your migration journey. Migrations have always been one of the highest-risk tasks for DBAs and architects. Even when everything works, there are long checklists: Until […]

What’s New in Azure Database Migration Service Hub (September 2025) Read More »

Azure Databricks vs Microsoft Fabric: Do you need one, the other, or both?

Summary Azure Databricks on Azure is great for heavy data engineering, Spark-first ETL, ML, lakehouse at scale, and open tooling. You pay by DBUs and compute. Microsoft Fabric is Microsoft’s end-to-end analytics platform that unifies ingestion, engineering, warehousing, real-time, and Power BI on OneLake with Delta tables and managed Spark. You buy capacity (F-SKUs) and

Azure Databricks vs Microsoft Fabric: Do you need one, the other, or both? Read More »

Real-Time Intelligence with Microsoft SQL Server: A Practical Guide

Summary Real-Time Intelligence means answering questions on fresh operational data quickly enough to influence what happens next. In Microsoft land, you can do this entirely inside SQL Server (e.g., nonclustered columnstore for “real-time operational analytics,” In-Memory OLTP, CDC) or you can offload streaming and analytics to cloud services like Azure Stream Analytics, Synapse Link for

Real-Time Intelligence with Microsoft SQL Server: A Practical Guide Read More »

SQL Server Machine Learning Services: a practical guide for DBAs, developers, and data-warehouse teams

This is a hands-on walkthrough of SQL Server Machine Learning Services (MLS). You will see what it is, when to use it, how to install and secure it on Windows and Linux, and how to build fast, reliable scoring pipelines you can surface in reports. I’ll keep the voice practical and call out tips by

SQL Server Machine Learning Services: a practical guide for DBAs, developers, and data-warehouse teams Read More »

From Ingestion to Insights: Practical Data Engineering & Data Science in Microsoft Fabric

Microsoft Fabric brings your lake, warehouse, pipelines, notebooks, and reporting together in one workspace. This guide shows how DBAs, developers, and data-warehouse teams can set it up, keep it fast and reliable, and ship both BI and data-science outputs. I’ll cover beginner to advanced moves, how it all ties together, and how to surface results

From Ingestion to Insights: Practical Data Engineering & Data Science in Microsoft Fabric Read More »

Data Platforms in Azure, Part 5: Choosing the Right Service

Over the last four parts of this series, we’ve gone deep into Azure’s major data platforms: Now let’s put it all together. Which service do you use, and when? The Decision Framework Here’s the big question: What kind of workload are you running? Service by Service Breakdown 🔹 Azure SQL Database 🔹 Azure Cosmos DB

Data Platforms in Azure, Part 5: Choosing the Right Service Read More »

Data Platforms in Azure, Part 4: Azure Database for PostgreSQL

In the last part of this series, we explored Azure Database for MySQL. Now let’s look at its close cousin: Azure Database for PostgreSQL. If you love PostgreSQL for its extensions, JSON support, and standards compliance, Azure gives you a managed version with built-in HA, scaling, and security. What is Azure Database for PostgreSQL? Azure

Data Platforms in Azure, Part 4: Azure Database for PostgreSQL Read More »

Data Platforms in Azure, Part 3: Azure Database for MySQL

So far in this series, we’ve looked at Cosmos DB (Part 1) for globally distributed NoSQL workloads and Azure Data Lake (Part 2) for analytics and unstructured data. Now it’s time to come back to familiar relational territory with Azure Database for MySQL. What is Azure Database for MySQL? It’s a managed database service for

Data Platforms in Azure, Part 3: Azure Database for MySQL Read More »

Data Platforms in Azure, Part 2: Working with Azure Data Lake

In Part 1 of this series, we explored Azure Cosmos DB and why you might reach for it when building low-latency, globally distributed applications. Now let’s switch gears and look at a platform designed for big data analytics and storage at scale: Azure Data Lake. What is Azure Data Lake? At its core, Azure Data

Data Platforms in Azure, Part 2: Working with Azure Data Lake Read More »

Data Platforms in Azure, Part 1: Getting Started with Azure Cosmos DB

When people first look at data services in Azure, they usually know SQL Database or maybe Azure Data Lake. But Azure has a much broader family of data platforms designed for different use cases. In this series, I’ll walk through the major options—Cosmos DB, Data Lake, MySQL, PostgreSQL, and more—so you can see when to

Data Platforms in Azure, Part 1: Getting Started with Azure Cosmos DB Read More »

Azure SQL, Explained: Picking the Right Option and Running It Well

If you’re new to Azure SQL, it can feel like a lot: Single databases, elastic pools, serverless, Hyperscale, Managed Instance, and full SQL Server on Azure VMs. The good news is the family is all built on the SQL Server engine, so your SQL skills carry over. The trick is choosing the right shape for

Azure SQL, Explained: Picking the Right Option and Running It Well Read More »

📊 Why Microsoft Fabric + OneLake Is Becoming the Go-To Data Platform in Azure (For SQL Pros in 2025)

The data landscape in Azure has shifted dramatically. If you’re still piecing together Azure Data Lake, Synapse, Data Factory, and Power BI manually — you’re behind the curve. Enter Microsoft Fabric and OneLake — a unified data platform that’s quickly taking over as the default stack for modern analytics in Azure. Whether you’re a SQL

📊 Why Microsoft Fabric + OneLake Is Becoming the Go-To Data Platform in Azure (For SQL Pros in 2025) Read More »

🔍 How to Create a Data Lake in Azure (2025 Edition) — And What’s New in the World of Data Lakes

In 2025, data lakes are more relevant than ever — especially in cloud-native environments like Azure. Whether you’re building analytics pipelines, prepping data for AI models, or just trying to wrangle millions of rows from disparate systems, an Azure Data Lake is a powerful (and scalable) foundation to get started. In this post, we’ll walk

🔍 How to Create a Data Lake in Azure (2025 Edition) — And What’s New in the World of Data Lakes Read More »

Mastering SQL Server Copilot Queries: A Comprehensive Guide

In the modern world of database management, SQL Server provides a powerful environment for managing data. Whether you’re querying large datasets or performing complex data transformations, having tools to make your development more efficient is essential. This is where Co-Pilot Queries come into play. In the context of SQL Server, Co-Pilot Queries refer to a

Mastering SQL Server Copilot Queries: A Comprehensive Guide Read More »

Understanding Optimized Locking in Azure SQL Database

When working with databases, one critical aspect of ensuring performance and consistency in multi-user environments is understanding how locking works. Locks are mechanisms that prevent multiple transactions from modifying the same data concurrently, ensuring data integrity. In the context of Azure SQL Database, optimized locking plays an essential role in improving performance while maintaining high

Understanding Optimized Locking in Azure SQL Database Read More »

A Complete Guide to Snowflake: Understanding Its Features, Functionality, and How to Use It

A Complete Guide to Snowflake: Understanding Its Features, Functionality, and How to Use It Snowflake is a powerful cloud-based data platform that offers a wide range of features for data storage, processing, and analysis. Unlike traditional data warehouses, Snowflake is designed to provide the scalability, flexibility, and performance that modern businesses need to manage vast

A Complete Guide to Snowflake: Understanding Its Features, Functionality, and How to Use It Read More »

Exploring Microsoft Fabric: The New Unified Data Platform in SQL Server Post-Ignite 2024

At Microsoft Ignite 2024, one of the most exciting announcements was the introduction of Microsoft Fabric, a unified data platform designed to seamlessly integrate analytics, data engineering, and data governance. This new offering aims to streamline the management of big data workflows and make it easier to manage data at scale, giving businesses the tools

Exploring Microsoft Fabric: The New Unified Data Platform in SQL Server Post-Ignite 2024 Read More »

Parquet vs. CSV for Azure Pipelines: Which is Better for Performance?

When building data pipelines for processing, transforming, and moving data through your workflows, choosing the right file format plays a crucial role in the performance, efficiency, and scalability of your operations. Two common file formats in modern data processing are Parquet and CSV. While CSV has been a staple for data storage and exchange, Parquet

Parquet vs. CSV for Azure Pipelines: Which is Better for Performance? Read More »