You should be able to do this via the Edition Upgrade option, I am sure we have done this.

Go to Microsoft SQL Server Configuration Tools, and navigate to...

The organisation I work for is moving its entire server estate to AWS, so I definitely expect to be working more with the cloud in 2013 than this year.

We...

True - if you are writing a multi-platform product then you are limited in what you can do, and you have to accept the costs of doing this.

The OP did...

Does your business know how much cost and time they are adding by forcing people to write code that can run on multiple types of DBMS?

This is like...

A number of our business units have installed Tableau Desktop and find it does the job for them.

If you are unable to upgrade to SQL 2012 then Tableau can be...

Even if you use Sync Framework to do P2P data propogation, this does not overcome having to deal with update conflicts.

Your design either needs to accept that conflicts will occurr...

P2P is inherently a multi-master system. If you update the same row in multiple peers at the same time you will get an update conflict.

SQL 2008 R2 allows automatic...

In general, this should not cause you any problems.

However, if your Production environment relies on parallelism and you cannot get the same degree of parallelism in your test environment, then...

SSIS can be clustered, but you have to do it manually.

However, there are very few situations where clustering SSIS will be of benefit, and many situations where it can be...

I have had so much trouble trying to install a SQL Cluster with the RTM installer that I always set up slipstream media with the latest SP, and also tend...

Registration is a pain!

There are many times when I have wanted to read an article on a site, but gave up when it asked for registration. Every new site...

FineBuild can do an unattended SQL Server install of a cluster for you. Its security model is that no account, apart from the account running the install, needs local...

The SQL Server install will always put upwards of 3GB on to the system drive. Most of this goes into the GAC, which must always exist on the system...

You can use DTS Backup 2000 http://www.sqldts.com/242.aspx to make this move. The DTS Backup 2000 product retains DTS package layout and annotations, with most other DTS export/import methods lose.

If you have a MSDTC instance local to your SQL Server instance, they can use memory to communicate. If MSDTC and SQL Server are on separate nodes they have...