SQL Server 2025: AI With Your Data at No Ongoing Cost

by Ginger Grant | August 28, 2026

Ginger Grant explains how SQL Server 2025 brings retrieval-augmented generation directly into the database, enabling organizations to ground AI on their own data entirely on-premises, without recurring cloud costs or exposing sensitive information outside the network. Vector search and embeddings solve a key limitation of traditional SQL by allowing semantically related terms—such as “quiet” and “low noise,” or “camera” and “webcam”—to be matched even when users do not know the exact schema or wording. Grant outlines a practical implementation using local tools like Ollama, Caddy, and SQL Server’s preview AI features, showing how to create embeddings, build vector indexes, and query them with natural-language similarity search. The overall message is that SQL Server 2025 makes enterprise AI more accessible, private, and cost-effective for managers and developers.

Read Post...

How to Validate Microsoft Fabric CI/CD Deployments Using SQL Server 2025 and SSMS 22

by Ginger Grant | July 31, 2026

Ginger explains how SQL Server 2025 and SSMS 22 can help teams validate Microsoft Fabric CI/CD deployments by addressing a common gap in migration workflows: deployment tools move Fabric objects such as lakehouses, warehouses, and SQL databases between Dev, Test, and Production, but they do not automatically move the underlying tables, views, stored procedures, or metadata. She shows that by using SSMS 22 schema comparison through SQL endpoints, teams can compare environments, identify missing database elements, and generate scripts to recreate them as part of an automated release process.

Read Post...

Cut Your Fabric MCP Costs: Why I Switched from GitHub Copilot to Claude Code

by Ginger Grant | July 1, 2026

Since GitHub Copilot's June 1 pricing shift to metered tokens, Ginger compares VS Code and Claude Code for working with the Fabric MCP Server. She breaks down setup steps, pricing, model options, and Fabric Capacity CU usage, explaining why Claude Code came out ahead on cost and simplicity.

Read Post...

MCP: The Open Standard Turning AI Chatbots Into AI Agents

Ginger Grant | 5/29/2026

Ginger Grant explains that Model Context Protocol (MCP) is the open standard enabling AI to move beyond chat and into agentic execution of real workflows. Rather than being an AI model itself, MCP provides a common way for LLMs, apps, and external systems such as GitHub, SQL Server, Microsoft Fabric, and Microsoft 365 to communicate through secure, standardized servers and tools. Grant highlights how MCP can streamline developer and analyst work by chaining tasks—such as creating lakehouses, querying databases, or generating pull requests—within familiar environments like VS Code or Copilot.

Read Post...

Plan: The Most Interesting Thing That Came Out of Microsoft Fabric Community Conference in April 2026

Ginger Grant | 4/24/2026

Microsoft unveiled **Plan** at FABCON — now the second-largest tech conference with 8,000 attendees — as a standout Fabric feature for budget and project planning. Born from a 2024 partnership with Lumel's EPM tool, Plan lets users import data from semantic models or Excel, apply machine learning to forecast outcomes, run what-if analyses, and validate projections against historical data. Available to all Fabric license holders, it offers a compelling reason to adopt the platform.

Read Post...

Cloud Data Transformation in Fabric with Medallion Architecture

Ginger Grant | 2/27/2026

Ginger explores how medallion architecture addresses the limitations of legacy ETL (Extract, Transform, Load) processes to meet the demands of modern data science, AI, and analytical workloads. She highlights the brittleness of traditional ETL pipelines, which often resulted in lost data, poor governance, and untestable transformations, and contrasts this with the multi-layered medallion approach. The architecture organizes data into bronze (raw data), silver (validated and transformed data), and gold (analysis-ready data) layers, ensuring robust governance, scalability, and trustworthiness. Grant emphasizes the importance of testing processes, securing sensitive data, and collaborating with stakeholders to meet organizational needs.

Read Post...

Do I Need a Database Anymore?

Ginger Grant | 2/2/2026

Are traditional databases necessary in 2026? Advances in storage compression, memory interfaces, and AI-powered retrieval have reduced reliance on costly databases that require extensive maintenance and tuning. Microsoft Fabric offers a transformative alternative, providing four flexible storage options that handle massive datasets using open-source Parquet files at lower costs than traditional cloud databases. Maybe your organization should consider adopting Fabric for future-ready, cost-effective data infrastructure.

Read Post...

What Happened to Power BI?

Ginger Grant | 12/29/2025

