• Skip to main content
  • Skip to primary sidebar

DallasDBAs.com

SQL Server Database Consulting

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

Career

TSQL Tuesday – Changing Times

April 11, 2017 by Kevin3NF Leave a Comment

T-SQL Tuesday is a blog party started by Adam Machanic (b/t) over five years ago. The first Tuesday of each month a blogger hosts the party and suggests a topic. Anyone who is interested blogs on that topic on the second Tuesday. It can be a lot of fun and quite a challenge to blog on a topic you didn’t pick.

This month’s topic is presented by Koen Verbeeck (b/t), who has challenged us to write about “The times they are a-changing”, a response to Will the Cloud Eat my DBA Job? by Kendra Little (b|t).

I previously blogged my Predictions for the future of the DBA role, so I offer these posts as my T-SQL Tuesday submission:

Prediction – The SQL Server DBA Role

Supporting post on why I am embracing PowerShell

Yes Koen, the times are indeed changing, as they have been for years and always will.  Remember, your mobile phone has more power than the best computers 50 years ago.  And when was the last time you actually saw a buggy-whip? 🙂

Anticipate the changes, test the betas, learn the terminology….or be left behind maintaining that old SQL Server 7.0 install in the corner that everyone is scared to touch.

Thanks for reading!

Kevin3NF

Feel free to stalk me on twitter…

 

Filed Under: Career, PowerShell, SQL, TSQL2sday

How I became a:________________

April 3, 2017 by Kevin3NF Leave a Comment

Thanks to Andy Warren (b|t) for this idea….

I am starting a collection of “How I Became A _____________” stories and will be aggregating them right here.   Your contributions are welcomed and encouraged.  You can email me some text, send me a link to your blog where you write it up, or even a video on YouTube if you have it.  Include what section below it should go in.  Longer submissions would be better as links to your blogs, shorter ones work as just text if you prefer.  Add your link as a comment, and I’ll delete that after incorporating into the list.

For now, I’d like to stick with items in and around the database world…DBA, Developer, Architect, BI pro, Database Manager, SQL Server, Oracle, etc.

The goal here is to have a place for people considering database work as a profession a place to go to get more info direct from the mouths of those of us already in the industry.  Lets keep the contributions family-friendly and encouraging!

 

Database Administration:

  • Jeff Miller (t) reboots his career and joins the Dallas DBAs staff
  • Andy Levy (b|t) finds out he has DBA tendencies…
  • Arun Sirpal (b|t) never stops learning!
  • Michael D’Spain, the landlocked surfing DBA musician shares his story
  • David Alcock (b|t) shares his path to DBA, along with tips for those considering the idea from across the pond.
  • Jr. DBA Julie (t) shares her story
    The story of how I became a SQL database administrator is … less than glamorous. Without going into specifics, I found myself at 35 years old in the position of needing to change careers – and needing to do so at a breakneck speed, because quite unexpectedly I became the sole provider for my family. I had a bachelor’s degree in art, few marketable skills, no professional job history for the past 10 years, and the weight of the consequences of failure breathing hard down my neck.
    So I reached out. I talked to people. I spammed my Facebook and Twitter feeds, asking people what it was like in their industry – what the job prospects were, what the working conditions were like, what the requirements were, what the long term growth potential might be. I made sure everyone I knew was aware I was looking for a job.
    I did not get a single response to the resumes I submitted to job postings. I DID get a response from my friend Jen McCown, who asked me one day if I’d like to do grunt DBA work for her home consulting business. YES, I said, I would love to do that.
    “Is this a pity job?” I asked her.
    “No no no,” she lied.
    Jen and her husband Sean spent a good part of the next couple of months training me to be a DBA. It was very difficult, as the learning curve was so steep as to be nearly vertical. I lived, breathed, ate and slept databases. I was keenly aware of what failure would mean, for me and my children, if I didn’t nail this. I remember one instance where I was sitting with my youngest child while he fell asleep, and he was annoyed by the light of my laptop and the click of the keys as I worked on some issue or other.
    “I hate databases,” he grumbled and pulled the covers over his head.
    At the moment, I kinda hated databases, too.
    Several months later, Sean introduced me to the folk at a local company, who had a position open for a junior DBA. They needed someone who could do backups and restores, document procedures, run queries, and look into basic problems like blocking and security access. I got the job.
    I’m almost three years into a DBA career now, and I am occasionally reminded with great humility and gratitude that I would not be here without Sean and Jen. I was lucky. But I am coming to realize that all of us have a Sean-and-Jen – people who opened up doors with opportunities for work. So how would I apply my experience becoming a DBA to others? To a certain extent, you have to make your own luck. Networking is the single greatest avenue to luck, but a lot of work comes before and after the opportunity presents itself. Have your resume together, read articles and books, take training courses and certifications, go to user group meetings and such. Most importantly, be prepared to work your butt off. Database work, especially in the beginning of a career, may mean a lot of late nights, even overnights. It’s not for everybody, but it certainly is a great path.
  • Chris Yates (b|t) – The SQL Professor
  • Anders Pederson (b|t) in 2 parts:
    • About Anders
    • Anders gives Access the boot
  • @SQLAndy: How to Become a SQL Server DBA (whitepaper, site registration required)
  • DBA Kevin Hill gives an email interview

