I believe what you're looking for is a 12 month counter, starting with the current month + 1 and moving backwards for 12 months. If I understand this, for any...

Definitely Freudian. I've done it a few times. Apparently, as much as I like Service Broker, I don't like Service Broker.

No, this is a simple form, not an interactive designer (yet).

We prefer to select answers so only one is correct, but we do support multiple correct answers. Be sure your...

Will do ,and apologies on the delay. Our migration expert has been on holiday and busy with non SSC stuff. The migration scripts seemed to run correctly this time, so...

OVER clause: https://docs.microsoft.com/en-us/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-2017

If you mean something like this, you can't do this:

declare @i int = 2;
select sum(a) over (partition by b
      ...

I see this, but without any data as well. The platform peridocally saves things itself, but nothing went through with the post. Not sure what's wrong here. Can you type...

Does this happen even if the browser is not maximized?

So it's official. I've been accepted to Grace Hopper 2019 in Orlando to talk about "Imposter Syndrome: Are You Ready To Mentor". WHEEE... Now I have to overcome my...

You can grant rights to the public server role here for access to the database, but be careful here. You might be better using SQL Server auditing instead.

You can also...

This doesn't make sense in how you've written it. Please be more descriptive and format the code so it can be understood. It looks like you intend the commit/rollback to...

These have been found and migrated.

Been a mystery for me as well. It's the big reason why Redgate built SQL Source Control. Not sure if they'll ever change.

Just saw that. Going to be a busy day. Hard choices to make

I love the touchsceen. XPS was on my list, but I think at the time the Spectre was a better deal. I'm not sure I need to 2-in-1 thing. After...

That's likely a default. Having your database as a different collation than the server instance is not a problem. You may have issues if you use temp tables, in which...