Voice of the DBA

Tag: syndicated

  • What’s a Disaster?

    In working on my Preparation for Disaster presentation and doing research, one of the questions that came up early for me was “what is a disaster?” After all, if you can’t answer that question, how do you prepare for it.

    I’ve got a list of stuff here, which ones of these qualify as disasters?

    • Hard Drive crash
    • Hurricane wrecks data center
    • Fire in the server room
    • Corruption in a clustered index
    • DBA deletes a table by running DELETE without a WHERE clause
    • User clicks submit on a web page and the database crashed before they get the acknowledgement
    • Admin uses Access to update and lock a table, and forgets to save their work before leaving for lunch
    • DBA deploys code to production instead of development by accident.

    The answer is all of these are disasters. Most people seem to plan for the first 3, and forget to plan for the rest.

    Anything that interrupts your system’s ability to serve clients and get work done is a disaster. It’s worth keeping that in mind and planning for all sorts of potential problems. It doesn’t mean you have to be ultra paranoid, but you ought to have thought about the various potential problems and have some ideas about how to deal with them.

  • SQL Dream Cars

    A mini debate on Twitter the other day got me thinking about cars. People that know me know I like cars. I’ve owned (or my wife has owned with me) 26 cars since I started driving. I used to write a car update, but found that there are a lot of passionate people out there about their vehicles, and too many people got upset during the debates, so I stopped.

    However this is my blog, and I decided to talk about dream cars, or any vehicle that you’d like to own. I’ve got my list of the cars that I’d like to own one day, but here is a good list of five:

    1929gazellembreplica071106

    1929 Mercedes Gazelle – Not a real one, but a kit car. The technology for running a car from that era isn’t great, but give me this body with a modern fuel infected engine, brakes, and a good transmission.

    magnum-pi-ferrari

    Ferrari 308 GTS – The Magnum PI car. This one always caught my eye, and I love the targa tops (my 911 has one), so this would be one that I’d like to drive. Once again, I’d consider a kit car because it’s hard to drive this one around town on a regular basis.

    vw-thing

    VW Thing – At the same time I was first shopping for a 911, I was also looking at Things, in case I couldn’t find a 911 in my budget range. Something about these cars just seems fun to me.

    CJ7_for_sale

    CJ-7 – I had a friend in high school who got one of these. He put a 308 8 cyl engine in it and I went with him to get 33” tires. I actually helped bolt on headers, and love cruising around with the doors off and a bikini top on it in the summer. One of these days…

    1965 lincoln Continental

    1965 Lincoln – Not necessarily this model, but a big old boat convertible with suicide doors. That would be cool.

    There are more I’d like, but these are some fun ones that I came up with today.

    I’ll tag Brent Ozar (blog | @brento), Allan Hirt ( blog | @sqlha), and Aaron Bertrand (blog | @aaronbertrand) to talk about what they’d like. Hopefully a few more of you will post your own dream cars.

  • SQL Server Default Backup Directory

    Someone asked me in a webinar how to change the default backup directory. I knew, but realized that I didn’t have a reference and ended up with more explanation than needed if I’d had a post. So here it is:

    If you right click on a server in Management studio and select properties, you get dialog with lots of options.

    serverpropertoes

     

    If you click on the “Database Settings” you get this:

    serverdbsettings

    Note that there is a default path for data files and log files, not not one for backup files.

    serverdbsettings1

    So how do you change it? In XP or Win 7, click Start and type this right away “regedt32”

    regedior

    That will start the registry editor. You ought to get a UAC box to confirm access, which is fine. Do that and you’ll be in the registry. In the left pane, browse to this path:

    HKey_LocalMachine\Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer”

    Note that the “MSSQL.1” might be different, depending on your instance. For me it’s SSQL10.MSSQLServer.

    backupdir

    Note that there’s a “BackupDirectory” key here. You can double click it to change the path:

    backupdir2

    I changed mine to a new path, c:\sqlbackup. Note that I had to create this folder.

    change path

    That’s not enough, however. If you go into your adminstrative tools and find the Computer Management and look for Users and Groups (Select groups), you’ll find groups like this. The name varies, depending on the name of your workstation/server and instance.

    security

     

    Once you have this name, I’d copy it and go to your new folder. Right click, select properties, and then the security tab

    sevc1

    As you can see, my group isn’t in here, but this group, with the SQL Server service account in it, needs permissions to this folder. So add them, with modify.

     

    sec2

    Is my default changed? I could now run this:

    backup1

    and I find a file in my new default folder:

    backup2

  • [OT] Running With Steve

    I woke up to this very cool photo from my employer.

    rg

    I was checking my Twitter feed, and noticed quite a few #runwithsteve hash tags, from various people already knocking out mileage for the goal of 1,000 miles today. The tally survey is here: Running With Steve. I am looking forward to getting out there in a bit with my wife, maybe a kid if I can convince them. I hope to do five today.

    It’s been quite a journey to get to 1,000 days. I was inspired in Sept 2008 and was thinking to get to one year and then see. When I got to 366, I did a Forest Gump. I kept going since it was fairly easy. I made it to two years, and then started thinking 1,000 days, and made it today. I’ll run this afternoon, when my wife has some time, and enjoy day 1,000.

    The act of doing something every day has been amazing for me. It’s not so much the physical benefits, which seemed to peak after about 4-6 months, but more the mental benefits. I know I’ve accomplished something every day, and it inspires me. It becomes a habit that helps me manage the rest of my life, keeping perspective, thinking long term, and balancing out the various things in my life.

    Where do I go from here? I’ll run tomorrow, day 1,001, and see what happens after that.