• Skip to main content
  • Skip to primary sidebar

DallasDBAs.com

SQL Server Database Consulting

  • Services
  • Pocket DBA®
  • Blog
  • Testimonials
  • Contact
  • About

Career

PASS Summit 2018 – My Schedule

November 6, 2018 by Kevin3NF Leave a Comment

If you are going to PASS Summit in Seattle and want someone to sit with, check out my schedule (primary and backup sessions) – very much subject to change:

 

Wednesday, November 7, 2018

============================

10:15 AM – 11:30 AM Room: 2AB

dbatools Powershell Library – The Complete Introduction (Yes, my very first session is Powershell, lol)

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=85712

10:15 AM – 11:30 AM Room: 612

Uncovering Duplicate, Redundant, & Missing Indexes

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=77036

1:30 PM – 2:45 PM Room: 606

Improving Availability in SQL Server and Azure SQL Database

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=84728

1:30 PM – 4:00 PM Room: 6E

SQL Server Migrations Done the Right Way

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=84219

4:45 PM – 6:00 PM Room: 6A

SSMS & T-SQL Tricks: Working Smarter, Not Harder

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78153

Thursday, November 8, 2018

============================

10:45 AM – 12:00 PM Room: 6B

Containers, Pods, and Databases- The Future of Infrastructure

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78022

1:30 PM – 4:00 PMRoom: 606

Query Tuning Internals for the Advanced SQL Developer

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78050

1:30 PM – 2:45 PM Room: TCC Tahoma 2

Top 5 Power BI Custom Visuals

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=82110

1:30 PM – 2:45 PM Room: 6C

Top Tips for Deploying AGs and FCIs On Premises or In the Cloud

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78041

3:15 PM – 4:30 PM Room: 618

An Introduction to Partitioning

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=77002

4:45 PM – 6:00 PM Room: 604

Data Science 101 for the SQL DBA

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=86521

4:45 PM – 6:00 PM Room: 6C

Validate Your SQL Server Estate with Ease Using dbachecks

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78382

Friday, November 9, 2018

============================

8:00 AM – 9:15 AM Room: 6C

T-SQL Habits and Practices That Can Kill Performance

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78111

9:30 AM – 12:00 PM Room: 6E

Migrating to SQL Server 2017

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78285

11:00 AM – 12:15 PM Room: 3AB

BI Power Hour

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=86517

2:00 PM – 3:15 PM Room: 3AB

Lightning Talks: DBA

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=85592

2:00 PM – 3:15 PM Room: 618

What’s New With Adaptive Query Processing?

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78238

3:30 PM – 4:45 PM Room: TCC Yakima 1

A DBAs Guide to the Proper Handling of Corruption

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78274

3:30 PM – 4:45 PM Room: TCC Tahoma 4

SQL Server Performance Monitoring Made Easy

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=85138

 

PLEASE feel free to come introduce yourself like we are old friends.  My brain is defective in remembering names and where we met, so you may have to remind me if in fact we have met before 🙂  Fair warning…I may ask you to take a selfie with me.  I suck at selfies so I may actually get a shot of your shoes, or the ceiling 🙂

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: Career, Summit, Training

Put a DBA in Your Pocket

October 12, 2018 by Kevin3NF Leave a Comment

Oh snap…one of your two DBAs just gave 2 weeks notice.

Now what?

You have 2 weeks before your other DBA starts feeling the pressure of doing 80 hours of work in a 40 hour week.

Did you see this coming?  Do you have a favorite recruiting firm on your vendor list?  Do you know a guy that knows a guy?

Assuming that the budget exists to pay for a replacement, you are very likely 4 weeks out from actually getting a replacement in the door:

  • 1 week for the recruiter to source candidates
  • 1 week to interview, if you are really on the ball and can “Agile” through the stack of resumes and the interview process
  • 2 weeks for the person you make an offer to so they can give proper notice
  • At best.
  • If you rush the process.

In reality, recruiters these days are handling 30+ openings and dozens of applicants per opening.  That’s a lot on their plate.

You have Stuff To Do™ as well, which limits your time to properly review resumes and get through the interview process.  Hopefully your process isn’t 3 phone calls and 4 face to face on different days…

Great…so we’ve defined the problem. What is the solution?

Put a DBA in your pocket.

You likely already have a lawyer and accountant in there.  Put a few critical technical people in there with them.

Set up a retainer agreement with an independent DBA to fill in when:

  • Someone leaves
  • Someone goes on a well-deserved vacation
  • Someone goes on Maternity/Family leave
  • A new project comes in and you cannot let the care and feeding go by the wayside

This doesn’t even have to be an actual independent contractor…many qualified DBAs, SysAdmins, storage people, etc. that are working full-time jobs but can check on your systems on weekends and evenings.

If your systems are mission critical, and you are running skinny in certain areas…protect yourself by having someone you already know in your pocket, ready to call when the unexpected happens.

For my fellow DBAs…would you like to take a vacation without your laptop? Or go to a training class? Send this link to your manager if you are stretched so tight you can’t breathe!

Dallas DBAs provides Remote DBA services at ‘X’ hours a week.  Contact us if this resonated with you.

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: Career, Management

Care and Feeding of your DBA

August 31, 2018 by Kevin3NF 2 Comments

The care and feeding of a DBA

Everyone in your organization is important, of course. You should take good care of your humans, because…they are humans. Not desks, not grunt labor, not assets, not even resources. Gold and Oil are resources. Your team is made up of real life people.

In your IT shop, you have a variety of types of people. Developers that write the products you sell, or the customer facing website. Project Managers that herd all the cats to get things done, etc.

An often overlooked group is the administration team. “Administrator” is not as cool of a title as say, “CIO”, or “Scrum Master” and quite often, many of the folks outside of the IT team have no idea what an admin does. Exchange admin, Systems admin, Database admin.

ADMINISTRATION – noun – the process or activity of running a business, organization.
“the day-to-day administration of the company”

Exciting! Yes?

Your IT admins are the ones keeping everything moving. If you get a “yes” email from a sales prospect, thank your mail admin. If you can log on to your machine each day, from Starbucks and IM with teammates around the world, thank your Systems Admins. If the data that runs the entire company is still there today just like it was yesterday, thank your Database Admins!

Admins keep the company alive and functioning properly.

A few tips on how to keep the database admins happy and eager to be a part of the team:

  • STOP BLAMING THE DATABASE!
    • Every time something goes wrong, please quit yelling at the DBAs to fix it. That’s like getting mad at the car engine for a flat tire without investigating why the car slowed down.
  • THANK THEM
    • DBAs are human. They appreciate being appreciated. Not just at the annual review.
  • TRAIN THEM
    • Allow your DBAs to continuously improve their skill set so they can continuously improve your systems. Conferences, paid online training, etc.
  • FEED THEM
    • Allow your DBAs to actually go to lunch on a lunch hour without calling them for non-emergencies
  • LISTEN TO THEM
    • When a DBA makes a recommendation, trust, test and implement. When you hire a consultant to come tell you the same thing, its insulting.
  • PAY THEM
    • Please stop offering to pay Junior level wages to a person with 20 years of experience. We know the market rates, just like you do. Be reasonable.
  • LET THEM TEST THINGS
    • Allow them to set up a test environment so they don’t have to test in Production when things go bad. Cloud VMs are super cheap to spin up for a day, test something and deallocate.
  • STAY CURRENT
    • No DBA wants to work on old, out-of-support versions of Oracle, SQL Server etc. We hear this from recruiters and already know what the day-to-day is going to be like. (Hint – its going to suck if you are still on SQL 2005)
  • TRUST THEM
    • You have given them SysAdmin rights to all of your company’s data. Trust them to use that access wisely. Let them do what they need to do to help you, without burying them under arbitrary InfoSec rules. If your DBA can be trusted to see everything in the HR database, surely she can be trusted to install appropriate things on her laptop, yes?
  • LET THEM HAVE A LIFE
    • A well rested, happy DBA is going to work their tail off for you. Demanding 60 hour weeks and 24x7x365 on call is going to burn them out. Some DBAs even have families they love and want to see. Limit the off-hours calls and texts to actual emergencies

Most of these are common sense (or should be) and apply very well to any number of positions in your organization. Many admins simply want to do their job and chill out in the background while being a part of the overall success of the firm.

Comments welcomed.

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: Career

T-SQL Tuesday: Brick walls

August 14, 2018 by Kevin3NF 1 Comment

T-SQL Tuesday is a monthly blog party for the SQL Server community. It is the brainchild of Adam Machanic (b|t). This month’s edition is hosted by Wayne Sheffield (b|t) who has asked us to tell a story about a time we ran into a Brick Wall.

So many walls, so few Bulldozers…

The largest brick walls I’ve ever run up against were not technical issues as you might expect…but people and processes.

Processes:

I was working for a company that bought a company that bought the company I had hired on with.  The newest owner was growing their managed hosting business by buying others out.   Not a bad approach when you have deep pockets.  BUT, they never integrated any of them.  Everything was still in its original silo.  So, anytime I got a call or a ticket, I had to search through 4-5 knowledge base/Sharepoints, 2-3 password repositories and 4 ticketing systems.  I could easily spend 2 hours to research and close a ticket that took 3 minutes to resolve on the technical side.

This place broke my flipper.  As in, I no longer gave a flip after it took a full year to get all the access I needed to every environment.  The Bulldozer here is that I got laid off.  They gave me a big bag of money to leave and go do cool things with modern SQL versions for other places.  YES!!

People:

I was asked to bill a crazy high rate for a full-time contract, to watch over a very small environment of 25 servers.  I was asked to put in best practices, be the unofficial team lead, make things go faster, secure them, etc.

