Datascape Podcast Episode 8 – SQL Server 2017 & Microsoft Data Amp

Posted in: Technical Track

Today on the episode, we are going to talk about the announcements from the Microsoft Data Amp Event (as well as the recently announced SQL Server 2017) with Warner Chaves.
Warner is a SQL DBA/Consultant at Pythian and has been working in database administration and consulting for almost eleven years. He is also a Microsoft Data Platform MVP, and continues to work with cloud-based platforms, mostly AWS and Azure.

In this episode, Warner joins us again, this time to discuss the Microsoft Data Amp 2017 event and dive into detail about all of the new and exciting announcements that were made. We dive into data migration services, the managed instance concept, today’s expectations of DBAs, and much more!

 

Key Points From This Episode:

  • Learn more about the Data Amp Event and the big new announcements that were made.
  • Find out about the Azure data migration service, moving from on-prem to the cloud.
  • Discover more about the data migration process and how it decreases friction for migrating.
  • Learn about “managed instance” and how it is implemented in the Azure SQL database.
  • Hear as Warner shares some of his most exciting features announced at the Data Amp event.
  • Find out why Warner believes DBAs only need to know the basics of R and Python.
  • Understand why Warner recommends not making a career on small scale infrastructure.
  • Learn more about Adaptive Query Processing and the impact of automatic tuning.
  • Discover the benefits and compelling reasons to upgrade SQL Server 2014 to 2017.
  • Why Warner believes that the architecture for cloud is going to be a hot commodity in the near future.

Links Mentioned in Today’s Episode:

Microsoft Data Amp 2017
Azure SQL Managed Instance, article by Warner Chaves
Datascape Podcast Episode 1
Datascape Podcast Episode 2

email

Interested in working with Chris? Schedule a tech call.

About the Author

Director of Consulting
Chris Presley loves order—making him a premier Microsoft SQL Server expert. Not only has he programmed and administered SQL Server, but he has also shared his expertise and passion with budding DBAs as SQL Server instructor at Conestoga College in Kitchener, Ontario. Drawing on his strong disaster-recovery skills, he monitors production environments to swiftly detect and resolve problems before they arise. A self-described adrenaline junkie, Chris likes tackling the biggest database problems and putting out the toughest fires—and hitting the road on his motorcycle.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *