Episode 23: IO, IO, It's Off to Tune We Go

Episode 23: IO, IO, It's Off to Tune We Go

If I were a betting man, I would wager your disk IO system is probably the biggest bottleneck in your SQL Server right now. Sure, there are lots of moving pieces, but if you can tame the IO situation, you are putting yourself in the drivers seat. So how do you go about putting together the pieces you need identify your IO constraints?

I chat with Theresa Iserman, a premier support engineer at Microsoft about some of her thoughts and why IO in general is an issue. She gives us some guidelines and even some metrics to check out. Join us in the conversation, and I'll see you on the SQL trail . . .

As always you can check out the show notes at http://sqldatapartners.com/2015/12/22/iotuning/

Jaksot(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 Loka 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 Syys 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 Syys 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 Elo 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 Elo 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 Heinä 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 Heinä 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 Kesä 20221h 1min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
psykopodiaa-podcast
voi-hyvin-meditaatiot-2
rss-valo-minussa-2
rss-niinku-asia-on
aamukahvilla
rss-narsisti
adhd-podi
rss-duodecim-lehti
rahapuhetta
aloita-meditaatio
kesken
rss-elamankoulu
koulu-podcast-2
salainen-paivakirja
rss-uskonto-on-tylsaa
rss-liian-kuuma-peruna
rss-luonnollinen-synnytys-podcast
rss-koira-haudattuna
rss-hereilla