The Data Massagist The Data Massagist by Pablo Junco

Filter by

6 Articles match the selected category: MS SQL


Scaling Databases Is Easy. Architecture at 100TB Is Not.

Scaling Databases Is Easy. Architecture at 100TB Is Not.

Modern data architecture is shifting from isolated systems to converging platforms. While every cloud provider can scale beyond 100TB, the real differentiation is how organizations achieve that scale—without redesigning applications, adding complexity, or creating technical debt. Enterprise architectures typically fall into three models: operational scale (single-database abstraction like Azure SQL Hyperscale), distributed scale (Cosmos DB-style partitioned systems), and analytics/AI platforms (Microsoft Fabric, ADLS, Synapse), which are not transactional databases but data platforms for intelligence at petabyte scale. Microsoft is increasingly unifying these layers through Fabric’s emerging database capabilities, while the industry is converging in parallel, with players like Databricks extending into operational workloads via Lakebase. The core shift: boundaries between operational, distributed, and analytics systems are disappearing, and architecture—not scale alone—now defines business success.

Read it Now

MS Fabric MS SQL

Building a Fabric Data Agent with On‑Premises SQL Server Data

Building a Fabric Data Agent with On‑Premises SQL Server Data

Organizations can keep on-premises SQL Server systems while enabling modern AI by using Microsoft Fabric. Data is continuously mirrored into OneLake, avoiding complex ETL and enabling real-time analytics without disrupting operations. A key requirement is building a strong semantic layer that defines business meaning, ensuring accurate, governed AI insights. Fabric Data Agents then provide natural-language access to this curated data via tools like Copilot. This architecture separates operational and analytical workloads, improves scalability, and enforces governance. The result: faster insights, reduced maintenance, and trusted AI-driven analytics—while preserving existing systems and modernizing incrementally.

Read it Now

Data Agents MS Fabric MS SQL

100+ Articles, One Hub and, FabCon Recap

100+ Articles, One Hub and, FabCon Recap

Edition #8 of The Data Massagist marks two milestones: the launch of thedatamassagist.com and key takeaways from FabCon / SQLCon Atlanta 2026. The new website centralizes 100+ articles from LinkedIn, Forbes, and other platforms into a curated, category-driven experience with AI-generated summaries—built as a hands-on coding project with the author’s 11-year-old son. FabCon/SQLCon highlighted a strategic shift toward convergence: Microsoft Fabric as the data and AI control plane, Azure Databricks as a complementary execution engine, Purview as the governance backbone, and SQL as a modern, AI-ready foundation. The core message: fewer platforms, stronger integration, and architecture focused on outcomes, trust, and intelligence.

Read it Now

Databricks MS Fabric MS SQL Newsletter

Fueling Generative AI's Potential through Databases

Fueling Generative AI's Potential through Databases

Generative AI enables machines to create human‑like text, images, and code, but its true potential depends on strong data foundations. SQL databases provide reliable, structured data and transactional integrity, while NoSQL databases offer flexibility, scalability, and support for unstructured data crucial to AI workloads. Generative AI often benefits more from NoSQL stores, as they handle vectors, embeddings, and real‑time data efficiently, though some SQL engines like PostgreSQL also support AI‑friendly features. Together, SQL and NoSQL form a complementary data ecosystem that fuels innovation. Technologies such as Azure Cosmos DB and patterns like Retrieval‑Augmented Generation (RAG) demonstrate how unified, scalable data platforms empower enterprise‑grade AI solutions by combining structured knowledge with rich, unstructured context.

Read it Now

MS SQL

SQL Server 2022, always innovating

SQL Server 2022, always innovating

SQL Server is a flagship Microsoft product with decades of innovation, including 50+ features added since SQL Server 2012. SQL Server 2022 is the most Azure‑integrated release to date, delivering major advancements across performance, security, availability, and analytics as part of the Microsoft Intelligent Data Platform. Key features include Azure SQL Managed Instance link for bidirectional disaster recovery, Azure Synapse Link for near real‑time analytics, Microsoft Purview integration for governance, SQL Ledger for tamper‑evident data, intelligent query processing improvements, enhanced Query Store, strengthened security, contained availability groups, and multi‑write replication. Together, these innovations help organizations modernize workloads, improve resilience, and unlock greater value from their data.

Read it Now

MS SQL

Enterprises are adopting a Hybrid Cloud, why is important?

Enterprises are adopting a Hybrid Cloud, why is important?

Hybrid cloud combines on-premises and public cloud services to deliver scalable, flexible, and cost-effective IT. Cloud computing enables on-demand, self-service access to resources with elasticity to scale as needed. A hybrid cloud integrates private and public environments, allowing organizations to handle peak demand efficiently while keeping some services on-premises. Key benefits include improved agility, better business alignment, and lower total cost of ownership. Successful adoption requires using multiple cloud models—IaaS, PaaS, and SaaS—rather than relying only on infrastructure. Tools like Azure Arc help unify management across environments. Overall, hybrid cloud strategies enhance innovation, optimize resources, and support regulatory and operational needs.

Read it Now

MS SQL

Article summary by M365 Copilot


Let’s talk!
Let's have cafecito together.

If you’re a Chief Data Officer (CDO), a data leader, or simply someone who believes in the power of preparing data for AI—you’re already a Data Massagist.

Whether you have an idea, a challenge, or just want a fresh perspective, let’s connect. I’m always open to collaborating, learning, and helping others move forward.

You can find me on LinkedIn (feel free to connect and send me a message), or book time with me directly for a virtual coffee (or "cafecito").