I will try to test this but have very limited time over the next 2 weeks.

We went live with SQL2014 CTP2 for our BI servers. For the stuff that existed in SQL2008R2 we have not noticed any problems. We are deferring the use...

I have had situations in the past where SQL Serve reported a network problem but the Network people said nothing had gone wrong.

Eventually we wrote a simple script that did...

There is very little difference in the footprint of Express and Developer editions, provided that you install the same set of components.

The main advantages of installing Developer Edition are:

a) You...

If you copy the folders without also explicitly copying the permissions, then the problems you had would be expected. The SQL Server install sets a lot of folder permissions...

I have not seen this specific problem, but I have seen other situations where a SQL Service does not start within the timeout limit after applying a patch.

This can be...

If you want to do this just using the command line, see http://sqlserverfinebuild.codeplex.com/wikipage?title=Install%20SQL%20Books%20Online%20Update#BOL Update for SQL 2012

I always put a space before each / character, to allow the preceding parameter to be correctly terminated. OK so I've never tried not putting a space, but all...

Personally I would never uninstall SQL Server on what is destined to be a Production machine. Outside of Production I still prefer to not uninstall SQL Server.

It is not...

Buffer Pool Extension is a really useful feature of SQL2014 that can reduce most IO latency, but it does have a few foibles.

Implementing it is easy but you need to...

SQL Server in a Workgroup has some advantages if it is used in an automatic scale-out scenario, such as in a cloud environment.

Connecting a Windows box to a Domain takes...

The moral is that you need to work this out with your license reseller. Be up-front about what you plan to do, and get their agreement. If the...

Our discussions with Microsoft and its license resellers have shown that the following is accepted:

If you set processor affinity to match the number of cores you have licensed, then you...

Apart from the vastly improved SMB process which impacts network IO and any Named Pipes processing, the improved IO process, the ability to turn Core mode on and off, and...

The Windows Security Log is protected. Only specific Windows components can succeed in writing to it, regardless of what permissions you give to any of your code.

AFAIK the only...