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...

One thing engineers can do is install the sensors and self driving software in cars - but just don't connect it to the steering, breaks, etc. Human drivers, who volunteer...

"Must have minimum eight years' experience with SQL, coding queries, SCUD, stored procedures and data import/export."

scud (verb):

1. to move or run swiftly especially as if driven forward

2. to run before...

In many cases, the "DBA" may in actuality be a jack of all data related trades - expected not only to keep the databases running but also create all the...