Episode 29: You Thinking What I Am Thinking?

Episode 29: You Thinking What I Am Thinking?

We each have our way of going about things–this is what makes us unique. When it comes to getting data out of the database, many times we might think that SQL Server would go about getting data the same way we would. If you think about scanning a Microsoft Excel document, how would you find the record you are looking for? How does that differ from SQL Server?

My guest for this episode is Brent Ozar and we chat about internals and how SQL Server processes your request and what you need to consider as SQL Server returns your result.

Our show notes for today's episode are available at http://sqldatapartners.com/2016/02/03/sqlserverthinks/

Avsnitt(287)

Episode 279: SQL Server Migrations Demystified

Episode 279: SQL Server Migrations Demystified

If you use SQL Server, you will eventually have to migrate that instance somewhere – to a new version, a new server, the cloud . . . somewhere. Or perhaps you'll find yourself migrating from another d...

20 Sep 20241h 3min

Episode 278: Running SQL Server on Azure VMs

Episode 278: Running SQL Server on Azure VMs

Can you run SQL Server on Azure VM? Which VM is best? Is running SQL Server on a VM in Azure the right choice? Find out in this insightful episode with Anders Pedersen! With over 10 different SQL Serv...

30 Juli 20241h 4min

Episode 277: PostgreSQL for the SQL Server Crowd

Episode 277: PostgreSQL for the SQL Server Crowd

Is testing out pgAdmin on your to-do list? In this episode of the podcast, we chat with Ryan Booz, a PostgreSQL advocate at Redgate, about how a SQL Server professional might begin a dive into Postgre...

15 Juli 20241h 2min

Episode 276: Dynamic SQL and Testing in Isolation

Episode 276: Dynamic SQL and Testing in Isolation

Listener beware! This episode is full of danger as we tackle an interesting use case for Dynamic SQL. Dynamic SQL generally has a bad reputation in SQL Server circles, and with good reason. Dynamic SQ...

21 Maj 202441min

Episode 275: Machine Learning and Power BI

Episode 275: Machine Learning and Power BI

What kinds of problems are organizations solving with Machine Learning? In this episode, we explore a situation where a public works department was looking for more accurate information to predict fut...

16 Apr 202444min

Episode 274: A CMM Case Study

Episode 274: A CMM Case Study

After discussing the Capabilities Maturity Model in our last episode, it was fate when Andy Levy reached out and suggested a topic which sounds like a case study about his experience with CMM. As the ...

22 Feb 202451min

Episode 273: The Capability Maturity Model for Data Professionals

Episode 273: The Capability Maturity Model for Data Professionals

Have you ever felt stuck in a rut, repeating the same tasks, while knowing there is room for improvement? The Capability Maturity Model may be a way for you to start contributing to those improvements...

2 Feb 202455min

Episode 272: Performance Tuning Scripts

Episode 272: Performance Tuning Scripts

Do you find yourself repeating the same actions when pulling SQL Server performance metrics? Performance tuning a troublesome SQL Server can be a challenge. Luckily the community continues to produce...

10 Jan 202450min

Populärt inom Utbildning

rss-bara-en-till-om-missbruk-medberoende-2
historiepodden-se
det-skaver
alska-oss
harrisons-dramatiska-historia
nu-blir-det-historia
not-fanny-anymore
rss-foraldramotet-bring-lagercrantz
roda-vita-rosen
johannes-hansen-podcast
rss-viktmedicinpodden
sektledare
sa-in-i-sjalen
i-vantan-pa-katastrofen
rss-max-tant-med-max-villman
rss-sjalsligt-avkladd
rib-podcast
rikatillsammans-om-privatekonomi-rikedom-i-livet
allt-du-velat-veta
rss-relationsrevolutionen