To generalise the issue, we need to look at why the policy was set.

Was it set to make money for the tow company, or was it set so that visitors...

I would be even more cautious. An in-place upgrade may be an interesting training exercise, but has considerable risks for...

Amazon RDS and Amazon Redshift are both packaged database services delivered in a PaaS model.

RDS is available for a number of different DBMS (Oracle, SQL Server, etc), and...

You have also over-allocated your server memory. On a 64GB server, you should not try to get SQL to use 63GB.

There are many processes that need to...

If your plan was to install standalone SQL instances on each node and then 'upgrade' them to clustered instances, there is no supported process to make this work.

You can continue...

It is definitely good to know the implications of choosing a default database.

A few years back I worked with the Remedy help desk system. I do not know if...

From what I can see, there is nothing in the release notes about required security. The same can be said about a lot of other topics in the release...

SQL 2008 Express and above can use the same SP and CU patches as the server editions. SQL 2005 Express can only use the SP patches but not the...

[Quote]I need my Azure BLOB or AWS S3, etc storage to appear just like any other remote drive[/quote]

(My addition in italics)

IMHO this is one of the key items in...

Consider packaging your SQL queries in stored procedures, and not imbed the query in the report. (There are about as many people who would fight to the death to...

You need to know how the drive letters that Windows sees are mapped to your underlying storage. If your storage uses thin provisioning then you are probably wasting...

My advice is to escalate this to your management. Both you and the VM admin are working for a common customer...

You sound new to AWS. If so, then ask your AWS Account Manager for advice, this is a problem that others have come across and resolved.

When we went to...

Personally, I have moved to the idea of putting the SQL programs and system databases (apart from tempdb and maybe msdb) on to the system drive.

In any SQL server install...

If the SQL install stops when installing the Setup files, typically this is because one of the pre-requisite components has not been installed. Unfortunately just about the only clue...