Category: Blog

  • Comments on the SQL in the City Tour

    sqlcityThere’s still an event in Seattle in a few weeks. As I’ve been traveling around the country, literally around through New York, Austin, San Francisco, Chicago and Boston, I’ve met a lot of people and shaken a lot of hands. There have been lots of questions as well as, I hope, lots of good answers.

    It’s been hard, and I’m tired, but I’ve enjoyed it. I hope we do it again next year, though I’m sure we’ll make a few changes.

    Photo Oct 01, 9 18 10 AM

    It’s been a fun event. We’ve had an opening keynote at every event that starts with the “deployment game” where we have balloons representing application changes (white) and database changes (red). They are inflated, but not tied and it’s up to the people to pass them from the front (development) to the rear (production).

    Photo Oct 03, 12 21 00 PM

    We’re simulating the issues involved with multiple steps of passing things from person to person. One of the chiefs at Red Gate had the idea that we’d do this with eyes closed to simulate “nothing in source control”. This ties in with our thought that it makes sense to keep everything, including the database schema in source control and we offer a few products to do this, including one that uses Visual Studio.

    It’s been a challenge at times with some strange rooms, some small

    Photo Sep 28, 7 12 23 AM

    and some large

    Photo Oct 05, 10 19 26 AM

    People have been slow to get going in a few venues, but with a little encouragement, and once a few balloons lose air, there are some cheers and it’s fun.

    They keynote is interesting, talking a little about our products, but it’s mostly a look at the things we’ve learned in building software, primarily about deployment and performance. I particularly like that we’re (Red Gate) supporting the Glimpse open source project, which looks really cool. If I were a web developer, I’d use this.

    I was tasked with two talks at the events: Database Maintenance Essentials and Prepare for Disaster. I’ve posted a few notes, and I’ll do more once the tour is complete. These talks have been fairly well received, and I’d be happy to do them at other events once this is complete.

    Photo Oct 01, 10 13 45 AM

    The schedule had me delivering talks each morning so that I could leave early if need be. I had to duck out of New York and Boston to catch my flights home, and my apologies to everyone. That schedule let me spend time talking with people and even watching a few talks at different places.

    Photo Oct 01, 3 56 21 PM

    I had new shirts at each location. It was time for a Hawaiian wardrobe refresh, and I even gave away 3 shirts at each event. We’ll have 3 more in Seattle, so register and come (must be present to win) if you will be in the city on Nov 5.

    The food was nice at each event. One of the nice things about running your own event is some level of control and we made sure there were plenty of snacks in between sessions, as well as breakfast and lunch. Lots of complements on the food, and plenty of it.

    Photo Oct 08, 7 15 33 AM

    We notified people when sessions were starting with the Red Gate “hoot” from this horn. I got a little too excited with it a few times and it was taken away from me on more than one occasion. I thought it was a nice reminder that things were moving along, and I’d often hear it as I wandered around the venues.

    Photo Oct 08, 6 27 43 AM

    The Red Gate staff was a mix of product managers, developers, marketing people, sales people, and more. With everyone in Red Shirts, it was easy to find someone to ask a question if you had it. We aren’t a pushy group, at least I didn’t think so from the conversations I overheard. Instead, we try to talk about what we do well, how we can help you, and if we can’t, we acknowledge that.

    There were lots of guest speakers in addition to Grant, myself, and a few Red Gate employees. Buck Woody was there, with his every present cup of coffee.

    Photo Oct 08, 5 50 59 AM

    Denny Cherry on the West Coast, hard at work on his way back home from events in Europe

    Photo Oct 03, 11 26 29 AM

    And in Chicago, Brent Ozar played host the evening prior to the event with the reception in his Chicago apartment overlooking the Field Museum.

    Photo Oct 04, 10 20 28 PM

    I don’t think he was upset by the group, and at least the folks from Cambridge were well behaved.

    Photo Oct 04, 9 49 38 PM

    It was amazing to see so much equipment move from place to place. We had lots of signage, though they made us take it down in New York with the wind and rain outside.

    Photo Oct 03, 11 21 49 AM

    It was easy to find the various product groups, some of which have a sense of humor.

    Photo Oct 05, 10 17 46 AM

    Overall I think we managed to give some training and knowledge to a lot of people that otherwise don’t get the chance to attend larger conferences around the country. With our short happy hour receptions at the end, there was even a nice casual networking opportunity at the end of each day.

    It was a long few weeks, and I ended up seeing too much of this, though my lines were never this short:

    Photo Oct 01, 10 47 17 PM

    I rode too many of these:

    Photo Oct 04, 11 53 12 AM

    But I did get to see, and do some neat things. I ran in Central Park and along the Red River in Austin. I went up and down some hills in San Francisco and ate dinner at Pier 39 and had a nice run and chat with Allen White in Chicago, looping around Grant Park. I even managed to swing by Fenway Park in Boston on my evening run.

    Photo Oct 07, 5 39 57 PM

    I saw the Field Museum in Chicago, though only a small part of it. That’s a place I’d like to go back someday.

    Photo Oct 05, 3 30 50 PM

    And I even managed to get home and take care of a few chores during one of my off days, which was good as it snowed in Denver last week.

    Photo Oct 02, 12 57 22 PM

    We gave away lots of swag, including a number of the books that we’ve published over the years. We had lots of books, and people had their choice of which titles they wanted. We even left a number of various user group leaders in the cities, so there’s more swag coming.

    Photo Sep 28, 5 52 53 AM

    A big thanks to Annabel Bradford, who organized the tour, kept everything moving along, and even motivated the group throughout the week.

    Photo Sep 28, 5 49 06 AM

    If you enjoyed the events, please send us your feedback (sqlinthecity@red-gate.com) and let us know what you liked and what we can do better. If you want to have Red Gate some do some training in your city, let us know that as well.

    We’ll be talking about our plans for events in 2013 soon and hopefully we’ll have another great set of ideas and events next year. We do believe in supporting, educating, and helping the community at Red Gate. We want to sell software, but we feel there’s more to our relationship with data professionals than just selling software.

  • T-SQL Tuesday #35 – Soylent Green

    tsqltuesdayThis month’s host is Nick Haslam (b | t) and he bases his question on the movie Soylent Green, which I haven’t seen. This month he asks what the most horrifying thing you’ve seen in SQL Server. It’s been a long few weeks for me, so I‘ll keep this short.

    As an FYI, if you want to host or participate, contact Adam Machanic.

    Horrifying

    The thing that first comes to mind for me is my first job in Denver. I had interviewed with a small financial services firm looking for a DBA. We thought it was a good fit and I came out to start work in early 1999. Fortunately my wife stayed back in Virginia to sell our house and I was alone since I ended up working a lot.

    The first surprise I had when I arrived for work was that not only was I responsible for the databases (v6.5), but that I was also going to manage the network administrator. He wasn’t that experienced and needed some guidance because we were experiencing daily problems.

    The second surprise was that all of our applications used the sa account. We had 3 or 4 standalone workstations devoted to loading pricing and position information every morning from clients, all using SA. We also had a web application and a thick client application (VB6) that allowed clients to authenticate with a name and password (stored in plain text) in the database, but the connection to SQL Server as with sa.

    However the most horrifying thing was that all developers used the “sa” account to connect to our database servers, in development, QA, and production, with the same password.

    A scary situation.

    The daily issues actually helped here. I started to tackle our problems, requiring the developers to fix the applications one by one, using a normal user account. It required months just to convince our management that stability was compromised by developers making changes in production, but we were able to change the sa password in all environments and make it different. We then started to require applications to use difference accounts, and a year later, we had ad least provided more stability by removing the “quick fixes” made in production.

    All sorts of poor practices at that job, and when I left after almost two years, there were still numerous issues.

  • Database Maintenance Essentials – Resources

    I told people in New York at SQL in the City that I’d post some resources on the blog from my talk. My apologies for not getting it done over the weekend, but during a little downtime in Austin I’m getting it done.

    Checklist

    From the last slide, a checklist of things for you to look at on your instances.

      • Backups scheduled on all database (full and log)
      • DBCC CHECKDB running regularly on all databases
      • Test restores scheduled
      • Manage mdf/ndf/ldf file sizes
      • Proactively monitor and maintain indexes and statistics
      • Monitor jobs and set up alerts

    Challenge

    At work, someday soon, but in the next 30 days, go through the checklist on your important servers, or all your production servers, and assess your maintenance.

    Resources

    From the slide deck, which will come soon in email. These are a list of links and resources from the talk.

     

  • SQL in the City

    Photo Sep 27, 4 11 59 PM

    That’s where we were on Friday. 780 Third Avenue, in the middle of Manhattan. The start of our 2012 US SQL in the City tour.

    I arrived Thursday, getting into the city in time to go running in Central Park. A solo #sqlrun, but one I enjoyed on a beautiful fall afternoon in the city. Then it was a short walk to rehearse a few things for the event.

    Photo Sep 27, 4 14 25 PM

    Coming out of the elevator, I could see a bunch of new swag on the book shelf. Water bottles? Very cool. I snagged one for my daughter, and she loved it.

    Photo Sep 27, 4 14 33 PM

    A nice setup, lots of demo booths, all ready for people to arrive.

    Photo Sep 27, 4 14 36 PM

    Plenty of coffee cups, sugar, etc. ready to be stocked

    Photo Sep 27, 4 14 45 PM

    And a big banner in our library. There was a set of almost every book we’ve published over the last couple years, and it’s quite a list of books. We have most of these available as free ebooks on SQLServerCentral, so check them out.

    Photo Sep 28, 5 52 53 AM

    Rehearsals went fine in the main room. I think everyone checked out their laptop on the projector. Since I walk, I took a few minutes to see how the projector would affect me. It was right in my line of sight, but I mentally prepared myself to cross over it a few times.

    Photo Sep 27, 4 16 19 PM

    Then it was off to dinner and an early bedtime. Friday morning I was up at 6:15 for a run. As I came downstairs, I noticed Grant had already run, and checked out his route. Not the one I was planning on.

    grantrun

    The streets were wet, and I almost went back inside, but decided not to. I ended up having a nice run as the sun came up on the city. Lots of people out in the early morning, which is strange for someone that lives in the middle of nowhere. Even in most cities I visit, there aren’t that many people running at 6:30am.

    steverun

    As you can see, my run was more organized. I cleaned up and headed to the venue, arriving just before the rain came down.

    Photo Sep 28, 6 14 51 AM

    We had banners outside, but had to bring them in. Fortunately I had my hat to keep dry. People wandered in and filled up the main room. Simon Galbraith, one of the joint CEOs at Red Gate, gave a nice keynote, talking about the challenges we face as an industry and how Red Gate is working to better serve our customers. Not only are we trying to build great products at value prices, but we are also putting on events like this, working with the community to educate users. We even support Open Source, funding the Glimpse project.

    Photo Sep 28, 7 12 23 AM

    I had the first two sessions, talking about essential database maintenance and preparation for disaster. Lots of developers and accidental DBAs in the crowd and while I didn’t have many questions in the session, I did get some in the hallways later.

    I watched a bit of other sessions, but mostly ended up chatting with different people throughout the day. It’s great to meet people at events, and the diversity and variety of people I meet in New York is amazing.

    We had a great time, though I ducked out just before the closing ceremony, prizes, and drinks. With a busy tour, I wanted to get to the airport and get home Friday night. I made it, though it was a challenge. Huge thanks to United for outstanding customer service in moving my flight arrangements.

    A great start to the tour, and I’m looking forward to Austin today.