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 →

Blocked When Dropping Databases

We have a database that we refresh every night with data from our production system. This is so that we can do a final test with real data when required. The first step of the job kills all of the users connections, however one of the applications that our developers runs tries to reconnect again... Continue Reading →

Create a website or blog at WordPress.com

Up ↑