With the announcement in September of SQL Server 2019 in public preview, we have been keeping an eye out for further information on what to expect. With the release looming, change is certainly ahead.
Here we take a look at some key trends and changes set to hit SQL Server in 2019:
- Management of big data is becoming a more integral part of SQL Server 2019 with a focus on enhanced integration and big data clusters. SQL Server environments will be better equipped to incorporate modern data processing tech and AI-enhanced apps including machine learning models using R and Python. Learn more here
- SQL Server 2019’s changes for big data, particularly data virtualization will aid DBAs efforts in managing huge data growth. Data virtualization integrates data from different sources without the need to replicate or move the data around, decreasing the time spent for DBAs. Learn more here
- Accelerated data recovery is a much-wished for enhancement which will be broadly available in SQL Server 2019. For all mission-critical systems that need to be patched regularly, or that have long-running transactions, this enhancement will be enormously beneficial. Learn more here
- SQL Server environments will continue the trend of moving to the cloud. Any DBAs who were not keen on the move will likely be reevaluating with Microsoft’s cloud-based development model and its cost and scalability benefits outweighing other concerns. Learn more here
- The continued growth of SQL Server on Linux, as Microsoft brings enhancements there. More businesses are also likely to evaluate the benefits of moving SQL Server environments into containers. Learn more here
The preview is available for trial, and you can get more details of that here.