Voice of the DBA

Author: way0utwest

  • We’re not craftsmen and craftswomen

    We’re just not, we’re not craftspeople, at least not most of us. We do what we need to do at work. We get systems working just enough. We get by. That’s a little sad, and one of my goals is to get as many of you as possible to think of yourselves as craftspeople, not technology workers.

    Jerry Rice was the best at his craft, and yet he continued to put in work on The Hill as though he were trying to catch others rather than the other way around. David Marks and Norm Abram are professionals, and while they need to complete projects to earn money, they also recognize that “just getting it done” is not enough. Doing just enough to complete a job is the sign of a amateur, not a craftsman.

    There are constraints in our business. We never have enough time, money, or all too often, specifications, when we are working with technology. We need to be effective and make things work. However that doesn’t mean doing the bare minimum to be functional.

    We should aim to be professionals, and part of being a professional is continuing to improve our skills over time. Professionals continue to learn; amateurs do not. We should consider new ideas and techniques, dig into new technologies, and avoid shortcuts. Most importantly, we should do the job that we would want someone to do for us.

    We do have lives outside of work, and outside of our careers. However it’s not an either/or, but a balance that we should strive for between work and life. We can include regular education, and consistent improvement over time as we complete work. We balance that by remembering to appreciate and enjoy our lives outside of our chosen profession.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 2.2MB) podcast or subscribe to the feed at iTunes and Mevio . feed

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

  • Cleveland Rocks! (and does SQL Server)

    My first flight of 2014 will be to Cleveland to run a SQL in the City seminar and then speak at SQL Saturday #241. Both are free events, taking place on February 7th and 8th, respectively, and it’s a great chance for you to improve your SQL Server skills, network, and move your career forward.

    SQL in the City Seminar

    Grant Fritchey and I did SQL in the City seminars last year (and 4 big events) and we kick off 2014 in Cleveland. Come see our Deployment Stairway half day session on Friday, Feb 7, 2014. It’s free, but we’d like you to register.

    We’ll be presenting 3 sessions that build on one another. We’ll set the base with Version Control Systems and databases, giving you some things to think about. We then go into Automated Build and Test, essentially Continuous Integration, which is an amazing process and one you’ll want to get set up in your environment. We finish off with a look at deployments, giving you some ideas on how to smooth and automate this process.

    We’ll cap the afternoon off with a short happy hour, giving you the chance to talk to Grant and myself about anything SQL Server, or anything else.

    SQL Saturday #241

    My second time to a Cleveland SQL Saturday will be #241. I think this is their third or fourth in total, but timing hasn’t worked out well for me. However I’m excited to go back and see friends and meet some new people.

    As an added level of excitement, the T-SQL guru from SQLServerCentral, Jeff Moden, will be speaking. Come learn from one of the masters and speed up your T-SQL code.

    Of course, there will be a ton of other speakers there as well. With 7 tracks and 6 time slots, you’ve got the magic number (and answer to the universe) of sessions to choose from. Speakers from all over the country will be there and you’ll have to really think about how to spend your day.

    I have 2 sessions in the morning. I’ll be talking about encryption at 8:45 and then branding at 11:15. Learn about how to better secure your data and the options that are available for encryption in SQL Server, and then learn about how you can stand out, improve your brand, and find a fantastic job for you.

    My apologies in advance that I won’t make the after party, but my daughter has a volleyball tournament in Colorado on Sunday and I’ll have to leave a little early to catch a plane home Saturday night. However I’ll be around during the day and please feel free to say hi and introduce yourself.

    As I mentioned, both events are free, so if you’re interested in database deployment, sign up for the seminar and if you want to work with SQL Server, register for SQL Saturday.

    Pre-cons

    If you’re looking to be a better DBA and want to learn about the internals of SQL Server and how to better recovery data, think about attending the pre-con from MCM Argenis Fernandez on Friday. It’s an inexpensive training session that will teach you a lot.

    If you want to learn about Powershell, Allen White is putting on an Automation pre-con using PoSh on Friday as well. Learn how to better manage your instances with a little scripting and thought.

  • SQL in Albuquerque

    It’s a little less than two weeks until SQL Saturday #271 – Albuquerque. The second event in that great city, and the beautiful state of New Mexico. I rarely get there now that my brother moved away, but’s always neat to visit.

    I was lucky enough to get chosen to speak and attend the first event last year. When I got my acceptance, a few of us from Colorado got together and planned a #sqlski day on Friday. It worked out well and we have plans to do it again. A few less of us this year, but a few new faces as well. Some of us will be driving to Taos on Thursday night and skiing Friday before driving the rest of the way to Albuquerque.

    This event was a lot of fun last year with an amazing lineup of speakers from all over the country. It was amazing to see how many speakers came from different states, though I do prefer to see more local speakers. Perhaps we’ll inspire a few more New Mexico SQL speakers to jump into the event next year.

    In any case, we have people from Missouri (Bill Fellows), Nebraska (John Morehouse), Texas (Tim Mitchell), Utah (Pat Wright), California (Denny Cherry and Lori Edwards), North Carolina (Bill Pearson) and of course, Colorado. There are at least 13 of us coming down from the north, by my count, and a few more that might be attending.

    I’ll be talking Encryption at the first session at 8am, and from there you have a great choice of lots of other sessions.

    If you’re anywhere near Albuquerque, I’d encourage you to register and come. It will be a fun day of SQL Server learning in New Mexico.

    And it’s FREEEEEEEEE.

    If you want to ski on Friday, keep an eye on the #sqlski hashtag on twitter and we’ll let you know where we are.

  • Double Checks

    It’s not the discount double check, but I am a fan of processes that are built to check other processes. When I have a process that runs, or data quality that should be checked, or some other system where I can potentially have a failure, I like to write a separate check, as an independent process, that ensures work is done correctly.

    Why? Because things go wrong. Most of us schedule a process, like an ETL job, and we assign failure notification (and potentially success notification). If the process succeeds or fails, we get notified. However, what happens if the process doesn’t run? In our busy lives, we might not notice that the success email is missing. What if the process runs incorrectly? Do we have some other process that looks for data to be correct, or even present?

    A second (or third) check can make all the difference in the world between operations that appear to run smoothly for our clients, and those processes that always seem to fail. Even if the process fails, if you get notified quickly, you can potentially fix it before your clients notice. That makes you look more professional, but it’s also what should happen. You should ensure things run smoothly.

    An independent check is also a good security check. Brian Kelley wrote a piece about people tampering with your processes. Would you be aware if that happened? Most people would not, unless they have some auditing, or independent processes that looks for potential security issues.

    There are all sorts of mechanisms to perform checks for you, such as GPOs, Policy Based Management, and more, but have you enabled or scheduled them? Anywhere you have automated processes, you should consider writing separate checks and scheduling them to be sure your processes are running correctly.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 2.4MB) podcast or subscribe to the feed at iTunes and Mevio . feed

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.