I was pretty hesitant to do in-place upgrades based on my experiences with older versions, but I've done about 8 in-place upgrades from 2012 to 2016 this year and, fortunately,...

At the bottom of this page there's a script posted by shahmm that will give you your IF NOT EXISTS...CREATE scripts for all of the indexes. You can...

What was wrong with mirroring that you chose not to use it? 
The big question is how you define "synchronize" - how much of the data do you need, how...

It's in 8KB pages, so multiply the number in the Size column by 8 and you'll have the size in KB.
See the documentation for that info and more: 

Just to tack onto Sue's advice, you should also look at the account that's running the scripts.
Running Get-Module -ListAvailable from Powershell running under the context of the account...

I realize this was a week ago, but have you taken a look at the CommandLog table in your master database?
You should be able to see the information (including...

Another option using the temp table provided by Steve, because it was a fun distraction:

SELECT final.MaxDate, final.Max FROM
(
    SELECT TOP 1 WITH TIES

Try


install-packageprovider NuGet -Force

get-packagesource

Install-Package Microsoft.SqlServer.SqlManagementObjects -source https://www.nuget.org/api/v2


The source in the last line should be listed as a location...

The first and most frequent thing I check is emails. Locally we get emails for job failures, deadlocks, long running processes, tempdb growth, and a few other health checks. The...