Sites Microsoft


Cloud data and AI services training roundup

Publié le 10 avril 2018 sur sql server team blog
 

To help you stay up to date on online training opportunities, we’re releasing a monthly list of the latest free data and artificial intelligence (AI) sessions in one convenient post. SQL Server 2017 Whether on Windows, Linux, or Docker containers …

March 2018 Leaderboard of Database Systems contributors on MSDN

Publié le 9 avril 2018 sur Microsoft SQL Server database engine blog
 

Congratulations to our March top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. Th …

Celebrating data and you with #SQLDataWins

Publié le 9 avril 2018 sur sql server team blog
 

Hey you, data whiz! You’re an expert, a data aficionado, a steward of a finely tuned database – but not everyone gets it. Well, we do. #SQLDataWins celebrates professionals who make an impact with data every day. Play along with us on Twitt …

Lesson learned from an Availability Group performance case

Publié le 5 avril 2018 sur css sql server engineers
 

Writer: Simon SuTechnical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah  Problem description  One of my customers implemented a very high workload synchronous AG (Availability Group) solution and he needs 10k transactions/sec in AG databa …

Troubleshooting SQL Server Scheduling and Yielding

Publié le 5 avril 2018 sur css sql server engineers
 

Writer: Simon SuTechnical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah   Scheduling and Yielding Knowledge Recap  We all know that SQL server is a multi-threads and multi-tasks system and it has its own thread scheduling mechanism w …

Troubleshooting data movement latency between synchronous-commit AlwaysOn Availability Groups

Publié le 5 avril 2018 sur css sql server engineers
 

Writer: Simon Su Technical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah Applies to: SQL Server 2014 SP2, SQL Server 2016 SP1, SQL Server 2017 RTM  In synchronous-commit mode AG nodes sometimes you may observe your transactions are pending on …

Monitoring performance of natively compiled stored procedures – database-scoped configuration options

Publié le 4 avril 2018 sur Microsoft SQL Server database engine blog
 

We just added new database-scoped configuration options that will help with monitoring performance of natively compiled stored procedures. The new options XTP_PROCEDURE_EXECUTION_STATISTICS and XTP_QUERY_EXECUTION_STATISTICS are available now …

Released: Microsoft OLE DB Driver for SQL Server

Publié le 30 mars 2018 sur microsoft sql server release services
 

We are pleased to announce the release of the Microsoft OLE DB Driver for SQL Server, as previously announced! This new driver follows the same release model as all the other SQL Server drivers, which means that it’s maintained out-of-band with t …

The March release of SQL Operations Studio is now available

Publié le 28 mars 2018 sur sql server team blog
 

This post is authored by Alan Yu, Program Manager, SQL Server and Karl Burtram, Senior Software Engineer, SQL Server.  We are excited to announce the March release of SQL Operations Studio is now available. Download SQL Operations Studio and …

Installation of SQL Server 2017 failing with ‘VS Shell installation has failed with exit code 1638’

Publié le 26 mars 2018 sur css sql server engineers
 

Dear all, Depending on which products were installed on the server beforehand, a SQL Server 2017 setup may fail with the following error : TITLE: Microsoft SQL Server 2017 Setup —————————— The following error has occurred: VS Shell …

Installation of SQL Server 2017 failing with ‘VS Shell installation has failed with exit code 1638’

Publié le 26 mars 2018 sur css sql server engineers
 

Dear all, Depending on which products were installed on the server beforehand, a SQL Server 2017 setup may fail with the following error : TITLE: Microsoft SQL Server 2017 Setup —————————— The following error has occurred: VS Shell …

Cumulative Update #5 for SQL Server 2017 RTM

Publié le 20 mars 2018 sur microsoft sql server release services
 

The 5th 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 mo …

SSMS 17.6 is now available: Managed Instance and many bug fixes

Publié le 20 mars 2018 sur sql server team blog
 

This post is authored by Alan Yu, Program Manager, SQL Server. Download SSMS 17.6 and review the Release Notes to get started. SSMS 17.6 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server 2017, which is now g …

Cumulative Update #11 for SQL Server 2014 SP2

Publié le 20 mars 2018 sur microsoft sql server release services
 

The 11th 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 …


Pages :