Let us learn more today in this blog about Maximizing SQL Server Security: Instance Hiding vs SQL Browser Disable.
SQL SERVER – Find Instance Name for Availability Group Listener
An Availability Group Listener identifies a connection endpoint rather than a separate engine instance. I query where this connection actually arrived.
Exporting and Sharing Registered Server Groups in SSMS
One shared server list can save you from running a query on the wrong server. Here is how to build it, export it without passwords and use it.
SQL Server Version and Edition: SQL in Sixty Seconds #043
To find the SQL Server version and edition, read SERVERPROPERTY instead of parsing @@VERSION. The tests here show every useful property on SQL Server 2025, why ProductLevel can say RTM after an update, and how to read the version from the ERRORLOG.
Is This Instance Patched? Reading ProductUpdateLevel and Build
An update label is one clue, the build number is the identity. I show how to read both, compare builds safely, and avoid the NULL typo trap.
PARSENAME for Dotted Values: Build Numbers and Object Names
Why does revision 12 sort before 7? Because the parts are text. Here is how PARSENAME fixes it, and where it trips you up.
Reading Default Data and Log Paths With InstanceDefaultDataPath
Changing the default folder does not move a single existing file. Here is how to read the defaults and spot databases that ignore them.