Because so much data is formatted as JSON, it’s critical for SQL Server to process JSON text retrieved from other systems, and to format information retrieved from SQL Server tables as JSON text. JSON is the common format when semi-structured information needs to be stored, such as in files. JSON is one of the most widely used data exchange formats, with most modern services returning information as JSON text, and web browsers using information formatted as JSON. Microsoft announces major commitment to Apache Sparkīack in June last year, we announced an extensive commitment for Spark to power Microsoft’s big data and analytics offerings, including Cortana Intelligence, Power BI, and Microsoft R Server. Preview the newest ODBC SQL Server Driver for Windows and LinuxĮarly last year, we announced our community technology preview of Microsoft ODBC Driver 13 for SQL Server on Windows and Linux, supporting Ubuntu, RedHat and SUSE distributions, providing robust data access to Microsoft SQL Server and Microsoft Azure SQL Database via ODBC on Windows and Linux platforms. While it doesn’t attempt to use every single feature (as that would be unrealistic!) it does showcase a variety of key SQL Server 2016 capabilities and performance enhancements. The new Wide World Importers sample illustrates how the rich feature set of SQL Server can be used in a real world setting.
Besides, it was time for an upgrade of the erstwhile AdventureWorks database, which had a good run for over a decade. We figured a major release of the magnitude of SQL Server 2016 deserved its own new sample database. WideWorldImporters: The new SQL Server sample database Developers can now build to a common programming surface across all editions – and do tons more, see the graphic below or read the full article for more.Ĩ. SQL Server 2016 Service Pack 1 generally availableĪ couple of months back, we made several new capabilities available as part of the SP1 release of SQL Server 2016.
In October, we announced the public availability of SQL Server 2016 Express Edition in Windows Containers, a capability that comes in especially handy when you need to quickly create SQL Server instances for development or testing or to maximize density in a test or production environment (especially in microservice architectures) or when you need to isolate and control apps in a multi-tenant infrastructure. SQL Server 2016 Express Edition in Windows containers Here are the posts that got the most number of views from our readers during 2016, in increasing order of readership:ġ0. We start off the new year with a quick recap of our most popular posts on this blog channel from the year just concluded.
0 kommentar(er)
