Episode 118: How has index maintenance changed?

Episode 118: How has index maintenance changed?

After having attended PASS Summit and seeing all the new features coming it out, it can be very easy to overlook the basics--they are boring. These features have been around forever. This may be true, but they still play an important role and ignoring them won't help get you those fancy new features any time soon.

In this episode, our topic is index maintenance, with an emphasis on what has changed or what might change. Is the query store feature going to impact the way we maintain our indexes? We invite one our favorite guests, Sean McCown back to talk with us and give some of his thoughts.

The show notes from today's episode can be found at http://sqldatapartners.com/2017/11/24/index-maintenance. Have fun on the SQL Trail!

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

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
treningspodden
foreldreradet
rss-strid-de-norske-borgerkrigene
jakt-og-fiskepodden
rss-sunn-okonomi
sinnsyn
takk-og-lov-med-anine-kierulf
merry-quizmas
gravid-uke-for-uke
rss-kunsten-a-leve
hverdagspsyken
rss-kull
hagespiren-podcast
rss-var-forste-kaffe
fryktlos
rss-mann-i-krise-med-sagen
lederskap-nhhs-podkast-om-ledelse