Trascritto
How T‑SQL Saves You From Begging IT: Safe SELECT Queries, SQL vs T‑SQL & Beating Blank Query Window Panic
25 set 2025 ·
19 min. 39 sec.
Scarica e ascolta ovunque
Scarica i tuoi episodi preferiti e goditi l'ascolto, ovunque tu sia! Iscriviti o accedi ora per ascoltare offline.
How T‑SQL Saves You From Begging IT: Safe SELECT Queries, SQL vs T‑SQL & Beating Blank Query Window Panic
Questa trascrizione automatica è offerta da
Sounder.AI
Questa è una trascrizione generata automaticamente. Si prega di notare che non è garantita la completa accuratezza.
Descrizione
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...
mostra di più
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.
mostra meno
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.
Informazioni
| Autore | Mirko Peters M365, Azure & AI |
| Organizzazione | m365 FM |
| Sito | www.m365.fm |
| Tag |
Copyright 2026 - Spreaker Inc. an iHeartMedia Company
Commenti