Licensing

High Prices for High Security

  • Editorial

I was excited to see the new Secure Enclave technology come to Always Encrypted (AE) in SQL Server 2019. I've thought that the way Microsoft implemented the AE technology in SQL Server 2016 was a start and a good step forward, but it had too many restrictions. Kind of like Availability Groups in 2012 and […]

2019-05-30

197 reads

Get CPU and Cores for SQL Server 2012 Licensing

  • Article

With SQL Server 2012, Microsoft introduced a new licensing model; licensing per core replaced the licensing per processor. We need to adjust budget to reflect licensing changes for our next Enterprise Agreement renewal, but we do not have processor core information from any of our server inventory tools. This tip explains how to quickly gather information about each server's processor cores without logging in to each server.

2013-10-02

3,659 reads

Blogs

Daily Coping 18 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Optimize for Unknown for Inline Table-Valued Functions

By

I had a curious performance issue today. An inline table-valued function (iTVF) was performing...

Daily Coping 17 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SQL Server 2016 seeding automatic stuck

By zouzou

Hi all, Problem help please, I have 2 servers in sql server 2016 and...

will this get replicated to secondary replica

By coolchaitu

Dear Experts, In Availability Group, if we move ndf file to another drive on...

slow query performance

By vsamantha35

Hi All, I have a SELECT query which is taking more 8 mins. Can...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers