The DBAdmin Toolkit

It’s time to put it all together into something useful, but before we do, we need to decide where to put it. There are two schools of thought on the subject: One maintains that user objects should never go into the master database, while the other maintains that administrative tools aren’t exactly “user” objects and so […]

Getting to Know You(r SQL Server) — Part 2

In my previous post, we gathered some basic information about the connected SQL Server using standard T-SQL commands and formatted it in a nice two-column output. To dig deeper, we’ll need to turn to the undocumented, unsupported (cue scary music) xp_instance_regread. Let’s get things going by finding where the current instance is installed:

SQL […]