Tag: SQL Server Administration

Core SQL Server administration topics covering day-to-day DBA responsibilities, configuration, maintenance, monitoring, and operational management of SQL Server instances.

  • How to Check SQL Server Version

    Knowing exactly which SQL Server version and build is running is foundational DBA work. It comes up during patching, incident response, audits, upgrades, and when engaging Microsoft support. SQL Server exposes version information in several ways. Some are fast and visual, others are scriptable, and a few provide deeper installation detail when you need it.…