• Skip to main content
  • Skip to primary sidebar

DallasDBAs.com

SQL Server Database Consulting

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

Training

SQL Saturday Dallas, 2018

June 4, 2018 by Kevin3NF Leave a Comment

 

Quacky rides bikes!

 

SQL Saturday Dallas #734 is a wrap!

I’m still tired, 2 weeks later!

This is my 7th or 8th SQL Saturday as an attendee.  3rd as a pre-con presenter.  5th delivering a Saturday session, 1st as a sponsor and 1st as a co-organizer.

And it was a blast.

Months of prep work went into getting things ready…venue change, sponsor chasing, speakers, goodies for speakers and attendees, pre-con stuff, after-part, speaker dinner…you name it, I at least read an email about it.  This was my first time around so I was following the lead of veterans on the NTSSUG board.  We had over 1000 people register…I don’t recall the final tally of actual attendees but the place was packed all day!

My pre-con (DBA Fundamentals) went really well, with a record number of attendees. By design this class is usually small and intimate.   The BI session next door had 65 or so!  I’ve done this pre-con 3 times now, and this was the first time I actually had a technical issue (fonts went wacky) and a brain cramp in the middle.  But, I recovered and people (hopefully) learned something they can take back with them to the office.

I also did my Disaster recovery session on Saturday, which I think went really well, and got a bonus of meeting someone I knew through a previous client and only by phone.  I always think you’ve done your session well when people line up to chat with you afterwards:

Either something was really funny, or my backpack has way too much stuff in it…

 

Our Dallas DBAs sponsor table went really well…except everyone seemed to think I was raffling off my personal racing bike.  Lots of folks came by for the raffle and the free t-shirts (100 only…gone in 90 minutes).  Some even stopped to ask what we do, giving me the chance to promote our Apprentice program.  Thanks to everyone that came by!  And also to Richardson Bike Mart for providing the $150 gift card for our raffle.

Not the raffle item….just clickbait apparently:

The entire staff of Dallas DBAs, in official uniform

 

A very special shout out to my good friend and graphics/web guy, Jeff Miller of Igniss Images for shooting this event as a free service to the SQL Server Community.  See the pics!

Thanks to all the attendees for coming, and to the Sponsors that make it possible!

Kevin3NF

 

Filed Under: Apprentice, Cycling, Dallas DBAs, HADR, SQLSaturday, Training

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

PASS Summit 2017

October 23, 2017 by Kevin3NF Leave a Comment

PASS Summit 2017

PASS Summit is the largest gathering of SQL Server developers, admins, vendors and MS product people in the world.

I’m making my third trip to Seattle next week for this festival of brain-melting, best friends making insanity.   For those not in the know, there is FAR more going on over the 3 official days of the conference than any person can possibly consume.  From all day pre-conferences, to multiple sessions across multiple time slots, to just chilling in the community zone, there is ALWAYS something to do, see or learn.  Plus the vendor area and their unofficial evening events.

As with last year, I have planned out my schedule, knowing full well that I will probably skip at least one session a day to just network with other members of the #sqlfamily, or even just be a new friend to someone that is on their first trip and looking very overwhelmed.

I have also volunteered to be the “host” of the Thursday night Game Night…set up for those that either are not into or just need a night off from the bar scene but still want to be around others.   Lots of board and card games available, or bring your own and teach your new friends.

I might even attend the unofficial #SQLRun on Wednesday morning.

I think so highly of this conference and the opportunities available that I pay my own way.   As with last year, I will not be paid while there (contractor blues), unless a client needs me to resolve an emergency.   Conference fee, airfare, parking, Uber, hotel, food, beverages, etc.   This will cost me several thousand in non-income and expenses.

Worth. Every. Penny.

A short list of people I want to meet or see again:

  • Jen and Sean
  • Shane
  • Brent
  • Pinal
  • Dave M
  • David K
  • Ola Last Name not needed
  • Bob Ward
  • Rie
  • Andy
  • Alex
  • Sooooo many others 🙂

And I’ll do it again next year, Lord willing and the clients don’t dry up in between 🙂

Thanks for reading!

Kevin3NF

Filed Under: Career, SQL, Summit, Training

Are IT Certifications worth it?

September 6, 2017 by Kevin3NF 4 Comments

I’ve been in IT for 2 decades.   I got my MCSE in 1999.   Via a BootCamp training class that Microsoft paid my way into.

I was the walking definition of a “paper MCSE” – all knowledge and no experience.   At the time the MCSE was Windows NT 4.0, IIS 4 and some other elective, along with some networking tests.  I really don’t remember, other than TCP/IP which I had to take, fail, study and take again.

