SQL Server Always on Availability Group Scalability Experiment and Result on Azure VM
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 …