YouTube
GitHub

Breaking News

  1. Home
  3. Production Database Administration
  5. Breaking News

Breaking News: Using TDE on 2016? Doing Backups? Time to Patch.

Brent Ozar
Backup and Recovery, Breaking News
, ,
3 Comments
Normally, when you use Transparent Data Encryption (TDE) to secure your database at rest, you can’t get backup compression. Encrypted data basically looks like random data, and random data doesn’t compress well. SQL Server 2016 introduced the ability to compress your TDE databases. Yay! Unfortunately, it has bugs that can leave you unable to restore…
Read More

Availability Groups: More Planned Downtime for Less Unplanned Downtime

Brent Ozar
Always On Availability Groups, Breaking News, SQL Server
,
9 Comments
I often hear companies say, “We can never ever go down, so we’d like to implement Always On Availability Groups.” Let’s say on January 1, 2016, you rolled out a new Availability Group on SQL Server 2014. It’s the most current version available at the time, and you deploy Service Pack 1, Cumulative Update 4 (released…
Read More

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
4 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
39 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

Urgent AlwaysOn Availability Groups Bug

Brent Ozar
Always On Availability Groups, Breaking News, SQL Server
, , ,
4 Comments
If you’re using AGs, don’t apply these patches: SQL 2012 SP2 CU3 SQL 2012 SP2 CU4 SQL 2014 CU5 until you read this Microsoft post about a breaking bug. Your AG may stop synchronizing due to blocking between user queries and a system session. The fix is to disable automatic failover, restart the primary, and…
Read More
Menu