Sites Microsoft


SQL Server Always on Availability Group Scalability Experiment and Result on Azure VM

Publié le 23 février 2021 sur MS Tech Community
 

Introduction The purpose of this scalability experiment is to evaluate the performance of AG cluster when it has large number of databases and some of the databases undergo large amount of traffic, and measure 1) OLTP transaction performance, 2) Failov …

Watch and learn about SQL Assessment API and SQL Assessment Extension

Publié le 23 février 2021 sur MS Tech Community
 

If you are curious about how to easily determine if your SQL is following best practices guidelines, you can watch the Data Exposed Live episode we did recently. We demo’ed SQL Assessment API and SQL Assessment Extension for Azure Data Studio (ADS …

The February 2021 release of Azure Data Studio is now available

Publié le 22 février 2021 sur SQL Server Blog
 

The February release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started.Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals using the Microsoft fami …

What’s new with SQL Server Big Data Clusters

Publié le 16 février 2021 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 …

Cumulative Update #9 for SQL Server 2019 RTM

Publié le 11 février 2021 sur MS Tech Community
 

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

Cumulative Update #16 for SQL Server 2016 SP2

Publié le 11 février 2021 sur MS Tech Community
 

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

Auto update statistics threshold of temp table in stored procedure

Publié le 7 février 2021 sur SQL Server Support Blog
 

The threshold of temp table in stored procedure is little bit tricky, it doesn’t exactly follow the regular threshold. First of all, you can’t use the modification_counter to determine when auto update statistics happens. Because the data i …

Intro into security principles in the context of database systems

Publié le 4 février 2021 sur MS Tech Community
 

Introduction into security principles in the context of database systems By Andreas Wolter   Preface While many of us are practicing ‘social distancing’, and spend lots of time at home, I am finally finding the time to share some of th …

New Home for SQL Server Troubleshooting KB articles ..and for other commercial products

Publié le 3 février 2021 sur SQL Server Support Blog
 

    Summary: SQL Server KB articles have migrated to DOCs at https://docs.microsoft.com/troubleshoot/sql. This excludes CU and hotfix which will remain currently on http://support.microsoft.com     What do you get: Articles organize …

PolyBase Service Account Permissions and Common Errors Observed When They Are Missing

Publié le 3 février 2021 sur SQL Server Support Blog
 

We have seen a number of PolyBase cases in SQL Server Support related to logins or permissions created and set during installation that are missing. It is quite common for organizations to want to lock down their environment from a security perspective …

New Trace flags for better maintenance of deleted rows in Columnstore Index

Publié le 1 février 2021 sur SQL Server Support Blog
 

  Qualification Limit for REORGANIZE to remove deleted rows from a rowgroup in Columnstore Index: By default when one runs ALTER INDEX REORGANIZE the qualifying limit to remove delete rows from a rowgroup is –> the specific rowgroup have 10% o …

JDBC Driver 9.2 for SQL Server Released

Publié le 29 janvier 2021 sur MS Tech Community
 

Version 9.2 of the Microsoft JDBC Driver for SQL Server has been released. Version 9.2.0 brings many added features, changes, and fixed issues over the previous production release. AddedAdded a connection property for maxResultBuffer 1431Added sup …

Microsoft Drivers 5.9.0 for PHP for SQL Server Released

Publié le 29 janvier 2021 sur MS Tech Community
 

We have released Microsoft Drivers for PHP for SQL Server, version 5.9.0. This production release of the SQLSRV and PDO_SQLSRV drivers has been built with PHP 7.3, 7.4, and 8.0 and tested on all supported platforms. Notable items about this releas …

ODBC Driver 17.7 for SQL Server Released

Publié le 29 janvier 2021 sur MS Tech Community
 

Version 17.7 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.7.1 brings several new features and fixes to the driver. FeaturesSupport Azure Active Directory Interactive authentication (Windows-only) against Azure …

Memory Grants: The mysterious SQL Server memory consumer with Many Names

Publié le 27 janvier 2021 sur SQL Server Support Blog
 

First published on MSDN on Jan 01, 2013 The Memory Consumer with Many Names Have you ever wondered what Memory grants are? What about QE Reservations ? And Query Execution Memory ? Workspace memory ? How about Memory Reservations ? As with most things …


Pages :