M365Con 2027 – free online conference · 11–22 Jan 2027 · 120 sessions m365con.net

SQL

Concept

Structured Query Language, the standard domain-specific language for querying and managing data in relational database systems.

✦ CONCEPTSQLM365.FM
Title graphic: SQL (Concept)

Often discussed together

Episodes about SQL often also cover Transact-SQL (T-SQL), Microsoft SQL Server, SQL Server Management Studio (SSMS), Azure SQL Database, Fabric workspace and Row-level security (RLS).

TypeConcept

Key points about SQL

Key points about SQL from the episodes, each with its source episode:

Episodes about SQL

Episodes in which SQL is discussed:

Timeline of episodes about SQL

Articles about SQL (10)

Articles in which SQL is a topic:

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?

Copilot Studio translates plain-English questions into governed Fabric queries. Asking what revenue was by quarter returns an instant, secure answer without SQL, tickets or waiting. · From the episode: Query Microsoft Fabric in Plain English with Copilot Studio

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

Glossary

Community wiki

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.

Sources

Maintained by Mirko Peters (Microsoft MVP) · Last updated: