It's likely never going completely away, but we are getting better about writing code to avoid this and detecting it in scans.

The hierarchy is that one key encrypts another. So the SMK (service master key) encrypts the DMK and allows it to open. The DMK, once open, allows you to open...

I also wonder how this works with staff turnover. Right now, most of us have met others in our offices and worked with them. What happens over time as we...

Will we continue to work long term WFH? I really don't know. I suspect not, because WFH was never something any employer in my state, allowed before COVID-19. My...

I ran into this and was surprised. The syntax is strange, but what a quick easy way to aggregate.

Why not indeed. This has been a bug with people and SELECT * for a long time.

Essentially, the compilation of the view is the problem. It's like two different programs...

My apologies, I neglected to look at the forum. Most of the T-SQL is from 2012+ (LAG/LEAD). EOMONTH is 2014+

That is really strange. If it works from the wizard, but not from T-SQL.

Is there some strange name? If the wizard, if you search, you can see local accounts, as...

Redgate owns SQLServerCentral. They purchased the site about 13-14 years ago. I now work for Redgate, though they give me a lot of independent editorial control.

Just submit an article and...

Use the "Script" button from the wizard to determine what you are doing wrong. Pick a local account and then see what is scripted out.

So, I broke this down a bit, using a tally table to project to the future. I think all your dates after n= 5 will be the same, but you'd...

With encryption how? TDE?

AFAIK, if you want to restore, this indicates you can restore on a different server. I haven't tried this, no MI in my account, but can you...

If you follow the same code path, unless the data changes, you'll get the same result.

However, and this might be me mis-reading your post, but it seems like there are...

The reseller sounds slightly incorrect. You always need a key for licensing. Maybe they are holding the key to keep you going back to them, but they shouldn't.

you need some...

I'm glad you posted. I had never thought of a pull request as being on the same branch, albeit a copy that is ahead of a remote. It made me...