Database Consultant:

  • David Alcock (b|t) turns to Consulting!
  • Matt Gordon (b|t)- Support Analyst to Consultant

Database Developer:

Business Intelligence/Analytics:

Database Management:

ETL Developer:

Database Architect:

Teacher/Presenter/Speaker:

  • Erin Stellato’s (b|t) 20 year presenting journey
  • John Deardurff (b|t), Trainer – Database on a Dare

 

Filed Under: Accidental DBA, Beginner, Career, Oracle, SQL

Prediction: SQL server DBA role

March 20, 2017 by Kevin3NF 3 Comments

There have been a lot of questions, posts, answers, guesses and such floating around the SQL blogs lately…most of which seem to suggest that the DBA is going away.

Hogwash.

The DBA position is not going away.  Ever.  Or at least not before I retire to Utah to spend my days mountain biking 😉

But…it is changing and will do so even more over the next 3-5 years.   Long gone are the days where a DBA stays busy backing up databases and creating indexes.   Those are still necessary, or even critical, but thanks to some brilliant minds and thousands of willing testers, the basic tasks of the DBA have largely been scripted away.

Automation.  Powershell.  Cloud technologies.  SQL Server on Linux.

Some of these have been around awhile, some are newer and some are still in CTP.  But they are ABSOLUTELY going to be required knowledge for anyone in or around the database world…admins, developers and managers.

Automation – this is a basic need at this point.   Whether running Ola‘s backup/maintenance scripts, or using Powershell to shut down Virtual SQL Server in Azure, if you are not automating repetitive tasks you are wasting your employer or client’s money.  Simple as that.

Powershell – 10+ years old now, and is really starting to pick up steam in the SQL realm…thanks largely but not solely to the dbatools team. Companies increasing their use of PS are going to make obsolete the “I can do everything I need in T-SQL” argument.  My decision to switch.

Cloud tech – AWS, Azure, Google, Cisco, internal, public, private…lions and tigers and bears, oh my!  As a DBA you are going to have to help guide your firm in the right path when the marketing/sales guys try to influence them.   You cannot do that unless you know the pros and cons…from Data Lakes to simple blob storage for backup.  Learn the lingo so you are not caught unaware.

SQL on Linux – Something I have just started messing around with.  I guarantee you this is going to be huge.  Microsoft made a brilliant decision here and has done an amazing job porting a massive number of SQL features to the Linux based “vNext”.  My prediction – in 5 years if you aren’t competent enough to navigate Linux in order to troubleshoot a SQL issue, your job prospects will be limited.  Just start learning now…free Linux training is all over the place.

This is just touching the surface of how the DBA job will be changing…just like it has been changing for the 18 years I’ve been in it.  Don’t be afraid, just begin adapting now so you are ahead of the game!

I sincerely hope this has been an encouragement to you.  Your job as a DBA is not going away…its actually becoming more necessary.  Are you up to the task of adapting?

Thanks for reading!

Kevin3NF

