Tag: syndicated

  • 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.

  • Customizing SSMS – Bigger Queries

    This is a short series on some customizations in SSMS to make it visually more appealing.

    As a presenter, I’ve learned how to change the way Management Studio (SSMS) looks to make it easier for people to see the screen on a projector. I had wrongly assumed that so many people knew many of these tricks, which is a poor attitude on my part. That should be especially apparent as I saw a presentation recently where the speaker didn’t know how to make things easier to see.

    Here’s another item I saw someone struggle with recently, the query font size.

    The Default View

    When you install SSMS, this is what you often get, and how your queries look:

    ssms_f

    Not easy to read, especially for these old eyes. When someone uses the default settings in SSMS and presents on a big screen, I am usually struggling to see, sometimes even when I sit in the front row.

    Customizing

    You can make SSMS easier to read for yourself in a couple ways. The first is the quickest, but it’s a change for only the current SSMS execution. If you close and re-launch it, things will return back to the previous settings.

    If you look below the query and above the results, there’s a drop down that says 100% in it.

    ssms_g

    If you click that, you’ll get a drop down of some percentages you can choose.

    ssms_h

    These percentages will change the size of the query pane. For example, if I choose 200%, you can see things are much easier to read. The query pane is much better than the results. This is great for quick changes when you are presenting.

    ssms_i

    For permanent changes, this is what I quickly do. Go to the Tools menu at the top of SSMS and select Options. You will get this dialog:

    Capture_002

    I’ve selected “Fonts and Colors” from the left already, but once you do that, there’s a “Size” drop down on the right. Choose that.

    Capture_003

    I usually set that to 14 and it looks good for me. A balance of large size, but still being able to get lots of code on the screen.

    Capture_004

    This make it easier to read your code. In another post I’ll talk about results.