Category: Blog

  • The DBA Team #1–Code and Slides

    Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment was a success and we’re already talking about where and when we might do this again.

    In the meantime, we didn’t make a separate site for this series of events, being an experiment and all. I’m adding this post as a placeholder for the various slide decks and code.

    Core Monitoring for SQL Server (Steve Jones)

    Good DBAs ensure that they are always aware of the state of their instances. All systems should have monitoring in place, not just so you know when things go wrong, but so you understand what a normal workload looks like and can plan for the future. This session will cover the basics of monitoring a SQL Server system and the various metrics you should be tracking.

    Getting Started with SQL Server Backup (Grant Fritchey)

    Backups are fundamental to protecting the investment your business has in its data and they’re the foundation of disaster recovery planning. We’ll go over best practices for database backups, to ensure you’re establishing that foundation correctly within your systems. This introductory level session covers full, log, and differential backups, as well as restores and restores to a point in time. Come along to be sure you’ve got the right protection in place for your systems.

    Understanding Database Corruption (Grant Fritchey)

    A DBA’s primary purpose is to ensure that the information in their charge is accessible by the correct people within their organization. Despite everything you do to make sure you’ve got your servers configured, monitored, and tuned, with well-tested backups in place, you can still lose data through corruption. But what is corruption in a database? This session lays out exactly where database corruption can come from, how to find out exactly where the corruption is within a database, and  the methods you have available to recover from database corruption.

    Indexing for SQL Server (Steve Jones)

    Indexes are important for improving the performance of your queries, but they add overhead to your server and require maintenance. This session examines how indexes work and the basic maintenance that you should perform to ensure your system is running at its peak level.

  • SQL Saturday #187–Richmond Recap

    I’m late writing this, and I did mean to get to it earlier, but life got in the way.

    TL;DR: It was a great event, lots of fun, and I’d love to do it again.

    When I first heard of a SQL Saturday coming back to Richmond (from Carlos Chacon of the Richmond SQL Server Users Group at SQL in the City 2012 – Boston), I started making plans to attend. I used to work in Richmond, for Dominion Resources in the Innsbrook area, and have spent a good amount of time in the city.

    The timing for Richmond was perfect, as Red Gate has been looking to experiment with some smaller events where we can teach people about SQL Server in The Red Gate Way. We decided to try this in Richmond, with Grant Fritchey, myself, and two of our salespeople flying into Richmond on Thursday night. I drove down from Washington D.C., arriving just in time to take a 30 minute walk around the Innsbrook area before delivering an encryption talk to the Richmond SQL Server User Group.

    One of the things I loved about growing up in Virginia was all the history of the beginning of our country which is noted and celebrated there. This statue outside the user group building has the US Constitution engraved in it.

    Photo Mar 07, 4 00 35 PM

    Friday had me up early, getting a little exercise before heading over to the Hollywood Cemetery with Grant Fritchey. We walked around for a half hour, seeing Jefferson Davis’ tomb along with many other famous Confederate resting places.

    Photo Mar 08, 7 34 59 AM

    We also saw this amazing pyramid, seemingly constructed of loose stones. No mortar we could find.

    Photo Mar 08, 7 43 23 AM

    Afterwards it was prep time for our Micro Event with The DBA Team. This was a short, four hour event where Grant and I each presented two sessions. This was our experiment, designed to let us talk about technical talks and include information about how our tools help you solve problems.

    Photo Mar 08, 12 28 40 PM

    We talked about these topics, in a technology neutral way, but our demos included Red Gate products. This isn’t a sales talk, but really a way to educate and inform people about SQL Server topics, but we include our products in the demos to show how easy it can be to handle any of these items:

    • backups
    • monitoring
    • indexing
    • corruption

    The event went well, and I’m hoping we try a few more of these at other events later in the year.

    One interesting thing I learned was a number of people attending our event hadn’t heard about the SQL Saturday, as well as vice versa. Definitely we, and the events, need to market better. Somehow.

    After a short happy hour, Grant and I drove over to the speaker’s dinner for SQL Saturday. This was a nice get together for speakers and volunteers at a local restaurant. We had the chance to catch up with quite a few people we hadn’t seen in a long time. I love having a few hours to chat and bond with the speakers and volunteers.

    Note for all organizers: I appreciate the dinner, but I’d be happy with us just meeting in a room and each person paying their own way. The important thing is for us to get together and enjoy the company.

    Saturday morning was a drive over to the University of Richmond. I’d never been there, and as we wound through large houses on big, treed lots, I wasn’t sure Google Maps had me going to the right place. It did, and we arrived at the campus, which was beautiful. Spread out, hidden in trees, brick buildings, an amazing location. I was reminded of the University of Virginia, which I attended.

    The event was in the Science building, which had a large, open atrium. All the vendors were set up, and as usual, the rooms were spread out. That made for lots of traffic between sessions, but that’s not bad. I thought it was fairly easy to find all the rooms and plenty of people were willing to point those that looked lost in the right direction.

    I started the day with Matt Velic’s session on building a virtual lab. He took an interesting approach, using free software to do this. Virtual Box, FreeNAS, and more allowed Matt to show how a virtual clustered environment can be set up for testing.

    Photo Mar 09, 6 46 18 AM

    Matt has blogged about this a bit and even written an ebook that you can download to learn how to build your own lab. He did a good job, though I’ll admit I had to duck out early to take a phone call.

    The inclusion of the ebook, which Matt mentioned a few times as stragglers came in, was good. I’ve been toying with the idea of providing some “prep” materials, as well as post talk support for attendees. Understanding a little of what the background for the material is might allow some presenters to go a little quicker for some talks. Something to consider for the future.

    I also slipped into Karen Lopez’s database modeling talk. Karen has a fun style, and this was an interactive talk, with people being asked to “vote” on various topics with post it notes.

    Photo Mar 09, 8 16 43 AM

    I sat in the back watching, and was glad to see so many people, probably everyone, participating. Based on the “votes”, Karen led some fascinating discussions.

    Photo Mar 09, 8 18 29 AM

    If you get a chance to see Karen, do so. This was a great talk, and thought provoking for those of us that have had to design databases.

    I was up before lunch, delivering my “Branding” talk for an audience in the auditorium. I was glad to have a little pad with lunch following my talk as I ran a little over. It was a fun talk, and had some good tweets.

    Capture_023

    It was also special as my Mother had driven up from Virginia Beach to see it and spend a few hours with me. I ate lunch with her and spent a little time before she left and I headed out to chat with more people.

    The events are always a busy day for me and this was no exception. While most people are in sessions, a few are always wandering around, and I had a few short chats with people that were attending the event, as well as some other speakers and vendors.

    In the afternoon I presented my Encryption Primer before packing up at the end of the day.

    The closing event was well attended, with people packing into the auditorium for thank-you’s and prizes. A nice tribute from the organizers for the speakers and volunteers, including recognition of the young lady who arranged for the use of the building. I hear this a lot, but many people don’t, and it’s always nice to remind people that this “free” event actually required work, effort, and donations from many people.

    There were lots of prizes given out, and some fun drawings as Carlos’ daughter participated in picking entries. I love seeing kids involved since they are the future of events and business, and letting them see all the people willing to work on improving their careers is a good role model, IMHO.

    I left right after the drawing, skipping the after event as I had to drive back to Washington DC. I arrived late, grabbing a hotel and a late dinner, but I had a nice surprise Sunday morning. My name on a sign.

    Photo Mar 10, 8 04 55 AM

    A fun event and trip for me.

    I know this event was stressful for the organizers, and it always is, but it ran smoothly, and people learned things. Yes, the coffee was slow to get out in the morning. Yes, rooms were spread out all over the building.

    None of that’s a big deal. People came, they learned things, and that’s the whole point of these events.

    Great job, Richmond, and I hope to come back in the future.

  • A Week from Omaha–SQL Saturday #197

    speakingsqlsat197Next week I head out to SQL Saturday #197 in Omaha NE. I’m looking forward to it as I’ve never been to Omaha, and only been to the state once, in the far SW corner to Oshkosh for a horse race. I’ll arrive Friday and have a short time to look around the city before the event gets started.

    If you are in the area, there three great pre-cons you can register for and attend on Friday. These are a good, low cost way to get some practical knowledge for your job from some knowledgeable experts. The choices are:

    • Practical Self-Service BI with PowerPivot 2012 for Excel – Bill Pearson
    • Prof. PowerShell Or How I Learned to Stop Worrying and Love PowerShell – Jeff Hicks
    • Scaling SQL Server 2012 – Glenn Berry

    I’ll be presenting a talk on encryption in the afternoon, but am looking forward to watching a few other sessions earlier in the day. I missed Kevin Boles talking about Window functions earlier this year, but I’ll catch him here. I’ll also be looking to see Bill Fellows talk a little T-SQL and Joe Sack talk about Troubleshooting Query  Plans. There are lots of other great options as well, and if you’re in the area, consider attending.

    This should be a fun event, and if you’re a SQL Server professional looking to learn a bit more about the platform and improve your skills, this even is worth a Saturday of your life.

    Register today and I’ll see you in Omaha.

  • Macbook Air v Surface Pro

    I love my MacBook Air. It’s small, light, and it works well as a traveling laptop for me. It starts and stops instantly, and the only complaint I have is that my 2011 version only has 4GB of RAM and no USB 3.0. The 2012 version improves, and I’d upgrade, but I’m waiting to see about the refresh that is supposed to come this summer. If the update is substantial, I’ll be ebay’ing mine and finding a new one.

    However I’m not blind to other options. I hadn’t seen many Windows laptops that are as small and light as an Air (or as well-built). However I ran across this article on Living With A Surface Pro for a week. In it, the author mentioned the Pro specs are better than the Air specs.

    Hmmmm. Intriguing. Let’s see.

    Surface Pro (from Microsoft ):

    • 2lbs
    • 42 Wh battery – 4,5 hours (from Microsoft) 2.5 hours (from the author)
    • 10.81” x 6.81” (1920×1080)
    • 128GB storage
    • Intel i5, 4GB
    • USB 3.0

    Macbook (from Apple)

    • 2.38lbs
    • 35 Wh – up to 5 hours (my current one gets 4 hours on Netflix according to my daughter)
    • 11.6” display (1366 x 768)
    • 128GB storage
    • Intel i5, 8GB
    • USB 3.0

     

    Those are fairly comparable. I’ve somewhat listed things in the order that they matter to me. Weight is big for me, and both of these are similar. If I add in a type keyboard, then the weight is probably similar. Battery is next, and I think this is a bit of a killer. I have to think about it, but that might be an issue.

    The Surface display is a much higher resolution. Does that matter? I’m not sure. A good display matters to me, but I’m not watching blu-ray on this thing, and for the most part, I won’t have anything to compare it to most days. I like the Air display, and I need to check out a Surface to see if it really makes a difference.

    Storage is the same, and with USB 3, not sure I care here. Both are Intel i5s, but the Air can go to 8GB. For me, doing work (as in SQL Server work), this matters. If the Pro can’t be upgraded or won’t come with more, not sure it’s a valid choice.

    My Air will be two years old later this year, and it’s working well, though depending on the talks I plan to give later this year, the 4GB might not be enough for me. I hate to think about a MacBook, both in size and weight, and I’m not sure I’ve seen a Wintel that I like. I’m also not sure a Surface will cut it. I have nothing against the Surface, and it intrigues me. I’ll have to go spend an hour at the MS store one day and see what I think.