SQL Server 2017 articles, fixes and updates - Year 2019

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2017 that have been released in Year 2019. The list is daily updated.

• 4046026 Data Platform Modernization Starter Kit Consultation Q4046026 KB4046026 December 30, 2019
• 4532171 FIX: Symmetric key encryption takes longer time in SQL Server 2017 than in SQL Server 2012 Q4532171 KB4532171 December 19, 2019
• 3196320 SQL query times out or console slow on certain Configuration Manager database queries Q3196320 KB3196320 December 18, 2019
• 3210239 Interoperability of Columnstore indexes with large page memory model in SQL Server Q3210239 KB3210239 December 16, 2019
• 263889 How to troubleshoot blocking caused by compile locks Q263889 KB263889 December 12, 2019
• 918483 How to reduce paging of buffer pool memory in SQL Server Q918483 KB918483 November 15, 2019
• 835185 Microsoft Windows Failover cluster resource dependencies in SQL Server Q835185 KB835185 November 14, 2019
• 2806535 Recommendations and guidelines for the "max degree of parallelism" configuration option in SQL Server Q2806535 KB2806535 June 12, 2019
• 4504104 Non-component VSS backups such as Azure Site Recovery jobs fail on servers hosting SQL Server instances with AUTO_CLOSE DBs Q4504104 KB4504104 June 6, 2019
• 2922898 "Error 9002. The transaction log for database is full due to 'AVAILABILITY_REPLICA'" error message in SQL Server Q2922898 KB2922898 June 3, 2019
• 4502458 FIX: Running RESTORE VERIFYONLY logs a CREATE DATABASE event in a server audit specification that uses DATABASE_CHANGE_GROUP in SQL Server Q4502458 KB4502458 May 15, 2019
• 4502457 "The transaction not longer valid" error when Database Mail fails to send a message in SQL Server Q4502457 KB4502457 May 15, 2019
• 312292 How to enable replication agents for logging to output files in SQL Server Q312292 KB312292 April 4, 2019
• 4479280 TDE-compressed backup to Emulation disk restore fails in SQL Server Q4479280 KB4479280 February 11, 2019
• 4488815 “The subscription does not exist” when a distributor primary replica fails over to a replica that does not use the same agent profile Q4488815 KB4488815 February 1, 2019
• 4488253 Configure MSOLAP data provider for Excel to connect to Analysis Services Q4488253 KB4488253 January 30, 2019
• 4488254 Many CMEMTHREAD waits when many SchemaMgr Store entries exist in SQL Server Q4488254 KB4488254 January 24, 2019
• 4480643 Performance issue when modifying entities, attributes, users, or groups when page load permissions used in SQL Server Q4480643 KB4480643 January 23, 2019
• 4465247 Deadlock when running a DAX query with time intelligence in parallel Q4465247 KB4465247 January 23, 2019
• 4463328 FIX: “An unexpected exception occurred” when you run an MDX query after an XMLA query to process a dimension in SSAS Q4463328 KB4463328 January 23, 2019
• 4459535 FIX: Masked data is exposed when a query that uses sp_cursorfetch is run in SQL Server if Dynamic Data Masking is enabled Q4459535 KB4459535 January 23, 2019
• 4099335 Improvement in finding actual errors when you execute the Test-SqlAvailabilityGroup cmdlet in SQL Server Q4099335 KB4099335 January 23, 2019
• 4483881 FIX: Primary replica will be unreachable when you use constant stream of new connections to connect to database in Read-Only Routing enabled AG in SQL Server Q4483881 KB4483881 January 21, 2019
• 4465518 Recommended updates and configuration options for SQL Server 2017 and 2016 with high-performance workloads Q4465518 KB4465518 January 21, 2019