Posted on

DevOps Terms – and Why They Matter to Database Specialists

In this 20 minute session, I define scrum, continuous deployment, test driven development, DevOps, and related concepts. I close with a quick discussion of why Database Administrators and Developers should care about DevOps.

Prefer to listen on the go? Subscribe on iTuneslisten on Google Play, or plug this URL into your favorite podcasting app: http://dearsqldba.libsyn.com/rss#

If you enjoy Dear SQL DBA, reviews  on iTunes help me out a ton.

Slides from the presentation

Posted on

Employee Agreements & Contracts: Best Practices (23 minute video)

So you’ve got an employee agreement in front of you: now what? In this  episode, I talk about practical steps you should take to make sure that you understand the terms of your contract, and how to potentially negotiate the terms.

Listen on the go

Subscribe on iTuneslisten on Google Play, or plug this URL into your favorite podcasting app: http://dearsqldba.libsyn.com/rss#

Video

Slides from the talk

Posted on

Employee Agreements & Contracts: Anti-Patterns (31 minute video)

When you take a new job in software engineering or in IT, within the paperwork there often lurks an employee agreement: a contract between you and your employer. In this half-hour live episode, I talk about why these contracts exist, and multiple anti-patterns you should avoid.

This is the first of a two part series. In the next episode, I’ll discuss best practices for understanding and negotiating the contract.

Want to listen on the go?

Subscribe on iTuneslisten on Google Play, or plug this URL into your favorite podcasting app: http://dearsqldba.libsyn.com/rss#

Video (31 minutes)

Slides from the talk

Posted on

Dear SQL DBA: Remembering Robert Davis, DBA Hero

What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that Robert displayed that I hope to emulate.

If you’d rather listen on the go, subscribe on iTuneslisten on Google Play, or plug this URL into your favorite podcasting app: http://dearsqldba.libsyn.com/rss#

Links from the video:

Posted on

Dear SQL DBA: Why Don’t You Teach Service Broker?

To Broker, or Not to Broker? That is the Question

I’ve gotten a few questions about whether I recommend learning Service Broker, and recently I was asked if I’m planning to make any courses on Service Broker. In this 23 minute episode, I talk about why I personally haven’t become an expert with Broker, the factors that I believe play into Service Broker adoption, and other resources online for learning Service Broker in SQL Server.

Join in the fun

  1. Attend the Dear SQL DBA podcast — live! Register here to get an invitation.
  2. Got a question for Dear SQL DBA? Ask away.
  3. Subscribe:  If you’d rather listen on the go, subscribe on iTuneslisten on Google Play, or plug this URL into your favorite podcasting app: http://dearsqldba.libsyn.com/rss#

Posted on

Dear SQL DBA: Training Resources for SQL Newbies

New to learning SQL Server? Get the scoop on free online resources to look up information, ask questions of community members, and learn SQL Server from the ground up.

Links from the episode

Clickable links are here.

Join in the fun

Attend the Dear SQL DBA podcast — live! Register here to get an invitation.

Got a question for Dear SQL DBA? Ask away.

Subscribe:  If you’d rather listen on the go, subscribe on iTuneslisten on Google Play, or plug this URL into your favorite podcasting app: http://dearsqldba.libsyn.com/rss#

Audio only version

YouTube version

Posted on

Dear SQL DBA: Dealing With a Lack of Control

This week I discuss a question that I’ve gotten in many forms over the years – a lot of the scenarios are so specific that it’s hard to keep them anonymous, but they can be generalized as a bigger problem: how do I deal with being responsible for things that I can’t fully control?

DBAs have huge responsibilities, so this is a common, frustrating scenario. In this episode, I talk about a few times that I’ve experienced this in my own life, what techniques didn’t work, and what strategies were more effective.

Attend the Dear SQL DBA podcast — live! Register here to get an invitation.

Got a question for Dear SQL DBA? Ask away.

Subscribe:  If you’d rather listen on the go, subscribe on iTuneslisten on Google Play, or plug this URL into your favorite podcasting app: http://dearsqldba.libsyn.com/rss#

My notes for the session

Everyday Dilbert moments

The Bug Nobody Caused

Committing to an SLA I couldn’t meet

The Case of the Weak KPIs

Techniques that haven’t worked for me

“No”
“This is not my responsibility”
“-TICKET CLOSED”

If other people keep tagging you and saying “you’re it”, just saying “not it” or “I’m not playing this game” doesn’t stop them from continuing.

Techniques that can work

First: chill

Being responsible for things you can’t control frequently triggers stress

Stress triggers knee-jerk responses

  • Knee jerk responses don’t go anywhere
  • Not taken seriously
  • Generally don’t have thoughtful, supporting data

You need to be more strategic

Find a way to de-personalize the issue

Think outside your current role

If you were the CTO of the company, what would you want to see happen?

Don’t limit your thinking to what you can do now

Do what you can

Outline and document the limitations to what you’ve done

“Here’s what I can do for you” (even if it’s to try to help escalate)

Sometimes… sketch out an approach to narrow the gap

Even if it’s not you who could carry it out

Ask for help to narrow the gap

Who do you think could help make this happen?

Raise the flag high when needed

Security risks

Risks of data loss

Ethics breaches