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

187 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

T-SQL Copy & Paste Pattern – Increasing a performance problem

By

Disclaimer: The title is my assumption because I saw it in the past happening...

Removing ad hoc plans from Query Store

By

This is not a post about the “optimize for ad hoc workloads” setting on...

Disaster recovery, tools edition

By

I just completed a chapter for another book where I spoke about the Recovery...

Read the latest Blogs

Forums

TDE for Always on databases

By bobrooney.81

Hi All, In terms configuring and usage of TDE encryption is there a difference...

OLE DB Destination has written 0 rows

By DinoRS

Hi SSC, I'm having issues with one SSIS Package running on SQL Server 2017....

FileStream - Azure managed instance

By NicHopper

Hi, Simple question, I know that FileStream is not supported in Azure DB single...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Fashion

See possible answers