datachick

Glad you added this. There's a lot of confusion out there how MQ works. 

Thanks. I'm glad it resonated with you.

Well, I like to refer to my points of view as being a "cynical Pollyanna". A hybrid. I specifically focused on the basics of data. People, places, things, and events. One could even introduce subsets of data (Indonesian people who have no family names, places with no mailing address. People with no middle names. Events…

Fill me in on the context of this, please...

And data will set us free. Or something like that.

I doubt that. But yeah, sometimes life is hard for a DBA.

Ahead is in the way, right? Same goes for Agile, Lean, MVP. All of it. You can’t leave infosec to phase 2. Or 22.

We should all wonder that, it keeps up on our toes! Seriously, thought, there isn't as much training out there for data protection at the technical level. I'm trying to change that.

In earlier years, we used shared dev environments. In those cases, the environments could more closely resemble production. But it's been years that we've had highly distributed development environments with a greater focus on shared repositories and smoke testing, not functional testing until later in the process. There…

I'm back as a Thwack Ambassador! I'm hoping this series on being an accidental DBA can lead to discussions about what it means to be "accidental" and a "DBA" at the same time.

Good designers work hand-in-hand with production DBAs, Developers, and business users to find the right balance of performance, data integrity and data quality. I'd also say that query-tuning is the number one value add for solving performance problems. It's why we go there first. Sure, we can make cuts to data quality to…

What, no @SQLClippy?

This page has a good list of countries that have federal data breach legislation and what the penalties are. Read carefully; it seems some of the items mix penalties for intruder and stewarding organization. But there are plenty that have criminal penalties. Practical Law UK Signon

That's great! I had a database prof who would do things that made even the men cry. He'd assign a 2-hour deep dive presentation on database Internet's, but when you walked in he'd say "sorry, today you are doing a 10 minute executive overview within a 15 minute q&A and you can't use your notes or slides. And then the…

Are your comments just anti-Microsoft, or anti-SQL Server?

Ah, the Throwdown. I will bring a crying towel for you.

That’s a difficult thing to balance.

Ah, right. And thanks for teasing me with space pics!

If you mean mimicking data to be using non-prod data that has a similar profile as production data, I have no issue with that. But it would still need to be enhanced to include data that needs to be supported but currently does not exist in production data.

Good point about alerts. I wrote this week briefly about Alert Burn Out. And one of the issues related to that is establishing the criticality of alerts. That sort of thing is usually tied to an escalation process as well. In other words, when should your boss be notified that you haven't responded to a certain type of…

Love that idea.

I'm trying to find more facts about this part. It's my understanding that the onsite team had alert overload, so were used to having slow responses to alerts.

I see what you did there...

Just leaving this here for you all.

Since you've started with "what's wrong", I'll come back with "no, it's not wrong". Dev environments: Modern dev environments often have less security. Many security tools and licenses aren't available for the 450 dev machines in a company. Not saying it's right, but it's real. Just like not all dev environments have the…

Good. The next post will focus on more steps, some with more detail. I feel like I could write a whole book on this.

In the US, that "shop rate" is overloaded with all those bad debts. It doesn't actually cost $1mil in your example; that's just what the hospital has to charge to make up for all the debts. Instead, in other countries (all of the industrialized ones), 300 million people pitch in $.001 each for that (actual) $300k surgery.…

I had a DBA tell me that about Foreign Keys: he told me SQL Server FKs don't work and that he could write triggers that would run faster than FK constraints. By co-incidence, he was the first production DBA I've ever had to remove production access from because he was always "Fixing things" in production that took down the…

Cobbler's children, all of us.