With old habits, even in enterprise companies SQL Server is used only for relational data storage.īesides SQL Server's new components, even new T-SQL functions are not commonly used in many enterprise level custom solutions. I will strongly suggest you all data professionals to download and evaluate new releases of SQL Server including SQL Server 2019. They bring the top 10 reasons to choose SQL Server 2019 as your unified data platform tool for future.Īs a SQL developer, I'm always interested in with new releases of SQL Server and other data platform vendors' tools. Microsoft SQL Server team has provided an infographics answering why to download and work with SQL Server 2019. Getting released just before the end of the year, SQL Server 2019 is now available in general release.I tried to summarize a few of the SQL Server 2019 features which are more related with big data and data analytics power of next generation data platform tool from Microsoft. 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. 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. This just means we need a few more episodes to dig into more features.

“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 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 Javier Villegas is a Database Administrator Manager for Mediterranean Shipping Company. 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.

Download Sql Server 2019 Full Crack