Actually auto shrink would cause greater transaction log growth - not less. Shrinking the files is a logged activity.

I'd just set it to simple recovery and leave autoshrink off. the...

I would leave that TF on.

On SQL 2016 RTM, the traceflag does nothing, but starting with CU1, it starts doing something again. I didn't know this until very recently and...

I'd switch to SQL server data tools

I would not under any circumstances run without HA, even if you are using Azure virtual machines. There have been a couple outages in Azure that took the main machines...

If the cluster is in two subnets, you will need two IP addresses for the cluster and two IP addresses for each listener.

I can't remember if 2014 supported multiple subnet...

If your CTFP is still at the default value of 5, there is very little use in changing the max dop until it has been adjusted.

At a ctfp of 5,...

If your AAG is going to be in one subnet you will need at minimum one IP address for each server. If your servers are physical, or your virtual infrastructure...

Why use the constraints at the destination? Integrity is enforced when the data is created, you only need to duplicate the data once it has been created. Since you are...

Thom, I actually didn't check it the other way, but it's sloppy code to not do it. Generally for anyone, queries should be written to exactly control their behavior rather...

If you are using SQL authentication (shame on you :-p) something is messed up in the linked server as Jeffrey Williams said.

If you are using kerberos authentication, you need to...

SELECT

price,

amount,

CAST((price + amount) AS FLOAT) as total FROM items;

You need to enclose the math operation.

Also, as an aside - your training site is probably telling you to do this, but...

You may get more bang for your buck by moving the databases to a different volume instead of the files, formatted to use the 64k allocation unit size. You just...

That's two different misconfigurations.

The first is setting the allocation size to something other than 64k. I always format the drives to use 64k allocations when I add a new volume,...

For that you may be able to add additional IP resources to the failover cluster instance and then configure each instance to listen on the default port on that IP...

Don't believe that tool is necessary anymore, and it was only ever minimally necessary when you mixed very large files on a volume with a large amount of small files...