Product has been added to your cart.

breaking news

Breaking News: 2016 Query Store cleanup doesn’t work on Standard or Express Editions

Brent Ozar
Breaking News, First Responder Kit, Query Store (QDS), SQL Server
5 Comments
If you’re using SQL Server 2016’s awesome new feature, Query Store, there’s a new bug with automatic cleanup. Books Online explains: Automatic data cleanup fails on editions other than Enterprise and Developer. Consequently, space used by the Query Store will grow over time until configured limit is reached, if data is not purged manually. If…
Read More

“Breaking” News: Don’t Install SQL Server 2014 SP1

Brent Ozar
Always On Availability Groups, Breaking News, SQL Server
24 Comments
Yesterday, Microsoft announced availability of Service Pack 1, saying: As part of our continued commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2014 deployments via the download links below. Yeah, about that commitment to software excellence. This morning, the download is gone: Notice: The SQL SSIS…
Read More

The Hard Truth About Patching SQL Server Availability Groups (Hotfixes, Cumulative Updates, and Service Packs)

Kendra Little
Always On Availability Groups, Breaking News
51 Comments
Whoa, be careful with that fix As a DBA, you’re responsible for identifying necessary updates to keep your SQL Servers healthy. Your business may have some mandates about the frequency of patches, but even if they don’t, you have a duty to look out for Cumulative Updates, Service Packs, and out of band hotfixes that can prevent…
Read More