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 →


This week, I was trying to improve the performance of a bit of SQL and noticed that it generated significantly different query plans depending on the parameters passed in. So I tried to work out how to make it run well for all scenarios.When SQL Server first runs a stored procedure, it works out the... 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 →

Integer Types

There are many different ways to store integers in SQL, how do you know which is the best? I have worked in organisations where it was decided that BIGINT should always be used for primary keys, because then we'd never run out of numbers. While the argument was true, they wouldn't run out of numbers,... Continue Reading →

SQL 2017 Release Announced

At Microsoft Ignite today, the SQL 2017 release date was finally announced for a week from now, on October 2. SQL 2017 is exciting because of the new Linux and Docker capabilities. Docker in particular will be an interesting one to see, particularly for dev/test environments where the ability to spin up and throw away... Continue Reading →

Create a website or blog at WordPress.com

Up ↑