T-SQL Tuesday: A Christmas Carol of Data Platform Features: A Festive Tech Calendar Crossover

Welcome to this month’s T-SQL Tuesday! A special shoutout to Kevin Chant (L | B) for hosting and aligning it with the Festive Tech Calendar. If you’re unfamiliar with T-SQL Tuesday, here’s a quick summary:

Every month, a host invites the Microsoft Data Platform community to write about a specific topic. Participants publish their posts on the second Tuesday of the month, following a standard format outlined in the host’s invite. The host then shares a roundup of all contributions.

This time, Kevin’s challenge is to write about a Microsoft Data Platform announcement or feature that made you go, “Wow!” It’s like receiving an amazing gift—a perfect crossover for the Christmas season.

I think I meant to put a logo here but I couldn’t resist this photo. Click on Kev and you can see the invite.

Given the seasonal theme, I’ve decided to put a Dickensian twist on my post. Inspired by A Christmas Carol, let’s explore the ghosts of Data Platform Features Past, Present, and Yet to Come. And, of course, I couldn’t leave out Jacob Marley—reimagined here as a champion of data-driven business success.

Be sure to check out the Festive Tech Calendar for more festive tech content!

The Ghost of Christmas Data Platform Feature Past: Availability Groups

The first stop on our journey is the past, where SQL Server Availability Groups were introduced in 2012. Back then, I was lucky enough to write a commercial training course covering SQL Server 2012’s new features, and Availability Groups were a standout.

These features revolutionised how we approached high availability (HA) and disaster recovery (DR). Availability Groups allowed us to synchronise databases across multiple servers while enabling read-only secondary replicas. This improved HA/DR capabilities and solved reporting pain points for many of my clients.

Even after 12 years, Availability Groups remain a cornerstone of the SQL Server database architecture. While newer features continue to evolve, this one set the stage for many of the innovations we enjoy today. It’s a classic gift that keeps on giving.

The Ghost of Christmas Data Platform Feature Present: Azure SQL Managed Instance

Moving to the present, we find Azure SQL Managed Instance—a feature that truly unlocked the potential of the Azure cloud for many of my clients. I would go as far to say that it unblocked their route to the cloud. Before Managed Instances, organisations faced two main options for moving SQL Server to Azure:

1. Azure Virtual Machines (VMs): Essentially a lift-and-shift of your on-premises SQL Server into the cloud. While this worked, it often cost as much (or more) as maintaining an on-premises setup and still required full administrative effort.
2. Azure SQL Database: A PaaS option requiring significant re-architecting of existing systems to fit the cloud model. While ideal for greenfield projects, it wasn’t always feasible for established workloads.

Azure SQL Managed Instance bridged this gap. It offered the familiarity of on-premises SQL Server—complete with features like SQL Agent and TempDB—but without the burden of patching, backups, or maintenance. This hybrid of familiarity and modern cloud management allowed many of my clients to seamlessly migrate to Azure and embrace the benefits a PaaS offering brings. They have embraced future without looking back.

The Ghost of Data Platform Features Yet to Come: SQL Database in Fabric

Peering into the future, we glimpse SQL Database in Fabric. Announced at Ignite, this feature promises to expand the reach of Microsoft Fabric by offering a relational database solution that integrates seamlessly into the Microsoft Fabric ecosystem.

While Fabric has made waves with its lakehouse, warehouse  and other analytics capabilities, SQL Database in Fabric addresses a different need: traditional relational data warehouses. For clients whose data needs fall well within the 4TB limit, this feature opens the door to Fabric’s broader capabilities without requiring significant architectural changes.

Currently, in public preview, SQL Database in Fabric isn’t yet production-ready. However, I’m already seeing interest from clients who are eager to adopt it once it goes GA. The integration with Power BI and other Fabric features will make this a game-changer in the future.

The Ghost of Jacob “Power BI” Marley

Finally, let’s talk about Jacob Marley—not Scrooge’s ghostly partner but the spirit of Power BI Pro in a shared capacity. Introduced in 2015, Power BI has been a present (a gift) to businesses of all sizes, enabling them to unlock insights from their data with minimal upfront investment.

For small businesses (10-50 employees), Power BI Pro is a powerful yet accessible tool. Without needing advanced features like Spark or Databricks, these organisations can drive value from their data almost immediately. This gift has transformed how businesses approach decision-making, proving that data-driven success is achievable for everyone.

Wrapping Up – see what I did there?

Thank you, Kevin, for hosting this month’s T-SQL Tuesday and for giving me the chance to reflect on these incredible features. From the enduring impact of Availability Groups to the transformative power of Azure Managed Instance and the exciting future of SQL Database in Fabric, the Microsoft Data Platform continues to deliver gifts that keep on giving.

If you’d like to achieve business success using data but need a little help, don’t hesitate to contact me. Here’s to a festive season full of data-driven cheer!