![]() ![]() Developers can now execute R, Python, and Java code from SQL Server scripts and stored procedures.It now supports UTF-8 character encoding.Store big data in HDFS managed by SQL Server.The TempDB can now be configured as a memory-optimized database (using SQL Server’s In-Memory OLTP technology), to vastly improve performance.Improved query optimizer to allocate more resources during query processing.There are definitely some new and powerful features in SQL Server 2019: While it doesn’t replace the power of SQL Server Management Studio (SSMS), it does offer some serious capabilities you won’t find in SSMS. It is essentially a cross-platform database tool for on-premises and cloud data platforms that can be used on Windows, MacOS, and Linux endpoints. This new cross-platform tool can be used for T-SQL querying, notebook development, running Spark jobs on BDC deployments, etc. ![]() Microsoft provides a tool named Azure Data Studio (works with all supported versions of SQL Server 2014 – SQL Server 2019) to do some of this new work. This also allows the BDC master node to communicate with the BDC compute, plus data and storage pools, to allow the nodes in the storage pool to connect to data in the co-located HDFS storage. While PolyBase can connect to Hadoop clusters and Azure storage, this new version can now also connect to other SQL Server instances. ![]() The new version takes the important capabilities we have admired in previous releases and expanded them to leverage data virtualization with PolyBase and combine Kubernetes with its container compatibility. At its Ignite conference in Orlando last week, Microsoft released a new version of its core relational database, SQL Server 2019. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |