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/

Episoder(287)

Episode 255: Automate Complex CRUD with sp_CRUDGen

Episode 255: Automate Complex CRUD with sp_CRUDGen

One of the biggest challenges with developers using object-relational mapping (ORM) tools is the bad queries or procedures they create. Sure, most tools can create CRUD (Create, Read, Update, Delete, ...

5 Okt 202228min

Episode 254: Code Smell Checks with sp_Develop

Episode 254: Code Smell Checks with sp_Develop

Would you be interested in a tool to help you do code review checks and provide developers guidance on best practices? In this episode of the SQL Data Partners Podcast, we talk with Kevin Martin, the ...

21 Sep 202229min

Episode 253: Go Mobile with Power Apps

Episode 253: Go Mobile with Power Apps

In this episode, we dive into the Power Apps offering and discuss the pros and cons of using this latest Microsoft offering. Some definitions are given and hopefully this episode can orient folks on h...

7 Sep 202235min

Episode 252: The Cumulative Update Dilemma

Episode 252: The Cumulative Update Dilemma

Knowing your SQL Server is patched when an issue occurs is worth the effort of keeping it patched. While I don't suggest a zero-day install for most folks, setting up a regular cadence to check is a r...

24 Aug 202229min

Episode 251: Azure Cognitive Services

Episode 251: Azure Cognitive Services

How can you begin to integrate AI models into your environment without spending months building everything out? As we continue our march to Episode 256, we bring back our friend Sam Nasr to talk about...

10 Aug 202241min

Episode 250: What happens before... "COMPANEROS!"

Episode 250: What happens before... "COMPANEROS!"

This episode we are doing a bit of a look back and are going to air some previously buried content. Some of the bloopers are pre-video and some of them have some physical comedy, which you'll have to...

27 Jul 202219min

Episode 249: Data Marts in Power BI

Episode 249: Data Marts in Power BI

Data marts in Power BI have arrived and the words "data mart" mean something to data professionals. In this episode of the SQL Data Partners Podcast, we introduce the latest offering in Power BI and ...

13 Jul 202227min

Episode 248: Inventory Documentation

Episode 248: Inventory Documentation

How do you keep records of your SQL Server environments? Patching levels, security accounts, configuration options, maintenance jobs and the like are some of the pieces we have to keep organized. Ar...

29 Jun 20221h 1min

Populært innen Fakta

mikkels-paskenotter
fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
foreldreradet
treningspodden
rss-strid-de-norske-borgerkrigene
jakt-og-fiskepodden
takk-og-lov-med-anine-kierulf
sinnsyn
hverdagspsyken
rss-bisarr-historie
rss-kunsten-a-leve
gravid-uke-for-uke
tomprat-med-gunnar-tjomlid
rss-kull
rss-sunn-okonomi
fryktlos
rss-var-forste-kaffe
lederskap-nhhs-podkast-om-ledelse