When i contracted at Microsoft (the second time) back in 2005, there were 20+ contractors all there getting ramped up for the SQL 2005 release.   Technically they were ramping up for SQL 7 and 2000, as the Full Timers were doing 2005 support. Most of them had the MCDBA certification….many hanging in their cubes.  Not one of them could admin their way out of a paper bag.   Nice people, but no experience.

I decided at that point that I would not be pursuing any more certifications, as these guys were making it look bad and watering the value down.   Certification tests are expensive, when you consider study time, prep materials, practice tests and exam fees.  I decided I would just learn the SQL Server things I needed to know and that were in wide use (skipped right on by Notification Services!).  This has served me well for the 10+ years since that contract at MS ended.

Fast forward to last month when I decided to quit being an old dog and go learn some new tricks.  Specifically Azure tricks…infrastructure and SQL, in parallel (MAXDOP 2).

I’m working through that.  I’m not ready to even think about the first test yet, because I’m taking my time and actually LEARNING the material, whether its on the test or not.  Shocking, eh? 😀  (Pluralsight is amazing for this, BTW).

The thing that triggered this blog came from a LinkedIn post this morning that caught the ire of Adam Machanic (w|t), as well as others:

Hello Folks,

Can someone please send me MCSA 70-764 and 70-765 exam dumps in PDF format.

My Email ID is: redacted@whatever.com

Thanks in advance..

Most of the responses were along the lines of “why not just study the material, you cheater?”

The original poster claimed this:

You are right . in my past I worked on old SQL version as of now working with new versions and everything is automation over here …hence just for reference I need them …

I call shenanigans.

OP is going for the “memorize, test, apply” method of certifications.   Maybe not apply for a new job. Maybe just to keep one.  Who knows.   But still shenanigans….and in .PDF format if you please.

As you might expect, this spilled over to Twitter, as many things do.   It was met there with a healthy dose of venom for those that shortcut the process, as well as places that issue fake certifications (I didn’t know that was a thing!).

For fun, I contacted my friend Gregory Knight at GTN Technical Staffing and Consulting (my first independent customer, way back in 2001) for some insider info on the other side of the recruiting and client pipelines.

My Question:

“Hey…curious how much recruiters and clients actually value Microsoft certifications these days, if at all…other then for resume filtering…thoughts?”

Gregory sent this wide internally at GTN and got these responses back:

I do. It tells me the following:

  • How much extra work a human has put into his/her career.
  • Suggests drive, love of the tech, going the extra mile
  • Low-level cert only or many unfinished certs (CCIE with no lab) and/or never finished college suggests lack of follow through.
  • Certs all over the place, e.g. MuleSoft, CCNA, MSCA suggests lack of career focus.
  • Date of completion matters. It tells me what the person was doing at a particular point of time.
  • E.g. an infrastructure/network candidate passing himself off as a network expert but has lots of Microsoft certs tells me the person likely leans more server side

It really depends on how much our individual client values it. MS Certs tend hold value and do demonstrate a general mastery of the technology. With that said, clients that do not require it tend to not be impressed or care enough about it to make a difference in choosing to select, interview, or hire a particular candidate.

I view certifications, any certifications, like a bachelor’s degree. It does not open the door for a candidate, but it can prevent the door from being slammed shut in their face…


Real world experience > certificates any time unless it’s Cisco.


Production > Lab


So…this settles nothing of course as far as whether you should pursue an IT cert or not.   If you do it the right way, you’ll learn things and have something to show for it.  If you shortcut the process, you’ll be found out when the time comes and others are depending on you to know what you are doing.

I’d love to hear your thoughts in the comments section.  Any comments bashing people (candidates, recruiters or clients) will not get approved.   Thoughtful, considerate discussion?  Yes please 🙂

Thanks for reading!

Kevin3NF

Filed Under: Azure, Career, SQL, Training

September DBA Fundamentals training in DFW – Free

September 3, 2017 by Kevin3NF Leave a Comment

I will be teaching an all day (9-5) class on SQL Server Database Administration fundamentals at the Microsoft building in Irving/Las Colinas on September 15, 2017.

Update: This is now a free class.  There will be a donation bucket, with 100% going to the Red Cross.

The target audience for this is System admins, Developers, Tier 1 support staff, IT managers…anyone that has to deal with SQL Server on a regular basis and finds themselves Googling everything.

Register (REQUIRED) on EventBrite to learn the following topics (subject to change due to time, class flow):

• What makes up a SQL Server

• How a database is structured

• How to install and what to look out for

• Finding what you need in Management Studio

• SQL Security Basics

• How to create and manage backups

• How to create a database, 3 different ways

• Basic performance troubleshooting

• Picking a Disaster Recovery option for your environment

Please see the FAQ section of the registration page, and feel free to contact me for anything not covered there.

Thanks!

Kevin3NF

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

  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • 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 © 2025 · WordPress · Log in

 

Loading Comments...