Sites Microsoft


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 …

Security Update for SQL Server 2019 RTM CU8

Publié le 12 janvier 2021 sur MS Tech Community
 

The Security Update for SQL Server 2019 RTM CU8 is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous SQL Server 2019 fixes through CU8, plus it includes a new …

Security Update for SQL Server 2019 RTM GDR

Publié le 12 janvier 2021 sur MS Tech Community
 

The Security Update for SQL Server 2019 RTM GDR is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2019 RTM, plus it includes …

Security Update for SQL Server 2017 RTM CU22

Publié le 12 janvier 2021 sur MS Tech Community
 

The Security Update for SQL Server 2017 RTM CU22 is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous SQL Server 2017 fixes through CU22, plus it includes a n …

Security Update for SQL Server 2017 RTM GDR

Publié le 12 janvier 2021 sur MS Tech Community
 

The Security Update for SQL Server 2017 RTM GDR is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2017 RTM, plus it includes …

Security Update for SQL Server 2016 SP2 CU15

Publié le 12 janvier 2021 sur MS Tech Community
 

The Security Update for SQL Server 2016 SP2 CU15 is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous SQL Server 2016 SP2 fixes through CU15, plus it includes …

Deploy SQL Server on Azure Kubernetes Service cluster via Helm Charts – on a windows client machine!

Publié le 4 janvier 2021 sur MS Tech Community
 

A brief snapshot of the conversation that my colleague and I had a couple of weeks ago: Colleague:  « I am new to Kubernetes and Linux world and was hoping if I could deploy SQL Server using he …


Pages :