If you have numerous installations of SQL Server in your infrastructure (with various different versions and licensing models in operation) – when you purchase a new copy of SQL Server – do MS give you a licence key that needs entering before the software is fully functional?
Likewise – when you purchase SQL CAL’s – is there a licence key to enter on the end users’ desktop before the CAL works?
If you have a central log of all software licences, it appears hard to determine were that software has been deployed (i.e. which server it’s been installed on), so if you could tie up licence keys it would be a lot easier.
Second part of the question will be to see if there’s a query to extract the keys to compare to the key entered to activate the software with the inventory of purchases licences.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …