DiscoverChannel 9How Resumable Indexes in SQL Server 2019 Makes Your Job Easier | Data Exposed
How Resumable Indexes in SQL Server 2019 Makes Your Job Easier | Data Exposed

How Resumable Indexes in SQL Server 2019 Makes Your Job Easier | Data Exposed

Update: 2020-08-04
Share

Description

Microsoft continues to push the envelope on feature capabilities with every release of SQL Server.  One of the more prominent features that was released with Microsoft SQL Server 2019 is the ability to resume or throttle certain index operations. Have you ever want to just stop and then resume an index operation picking up where it left off?  Now you can! This feature alone magnifies the data professionals ability to have deeper granular control on how index operations affect their ecosystem as well as their work-life balance.  In this episode, John Morehouse gives a high-level look at how this feature works and how it can be applied seamlessly to your environment.
 
Resources:
Denny Cherry & Associates

About John Morehouse:
John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server.  He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, 2016 Idera Ace, Friend of Red Gate, Sentry One PAC member & Community Ambassador.  John has a passion around speaking, teaching technical topics and giving back to the technical community as much as possible.  He is a user group leader, SQL Saturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQL Saturday's as well as other conferences.  If you want to find John, you can find him on Twitter (@sqlrus) or on his blog.

About MVPs:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram



Comments 
In Channel
loading
Download from Google Play
Download from App Store
00:00
00:00
x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

How Resumable Indexes in SQL Server 2019 Makes Your Job Easier | Data Exposed

How Resumable Indexes in SQL Server 2019 Makes Your Job Easier | Data Exposed

Anna Hoffman, Marisa Brasile