Released this back to normal. I don't see anything in there that would...

Unless these are relatively small tables, this is going to be a problem. There isn't a way to do this across tables easily.

You can insert data from a table into...

https://www.mssqltips.com/sqlservertip/2612/data-driven-colored-text-for-reporting-services-reports/

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...