One thing to keep in mind in full mode that if you have the active part of the log at the end of the log, the file won't shrink. There...

Heading the SQL Sat LA in a few weeks.

The only other one I have on the agenda now for the US is Pittsburgh. Louisville/BatonRouge/Sioux Falls/Lincoln up in the...

Well, it's a problem with MS not supporting an LTS (long term support) version. I'd expect that MS moves to support the LTS or active branches. This seems more like...

You can use netstat /a to look for listening ports on the server.
Double check that config manager has the correct ports for the instance.
Check that the cluster is...

Is there some issue with this? I'm curious why/how you noticed this or are concerned.

If you bring the secondary online, you might appreciate single user, especially if you...

Did you check both the source and desintation servers? Maybe the job is on the other one?

My reading of this is that you installed SQL Server, created a login and/or user, and assigned a password. You then entered this in your Control M application. Is that...

SQL Prompt offers lots of formatting choices, but it's a paid tool.

There are options when scripting in SSMS. If you look under options, in the SQL Server...

Good list above. I've avoided setting this up, as it an be a pain, but here's what I'd do.

1. Need to get some VPN on your home side....

That spammers constantly find new ways to auto submit some things. There certainly are some holes in the site, and we've avoided trying to make it difficult to post, since...

Sorry, pad the space in each interval to get values inside of the spaces. I don't quite understand the exact math used here myself, and I've struggled to determine the...

Ah, it's a poor question. I've been working with the Scripter object and using it, so I was thinking along those lines. I should have used a poorer alternative answer.

Perhaps. Didn't add one as it wasn't on my mind here.