CDC breaks after patching

By Greg No comments

I recently patched some servers from SQL 2014 SP2 CU3 all the way up to CU10. The patching went fine, everything came back online and looked to be working perfectly. However, the next day I realised that the CDC Collection Job was not running. After much googling and trying to rebuild the collection job, I […]

Dangers Patching Reporting Services in a Scale Out Environment

By Greg No comments

Recently, I did regular patching of SQL Server, upgrading to SQL 2014 SP2 CU3. Normally this goes without any problems and we had tested it out in our test environments, but this time it took all reporting services offline. What happened? We upgraded the DR server like normal, but in doing so it upgraded the SQL […]