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 →

Asking for Help

I always think it's a great idea to ask for help. When I was a kid, my parents taught me that it's always a good idea to ask for help - the worst that will happen is they'll say no. In IT there is too much to learn so I always think it's a great idea... Continue Reading →

Create a website or blog at

Up ↑