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 …
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 …
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 …
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 …
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, …
SQL Server 2017 Community Technology Preview 2.0 now available
Microsoft is excited to announce a new preview for the next version of SQL Server! We disclosed a name for this next release, SQL Server 2017, today at the Microsoft Data Amp event. Community Technology Preview (CTP) 2.0 is the first production-q …
Top three capabilities to get excited about in the next version of SQL Server
We announced the first public preview of SQL Server v.Next in November 2016, and since then we’ve had lots of customer interest, but a few key scenarios are generating the most discussion. If you’d like to learn more about SQL Server v.Next …
Cumulative Update #12 for SQL Server 2014 SP1
The 12th cumulative update release for SQL Server 2014 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 s …