Sites Microsoft


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 …

SQL Server Unconstrained Delegation failing after 10 hours

Publié le 27 janvier 2021 sur SQL Server Support Blog
 

After the Windows updates from November 2020, you might be facing some issues running Bulk Inserts or working with linked servers, if you keep an open session for more than 10 hours.   Some recent changes were done on the Windows side when it come …

SQL SERVER installation failed. “Access is denied” when validating SQL Service account password

Publié le 24 janvier 2021 sur SQL Server Support Blog
 

  We failed to install SQL cluster instance and encountered below error.         We checked SQL setup logs. Issue happened when SQL setup was trying to check if SQL service account exists in AD.   (05) 2021-01-18 15:36:44 …

Around the clock with Azure SQL and Azure Data Factory

Publié le 20 janvier 2021 sur SQL Server Blog
 

On February 3-4, the Azure SQL and Azure Data Factory teams are partnering on a learning event for the community to come together to learn about Azure SQL and Azure Data Factory, meet the engineering teams behind these services, and learn how you can g …


Pages :