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 […]


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


3,659 reads


T-SQL Tuesday #121: Gifts received for this year


At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve...

T-SQL Tuesday Gifts (#121)


It’s that time of month. I missed last month while traveling, but I wanted...

Speakers wanted for the Richmond (VA) SQL Server Users Group – 2020


Are you a speaker in SQL Server topics? Come on out to Richmond, VA...

Read the latest Blogs


Star- and Snowflake Schema in MOLAP

By ktflash

Ahoi, the difference between Star- and Snowflake obviously makes a difference in performance for...

Is there a reason to change the service account name?

By shmulikc1204

Hi All I was asked to change the SQL service account name.  I asked...

Failed to initialize sqlcmd library with error num -2147467259. [SQLSTATE 420000

By prem.m38

Hi Guys, I am getting below error when i am trying to  send the...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers