Author: way0utwest

  • Avoiding a DBA’s Worst Days with Monitoring

    SQL in the City Abstract: When things go wrong with a database, it can be the start of the worst day of a DBA’s life. Join Steve Jones as he examines the problems uncovered by The DBA Team and how you can prevent them with proactive monitoring and in-depth knowledge of SQL Server.

    General Abstract: A DBA usually has a bad day because they are unprepared for issues that commonly occur or unaware of situations that can cause problems. Learn about the five things Steve Jones finds to be most important for DBAs and how you can be ready to handle issues in these areas:

    • Backups
    • Space
    • Security
    • Resources
    • Deployment

    This session does include Red Gate tools but explains how issues can be avoided with your own utilities.

    Slides: DBAsWorstDays.pptx

    Placeholder resources:

    Custom Metrics used in the demo:

  • Off to London

    Today I’m off across the Atlantic again. SQL in the City 2014 kicks off in London and I have 3 talks to give on Friday. Plus a keynote.

    Today is keynote practice, last minute packing, and then off to the airport for my flight overnight to London. This will be another quick trip, and although I think it would be good to spend a few days in Cambridge at the Red Gate offices, I’m so focused on SQL in the City, as well as this being my third trip this month, I didn’t think it made sense. I still have a week in Seattle coming, so this has been a tough time.

    I am a bit excited about the event. We have a new venue, and we’ve worked to fit a number of talks together in a sequence that I think can help get people moving forward in a Continuous Delivery software+database development process. I really think this is the way to build better software, and I want to see us jumpstart development on SSC in this manner in 2015, and hopefully get continuous work being done.

    I’ve also got a new talk based on the DBA Team articles, and I hope everyone likes it. I tried for a bit of humor, so we’ll see. If it does well, I’ll do it in Seattle. If not, I’ll be reworking things next week.

    Once again work blends into the weekend, though not by much. I’ll be heading back from the UK Saturday morning, so I’ll miss a half day in Denver, though it will be a long day in all for me. My flight will leave around 1am Denver time, so by the time we hit Saturday night, I’ll be a bit worn out.

  • Searching for a Laptop Bag

    I was in San Jose recently for the Silicon Valley Code Camp and when I picked up my backpack in the morning at the hotel, an edge caught on the desk and my zipper pulled loose. Not what you want to have happen when you’re transporting a laptop that you use for work.

    This has been a good backpack for me during the last couple of years, but as you can see below, it’s wearing out.

    Photo Oct 20, 5 27 30 PM

    The zipper pulls are fraying, the Velcro doesn’t stick as well, and now the zipper has issues. For a free bag, I can’t complain ,but I think it’s time to move on.

    Past Choices

    I’ve had more than a few bags in my life. Early bags came from vendors, and I’ve had no shortage of conference bags over the years. This was a good one, but I found the flap to be annoying to me, and I’ve sworn off messenger bags.

    Photo Oct 20, 4 07 22 PM

    I had a stage with my bad knee (and aching back), where I used roller bags. I had this great Targus for a lot of trips, and really enjoyed it. I could put in some clothes and plenty of gadget, and make this a single bag on short trips.

    Photo Oct 20, 4 07 38 PM

    However. I’ve also found that airlines have moved to smaller jets where possible, I often do have another carryon, and this doesn’t fit under a seat (often) or overhead (in smaller planes). As a result, I went searching for a smaller roller.

    My wife used to use this nice leather one, and I tried it for awhile. However it had a few issues.

    Photo Oct 20, 4 07 08 PM

    It also doesn’t fit under seats well (too wide), and it’s got a frame, so the size doesn’t change much. However the other issue is that it’s hard to maneuver with a second bag. It doesn’t stand up by itself, and the handle doesn’t easily fit over a luggage handle, so it’s a pain.

    The Search

    I started on Twitter, and got a lot of recommendations. Far too many were for messenger, shoulder style bags, which people seem to like, but I don’t. I also didn’t want a bare bones, super small backpack.

    My son has a nice, military style Maxpedition bag, but I don’t love the single sling. It’s a bit of a pain to get on/off without unclipping and don’t want to be doing that. However it is durable as can be.

    When I look at reviews, I see all kinds of different bags and features. There’s an amazing selection. That’s good and bad, but it certainly makes me think about what matters to me.

    One of the first companies that popped up for me was Everki. I’d never heard of them, but for some reason I clicked through and started browsing their backpack bags. At first I dismissed a few models that claimed they could store an 18” laptop as I’m never getting one of those. I’ve had a 17” model before and didn’t love it. As of now, I’m always searching for the smallest machine I can find that takes 16GB. Soon it will be 32GB, but I’m not ready for one of the W540-sized machines yet.

    As I looked, I watched a few of their videos, and I have to say that while I hadn’t considered the fold flat to be a feature (TSA doesn’t care in many places), I did like the fact that I often get stuff stuck down in the bottom of my bag now and have to search around. I also liked the hi contrast orange inside, because surprisingly often I can’t see inside my bag.

    versa_1

    I settled on the Versa for one main reason: the sunglass case. It’s also in the Concept, but I didn’t want to spend $300 (though for some reason $200 didn’t seem too bad). However I usually want sunglasses with me when I drive, and I’ve even found them on my head as I get to the TSA line and have to slip them into my bag, where they’re not well protected. Yes, I know I can take a glasses case, but I’d need 2 and I find those to be a pain. It’s not rational, but I’d rather have it built into the bag, a place I can drop stuff.

    versa_2

    I think this bag will be similar to lots of other bags that are in the price range and ta

    I’ve found with luggage that I get better bags (usually) for more money, and I’m hoping this will last me a few years. I spent $150 for a roller that I really like and think it was worth every penny. It’s lasted 4 years and still is going strong.

    I won’t get this before my trip this week because I waited too long to order it. However I’ll have time to pack it next Monday and see what I think, with the chance to order a different bag before I leave for PASS.

    I’ll update a review next week with first impressions.

  • When Work Gets in the Way of Work

    It seems I find myself in this situation more and more. I’ve got work to do at SQLServerCentral. There’s a constant stream of articles to edit, content to review and schedule, questions to build, and of course, writing these pieces on data related topics. That goes on 220+ days a year, as we keep the site going and send a newsletter every weekday of the year.

    However the last few years I find myself crunched to get work done in my work week with the addition of other tasks to my routine. I’ve moved from 2-3 events and 5-6 presentations to 20+ events and closer to 40 talks a year that I deliver. Not only is there a high frequency of events, but there’s also a number of new presentations to build. It seems I have 3-4 (at least) new talks to assemble, which can be quite time consuming. That’s in addition to keeping SQLServerCentral moving.

    This isn’t different than many of the jobs I’ve had in the past. Often I’ve had a set of tasks that I need to work through regularly. Whether these were admin tasks, or development projects, I usually have found that I can develop a routine throughout most weeks. However things crop up. Bug fixes are reported, or hardware fails, or some other project takes some priority, but I need to somehow fit this into my week, along with everything I normally do.

    It’s tough, and I think far too many people with salaried jobs try to just work harder and longer to complete their work. That makes some sense for a short period of time (2-4 weeks), but after that it’s a mistake. Productivity declines and people burn out. They become cranky, and more importantly, they lose a substantial portion of their life over time.

    I’ve learned to push back when things become too busy, and while I’ve had managers that weren’t thrilled, even angry, almost all of them understood the problem and worked with me and others to change things.These days that means I cancel or skip events. More often I decline to accept engagements in the future to bring balance into life. 

    This month is tough, with a lot of commitments made months ago, and flying to the UK this week doesn’t help. However I’ve learned a few things about scheduling my time this year and hopefully I’ll do a better job next year.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 3.0MB) podcast or subscribe to the feed at iTunes and LibSyn.