Why Backup SQL Server?

I'm going to start a new series on backing up SQL Server. This was inspired by @Kendra_Little in one of her Dear SQL DBA podcasts In this series I want to work through why we need backups, how to do backups, and the different types of backups that you could do and why you would... Continue Reading →

What is Your “Why”?

Andy Leonard (@AndyLeonard) has asked this month on T-SQL Tuesday "Why do you do what you do?" I have two answers to this question. On one hand I do what I do because it pays the bills. I have a full time job working for a company here in Australia and it pays the bills... Continue Reading →

Ubiquiti Amplifi Router

I have been using Linksys routers for years, since my first router, a WRT54G purchased off eBay. So when my most recent router started to die, it was time to look for a replacement and I naturally went to look at the new Linksys routers again. However, with more and more wireless devices in the house, and... Continue Reading →

CDC breaks after patching

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... Continue Reading →

Create a website or blog at WordPress.com

Up ↑