Sites Microsoft


Cumulative Update #5 for SQL Server 2019 RTM

Publié le 22 juin 2020 sur MS Tech Community
 

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

The June 2020 release of Azure Data Studio is now available

Publié le 18 juin 2020 sur SQL Server Blog
 

The June release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started.Note: After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions.Azure Data Stu …

Data Exposed | Elastic Jobs in Azure SQL Database (Part 1)

Publié le 18 juin 2020 sur Azure SQL Database Blog
 

In the first part of this two-part video series, Kate Smith gives an introduction to what Azure SQL Database Elastic jobs are, and when you should consider using them, as well as what products support Elastic Jobs.   Watch on Data Exposed   A …

Elastic Jobs in Azure SQL Database (Part 1) | Data Exposed

Publié le 18 juin 2020 sur Azure SQL Database Blog
 

In the first part of this two-part video series, Kate Smith gives an introduction to what Azure SQL Database Elastic jobs are, and when you should consider using them, as well as what products support Elastic Jobs.   Watch on Data Exposed   A …

Join Microsoft at PASS Virtual Summit 2020

Publié le 17 juin 2020 sur SQL Server Blog
 

This year’s PASS Summit conference, the largest gathering of data professionals focused on the Microsoft platform, will be a virtual-only event for the first time.This will make PASS Virtual Summit 2020 more accessible than ever, giving attendees from …

Released: SQL Server Assessment Extension for Azure Data Studio (Public Preview)

Publié le 17 juin 2020 sur MS Tech Community
 

SQL Server Assessment Extension for Azure Data Studio provides a user interface for evaluating your SQL Server instances and databases for best practices. It uses SQL Assessment API to achieve this. In this preview version, you can: – Assess a SQL Serv …

Released: General Availability of Microsoft.Data.SqlClient 2.0

Publié le 16 juin 2020 sur MS Tech Community
 

We have released for general availability Microsoft.Data.SqlClient 2.0. This .NET Data Provider for SQL Server provides general connectivity to the database and supports all the latest SQL Server features for applications targeting .NET Framework, .NET …

Expanding SQL Server Big Data Clusters capabilities, now on Red Hat OpenShift

Publié le 16 juin 2020 sur SQL Server Blog
 

SQL Server Big Data Clusters (BDC) is a new capability brought to market as part of the SQL Server 2019 release. BDC extends SQL Server’s analytical capabilities beyond in-database processing of transactional and analytical workloads by uniting the SQL …

Improving concurrency of asynchronous statistics update

Publié le 16 juin 2020 sur Azure SQL Database Blog
 

Executive summary   In Azure SQL Database and Azure SQL Managed Instance, the background process that updates statistics asynchronously can now wait for the schema modification lock on a low priority queue. This improves concurrency for workloads …

How to troubleshooting “SQL Server is terminating because of fatal exception c06d007e”

Publié le 11 juin 2020 sur SQL Server Support Blog
 

Case 1, with Dump generated Issue definition: ======== Customer have SQL 2008/2012/2014 running on the same server, and then applied the SP4 for SQL Server 2012 in Windows update. But after this customer saw some issue from application side, then you r …

How to troubleshoot “SQL Server is terminating because of fatal exception c06d007e”

Publié le 11 juin 2020 sur SQL Server Support Blog
 

Case 1, with Dump generated Issue definition: ======== Customer have SQL 2008/2012/2014 running on the same server, and then applied the SP4 for SQL Server 2012 in Windows update. But after this customer saw some issue from application side, then you r …

Schema change getting applied repeatedly every time Merge agent runs

Publié le 10 juin 2020 sur SQL Server Support Blog
 

Recently worked on an interesting case. Customer had an existing Merge Replication and it was working fine. They added a new article to the existing Publication and ran the Snapshot Agent. Now Every time Merge agent runs we see that Schema changes were …

Rowgoal impacts the estimated row

Publié le 7 juin 2020 sur SQL Server Support Blog
 

The engineer asked me a question, how does the optimizer estimate the row for index scan(range scan). he observed 100-109 estimated row for index scan but he wants to know the reason.     As my understanding, if there is no predicated, the es …

How to manually reuse the identity range under the merge replication

Publié le 7 juin 2020 sur SQL Server Support Blog
 

when you choose the auto manage the identity range on the merge replication, and some subscriptions dropped, that identity range could not reuse. see this sample:   this sample used too large range for auto managed identity range. after some subsc …

REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT and error 988 –SQL 2017 AlwaysOn

Publié le 7 juin 2020 sur SQL Server Support Blog
 

Recently we got the issue from customer, they failed to add the database into the existing AG with error 988: Msg 988, Level 14, State 1, Line 17 Unable to access database ‘ag_03’ because it lacks a quorum of nodes for high availability. Try the operat …


Pages :