HOW TO find SQL Server edition info

While deploying applications, you may require details of the SQL Server edition or other properties, like I did when I had to find if the latest Service Packs were installed and this function is useful to know:

SELECT SERVERPROPERTY('ProductLevel')

Edition
ProductVersion
ServerName
Collation
Engine Edition
InstanceName
IsClustered
IsFullTextInstalled
IsIntegratedSecurityOnly
IsSingleUser
IsSyncWithBackup
LicenseType
MachineName
NumLicenses
ProcessID

Comments

Post a Comment

Popular posts from this blog

A Beginner's Guide to Data & Analytics - Highlights

Image
The 22-page free ebook " A Beginner's Guide to Data & Analytics " from Harvard Business School Online offers essential definitions and practical advice for those looking to learn more about the field. * Data science is the process of building, cleaning, and structuring datasets to analyze and extract meaning.  * Data analytics refers to the process and practice of analyzing data to answer questions, extract insights, and identify trends * Types of Analytics: Descriptive analytics looks at data to examine, understand, and describe something that’s already happened. Diagnostic analytics goes deeper than descriptive analytics by seeking to understand the “why” behind what happened. Predictive analytics relies on historical data, past trends, and assumptions to answer questions about what will happen in the future. Prescriptive analytics identifies specific actions an individual or organization should take to reach future targets or goals * Data literacy is the ability to
Read more

Oracle Cloud Infrastructure 2024 Generative AI Professional Course & Certification Exam (1Z0-1127-24)

Image
I was happy to learn about the Oracle Cloud Infrastructure 2024 Generative AI Professional Course with video tutorials and the Certification Exam (1Z0-1127-24) from their newsletter. I found it extremely useful, timely, and relevant. The course, with about 6 hours of videos, provided me with a comprehensive view of what it takes to build a Generative AI application. Although some parts reference OCI services, much of the course remains vendor neutral. Rohit Rahi and his team at Oracle have done a great job of structuring the beginner-friendly yet comprehensive course so well, covering all the essentials across four modules. The curriculum strikes an excellent balance between depth and accessibility.  While Gen AI output is typically non-deterministic, I was surprised to learn that they can be made completely deterministic under certain conditions. Specifically, in the OCI Gen AI service, setting the temperature parameter to 0 produces consistent, deterministic output for a given prom
Read more

AI - Reflections & Perspectives

Image
* "Treat AI assistants as a slightly-drunk knowledgeable friend" - Richard Seroter * "No matter how valuable your skills are in the market today, they may or may not be highly valued by the market over the course of your lifetime. With artificial intelligence (AI) threatening to devalue entire categories of human work, we need to be more purposeful in recognizing a key distinction: the market value of a set of skills is not the same as its human value.  ...the US has become a service economy.  Many people still don’t recognize caregiving, for example — whether for the very young or very old — as a particularly skilled profession. This is mistaken. Anyone who has ever had a teacher who changed the course of their life simply by listening knows that some people develop skills that are extremely valuable and hard to acquire. How do you listen to someone’s needs even when they’re not clearly articulated? How do you help children develop confidence and joy? How do you help pe
Read more