Voice of the DBA

Author: way0utwest

  • On the Road Again – SQL Saturday #90

    I’m leaving this morning for Oklahoma City for SQL Saturday #90. This is my first time traveling to Oklahoma City and I’m looking forward to it. I’m thinking to check out the National Cowboy Museum, I need to see the national memorial, and of course, get it in a run. It looks like the event isn’t too far from the river, so I might get it in run along there.

    I have a light schedule for the event, which is good for me. I have the opening keynote and then a lunchtime demo session of Red Gate tools. That’s about all I want to do, having learned the hard way that more than 2 sessions is a lot of work. I’m happy to do three if someone drops out, but I’d rather not.

    It should be a good event, and I’m looking forward to seeing OKC for the first time.

  • Create a Log Backup Schedule – #1 Skill You Need

    This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011.

    You Need Log Backups

    By default databases in SQL Server are created with the Full Recovery Model. That means that without log backups, the log will continue to grow and grow until it hits the growth limit you’ve set, or it fills the disk. I see questions on this constantly at SQLServerCentral from people who have a 10MB database and a 653GB log file.

    A log backup will mark the transactions in the log as backed up, and that space can be re-used. The log backup aids in space management and also provides recovery to points in time in between full backups. With that in mind, you need to do a few things.

    Schedule Log Backups

    As soon as you create a database, and you create a full backup schedule, schedule log backups as well. It’s easy to schedule a single daily log backup along with your full backup. They don’t block each other, and for most non-production systems, this works fine.

    Note that the total space used for the log backups is the same whether you schedule 1 a day or 86,400 a day. There is a slight overhead to each file, but essentially the space used is the same. However backups scheduled more often result in a smaller log files size for the LDF.

  • Keep Data Forever

    Will this keep data forever?

    How long do you expect to keep a piece of data in any of your databases? Chances are if you’re like me, you rarely think about it and expect that you need to store all the data perpetually. As long as you have a job, and the database is being used by some system, you keep the data.

    Over time that becomes a problem. Some companies are starting to examine the legal issues of old data, mostly emails, but potentially other records, and digitally shredding or removing that data over time. For others there are the problems of storage, with the raw space needed to keep all this data growing faster than hardware budgets. More and more companies are looking to archive data that is less used to ease the stress on their storage and backup systems.

    However if you do decide to keep data forever, how do you do it? There are all sorts of issues with various techniques, and I have heard a few companies considering printing out the 1s and 0s and using a more durable storage medium like microfilm or even paper-like substrates that might last more millennia. There is a new type of disk that promises to last longer than ordinary discs thanks to it’s “etching” rather than “burning” process.

    Whether it really works is something we won’t know for years, but I do know that the best solutions for now are migrating your data to new (and larger) storage mediums and crossing your fingers that any archived data on disk, tape, or DVD is still readable if someone asks for it.

    Steve Jones

    The Voice of the DBA Podcasts

  • How is this free?

    I received this ad in an email:

    free

    Now I’m a member of the SSWUG mailing list, I get their daily lists and they know that I’m a registered member, but not a paid member. I don’t feel that their service is worth paying for since the majority of the content is available free on the web, I have a ton indexed on SQLServerCentral, and don’t see the value. I don’t dispute the service is worth something, and if it’s worth $79/yr to you, feel free to subscribe.

    However I clicked this link and went to another page where I was informed that this webcast was actually $29. It’s free for paid members of SSWUG, but not for registered members.

    I went back to the email and saw the fine print below this ad:

    free2

    I suppose this is adequate disclosure, but it feels deceitful to me. I was thinking that I’d hear Ryan speak, who I met at SQL Saturday #63, and see if there was something about CMS that I’d missed, or could learn.

    Instead I feel a little cheated, and a rather annoyed that I wasted my time with this. I don’t blame Ryan, and think this is a poor business practice on the part of SSWUG.

    If you want to give something away for free, do it. If you advertise something for free, but then have fine print that it’s only for certain people, I think you’re fundamentally being a little dishonest with the people with whom you’ve communicated.