Transcribed
How T‑SQL Saves You From Begging IT: Safe SELECT Queries, SQL vs T‑SQL & Beating Blank Query Window Panic
Sep 25, 2025 ·
19m 39s
Download and listen anywhere
Download your favorite episodes and enjoy them, wherever you are! Sign up or log in now to access offline listening.
How T‑SQL Saves You From Begging IT: Safe SELECT Queries, SQL vs T‑SQL & Beating Blank Query Window Panic
This automatic transcript is brought to you by
Sounder.AI
This is an automatically generated transcript. Please note that complete accuracy is not guaranteed.
Description
If a blank query window in SQL Server Management Studio makes you open a ticket instead of getting the answer yourself, this episode is for you. Business users and analysts...
show more
If a blank query window in SQL Server Management Studio makes you open a ticket instead of getting the answer yourself, this episode is for you. Business users and analysts learn how safe, read-only SELECT queries, the difference between SQL and T-SQL, and careful joins let them pull their own numbers without breaking production.
In this episode
Key takeaways
Worth quoting
“And that's what most people never get told. SQL was designed to be approachable. It wasn't supposed to sound like obscure math.” – Mirko Peters (01:44)
“Bottom line, don't panic about extras. They're not roadblocks. They're optional power tools. You don't need them to pull quick answers. But when you start building repeatable processes, dashboards or anything automated, they'll earn their keep.” – Mirko Peters (07:22)
Explore more on M365.FM
Follow and rate M365.FM in your podcast app, and join the free M365 community at m365con.net.
Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.
show less
In this episode
- 00:00 – The blank query window panic
- 03:31 – T-SQL vs SQL: Microsoft's dialect
- 07:37 – The SELECT survival guide
- 11:00 – Joins and the relationship drama
- 14:45 – Mistakes that make DBAs cry
- 18:45 – Three rules and your homework
Key takeaways
- SELECT is read-only in normal use, so writing your first query to answer a business question is a safe way to learn instead of waiting in a ticket queue.
- T-SQL is Microsoft's dialect of standard SQL: the basics like SELECT, FROM, WHERE and ORDER BY stay the same, while extras such as TOP, TRY/CATCH and GO matter once you automate.
- Choose inner or left joins deliberately and avoid SELECT *, missing WHERE clauses and sorting huge unindexed tables, because those habits are what overload production databases.
Worth quoting
“And that's what most people never get told. SQL was designed to be approachable. It wasn't supposed to sound like obscure math.” – Mirko Peters (01:44)
“Bottom line, don't panic about extras. They're not roadblocks. They're optional power tools. You don't need them to pull quick answers. But when you start building repeatable processes, dashboards or anything automated, they'll earn their keep.” – Mirko Peters (07:22)
Explore more on M365.FM
- Episode page: the full episode with chapters, quotes and a short FAQ on safe queries
- Microsoft Excel – the comparison point: pivot table skills are a head start, and joins replace VLOOKUP chains
- Microsoft – maker of T-SQL, its own SQL dialect, and the documentation the episode keeps pointing to
- Related episode: R vs T‑SQL Performance: Compute Context, Batch Size, Parallel Queries & How To Fix Slow R‑SQL Pipelines
- Related episode: Copilot Studio Fabric data: stop writing SQL and let natural language query your warehouse
Follow and rate M365.FM in your podcast app, and join the free M365 community at m365con.net.
Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.
Information
| Author | Mirko Peters M365, Azure & AI |
| Organization | m365 FM |
| Website | www.m365.fm |
| Tags |
Copyright 2026 - Spreaker Inc. an iHeartMedia Company
Comments