SQL Server community-driven enhancements in SQL Server 2017
This post was authored by the SQL Server Tiger Team Although SQL Server 2016 runs faster, SQL Server 2017 promises to run even faster and empower customers to run smarter with intelligent database features like the ability to run advanced analytics usi …
Certificate-based authentication for Azure SQL DB using Azure Active Directory with recent Azure RM PowerShell version
This is a new version of the previous blog on Token-based authentication (see https://blogs.msdn.microsoft.com/sqlsecurity/2016/02/09/token-based-authentication-support-for-azure-sql-db-using-azure-ad-auth/ ) updated to accommodate recent Azure RM Powe …
Get to cloud faster with a new database migration service private preview
Last week at the Microsoft Data Amp online event, Microsoft announced a private preview for a new database migration service that will streamline the process for migrating on-premises databases to Azure. Using this new database migration service …
“You Shall Not Regress!!!” – How SQL Server 2017 prevents plan regressions?
SQL plan regression is a case when a T-SQL query that executed fine becomes much slower or uses more resources because the underlying SQL plan changed. SQL Server 2017 would not allow that kind of regressions if you enable new automatic tuning feature …
How to find query plan choice regressions with SQL Server 2017 CTP2
SQL Server 2017 in CTP2.0 version automatically identifies potential performance regressions in SQL queries, enables you to easily find potential issues, and gives you information what should you do to fix the issue. In CTP2.0 version is added ne …
Released: Public Preview for SQL Server vNext Replication Management Pack (6.7.40.0)
We are happy to announce that public preview for SQL Server vNext Replication Management Pack is ready. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com). You can download the public preview at: ht …
Graph Data Processing with SQL Server 2017
SQL Server is trusted by many customers for enterprise-grade, mission-critical workloads that store and process large volumes of data. Technologies like in-memory OLTP and columnstore have also helped our customers to improve application performance ma …
Resumable Online Index Rebuild is in public preview for SQL Server 2017 CTP 2.0
We are delighted to announce that Resumable Online Index Rebuild is now available for public preview in the SQL Server vNext 2017 CTP 2.0 release. With this feature, you can resume a paused index rebuild operation from where the rebuild operation was p …
Introducing Interleaved Execution for Multi-Statement Table Valued Functions
For SQL Server vNext and Azure SQL Database, the Microsoft Query Processing team is introducing a new set of adaptive query processing improvements to help fix performance issues that are due to poor cardinality estimates. Improvements in the adaptive …
Introducing Batch Mode Adaptive Joins
For SQL Server 2017 and Azure SQL Database, the Microsoft Query Processing team is introducing a new set of adaptive query processing improvements to help fix performance issues that are due to inaccurate cardinality estimates. Improvements in the adap …
Announcing the General Availability (GA) Release of SSDT 17.0 (April 2017)
We are pleased to announce that SQL Server Data Tools 17.0 is officially released and supported for production use. This GA release includes support for SQL Server 2017 and SQL Server on Linux including new features such as Graph DB. It includes severa …
Python in SQL Server 2017: enhanced in-database machine learning
We are excited to share the preview release of in-database analytics and machine learning with Python in SQL Server. Python is one of the most popular languages for data science and has a rich ecosystem of powerful libraries. Starting with the CTP 2.0 …
Delivering AI with data: the next generation of Microsoft’s data platform
This post was authored by Joseph Sirosh, Corporate Vice President, Microsoft Data Group Leveraging intelligence out of the ever-increasing amounts of data can make the difference between being the next market disruptor or being relegated to the pages o …
Introducing Microsoft R Server 9.1 release
This post is authored by Nagesh Pabbisetty, Partner Director of Program Management at Microsoft. Expert data scientists are adopting Advanced Analytics and Machine Learning at a rising rate. The adoption of these technologies is increasingly possible, …