Javier has more than 18 years working with SQL Server on every version from 6.5 to SQL Server 2019, Including SQL Azure Database and SQL Azure Managed Instance. Javier Villegas is a Database Administrator Manager for Mediterranean Shipping Company. “This concept of notebooks is really great in where you can encapsulate your whole set of scripts in only one notebook and then share it with everybody, including the results.” Listen to LearnĠ2:50 Big Data Clusters is the star of the showĠ6:19 Soon, SQL Server will run everywhere, on any deviceĠ8:07 The three pillars of this version are performance, security and availabilityġ5:09 Intelligent Query Processing doesn’t rely on Query Storeġ6:33 Big improvements related to memory grant feedbackġ9:39 Approximate Count Distinct has a 3% variation but so much fasterĢ3:12 How to find out if you can use these new featuresĢ5:06 Rollback is much faster with Accelerated Database Recoveryģ3:47 A bunch of other new and improved features, including notebooksĤ2:02 Closing Thoughts About Javier Villegas
“In this particular version, they are focusing very heavily on three pillars: performance, security and mission-critical availability.” Every time that you get into a major SQL Server version, you say, ‘come on, what’s left?’” “It’s been a journey to get into SQL Server 2019. This just means we need a few more episodes to dig into more features. We spoke about some of the Polybase changes in Episode 180 and in this episode Javier Villegas guides us as we dive into some of the performance enhancements–and run out of time. While at first glance, it appeared this release was all about Big Data Clusters, and rightfully so–it brings ‘cloud first’ options to on-premises scenarios however, it is not the only big feature. Getting released just before the end of the year, SQL Server 2019 is now available in general release.
0 kommentar(er)
