Sites Microsoft


Cumulative Update #3 for SQL Server 2017 RTM

Publié le 10 janvier 2018 sur microsoft sql server release services
 

The 3rd cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release, please visit: …

Compatibility Level 140 is now the default for Azure SQL Database

Publié le 10 janvier 2018 sur Microsoft SQL Server database engine blog
 

Database compatibility level 140 is now the default for new databases created in Azure SQL Database across almost all public regions.    As of this writing, there are already 539,903 databases in Azure SQL Database running in compatibili …

Database scoped optimizing for ad hoc workloads

Publié le 4 janvier 2018 sur Microsoft SQL Server database engine blog
 

SQL Server provides the “optimize for ad hoc workloads” server-scoped option that is used to reduce the memory footprint of single use ad hoc batches and associated plans.  When enabled at the SQL Server instance scope, the “opti …

Azure Log Analytics (OMS) Agent now collects SQL Server audit logs

Publié le 28 décembre 2017 sur sql server security blog
 

We are happy to inform that the Azure Log Analytics (OMS) Agent is now capable of pushing SQL Server audit logs into Azure Log Analytics (OMS), supporting SQL Server both on-premises, as well as on Azure VMs. The Azure Log Analytics (OMS) platform can …

Injecting JSON objects into existing JSON text with JSON_MODIFY function

Publié le 22 décembre 2017 sur Microsoft SQL Server database engine blog
 

JSON_MODIFY function that is available in SQL Server 2016+ enables you to modify existing text formatted as JSON and add or update existing values. One common problem that happens is inserting unexpected value while trying to update existing JSON text …

Transitive closure clustering with CLR and JSON

Publié le 20 décembre 2017 sur Microsoft SQL Server database engine blog
 

Transitive closure is a graph algorithm that tries to follow paths in graph edges and tries to find all elements that can be reached from some element, or groups of elements that are mutually reachable. Although SQL Server still don’t provid …

The December release of SQL Operations Studio is now available

Publié le 19 décembre 2017 sur sql server team blog
 

This post is authored by Alan Yu, Program Manager, SQL Server. We are excited to announce the December release of SQL Operations Studio is now available. Download SQL Operations Studio and review the Release Notes to get started. SQL Operations Studio …

Storing JSON Documents in SQL Database

Publié le 19 décembre 2017 sur Microsoft SQL Server database engine blog
 

SQL Server and Azure SQL Database have native JSON functions that enable you to parse JSON documents using standard SQL language. Now you are able to store JSON documents in SQL Database and query JSON data like in any NoSQL database. In this post …

Cumulative Update #9 for SQL Server 2014 SP2

Publié le 18 décembre 2017 sur microsoft sql server release services
 

The 9th cumulative update release for SQL Server 2014 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing mo …

Building SQL REST API back-end for Angular apps

Publié le 18 décembre 2017 sur Microsoft SQL Server database engine blog
 

JSON support in SQL Server/Azure SQL is designed to make integration between the relational database models and the modern single-page JavaScript apps easier than ever. SQL Server/Azure SQL enables you to easily format results of SQL queries as JSON te …

Bring clarity to complex data with graph databases on SQL Server 2017

Publié le 13 décembre 2017 sur sql server team blog
 

SQL Server 2017, in addition to processing relational data, now fully integrates with graph database models, all on the same familiar system. This will bring clarity to the increasing amounts of data businesses generate every day. What’s the diff …

Try mssql-cli, a new interactive command line tool for SQL Server

Publié le 12 décembre 2017 sur sql server team blog
 

This post is authored by Alan Yu, Program Manager, SQL Server. We are excited to announce the Public Preview release of mssql-cli, a new and interactive command line query tool for SQL Server. This open source tool works cross-platform and is a proud m …

What’s new in SSMS 17.4: SQL Vulnerability Assessment

Publié le 11 décembre 2017 sur sql server team blog
 

This post is authored by Ronit Reger, Senior Program Manager, SQL Data Security and Alan Yu, Program Manager, SQL Server We are excited to announce the release of SQL Server Management Studio (SSMS) 17.4! Download SSMS 17.4 and review the Release Notes …

SQL Vulnerability Assessment now available for SQL Server 2012 and up

Publié le 11 décembre 2017 sur sql server security blog
 

SQL Vulnerability Assessment has been available for preview on Azure SQL Database for a couple of months, and has now been released on SSMS 17.4, supporting scanning of SQL Server 2012 and up. Whether on-premises or on a VM! SQL Vulnerability Assessmen …


Pages :