Licensing

SQLServerCentral Editorial

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

You rated this post out of 5. Change rating

2019-05-30

423 reads

External Article

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

Cool AI sites

By

As I researched and wrote my OpenAI and LLMs blogs (see Introduction to OpenAI...

A Quick Test Data Manager Eval with My Database Backup

By

I wrote about getting the Redgate Test Data Manager set up in 10 minutes...

Take over Ownership in Microsoft Fabric

By

When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse,...

Read the latest Blogs

Forums

Why you should avoid Implicit Measures in your Power BI model

By Koen Verbeeck

Comments posted to this topic are about the item Why you should avoid Implicit...

Change all occurances of one field in DB

By water490

Hi everyone I am doing some clean up of my DB.  There is one...

locks in sql database 2019

By yfiguero

please help. Do they know if the use of try and catch for error...

Visit the forum

Question of the Day

Dates and Languages

The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned?

DECLARE @yourInputDate  NVARCHAR(32) = '28 listopad 2018';

SET LANGUAGE Polish;
SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish];

SET LANGUAGE Croatian;
SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian];

SET LANGUAGE English;

See possible answers