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.
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.
Named Instances and Default Instances
Named instances and default instances differ in connection strings, ports, SQL Browser discovery, and the operations each one needs.