datachick

I've seen that. Plus to train them on how to analyze the data and react to it appropriately.

That's a good point, too. I wasn't advocating that cross-collaboration means that people should be make changes in these other environments, but being able to see across team resources to have a better view into what's going on. I've also been in situations where separation of duties meant I couldn't do my job. I was an…

SIgns You Might Be An Accidental DBA

I think we need to question everything. Maybe not every day. Maybe not with the same priority. But being able to ask questions is how we progress. On projects where asking questions is seen as frivolous, I see a lot of fail. So I'm not saying we have to collect ALL THE DATA. But asking questions leads to asking more…

Yes, always important. But I've seen the biggest risks taken by IT users. Likely because they have greater access to technical resources.

Thank you. What else would you like to see a new DBA do first thing?

Another tactic is to do your best to publish data you can find about that guy or gal's stuff. They will immediately see the loss of power and start sharing bits of data.

That's like Azure and me. I have a lot of resources and no time to learn.

Not quite a CMDB (because these are inventory scans without a lot of enhancements and meta data, at least for now). But in principle, it's similar.

In almost all my engagements I have to beg people to completely shut down all access for me when I leave.

And then automate your automations. I can't tell you how many troubled projects I've been on where it was clear the reason they were so behind was that they were doing EVERYTHING manually, and doing things they didn't need to do.

Excellent point. Have you been reading the yet to be published third post in this series?

I can't wait, either. What I saw at Tech Field Day was great.

I think it will be a CLM* as a data professional to ignore or be ignorant of security issues in IT due to these laws. And I'm a firm believer in the snarky ROI definition. It's not just data breaches. I've worked in safety-focused IT (utilities, healthcare, transportation, defence, etc.). Keeping my boss out of jail was a…

So far the data shows that human drivers do more harm than autonomous cars (semi-autonomous), per mile. And the classic "trainload of passengers" or "child" dilemma won't go away with technology.

I agree. Getting stuff approved is a zero-sum game when it comes to budget. There's a fixed amount of money and the people who bring the right cost, benefit and risk statement are going to get to that pot of cash first.Having data to back up that business case really helps.

I could talk normalization myths all day. So many people don't really understand it.

All of these discussions are the same ones I'm having with end users: how much data do we need to keep, how do you use it for decision making, how much data do you need to make a reliable decision, how do you make those decisions...we need to manage our own data the same way.

So surely there are more questions...which ones have you asked?

Thank you. I've already used it a couple of times!

Especially while you are grabbing another coffee and watching the script do all the hard work for you.

I'm happy you found it helpful

The trade off of hiring people you like is that you may end up discriminating of just ”different”, depending on how your personal preference system works. If you just mean “don’t hire jerks”, I’m with ya.

If you can map your technology wants with business needs, you're golden. Love this saying. I may steal it

Yes, sqlrockstar​ and I have a section on that in one of our webinars on this topic. "Don't Panic" I think is the theme.

I think that's already been done...

Maybe you are thinking just about operational DBAs? I'd definitely say that dev DBAs and Data Architects are responsible for data quality. And ETL time is WAAAAAAY too late to be working about data integrity. Also, while some application features can help with data quality, having data quality built into the database with…

In some jurisdictions there are privacy laws that make breaches a criminal offense for allowing a breach or disclosure to happen. In the US there is no current criminal legislation for breaches, you are correct. I believe at some point the US or some states will begin enacting non-trivial penalties for the types of things…

I hear that involves breakfast tacos, BBQ and beverages.

Very good point. I'd say that's true for most outside service providers.