How to target SQL Server 2014 from a Visual Studio 2013 SQL Server Database Project

I’ve just installed SQL Server 2014 and want to check what might break in my current SQL Server 2008 database when I upgrade it.

Thomas LaRock has written a great article providing a list of a dozen things to check before upgrading and I would definitely suggest making this your first port of call if you’re planning an upgrade.  Continue reading

Aliases in SQL Server 2008

As far as I’m concerned remembering server names is a pain in the backside especially when you have no control over how they are named.  Is the development environment, or is it the UAT environment, or is it production?

The good news is that you can set up aliases in SQL Server 2008 to help you out and it literally only takes a couple of minutes to do. Continue reading

Remove Recent Server List in SQL Server 2008

Having recently gone through the process of moving a number of databases to new servers I was met with the annoying issue of having my list of recent servers in SQL Server 2008 being cluttered with servers that were no longer active.  Although you can’t clear this list directly through the SQL Server GUI (apparently this is possible in SQL Server 2012) it is straight forward enough to get rid of your unwanted servers.

Before you start though, make sure all instances of SQL Server are closed. Continue reading