SQL Server 2019

05-09-2019  0 Comment(s)

consider when you deploy SQL Server 2019, you are also gaining new capabilities from the amazing work of SQL Server 2012, 2014, 2016, and 2017 including but not limited to:


  • Query Store
  • Adaptive Query Processing
  • Automatic Tuning
  • Columnstore and In-Memory OLTP
  • “It Just Runs Faster”


  • Security
  • Always Encrypted
  • Row Level Security
  • Dynamic Data Masking


  • Availability
  • Clusterless Availability Groups
  • Distributed Transactions for Availability Groups
  • Resumable Index Maintenance


  • JSON
  • Temporal Tables
  • Graph Database

Modern Platform

  • Linux and Containers
  • Machine Learning Services with R and Python

Furthermore, I found customers were looking to solve these challenges to use a modern data platform:

  • Deploy a Mixture of SQL Server 2008, 2014, and 2016 servers
  • Expensive ETL applications for data sources outside of SQL Server
  • Should we use “Big Data” technologies?
  • Query performance tuning expensive
  • Some database applications suffer from I/O performance
  • Need data secure end-to-end with classification and auditing
  • Applications need better availability and less downtime
  • Our company uses a mixture of different operating system platforms
  • Popularity of containerized applications growing
  • What, when, and how should I migrate to the cloud?
  • Desire to build more intelligent applications with AI and Machine Learning

SQL Server has solutions for all of these and there is also a way to get all of these capabilities in the cloud with Azure in different forms.

Sam Analytiks motivates, educates and proliferates data for any organisation as a non-profit partner. If you or any of your team member needs a help, surely our consultants will be glad to help you in any case.

Call us at +48-729473572 or email us at
#data #datavisualisation #datamodelling #datamart #powerbi #sql #excel #powerquery #azure #azureanalysis 

Comment Here


No Comments to Show