BUT…JimBob the Manager (clearly not his real name) gave me the brick wall at every turn. It took 6 weeks to get rid of NetBackup in favor of SQL Server Maintenance Plans. (I know…lets not go there.).  Compressed backups?  Made me prove it.   Index maintenance?  OK, but he wouldn’t let me schedule it.  New indexes that actually made sense?  No chance, as that was a code change to the application our Very Big Vendor had written for us.  Within 3 months, I was down to 15 minutes of real work a day, and the rest spent blogging, Tweeting and answering questions on DBA.StackExchange.

The Bulldozer on this one was me walking out the door into cooler things.  33% pay cut was worth it, to save my sanity and go independent again!

Technology:

I don’t run into technical Brick Walls, because I know how to Tweet using #sqlhelp, as well as read blogs from people I trust in the #sqlCommunity, and Vendor docs.

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs


Filed Under: Career, TSQL

T-SQL Tuesday: Giving Back

May 8, 2018 by Kevin3NF 2 Comments

T-SQL Tuesday is a monthly blog party for the SQL Server community. It is the brainchild of Adam Machanic (b|t) and this month’s edition is hosted by Riley Major (b|t) who has challenged us to “Pick some way you can help our community“…but not just give a few sentences on how you want to help, but to actually put feet, brain cells and dates to it.

Community service is something I’ve been involved in for decades in many different ways.  Within the SQL Server specific community, I got serious about it a couple of years ago when I changed the nature of this blog from “weird stuff I saw at work today” to “here is some info you can use to make your life better today.”  I also started speaking at SQL Saturdays last June in Houston.

Last year, I decided to take this a step further and set up an unofficial “Apprentice” program to help young people get into tech careers that don’t (for whatever reason) have the same opportunities most of us do.   My barrier to entry was low…others not so much.

The 1st Apprentice is ready to become a part-time Junior DBA and I couldn’t be more proud of him for his hard work.  He entered the program as a bit of a test case.  His barrier to entry – zero desire to go to a 4-year school and chase a possibly useless (for him) degree.

I will soon be looking for the next Apprentice.  Will s/he be like the first?  Maybe from a low income area?   Possibly aging out of the Foster Care system?  On the Autism spectrum?  Who knows.

For now, I will be working with one at a time.  I would like to get to the point where I have 2 or 3 that can learn together by working out solutions as a team.   This will help them not only learn Database Administration, but teamwork, trust, communication skills, etc.  Some of them may decide they hate databases but think Security is really cool.  Or Python.  Or Networking.  And that is great!  If they can find a career that they enjoy and provides a stable lifestyle financially, then I’m thrilled to be a step along a glorious path for them.

HOW YOU CAN HELP!

As these young people get to the point that I run out of things to teach them, they need real-world practice. Eventually I will have an “Apprentice” rate/offering on my Services and Pricing page for them to do the grunt work on your servers.  Part-time, with oversight from me or another Sr. Level DBA.  There are caveats and conditions on this I have not sorted out yet, but its coming sometime in the next 6-12 months.  Please keep an eye out for my posts here, on Twitter and on the Dallas DBAs LinkedIn Page.

I want your thoughts on this…privately or in the comments as you see fit.

Thanks for reading,

Kevin3NF

 

Filed Under: Apprentice, Beginner, Career, EntryLevel, Training, TSQL2sday

SQL Saturday Dallas 2018

April 12, 2018 by Kevin3NF Leave a Comment

Hey all!

I am doing my DBA Fundamentals all day pre-conference at SQL Saturday Dallas on Friday, May 18.  Register HERE. $120 until May 1, then $140.  If you are not sure if this is the class for you, please go watch this promo video I threw together, then email me if you still have questions.  If you are a mid or senior level DBA, this is not a good use of your money and time…check out the others that are happening that day.

And then on Saturday, May 19 (Free!) I will be giving my Disaster recovery is everyone’s job! presentation, currently scheduled for 11am, subject to change at the whim of the organizers (spoiler alert…I’m one of the organizers, lol)

This is going to be a great event…the theme is “SQL de Mayo”, because Texas!  Go register now to reserve your spot, because it will fill up and being on the wait list is kind of a drag.  And buy lunch too!  No free lunch…

Hey…we still need more sponsors at Bronze, Silver and Gold levels to make this event even more awesome and I’m the guy to contact about that, so…contact me!

Thanks for reading!

Kevin3NF

^^^ follow me, you stalker 🙂

 

Filed Under: Accidental DBA, Career, SQLSaturday, Training

  • « Go to Previous Page
  • Go to page 1
  • Interim pages omitted …
  • Go to page 7
  • Go to page 8
  • Go to page 9
  • Go to page 10
  • Go to page 11
  • Interim pages omitted …
  • Go to page 13
  • Go to Next Page »

Primary Sidebar

Search

Sign up for blogs, DBA availability and more!

Home Blog About Privacy Policy
  • Home-draft
  • Blog
  • About Us

Copyright © 2026 · WordPress · Log in

 

Loading Comments...