Thanks for the feedback everyone.

Rod, I think the analysis paralysis thing is a problem for really smart people. Me, I'm more likely to come to the brown leaves conclusion...

Often times (especially in the realm of politics, finance, and health) the data itself can be rubbish when curated to support a narrative.

My basic advice to a startup would be:

• Don't build up your own data center - Let cloud providers like Azure and Amazon do this for you at a fraction...

Logging process failure notifications to a Slack channel is good too, because there an existing app for receiving alerts and it's easily accessible to users across the organization.

It's now 2021, and one option we have now is to log errors to something like a csv file, and then mount it as an external table using PolyBase, so...

On-prem SQL Server instances in large organizations are typically treated by accounting as a capital expenditure (CapEx), so there is a financial motivation to hang onto it for 10 years...

Steve, what you've started is great, and the site works perfectly for me in Chrome.

I've been wanting to start a blog and debating various low maintenance options. This approach you've...

Maybe these temp files are how Spotify keeps track of how many active devices are connected to your account at one time. Your account may have a limit of like...

Yes, understanding the nuances for RDMS security models can be difficult. Really, most DBAs don't know as much as we should. Everything from contained users, ownership chaining, nested domain groups,...

Regarding MS Excel, that's my least favorite data interchange format. In a previous job, I found out the hard way that when someone in accounting hides a range of rows...

When it comes to data interchange file formats, the merits of one versus another comes down to:

• how efficiently it can be parsed (ingesting a million records in 1 minute...

So, companies that provide 3rd party database management solutions need to do a better job of designing their software to operation with least privilege rather than simply requiring that the...

I was thinking the other day about why Colonial Pipeline shutdown their flow of oil for weeks after their ransomware attack - rather than simply restoring from backup and/or keeping...

The example presented in the article, executing a stored procedure within a loop for a set of input parameters, is one of those scenarios where looping is justly applied. Refactoring...

When I do use looping in conjunction with SQL, it's because I'm doing something DBA-ish: like looping across databases to execute a DBCC or BACKUP command, or querying meta data...