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

HOW TO Filter Products on Open Food Facts by Country (India) Using DuckDB & Superset

Image
Open Food Facts (OFF) is a crowd-sourced database of food products from around the world.  Somewhere in the world, a shopper scans the barcode on a packet of biscuits and adds basic product details. Another person photographs a package label for the same product in Hyderabad. A volunteer in France fixes a typo.  That's Open Food Facts, a volunteer-built, openly licensed database of food products that's continually changing and growing. Each product is identified by a barcode and carries ingredients, nutrition facts, brands, labels and more. The whole database has millions of products, and let's say you only want the products recorded as being sold or available in one country like India. There are multiple ways to extract a subset of the OFF database. I have already tried using the daily dump available on Hugging Face through Google Colab and GitHub Actions in the past but it blew my mind that using the OFF deployed Apache Superset , you can execute a SQL query in a brows...
Read more

Oracle University Free Courses & Certification Exam Prep Material (2026)

Image
A few decades ago, quality training was scarce and costly. Thanks to the convergence of several new advancements, software vendors now provide online training to a worldwide audience, making skill acquisition more accessible than ever. Microsoft offers its Microsoft Learn platform, Google provides Google Skills , and Oracle University is doing a great job of delivering training for their products while also covering higher-level concepts relevant to the database, cloud, and AI domains. The following Oracle certification exams are free to take and come with learning resources: Oracle Cloud Infrastructure Foundations Associate (1Z0-1085-26) Oracle Cloud Infrastructure Architect Associate (1Z0-1072-26)   Oracle Data Center Operations Foundations Associate (1Z0-3000) Oracle Multicloud Foundations Associate (1Z0-1144-26) Oracle Cloud Infrastructure AI Foundations Associate (1Z0-1122-26) Oracle AI Database Foundations Associate (1Z0-1195-26) Additionally, Oracle University offers many ...
Read more

This Week I Learned - Week 42, 2026

Image
This Week I Learned -  * 18 large language models from six AI labs now generate everything from code explanations to creative fiction. Even in a single short paragraph, every model leaves subtle clues in its word choice, tone, and sentence structure. Each lab's training data and post-training choices leave behind distinct stylistic fingerprints in vocabulary, phrasing, and punctuation. The October Kaggle competition requires participants to build models to classify ~4,000 unlabeled text passages across 18 frontier language models from OpenAI, Google, Anthropic, Qwen, ZAI, and Moonshot AI. The goal is to find out how reliably today's frontier models can be fingerprinted from short text alone.  * Experiential Labs is an OpenAI-compatible model gateway. A user reported that they're injecting ads into free tier model  responses without disclosure. It turns out it is mentioned in their long privacy policy that no one really reads.  * Tesla's Full Self-Driving (FSD)...
Read more