Sites Microsoft


Modify Azure SQL Database Managed Instance using Azure CLI

Publié le 15 novembre 2018 sur Microsoft SQL Server database engine blog
 

Azure SQL Managed Instance is fully-managed SQL Server Database Engine hosted in Azure cloud. With Managed Instance you can easily add/remove cores associated to the instance and change the reserved size of the instance. You can use Azure CLI to easily …

Create Azure SQL Managed Instance using Azure CLI

Publié le 15 novembre 2018 sur Microsoft SQL Server database engine blog
 

Azure command line interface (CLI) is a set of commands that you can use to create and manage Azure resources. In this post your will see how can you create Managed Instance using Azure CLI. The Azure CLI is Microsoft’s cross-platform command-lin …

Cumulative Update #4 for SQL Server 2016 SP2

Publié le 14 novembre 2018 sur microsoft sql server release services
 

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

Cumulative Update #12 for SQL Server 2016 SP1

Publié le 13 novembre 2018 sur microsoft sql server release services
 

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

Diagnostic Data for Synchronous Statistics Update Blocking

Publié le 13 novembre 2018 sur Microsoft SQL Server database engine blog
 

Consider the following query execution scenario: You execute a SELECT query that triggers an automatic synchronous statistics update. The synchronous statistics update begins execution and your query waits (is essentially blocked) until the fresh stati …

Creating a data hub for your analytics with PolyBase

Publié le 13 novembre 2018 sur sql server team blog
 

Data is the new currency of the digital world, and Microsoft is uniquely positioned to help businesses and consumers get the most out of their data assets. With the leading database in the world, SQL Server, and the rapidly growing Azure cloud data pla …

Released: Public Preview for SSRS 2017+ Management Pack with Power BI Reporting Server Support

Publié le 13 novembre 2018 sur microsoft sql server release services
 

We are getting ready to release an update for SQL Server Reporting Services 2017+ Management Pack. We are introducing support for monitoring Power BI Report Server with this management pack. It now provides the same level of monitoring f …

What Azure permissions are required to create SQL Managed Instance?

Publié le 12 novembre 2018 sur Microsoft SQL Server database engine blog
 

Azure SQL Managed Instance is a fully managed SQL Server Instance hosted in Azure cloud that is placed in your Azure VNet. Users who are creating instances need to have some permissions. In this post you will see the minimal permissions required to cre …

Public preview of derived tables and views on graph tables in MATCH queries

Publié le 7 novembre 2018 sur Microsoft SQL Server database engine blog
 

SQL Server 2017 and Azure SQL Database introduced native graph database capabilities for modeling many-to-many relationships. The first implementation of SQL Graph introduced support for nodes to represent entities, edges to represent relatio …

Introducing Scalar UDF Inlining

Publié le 7 novembre 2018 sur Microsoft SQL Server database engine blog
 

Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt optimization strategies to your application workload’s runtime conditions. These improvements included: batch mode adaptive joins, batch mode mem …

Announcing: Preview of Machine Learning Services with R support in Azure SQL Database

Publié le 7 novembre 2018 sur sql server team blog
 

We are excited to announce that Machine Learning Services with support for R is now available for public preview on Azure SQL Database. Machine Learning Services has transformed SQL Server into a versatile machine learning platform. We are now bringing …

Harness the future with the ultimate hybrid platform for data and AI

Publié le 7 novembre 2018 sur sql server team blog
 

Today Im excited to give the Day 1 keynote at PASS Summit v.20, a gathering of our longtime community of SQL Server users and data professionals. PASS Summit is an amazing chance to see the faces of old and new friends. Its a place to meet with custome …

The November release of Azure Data Studio is now available

Publié le 6 novembre 2018 sur sql server team blog
 

We are excited to announce the November release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studioand review the Release Notes to get started. Note: If you are currently using the preview version …

Meet the Azure SQL Database team at PASS Summit 2018

Publié le 5 novembre 2018 sur Microsoft SQL Server database engine blog
 

Azure SQL Database Engineering team (@azuresqldb) represented by Lindsey Allen,  Joachim Hammer, Ajay Jagannathan, Joe Sack, Borko Novakovic, Mine Tokus, Kevin Farlee, Xiaochen Wu, Jakub Szymaszek, Shreya Verma, Perry Skountrianos, Alain Dormehl, …


Pages :