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 […]

Can you use a case statement as part of a join?

By Greg No comments

I had a question yesterday about whether or not you can use a case statement as part of a join condition. I was pretty sure the answer was yes, but we can always just run a simple test to prove it. It’s a pretty simple test to setup, I’m going to create 2 tables, populate them […]

GitLab Data Loss

By Greg No comments

Overnight (at least in Australia) GitLab had a little problem: We accidentally deleted production data and might have to restore from backup. Google Doc with live notes https://t.co/EVRbHzYlk8 — GitLab.com Status (@gitlabstatus) February 1, 2017 At the time of writing this, it looks like GitLab has lost about 6 hours of data that it will […]