Video

Rob Collie starts 16min in and is in English

16:15 calculate - your best new friend. Sometimes debatable.

groundbreaking. Though it is a joke only ~ 3000 views

great lecture still we passed 10 years but the lecture get super and it made easy understand architecture great simple a fan made comment

not good. most of the time i see drop and create table code. this is a waste of time. you should focus more on query.

loved it

42:49 Does that mean that the Cmd Parser is the one in charger of looking up the cache plan for matchinf execution plans for the received query?

I'm starting with T-SQL with his book and it's great, I'm glad I found the author on CZcams video. (I start 2 LOVE T-SQL) I KNEW SOMETHING ABOUT sql, BUT I'VE BEEN THOROUGHLY SUBMERGED WITH t-sql for two weeks. Gracias Itzik Ben !!!!

Great session Brent! Thanks 🙂

Hi Kevin.... I told my son I can make pal with you by database reply me

Thanks, Kevin, for taking the time to make it easy to digest.

Awesome stuff

Absolute amazing!!!!

I can't thank you enough for letting me get a grip on this awesome cross apply....Thanks a lot !!!

Very goo content

I have covered one session abt ARCHITECTURE

Good one 👍

Excellent. I liked the "A), 2) and III)" summary for the business. Big brother Buzz, in "Home Alone," used "A) 2) and D)" to summarize why he didn't think anything bad would happen to Kevin while home alone.

Wow! This has just blown my mind. This is literally just poetry how this master just spews out clean, effective and beautiful code 😱

APPLY Operator provides great job security. Almost noo one will be able to understand what you wrote :)

cant hear the questions.

very meaningful. must see.

GOOD STUFF. THANKS FOR SHARING!! Though didn't find it related to many to many in DAX

Thanks a lot sharing this. Love For Gail from 🇦🇪

The questions are kind of stupid.

Thank you Brent Ozar

Really helpful, thanks.

Perfecte uitleg, alles is klaar en duidelijk!

Hi Kevin, I wanted to know any co-relation between the removal of any plan from the plan cache and the corresponding data present in the buffer cache. While removing the plan from the plan cache by the lazy writer does it also perform any action to remove the corresponding data page from the buffer cache. What if happens if there is plan in the plan cache but not present in the buffer cache.

Awesome session... What happens to the data in the transaction log and has not been written to the disk (mdf). if in that mean time the server crashes?

One of us is seriously confused about what Atomic and Consistent mean. Atomic doesn't remotely mean that a transaction "doesn't do multiple things"; it means that the entire transaction goes as an indivisible unit--precisely so that, if you want to do more than one thing (debit one account and credit another), it either all happens or none of it does. Consistent doesn't mean a transaction does the same thing every time you run it, but that the database transitions from one relationally-consistent state to another. It has nothing to do with repeatability. I'm hoping this gets a lot better, fast. The first two substantive things he said about databases seem to be flat-out wrong.

Hi kevin what is the actual job of query executor?

First words that came to my mind about this video were "Awesome", then "Brilliant", but I see others have used those adjectives already. "Stupendous" maybe. Thanks.

Did he say ACID?

Awesome!

Hi Alberto, greetings and thanks. I have a couple DAX tables in my model. How can I view the DAX code of those tables in DAX Studio? I can't click it out. I know I can paste it from Power BI. Is it possible to list it without copy paste method?

Super cool. Before doing the indexed view, would it also be (potentially) useful to look at the distribution of vote count per post? Idea: if there are a large number of posts with say only 1 vote, those posts couldn't possibly meet the HAVING aggregate condition, and thus could be WHERE'd out from the get-go.

Where is query performance tuning?

Wow. I learned a lot

Great video, my only suggestion would be to include an ambient mic to pickup the audiences' energy and reactions to Brent too :)

Brent you're the best!

00:40 Just one second; your wife knows you either talk a lot about SQL Server, or you know a lot about that. Assuming she doesn't know a lot about SQL Server - and that is a guess - we can conclude she cannot confirm Brent knowing a lot. Because if you don't know yourself, you cannot judge somebody else's knowledge. Which means that the knowing part is not true, and since one is true, Brent must be talking a lot about SQL Server. I guess the words SQL and Server would pass quite regularly.

Thanks Alberto ! Where can I get the source data used in this demo?

Great video. Thank you!

Very engaging. I get it when HE says it.

this guy is great! Great presentation, and great info!

Conclusions: DAX is not easy to optimize, Test,test,test, Never trust simple rules. =))

Excellent session. Thanks a lot, Brent!

Thank you Kevin, this is very helpful.

Awesome content and very well presented, thanks!