Transact-SQL
Programming languageWikipedia
11
MENTIONS
6
EPISODES
5
PODCASTS
Search complete. 11 mentions across 6 episodes found for "Transact-SQL".
Oct 26, 2026
Mirko PetersHOST
Serverless SQL is different.
Mirko PetersHOST
It lets you use T-SQL to query files in Azure Data Lake storage without keeping a warehouse running all day.
Mirko PetersHOST
You pay for the data scanned by the query.
Mirko PetersHOST
Then there are Spark pools for data engineering, notebooks, and larger transformations.
Mirko PetersHOST
Synapse Studio gives your team one place to work, but the services remain separate parts with separate choices.
Mirko PetersHOST
That separation works well when your organization already has a mature Azure setup.
Mirko PetersHOST
Maybe your data warehouse uses detailed T-SQL patterns your SQL team knows inside out.
Mirko PetersHOST
Maybe you need to size warehouse compute for a predictable overnight load.
Don SullivanHOST
After I was a math and science teacher, after my athletic career, in 1994, I did my graduate work in Arizona in the study of the RDBMS.
Don SullivanHOST
Specifically, my thesis was on comparing what was then called PL SQL in Oracle 6 version to Transact SQL, which was a site-based version, and some of the major distinctions of that.
Don SullivanHOST
And believe it or not, the content of that particular study excuse me, thesis is actually still relevant.
Don SullivanHOST
So Oracle themselves started in about 1978 as Project Oracle.
Mirko PetersHOST
The commands you'd learn for any one of them carry over to the others.
Mirko PetersHOST
So the T-SQL you write once tends to work across all three.
Mirko PetersHOST
It's also a managed service, which means there's no server for you to patch and no version to install.
Mirko PetersHOST
You open a Fabric workspace, create the database the same way you'd create any other item, give it a name, and it's ready to use.
Mirko PetersHOST
why it feels like Azure SQL and where it doesn't.
Mirko PetersHOST
If you've touched Azure SQL Database before, this will feel familiar in the best way.
Mirko PetersHOST
It's the same engine, the same T-SQL, and the same tools.
Mirko PetersHOST
You can connect with SQL Server Management Studio, the MS SQL extension for Visual Studio Code, or the SQL CMD command line.
Troy HuntGUEST
Option two is remove all the data you have about me, but keep the email address, and any time you see new data associated with this email address, don't load it.
Troy HuntGUEST
So every time data gets loaded now, literally one of the conditions on the TSQL statement is don't insert this record if this person has been flagged as no more breaches.
Troy HuntGUEST
And then the third option is just delete everything you have on me, but that means that we no longer know that you don't want us to have stuff about you.
Troy HuntGUEST
I was just
speaker_0NARRATOR
Yes, it is so
Brent OzarHOST
easy to write T-SQL code that returns the wrong result.
Brent OzarHOST
And I don't mean just like with NOLOC.
Brent OzarHOST
I mean that calls the wrong functions, has the wrong joins, doesn't understand what profit or tax means.
11 MINS LATER
Brent OzarHOST
Next up, Reviewbombed says, Torsten says, code review is dead because humans can't find bugs in AI-generated code fast enough.
Brent OzarHOST
Should I stop reviewing the T-SQL that my developer's LLM tools generate, or is the database the one place where somebody needs to read every query before it hits production? I have a real opinionated answer here.
Brent OzarHOST
I think T-SQL code review has been dead and broken for a long, long time.
Brent OzarHOST
I think a lot of people have a list of like five or six things that they look for in code because they've been personally burned by those things.
Mike CarloHOST
This is so cool to me.
Mike CarloHOST
This means they're just saying the term total revenue can be defined in T-SQL and in DAX, and here's exactly how you write it on this table to tell the systems, either this would... what I would argue here, this is going to be a consumption for the SQL database.
Mike CarloHOST
It's going to be the consumption for the SQL data warehouse.
Mike CarloHOST
You can say DAX and T-SQL.
Mike CarloHOST
This is huge because what this means is I can define a common metric in some generic place, AKA here with the lake house, these semantic views, and that then can be used wherever it makes sense, anywhere in any model or in any SQL database.
Tommy PugliaHOST
Huge, huge.