Ginger Grant explains that Power BI remains a healthy, actively developed product despite recent licensing changes and Microsoft's emphasis on Fabric; you can still use Power BI standalone, but Fabric provides compelling benefits for organizations that need scale, real‑time performance, and more modular development. By moving data engineering, security, and storage into Fabric’s OneLake and using features like Direct Lake, teams gain near‑instant, scalable reporting, better pipeline and notebook workflows, improved monitoring and validation, and easier collaboration than traditional Power Query approaches. In short, Fabric is not required, but it materially enhances Power BI for enterprise scenarios.

Read Post...

Microsoft Fabric: The New Method for Organizing Data in the Azure Cloud

Ginger Grant | 11/1/2025

Ginger Grant presents Microsoft Fabric as a unified, modern solution for organizing and centralizing organizational data in the Azure cloud (and beyond) with dramatically simplified setup and governance. She explains how Fabric replaces the traditional mix of disparate tools (Data Factory, Databricks, Data Lake, IoT/Event hubs, and databases) with a single, configurable resource that orchestrates data from multiple sources—including multi-cloud and Snowflake—through seamless referencing or mirroring rather than heavy data import. Fabric includes broad tool compatibility (PySpark, T-SQL, Power Query, notebooks) and a predictable fixed-hourly pricing model, plus a centralized storage layer called OneLake. Overall, Fabric addresses complexity, cost, and collaboration challenges by delivering an integrated, cross-provider data platform.

Read Post...

Self-Service Reporting: Setting Up Successful Reporting for Everyone

Ginger Grant | 10/7/2025

Ginger makes the case for giving business users the tools to create their own reports. When IT controls all data access, teams often resort to inefficient workarounds that create security risks and waste time. She shows how Microsoft Fabric and Power BI can solve this problem by giving users secure, well-governed access to the data they need. With the right setup, people can build their own reports without sacrificing data quality or creating chaos. The result? Less waiting on IT, more consistent data across the organization, and faster, smarter decisions.

Read Post...

The Strategic Case of Open-Source Data Engineering

Ginger Grant | 8/29/2025

Ginger explores how companies can break free from the expensive 10-year cycle of proprietary data transformation tools by embracing open-source technologies like Python and Spark, which Microsoft Fabric now fully supports through its adoption of vendor-agnostic approaches and Medallion Architecture.

Read Post...

When Database Alternatives Make Business Sense: A Microsoft Fabric Perspective

Ginger Grant | 7/31/2025

Ginger Grant examines the transition from traditional databases to Microsoft Fabric's analytics-focused architecture. Fabric uses Delta Parquet files in scalable lakehouses and warehouses, supporting familiar tools like T-SQL and Power BI while adding AI-powered natural language queries. While databases excel at fast transactions, Fabric offers cost-effective, petabyte-scale analytics with integrated AI tools, making it ideal for organizations prioritizing data analysis over transactional processing.

Read Post...

Turning Data into Information with Fabric

Ginger Grant | 7/2/2025

Microsoft Fabric addresses the challenge of data silos by creating OneLake, a unified data lake that consolidates organizational data from multiple applications like CRMs, HR systems, and accounting software. The platform transforms fragmented data into actionable information through shortcuts, real-time database mirroring, and integrated analytics tools. By combining lakehouse and warehouse structures with security controls, Fabric enables organizations to achieve a single version of truth for data-driven decision making across Power BI, Excel, and other Microsoft tools.

Read Post...

Unlocking the Promise of Data-Driven Decisions: Why Microsoft Fabric Can Succeed Where Legacy Systems Failed

Ginger Grant | 5/30/2025

Ginger Grant examines the challenges organizations face in transforming data into data-driven decision-making. Despite the pervasive availability of data, many companies have struggled with disjointed systems and inaccurate data, leading to failed AI implementations and ineffective decision-making. Microsoft Fabric, supported by Azure's cloud capabilities, addresses issues inherent in past data solutions, including integration, storage, and visualization, to provide a cohesive approach for data-driven insights. Microsoft Fabric stands out with its open standards, low-code tools, and interoperability with platforms like AWS, Google Big Data, and Snowflake, making it accessible for diverse organizational needs. Ginger thinks Microsoft Fabric is a game-changer that can help companies connect, clean up and organize data, leading to intelligent business decisions through streamlined data processes. Future posts in this series will discuss the business considerations in how to connect the data using Microsoft Fabric to get to data-driven decision-making.

Read Post...