I see this responsibility (maintaining an inventory of Azure assets owned by the enterprise) falling under the umbrella of Platform Operations or Data Governance, not necessarily the DBA team. Not...

Yes, going forward, SPID and LoginName would be useful in the error log.

For now, if no one fesses up to the infraction, then perhaps hold all the...

Regarding the observation that the pace or quality of documentation often doesn't keep up with the pace of software development, one factor is that documentation is often left up to...

If you must do something like this, then at least automate it using a simple and tested script like the author provides. In the distant past, I've seen projects where...

What I've observed about SSMS 2016, since it was ported to VS framework, is that it takes longer to load and will occasionally freeze up. I'm guessing it has more...

Stupid SPAM doesn't even compile enough to form a complete a thought.

I have a database table containing one row for each MSSQL instance, and this table contains columns for physical environment, settings, capacity, etc. in addition to a description and the...

Yes, SSMS is free, as in free beer at a $5000 / week all inclusive resort. But the SQL Server resort experience is well worth the price tag.  🙂