Author: way0utwest

  • SQL in the City – London 2012

    It’s a wrap. Two days of SQL in the City are complete, and I’m back at home, almost feeling normal. I prefer short trips to the UK, but this one was extra hard since it was a conference schedule. For me that’s up at 6:30 to run and usually not getting back to my room until 10:00pm. Long days.

    The event was great. If you haven’t been, or wonder what it’s about, SQL in the City is a day of training from Red Gate Software. We do have a track that talks about how to use our tools, but we have two tracks that are mostly technical information. Brad, Grant, and I do mention Red Gate tools, but we aren’t really there to focus on the tools. We’re there to talk about technical subjects and ideas.

    Think SQL Saturday, but a bit more “posh” and sponsored by Red Gate Software. Not this posh:

    9180511dfff63fd6_spice_girls_retro

    This posh:

    Royal-Society-of-Medicine

    Once again this year the event was held at the Royal Society of Medicine in London. We had a tremendous number of people sign up, so we added a day and ran the same one day conference for two days. Friday was packed, with over 400 people coming to learn a few things about SQL Server.

    A note for the US: We’re bringing this event to the US in September and October, touring 5 cities in two weeks. We’ll also be in Seattle on the Monday before the PASS Summit.

    A note to the UK and Europe: Let us know if you enjoyed it, missed it, and want us to come next near. I’d like to do more of these if there is a demand.

    Photo Jul 13, 2 46 12 AM

    One of our two joint-CEOs, Simon Galbraith, opened the event, giving a short keynote on building software. For those of you used to long-winded, marketing filled keynotes, take note. This was 10 minutes, about 10 slides, 3 laughs from the audience, and that’s it.

    Photo Jul 13, 2 46 03 AM

    Photo Jul 13, 3 06 38 AMThen it was time to learn. I watched a session from two Red Gate employees, Dave Atkinson and David Simner, on Continuous Integration (CI). If you aren’t using CI in your software process, you should. They showed how this process works, and how it has helped them build software quicker, and more bug-free. A few of the Red Gate tools make this easier, but there are many ways to do it.

    I’ve never used CI before since the last time I developed software in a team was almost a decade ago. I realize now that I was really missing something. There aren’t a lot of cool, new things that I think have come through our industry, but this is one of them. Read the white paper we have, and start learning more about Continuous Integration.

    There were a number of other talks on database maintenance, writing T-SQL, and more. I did two, one on preparing for disasters and thinking about things ahead of time and one on Contained Databases and AlwaysOn in SQL Server 2012. Grant talked about Sandbox development and monitoring your servers with the ring buffer (an amusing talk with movie photo quizzes included).

    Photo Jul 14, 9 06 42 AM

    This was a little more of a formal event than most SQL Saturdays. We recorded the event, and while the videos will only be available to attendees for the next few months, that does mean that if you missed a session, you can watch it.

    Photo Jul 13, 3 06 44 AM

    We also had a very hard working staff, including product managers

    Photo Jul 13, 6 51 31 AM

    developers

    Photo Jul 13, 6 56 45 AM

    and quite a few people from all parts of the company.

    Photo Jul 13, 4 43 13 PM

    Even more importantly, we had free refreshments at the end of the day. I remember because I was told more than a few times to mention this before my talks. Our 2012 Red Gate brew of Select Star beer (along with wine and soft drinks) was handed out at the end of the day.

    Photo Jul 13, 4 45 52 PM

    Photo Jul 13, 5 20 05 PMWe also had a nice happy hour with a few prizes. A SQL Toolbelt from Red Gate first, and then a ticket to the PASS Summit 2012. That one had quite a few people hurriedly filling out their evaluation forms.

    This was a great time, and though it was hard and long for me to speak two days in a row, I enjoyed the trip. I got to run through Hyde Park (haven’t done that in 25 years) and Regents Park (never done that), and had the chance to meet a lot of people from the SQLServerCentral community, including a few I’ve corresponded with for years.

    The US tour starts in September. The cities and dates are:

    I’ll be at all of them, along with a crew from Red Gate and a few guest speakers from the local areas.

    This is a great chance for free training, one that we think is worth a day of your time. Sign up today if you’ll be near one of the events, and I look forward to shaking hands with you if you attend.

  • A Cool Job

    Unisys ES7000
    How would you like to play with this server every day?

    I saw recently that the newly approved TPC-E Benchmark, a test of OLTP systems, is having a test system submitted by Unisys. They’ll be the first ones to send a system, in this case the ES7000, through it’s paces with this benchmark.

    It’s got to be a cool process and I’ve got feelers out to Unisys to try and dig further into what goes on when you try to build a system to test the benchmark. I have the feeling this will be an interesting story, so be on the lookout for that.

    However I’ll speculate a little that this has to be a very interesting exercise. The application is static, after all, it’s a standard set of routines (I’m assuming) that you’ll run against your server. So the challenge is in sizing and tuning your system. Tweak a knob, hit the turbo switch, get advice from the MS guys, it’s got to be an interesting day’s work.

    And I’m sure it’s incredibly enlightening. What does file placement mean? How far can you push a system? At the very least you’d think that they’d build some sort of real-time, F1-like dashboard so they can watch the system go.

    Heck, that would be a cool job just to build some application to receive the telemetry of the system in real time and display it on some sort of dashboard. Maybe I’ll see if Unisys wants someone to work on that aspect of the test system.

    Now if we could just have some real-time knobs and sliders on the server to actually adjust various parameters…

  • AlwaysOn and Contained Databases in SQL Server 2012

    This talk is mostly based on contained databases in SQL Server 2012. The first part of the talk goes over the problems with current database movement, the idea of containment, and the implementation in SQL Server 2012. There are demos that cover the user and collation scenarios. The second part of the talk goes into the basics of AlwaysOn. I talk about the architecture, the various scenarios you can have, and the advantages and drawbacks of the technologies involved. There are no demos of AlwaysOn mostly due to time.

    Length: 60 minutes

    Slides: downloadable after the SQL in the City 2012 tour.

    Code: Demo code

  • Prepare for When Disaster Strikes

    When disaster strikes you have to respond and get things fixed ASAP. However if you could turn back the clock, and think about the potential problems and possible issues, can you decrease the time it takes to get things back to normal?

    This presentation looks at reducing your RTO by examining four common disasters, of which most disasters are a variation. We examine the components of RTO and then how you can reduce each one of them with a little forethought and preparation. The disasters are

    • Hardware Failure
    • User (or DBA) error
    • Corruption
    • Bad Deployment

    The talk includes a few demos of how you can respond quicker using Red Gate tools.

    Level: 100

    Length: 60 minutes

    Slides: Available after the SQL in the City 2012 tour.