Voice of the DBA

Author: way0utwest

  • MCM Prep – Sliding the test

    If you can’t cram enough for the test, what’s the thing to do? Slide the test. I realized last night that I was scheduled for this Friday, but I’m nowhere near prepared. Not that I’ll be totally prepared, but I’d like to be well prepared in my mind and I haven’t gotten through all modules.

    I did XML last night, and realized I’m a little lost. The CLR I did today made sense, but I decided to give myself more time. So I moved it to late February, after vacation, where I think I’ll do some prep as well with all the flights and laying around the pool time. It will be good to keep the mind moving while I’m in the Bahamas.

  • MCM Prep – Only ONE Transaction Log File

    Unlike for data files, SQL Server does not use multiple files for the transaction log in any way that improves performance. The writes are not striped across files. Instead SQL Server will write to one file, then the next, then the next, wrapping to the first file when all the VLFs are full, just as it would with one file. In other words, it moves sequentially through the files for new transactions.

    I haven’t found a BOL reference for this, and don’t really feel like continuing the search, but Kim Tripp blogs about it here and it’s mentioned in the log file internals MCM video.

  • Welcome to 2011

    It seems amazing that it is already 2011, and we’re ten years past the point when I expected there to be a manned mission to Jupiter. Or at least hoped it would have happened. We look forward to 2011, with many people expecting a new version of SQL Server to be released, along with many other technological advancements likely coming.

    The new year is a few days old, and I suspect a few of you have set some new years resolutions. Those are always hard to stick with, and it almost seems like failing to keep them is as much a tradition as making them.

    I read quite a few blogs last week talking about goals for 2011, and this is a good time to think about what you would like to accomplish in your career this year. I am trying to work through this myself, thinking about where I would like to take my life over the next year. Like many of you, I have to blend a busy family life, a job working for someone else, and professional goals into some strategy that fits into that ever limiting 24 hours we are stuck with each day.

    I think that putting these goals down is important. It helps to focus you, and regular review or reminders to check them can ensure that you will work on them. It’s easy to forget in which direction you want to go, because we get busy and are pulled in many different directions each day.

    This next year I am not sure what will be on my list, or even if I will have a list of goals for the year. The pace of change seems to almost dictate a shorter term set of goals, perhaps quarterly. I do think, however, that it’s important to have a list of things that you would like to accomplish in your career, and make an effort to progress through them on a regular basis.

    Steve Jones

    (originally published at http://www.sqlservercentral.com/articles/Editorial/72059/)

  • MVP 2011

    Microsoft_MVP_logo I was awarded the MVP status from Microsoft for 2011 on Jan 1, 2011. This is my fourth consecutive award and I am honored to be recognized for my efforts in the SQL Server community.
    When I opened the email last Saturday morning, I had mixed feelings. On one hand I think I deserve the award for my efforts in the community in speaking, writing, and promoting SQL Server. I think I do a lot, and while it’s my job, it’s also a bit of a passion for me.
    On the other hand, I always think “what was Microsoft thinking” when I consider the deep technical knowledge that so many of the MVPs display. I know a lot about SQL Server, but it’s in a fairly shallow, general knowledge area, though I do have a lot of experience in the past. I don’t do any earth-shaking work, and I certainly don’t impress many of the experts in various areas of SQL Server work. So in some sense I didn’t really contribute a lot to the growth of the knowledge base of SQL Server in 2010.
    The award, however, is very much a community award, and it is for the contributions in sharing knowledge and helping others work with SQL Server. Without the award, I wouldn’t do anything different. This doesn’t drive me, and if I lose it, it won’t change the way I approach the community.