Sites Microsoft


Cumulative Update #14 for SQL Server 2019 RTM

Publié le 22 novembre 2021 sur MS Tech Community
 

The 14th 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 m …

Released: General Availability of Microsoft.Data.SqlClient 4.0

Publié le 19 novembre 2021 sur MS Tech Community
 

We have released for general availability Microsoft.Data.SqlClient 4.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 …

Recover TDE Databases in Disaster : Recover Steps for 3 Common Scenarios

Publié le 16 novembre 2021 sur SQL Server Support Blog
 

Summary: This article discusses 3 common scenarios where you can and cannot recover your TDE-enabled database that using native SQL certificate stored on master database to encrypt the TDE (not using AKV or 3rd-party EKM/HSM).    In unexpecte …

Prevent SQL Server Dump Generation in Hot Cases: Common Ways & Scenarios

Publié le 15 novembre 2021 sur SQL Server Support Blog
 

Summary: This article discusses common way to prevent SQL dump from being generated in different exception scenarios. This workaround serves for hot scenario where you need to immediately stop the PRODUCTION outage caused by dump generation. You should …

Prevent SQL Server Dump Generation in Hot Cases: Common Ways & Scenarios

Publié le 15 novembre 2021 sur SQL Server Support Blog
 

Summary: This article discusses common way to prevent SQL dump from being generated in different exception scenarios. This workaround serves for hot scenario where you need to immediately stop the PRODUCTION outage caused by dump generation. You should …

Use Trace Flag 902 (TF902) to Bring Up Your SQL Service in Failed Post Upgrade Script

Publié le 14 novembre 2021 sur SQL Server Support Blog
 

Summary: This article discusses using TF902 as a quick workaround to bring up your SQL Server service if it fails to be started due to post upgrade script failure after installing SQL Server patch. Further troubleshooting steps to address the post upgr …

Use Orca.exe Tool to Verify Corrupted MSI/MSP file in Failed SQL Patching

Publié le 14 novembre 2021 sur SQL Server Support Blog
 

DISCLAIMER : THIS CODE AND INFORMATION IS PROVIDED « AS IS » WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.   Multiple reasons c …

Common Causes and Troubleshooting Solutions for SQL AG Data Synchronization Latency

Publié le 14 novembre 2021 sur SQL Server Support Blog
 

This article summarizes the common causes , solutions and troubleshooting mechanism for SQL Availability Group (AG) data synchronization latency between primary and secondary for both synchronous-commit and asynchronous-commit mode.   The latency …

Early technical preview of JDBC Driver 9.5.0 for SQL Server released

Publié le 9 novembre 2021 sur MS Tech Community
 

We have released a new early technical preview of the JDBC Driver for SQL Server which contains a few additions and changes.   Precompiled binaries are available on GitHub and also on Maven Central.Below is a summary of the new addi …

PASS Data Community Summit keynote: a bridge to a new universe

Publié le 8 novembre 2021 sur SQL Server Blog
 

It is almost time for PASS Data Community Summit 2021, a free online conference for the Microsoft data platform professional. The conference, hosted by Redgate, will include the latest SQL Server and Azure data innovations, practical training, and netw …

SQL Server on Azure VM – Now with 30% better price-performance on the new Ebdsv5 VM series!

Publié le 2 novembre 2021 sur MS Tech Community
 

No one knows SQL Server like Microsoft, so it should be no surprise that Azure offers the best overall value for running your SQL Server workloads in the cloud. Today I am thrilled to introduce a new Azure Virtual Machines offering that will bring even …

Preview: SQL Assessment for SQL Server on Azure Virtual Machines

Publié le 2 novembre 2021 sur MS Tech Community
 

Wouldn’t it be great if there was a way to learn if your SQL Server on Azure Virtual Machines was configured optimally? Do you have the right options set? Do you have your tempdb on the right disk? Can your queries perform better? All these and more ca …

Announcing SQL Server on Ubuntu Pro in Azure Virtual Machines

Publié le 2 novembre 2021 sur MS Tech Community
 

We are excited to announce that Microsoft SQL Server is now available on Ubuntu Pro in the Azure Marketplace. SQL Server on Ubuntu Pro combines the industry-leading performance and security of SQL Server, now available on both Linux and Windows, with c …

Announcing the SQL Server 2022 Early Adoption Program

Publié le 2 novembre 2021 sur MS Tech Community
 

The next version of SQL Server has been announced! SQL Server 2022 has built-in Azure enablement and innovations in security, performance, availability, data virtualization, and enhancements to the T-SQL language. The SQL Server engineering team is loo …

Announcing SQL Server 2022 preview: Azure-enabled with continued performance and security innovation

Publié le 2 novembre 2021 sur SQL Server Blog
 

Today we are announcing the preview of SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation in performance, security, and availability.The rise of data represents a tremendous opportunity and also poses challenge …


Pages :