Glad it works. You are welcome and hope this solves your issue.

The product key will not limit the number of cores. The PID is an administrative item, not an item that changes how SQL works. You can use affinity to limit...

Just a question about data masking. If a customer describes a problem in production, he uses the real environment with the real names of persons, etc. For example :...

• This reply was modified 6 years, 8 months ago by Steve Jones - SSC Editor.

Glad we can help you in some ways, and maybe you'd like to write a bit on how you build a db for personal use sometime. I'm sure it might...

That should work, though I would think you could name the CMK/CEK the same on each system, even if different values.

I can see the answer as misleading. Edited it.

Here's the issue. AE requires the cert to be installed for the system and access to resources outside of SQL Server. This also does an encryption outside of the db,...

I see few people use it. Those that do think it's great, but I think this is a bit of you needing to ensure your process fits with DQS, not...

I agree with Jeff. If you want to change passwords, do so though be aware this might mean reboots or restarts. For service accounts, use group service accounts, or strong,...

Edition? This matters.

SQL licensing guide: https://www.microsoft.com/en-us/sql-server/sql-server-2017-pricing

For Standard, only 20 cores are used. If you want 24 cores, you need to go with Enterprise.

You cannot license 8 cores. From the...

I assume this was a dev server of some sort?

Moving the files is good for organization, but it doesn't really matter here. I would likely have left them alone and...

Scott has a good explanation, but I agree with Eirikur, get Grant's book:  https://www.sqlservercentral.com/books/sql-server-execution-plans-second-edition-by-grant-fritchey

OK, I assume you mean that you can look at the SQL Server error log and see this. It is also logged to the Windows Application log, and you can...

Closing. Post here: https://www.sqlservercentral.com/forums/topic/not-seeing-failed-logins-in-log-viewer-or-profiler

Wed am. Not going to the opening party, no ticket, but will be in the WSCC until 4-5.