people often hear the words sql and t-sql thrown around as if they’re interchangeable, and for a while they feel like they are. you write a query, you get your results, and everything seems straightforward. but the deeper you go into database work, the more…
Your company isn’t blocked by data—it’s blocked by syntax. Copilot Studio turns plain-English questions into governed Fabric queries, so “What was our revenue by quarter?” finally gets an instant, secure answer—no SQL, no tickets, no waiting. It’s not a…
In this episode, we dive into Microsoft Fabric, the unified data and analytics platform reshaping how organizations manage, analyze, and act on their data. Designed to bring Power BI, Data Factory, Azure Synapse, and other Microsoft services into one…
LINQ to SQL remains one of the most approachable ways to query and manipulate relational data in .NET, and in this episode we break down exactly how it works, why it’s so powerful, and how it simplifies database interaction compared to traditional SQL and…
Your Copilot sounds smart but secretly knows nothing about your business. It’s guessing from Wikipedia while your real memory—orders, invoices, inventory—sits locked in SQL Server behind the firewall. This episode exposes the fix: the Power Platform Data…
Learn what a Fabric SQL Database is, how it compares to Azure SQL, how mirroring works, and how it powers your analytics without extra pipelines. Fabric and SQL sound like two different things, but Microsoft built them into one. It's called a SQL database in…
Everyone says SQL is obsolete. This episode argues the opposite: SQL has never mattered more—because modern data platforms removed the guardrails that used to hide its importance. In systems like lakehouses and Fabric, T-SQL didn’t disappear; it moved…
Most teams still treat Azure SQL as passive storage behind the application. In this interview, Dirceu Resende shows data engineers and architects how Azure SQL Database can call REST APIs, automate workflows and support AI with vector search. You learn where…
In this episode of the M365.FM Podcast, the discussion focuses on a critical shift happening in cloud security: the collapse of the traditional network perimeter. The episode explains why Azure SQL firewall rules, static IP allowlists, VPN-based trust models…
In this episode, we dive into how R and SQL Server work together to create a powerful data analytics workflow. You’ll learn why SQL Server excels at storing, organizing, and retrieving large datasets, while R specializes in statistical analysis…
In this podcast, the speakers discuss performance optimization strategies for data flows and SQL queries, focusing on tools like the Monitoring Hub, DMVs, and Query Insights. The conversation emphasizes the importance of monitoring key metrics, such as…
Microsoft Fabric Apps are a new way to build modern, data-driven web applications directly inside Microsoft Fabric. Rather than managing servers, APIs, databases, authentication, and hosting separately, Fabric provides these services automatically, allowing…
Mastering the Microsoft Fabric Monitoring Hub · Mirko Peters When I first plunged into Microsoft Fabric, the complexity was daunting. I spent hours combing through logs, convinced there was a "magic pill" that would streamlin…
Mastering CRUD Operations and Change Tracking in LINQ to SQL · Mirko Peters Welcome back to the podcast! Today, we are expanding on our recent discussions about data access strategies. If you want to catch up on the foundational debates sur…
Conquering the N+1 Query Problem Once and For All · Mirko Peters Welcome back, fellow developers! If you have ever built an application using Entity Framework Core, chances are you have run into performance roadblocks that left y…
Frequently asked questions
What is the difference between SQL and T-SQL?
SQL is the standard language all relational databases share, while T-SQL is Microsoft's extension used with SQL Server and Azure SQL. T-SQL adds procedural features such as IF...ELSE, WHILE and TRY...CATCH. · From the episode: SQL vs T-SQL: Key Differences for Microsoft Data Teams
What does T-SQL add to standard SQL?
It adds procedural tools like IF...ELSE and WHILE for controlling workflows, and TRY...CATCH for managing exceptions. These let you build logic inside the database rather than only selecting and changing data. · From the episode: SQL vs T-SQL: Key Differences for Microsoft Data Teams
When do the differences between SQL and T-SQL matter?
They matter once you work with Microsoft SQL Server or Azure SQL, where T-SQL becomes its own world. Knowing them is the key to building things that are faster, safer and smarter. · From the episode: SQL vs T-SQL: Key Differences for Microsoft Data Teams
How can you query Microsoft Fabric in plain English?
Does plain-English querying bypass data permissions?
No. The queries are governed and permissions are respected, so users only get answers they are allowed to see. That keeps the instant answers secure even though no SQL is written. · From the episode: Query Microsoft Fabric in Plain English with Copilot Studio
Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.
Experts and companies for this topic
Nobody has listed this topic yet. Add it to your profile.