Filed Under: Career, PowerShell, vNext

The Apprentice: Non-SQL stuff that SQL Server depends on

February 27, 2017 by Kevin3NF Leave a Comment

The apprentice and I gathered at my house Sunday evening for a bit of training.   I gave him some homework ahead of time to go look up RAID and the most common levels.

Yep…we spent an hour standing/sitting in my kitchen discussing RAID 0/1/10/5/5+1, etc.

And Spinning disks vs. SSD

And Memory (including addresses)

And CPUs

And SAN vs. DAS vs. internal

And how SQL Server uses all of these items.

And how the costs associated with these choices vary from client to client.

And how it is perfectly acceptable to blame the storage team for anything up to and including your lunch being stolen from the office fridge. 😉

We never even started the SQL Services…went old school with pen and paper to map things out.

Short one today, thanks for reading!

Kevin3NF

Filed Under: Apprentice, Beginner, Career, EntryLevel

Before you burn that bridge…

February 2, 2017 by Kevin3NF Leave a Comment

Yes…some customers are horrible to deal with.  Some co-workers and managers can make your life miserable.   And yes, it would feel great to tell them exactly what you think, give them some hand signals, and a swift kick on the way out the door.

Wouldn’t that be amazing!!!

No.

OK maybe for a day, or a few minutes…or a month it might.  But I promise you will look back later and kick yourself.  More so if you need that customer, company or person back in your life in ways you cannot imagine in the heat of whatever was going on.

Four times in my professional career (not counting a fast-food job), I have gone back to a place I previously worked.  Each time, the return trip has been in a better position and higher wages.

Why?  Because when I leave, whether due to my own choice, layoff, or other reasons, I leave clean.  At a minimum I finish my projects, document everything I can and email a very nice thank you note to my team and a few other key people.  Not one of those “Everyone” email groups…just the people I worked with the most.

Before you burn that bridge, make sure you are absolutely never going to need to cross it again.  And then don’t do it.  The view is so much nicer from the high road.

There are a myriad of article on the interwebs telling you how to deal with conflict, how to quit, how to stay, etc.   My take on all of them is basically:  Politely confront the problem or person you are facing.  Ask your supervisor for help.   Make EVERY effort to resolve it.   If resolution is impossible, start your job search with a clear conscience that you tried your best.  And start cleaning things up while you look.

Comments are encouraged and appreciated with your “Bridge burning” stories.

Thanks for reading!

Kevin3NF

(originally published on my LinkedIn feed in late 2015)

 

Filed Under: Career

The Apprentice: Intro to Troubleshooting

January 26, 2017 by Kevin3NF Leave a Comment

Just for kicks (and because I hadn’t prepared my intro to Indexes…), I broke The Apprentice’s database (dbname MoreCake if you are following along) when he wasn’t looking.

I had told him I was going to break something, just to watch him try to sort it out, so he knew it was coming.

Before we got started, I changed the name of the data file from MoreCake.mdf to MoreCake .mdf.

His steps:

  • Start SQL Services…notice it come up fine
  • Notice MoreCake came up “Recovery Pending”
  • Verify Restore is an option
  • Take offline
  • Try to bring online
  • Read error message after online failure (OS error 2, file not found)
  • Look in Windows Explorer, squint, remove space
  • Refresh database and smirk at me.

Elapsed time from start services to smirk?  3 minutes.

Me: Jaw on ground.

If you add it all together and are generous, he has maybe 4 days of training including videos.

I know some DBAs that would never have noticed the extra space.

3 minutes.

We went on to look at ERRORLOGs, talk about what is contained in the master database, and a little bit of creating a database with a bunch of records to start off Index training in our next session.

And then I deleted MoreCake along with all Backup and Restore history when he went to grab a soda.  Still GUI, and with no backup history to populate it he figured out to go to devices and browse for the most recent .bak file.

3 minutes.   Smart dude.

Thanks,

Kevin3NF

 

Filed Under: Apprentice, Beginner, Career, EntryLevel

  • « Go to Previous Page
  • Go to page 1
  • Interim pages omitted …
  • Go to page 10
  • Go to page 11
  • Go to page 12
  • 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...