Voice of the DBA

Author: way0utwest

  • Back Across the Water

    Another trip to the UK this week, with me leaving today for Cambridge and meetings at Red Gate Software. This will be my third trip this year, a record for me, and also the most travel I’ve done in a year.

    We are doing some planning for 2013, for the community and various events that Red Gate is a part of each year. We’ve supported user groups, SQL Saturdays, various conferences and our own SQL in the City events. Our goal is to interact with the community and learn things about how people use our software, as well as promote it, but also to educate data professionals. We want to turn a profit, but we also want to be a part of the community and support it where we can.

    I wish I could say that I’ll travel less next year, but I’m not sure that’s the case. We are looking to more effectively provide support, with more value for the money we spend, but I suspect that will mean more travel for Grant Fritchey and myself.

    We’ll see what happens, and we’ll likely start booking some events in 2013 soon. If you have ideas, suggestions, or requests, please feel free to post something here or send an email to communities@red-gate.com.

  • The Default DBA

    When we setup SQL Server, there are a few choices we need to make, some of which require a few items be prepared in advance. Service accounts are one of those preparation tasks that DBAs usually perform in advance of installing an instance. There are a few things, however, that aren’t configured when SQL Server is installed, like alerts and operators. I find that often these items can be missed by inexperienced DBAs, who forget to configure standard alerts. They might also not have a mail account ready, which is required for the instance to send mail.

    Perhaps there’s a better way for SQL Server to request this information when it is installed. If one part of the setup program asked for default mail information, it would be easy to pre-configure the instance to setup alerts and enable them for communication with a DBA. Personally I’d prefer that setup get a mail profile and a default DBA group email address that receives information about the operation of the instance that the DBA should be aware of.

    There can be a hesitation from experienced DBAs that don’t want setup to install mail for them, but it would be easy to make this an optional component, with a checkbox like the one for a blank sa password. You actively choose to install the server differently if necessary, but otherwise setup would push DBAs to ensure that notifications are configured. We could even see a pre-selected list of alerts that will be enabled, with the option to disable all or just selected items.

    I don’t know that Microsoft will build these types of defaults into SQL Server, but I wish they would. We’ve done that with SQL Monitor at Red Gate, and we have seen the advantages that come when you provide good practices and knowledge to less experienced DBAs: they gain some knowledge transfer and have software running at a high level from the very beginning.

    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.

  • Speaking at Oracle Training Days

    RMOUGSpeakerA first for me. I’m attending a non-SQL Server event, trying to bring a little knowledge of my platform to those that typically work on the Oracle side of things.

    The Rocky Mountain Oracle Users Group is holding their Training Days 2013 event on Feb 11-13 in Denver and a few of us SQL Server people were invited to speak.

    I’ll be talking about Database Maintenance one of the days, hopefully ensuring that some of the “accidental” SQL Server DBAs that also manage Oracle understand the basics of maintenance in SQL Server.