Voice of the DBA

Tag: career

  • Test Your Restores

    The ultimate testers.

    I was talking with someone the other night about their database systems and they mentioned they had implemented TDE (Transparent Data Encryption) to comply with HIPAA regulations. This person had verified that they were backing up the Database Encryption Key, which you definitely need if you want to restore a backup from a TDE encrypted database. However they weren’t sure if the certificate that protected the DEK, and the master keys on that instance were being backed up. Probably most scary to me, they hadn’t tested any restores of the database.

    Encryption is serious business, and if you are going to implement it in your databases, you had better be sure you understand how the various keys and certificates work. You better be sure you have protected your passwords, and that you can find them in the event of some issue.

    Most importantly, though, is that you need to practice recovering your database to another instance. Preferably you’d learn how to recover on an instance that hasn’t ever enabled encryption as well as one that has a different SMK or DMK.

    Practicing restores isn’t just about encryption and the potential for data loss because you don’t have a key. Practicing restores is important for all of your systems to be sure you have the skills to successfully complete a restore. It helps ensure you know where the files, tapes, disks, or any other resources are located. Most importantly it ensures that your backup process is actually running smoothly.

    Please don’t assume your backup process works. Whether you’re an accidental DBA stuck with their first SQL Server, or a ten year senior DBA that has performed hundreds of restores at previous jobs. You need to test your process and ensure that you can perform restores on the systems you are managing.

    Steve Jones

    The Voice of the DBA Podcasts

    We publish three versions of the podcast each day for you to enjoy.

  • Grow Your Skills

    SQL Server Books
    A large collection of books can help you improve your skills.

    The cloud is scary. Without a doubt the idea of outsourcing parts of your organization’s technology department should concern you if you manage systems. Anything outsourced, whether to another firm or automation, means there is less work for you to do. Even in the places where automation grows, we find that sometimes the growth of systems occurs so fast that there are still things for a worker to do, but that’s a losing battle in the long term. At some point the automation will catch up and less people will be needed to manage the systems.

    However the news isn’t all bad. There are some systems that will always be managed inside of a company. Whether because of regulatory requirements, performance needs, or even just the stubbornness of management, I am sure that some percentage of systems at most companies will remain in-house. Those will be the minority of systems in some places, and since many of us change jobs at some point in our careers, we should be concerned.

    I would argue that all of us working in technology should be looking to improve our skills in whatever field we work. However we should be growing the skills in the hard parts of our jobs, in the parts that we struggle to automate or describe. The easy parts of our jobs will become more automated, more likely to be managed by a tool or outsourced. The hard parts, the thoughtful parts, those are the skills we should concentrate on when improving our skills.

    Outsourcing isn’t all bad. As Toyota has outsourced some of their systems, they are not looking to shrink their IT department. Instead they are focusing on delivering new products and services for their customers. Make sure you are prepared to take advantage of new opportunities if your company follows a similar path.

    Steve Jones

    The Voice of the DBA Podcasts

    We publish three versions of the podcast each day for you to enjoy.

  • Grow Your Skills

    Look to grow your skills on a regular basis.

    The cloud is scary. Without a doubt the idea of outsourcing parts of your organization’s technology department should concern you if you manage systems. Anything outsourced, whether to another firm or automation, means there is less work for you to do. Even in the places where automation grows, we find that sometimes the growth of systems occurs so fast that there are still things for a worker to do, but that’s a losing battle in the long term. At some point the automation will catch up and less people will be needed to manage the systems.

    However the news isn’t all bad. There are some systems that will always be managed inside of a company. Whether because of regulatory requirements, performance needs, or even just the stubbornness of management, I am sure that some percentage of systems at most companies will remain in-house. Those will be the minority of systems in some places, and since many of us change jobs at some point in our careers, we should be concerned.

    I would argue that all of us working in technology should be looking to improve our skills in whatever field we work. However we should be growing the skills in the hard parts of our jobs, in the parts that we struggle to automate or describe. The easy parts of our jobs will become more automated, more likely to be managed by a tool or outsourced. The hard parts, the thoughtful parts, those are the skills we should concentrate on when improving our skills.

    Outsourcing isn’t all bad. As Toyota has outsourced some of their systems, they are not looking to shrink their IT department. Instead they are focusing on delivering new products and services for their customers. Make sure you are prepared to take advantage of new opportunities if your company follows a similar path.

    Steve Jones

    The Voice of the DBA Podcasts

    We publish three versions of the podcast each day for you to enjoy.

  • Targeted Learning

    do not disturb
    Targeted learning means the event isn’t all fun and games.

    I received an email just after I arrived in Seattle for the last SQL in the City 2012 stop. It was from Simon Doubt, who was also coming to Seattle for the PASS Summit, but who hadn’t planned on just attending the conference. Simon had actually come to the Pacific Northwest with a plan: The OLAP Sprint.

    After a few years of attending the Summit and being inspired, taught, and excited by the immersion, it was time to up the ante. The idea was simple, even if the execution would be a challenge. Simon wanted to do more than attend a variety of talks and have interesting conversations. In seven days in Seattle he planned on learning to build an OLAP solution.

    You can read about his journey and it’s an interesting one. It was a success, and while it hasn’t created an OLAP expert, I’m sure that Simon has gained a lot of things from his focused effort. It’s a starting point to learn more. It’s an accomplishment of a fairly difficult task, and it’s a great story that should help a career move forward. This is certainly something I’d put on my resume.

    Throughout the week as I read each entry, I noticed this was a way to tackle the week long conference not as a break from work, but as an exciting new project. The posts showed someone that was taking advantage of the resources at a conference to grow their knowledge and skills. This is a great example of what a plan can do for you, and how you can show your boss that the money spent on this type of training is worthwhile.

    Not everyone will have a plan, and I’d guess most don’t, but the next time you ask for funding think about including a plan of what you are looking to accomplish in a week. Whether you’re attending a conference or an Immersion event, having a plan, with a few specific goals can show that you are using the money you get wisely.

    Steve Jones

    The Voice of the DBA Podcasts

    We publish three versions of the podcast each day for you to enjoy.