If you have any SQL 2012 or above instances running on Windows 2012 or above then you really should look at using Group Managed Service Accounts, at https://technet.microsoft.com/en-gb/library/hh831782.aspx

gMSAs have the...

One thing I noticed after going through burnout is that some thing I used to cope with were just not happening anymore. After being very rigorous on deadlines and...

Kurt, I am assuming you have a VPN between your current data centres and AWS. The...

Going back to the OP, what is the main reason for wanting to move to AWS?

Is this just for personal training, or is your organisation planning to move...

If this is a database for a real vehicle that will be put into production, then you are looking at closer to 2,000 to 3,000 tables instead of 2 or...

IMHO the main items are:

1) Cost of conversion to a new DBMS, which will involve re-writing all of the database...

In the end it will be management that decide this issue, not technical people.

My advice is to talk to your management and find out what pressures they are under regarding...

Getting MSDTC to work correctly on a cluster is complex, and it is hard to find all the information in one place.

* Your local MSDTC must have a CID on...

Most of the figures you mention are helpful in working out a theoretical performance model, but your organisation uses SQL Server to give actual performance to the business.

My advice is...

Even the best Capacity Planners, the people who specialise in doing capacity planning as their paid job for many years, reckon any estimate they give is at best accurate to...

This is definitely my last commercial job, with last day in the office Friday of this week.

I have been offered a 1-day per week job with a charity to help...

Your examples show phone numbers from the US only. If your data can validly contain phone numbers from other countries then your validation and formatting is not correct.

You need to talk to your license reseller to work out the most business-effective and cost-effective design.

You need to talk to your license reseller to work out the most business-effective...

If you are running in AWS then disabling TCP Offload can give a performance benefit - it certainly did for my employer.

SQL FineBuild will by default disable TCP...

See https://sqlserverfinebuild.codeplex.com/wikipage?title=Windows%20Memory%20Switches for suggestions of what switches you should use.

As Gail says, most of these settings only give a benefit in a small number of situations.

The UserVa value is only...