Sites Microsoft


SQL Server 2017 on Linux webcast series

Publié le 22 janvier 2018 sur sql server team blog
 

The world’s leading database is now available on Linux by bringing Microsoft SQL Server to Linux, Microsoft continues to embrace open source solutions. SQL Server 2017 brings the best features of the Microsoft relational database engine to the en …

Cumulative Update #10 for SQL Server 2014 SP2

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

The 10th 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 m …

Webinar: Modernize your applications with cloud and on-premises data solutions from Microsoft

Publié le 18 janvier 2018 sur sql server team blog
 

Customers today demand the latest innovations in every solution you deliver. How can you make sure your data infrastructure not only keeps up, but drives innovation? Data is the core of modern applications. Two key trends that help organizations extrac …

Cumulative Update #7 for SQL Server 2016 SP1

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

The 7th cumulative update release for SQL Server 2016 SP1 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 …

The January release of SQL Operations Studio is now available

Publié le 17 janvier 2018 sur sql server team blog
 

This blog post was authored by Alan Yu, Program Manager, Microsoft SQL Server. We are excited to announce the January release of SQL Operations Studio is now available. Download SQL Operations Studio and review the release notes to get started. SQL Ope …

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 …


Pages :