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

30+ GitHub Products & Key Ecosystem Features You Should Know in 2026

Image
GitHub has grown far beyond a place to host code — today it's an entire ecosystem covering CI/CD, AI-assisted development, security, package management, and team collaboration. Whether you're new to the platform or just want a single reference point, here's an alphabetical list of GitHub's major products and features, each linked to its official page - GitHub Actions GitHub Advanced Security GitHub Apps GitHub CLI GitHub Code Review GitHub Code Security GitHub Codespaces GitHub Container Registry GitHub Copilot GitHub Copilot Business GitHub Copilot CLI GitHub Copilot Enterprise GitHub Copilot Extensions GitHub Dependabot GitHub Desktop GitHub Discussions GitHub Education GitHub Enterprise Cloud GitHub Enterprise Server GitHub Gist GitHub Importer GitHub Innovation Graph GitHub Issues GitHub Marketplace GitHub Mobile GitHub Models  (retiring July 30, 2026) GitHub Packages GitHub Pages ...
Read more

Uncle Bob vs. Grady Booch: Rethinking Code Reviews in the Age of AI

Image
In response to a question about the feasibility of effective code reviews for large (e.g., 500-line) AI-generated PRs like those from Claude, especially when reviewers lack deep codebase familiarity in new projects or fast-paced environments, Uncle Bob Martin and Grady Booch have contrasting views Uncle Bob Martin advocates metrics-based oversight (test coverage, complexity, dependencies) and higher-level management over line-by-line AI code review, while Grady Booch stresses manual verification for vulnerabilities, dead code, and performance factors. Uncle Bob Martin : " I don’t review code written by agents . I measure things like test coverage, dependency structure, cyclomatic complexity, module sizes, mutation testing, etc.  Much can be inferred about the quality of the code from those metrics. The code itself I leave to the AI.  Humans are slow at code. To get productivity we humans need to disengage from code and manage from a higher level." Grady Booch : "Unlike B...
Read more

Compact Business PCs Explained: Dell OptiPlex, Intel NUC and Lenovo ThinkCentre Tiny Desktops Compared

Image
For many people, a desktop computer conjures up images of a large tower sitting under a desk. Yet over the past decade, manufacturers such as Dell, Intel, ASUS, and Lenovo have shown that a capable desktop doesn't have to be much larger than a paperback book. Compact business desktops—including the Dell OptiPlex Micro , Intel NUC (now ASUS NUC ) , and Lenovo ThinkCentre Tiny series such as the M700 Tiny —typically occupy just around one litre of volume , earning them the nickname "1L PCs." Despite their small size, these machines often include desktop-class Intel Core processors, support up to 32–64 GB of RAM (depending on the model), NVMe SSD storage, Gigabit Ethernet, Wi-Fi, and the ability to drive multiple monitors. Many consume only 10–30 watts during typical office work, making them significantly more energy efficient than traditional desktop towers. Originally designed for enterprise environments where desk space and manageability were important, these systems ...
Read more