Released: Public Preview for SSRS 2017+ Management Pack with Power BI Reporting Server Support
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?
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
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
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
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
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
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
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, …
SQL Server 2014 Service Pack 3 is now Available!!!
The SQL Server team is excited to bring you SQL Server 2014 Service Pack 3 (SP3). SQL Server 2014 SP3 contains 25+ improvements centered around performance, scalability and diagnostics based on the feedback from customers and SQL community. These impro …
Data and AI Services training roundup October 2018
To help you stay up to date on online training opportunities, were releasing a monthly list of the latest free Data and Artificial Intelligence (AI) sessions in one convenient post. SQL Server 2019 SQL Server 2019 brings innovative security and complia …
SQL Server IaaS Extension Query Service for SQL Server on Azure VM
SQL Server IaaS Extension is installed by default on Azure virtual machines deployed from SQL Server based images on Azure Market Place. SQL Server IaaS extension manages SQL Server configurations on the VM including SQL server connectivity, storage co …
Cumulative Update #12 for SQL Server 2017 RTM
The 12th 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 or servicing m …
An Engineer and a tiger walk into a Clinic at the PASS Summit 2018
Sounds like there should be a punchline right? Well, there is. Microsoft will be in full force at PASS Summit 2018, and this is the third blog post in a series describing the involvement of the Microsoft SQL Server engineering team there. You can read …
Understanding Optimizer Timeout and how Complex queries can be Affected in SQL Server
What Is Optimizer Timeout? SQL Server uses a cost-based query optimizer. Therefore, it selects a query plan with the lowest cost after it has built and examined multiple query plans. One of the objectives of the SQL Server query optimizer (QO) is to sp …