Disclosure: I work for Redgate Software and am biased, so be aware. Also, I will not talk up or down anyone else's products. If others have experience or thoughts on...

Click Windows key, the type "services", you should see this:

Run the services app and then scroll down to the "s" section. You should see SQL...

That is an Azure SQL Database, not SQL Server 2012. There is no SQL Server service pack for this. Microsoft controls those versions and v12 is the current one.

What's the build there?

You can get builds  here: https://www.sqlservercentral.com/articles/sql-server-2012-build-list

select @@version

gives the build

Semiconductor

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