People often confuse the window and analytical functions, which is what I would have asked. Often the code might need to be pre-2012, so using the OVER() with windowing functions...

Apologies. That is poor verbiage. I want to omit these from the result set. I'll change that.

DevOps doesn't remove the need for QA functions. It might say that we blend that into the development team, but there is still the need for testing. Most DevOps shops...

No need to apologize, but the "up to date" doesn't fix this. You need a trace flag, which is part of what you would need to know. This isn't fixed,...

Still haven't seen Star Wars. Was disappointed in 7, 8 was better. Need to go see the last one with my kid. Finding time is the hard part now.

As practice? Or to...

Good article, Steve. At first I thought it would be much the same as I see everywhere, at this time of the year. However, you brought up two important...

At first, I read this as Steve saying (in a general way) "...write articles to help get jobs...", but on reflection I now see it as "...use the written...

Congrats, and glad we helped you.

Yeah, I worry about that as well. I'd think flying cars would need some sort of lane (tube?) that limits where people can do.

What do you mean, Neil? The question states the data is encrypted in 2016, moved to 2017. There's no "up to date" here. The algorithm changes. You can't xfer a...

Every one they support. If you support it, you should be supporting it on the platforms that are out there. Most minor changes shouldn't be affected, but limiting the ability...

What do you mean by description? The extended property for MS_DESCRIPTION?

Except, Microsoft provides support for the CUs. A vendor should be able to test that a CU will, or will not, cause issues in their test suite. It's not perfect,...

Vendors are a huge problem in patching. I'd like to see contracts explicitly state they'll certify within xx months, with xx being < 3.