Tag: syndicated

  • The Great Laptop Search of 2013

    It’s time for a new laptop. I don’t think it’s time, as I love the Macbook Air I bought a couple years ago. Rather some requirements for work, mainly Hyper-V, have come up and I can’t meet them with the Macbook Air. Even a 2013 summer refresh of this platform likely won’t get me what I need and I’m back to Wintel. I have a sad face, but since my daughter will likely inherit the Air, she’s smiling ear to ear.

    However that means I have work to do. Grant Fritchey went with a Lenovo W530, just getting a powerful machine. I had that form factor with a W510, and I had issues with the suspend/hibernate. However I also didn’t love the size of the machine. It was heavy and cumbersome and as much as I travel, I’d prefer something lighter.

    Ultrabooks are tempting, though I seem to only find them with 8GB of ram. The bare minimum I need. The IT group as Red Gate told me that I needed:

    • Windows 8 or Win 2012 for the Hyper-V images
    • Core i7
    • 8GB of RAM at a minimum, being prepared to give 6GB to our complex VM system.
    • 100GB of disk space
    • SSD preferred.

    That doesn’t’ give me a lot of choices in the sub 4lb range, 13” display range.

    If I was going to get a new laptop, a touch screen with Windows 8 is something that came to mind first. With that in mind, I started looking at the Lenovo X series, since I’ve had a few friends that liked those models. The X1 Carbon Touch got my first look. It’s a nice looking machine, but I’ve seen a number of complaints from people about order fulfillment for this model. That concerns me, since I would guess some of these issues are problems with the hardware. A few people I know have gotten the W530 in the same timeframes and there haven’t been issues. Besides, this machine tops out at 8GB, which is the base minimum I need.

    There were a few other machines I looked at, all in the touch screen, convertible form factor, which were interesting, but unfortunately these topped out at 8GB. That’s plenty for an ultra book or convertible that runs one operating system, even a couple virtual machines. However I don’t have control over my demo image, which others have noted really needs 6GB to run smoothly. The list I considered and rejected was:

    I suspect 8GB could work, but I don’t want to be limited if it doesn’t. We have a complex set of VMs to work with, and I think I need more RAM to be safe. After my post on the Surface Pro last week, I had a few other recommendations.

    I decided to examine each of those over the weekend and make a decision.

    I first looked at the ASUS. I’ve seen a few developers that liked this model, and it looks interesting. I can upgrade it to 10GB, which gives me a little breathing room. It’s small and thin, lightweight, and looks good. However I decided to skip this because the 10GB makes me only slightly less nervous than 8GB. I decided to check other options.

    The Toshiba is a nice machine. I used to have a 15" Qosmio, and I liked the machine. I ditched it when Toshiba wasn’t very helpful with Windows 7 drivers for my model. My son had it for about 6 months before the motherboard died, but during the 3 years it was my main machine, it worked well. The R930 looks nice, and has most of what I need. Worth considering further.

    The Sony was interesting. I’ve never had a Sony, but I’ve heard good things from people about the laptops. The Duo would have been a choice for me if it held more than 8GB. The S Series is interesting, and it goes up to 12GB of RAM. That’s likely enough for me. The display is 1600×900 and it’s under 4 lbs. It seems to meet all the criteria. A few reviews didn’t love the keyboard, and they mention going to 12GB of RAM means single channel access. I’m not sure how big a deal this is, but it’s one item.

    The Lenovo T-430 meets my criteria as well. A nice 1600×900 screen, 16GB of RAM, and it has the eraser head mouse movement. I have liked that format since IBM introduced it in the 90s. This one is a touch heaver, but it gets good reviews, and it’s a format I’m familiar with. It also has the advantage of the switching out the optical drive for a second SSD. That is what I did in my W510, and it’s what I’d likely do here as well. The T431 looks better, but since it’s not yet out, I can’t consider it.

    In weighing all the options I finally decided to get the Lenovo T431. The Toshiba was close, but I know the Lenovo product and the ultra bay that would let me stick in two drives was appealing. The Sony worries me slightly with 12GB with mismatched memory. Not a lot, but all things being equal, the T431 seems like a good fit for me.

    It’s ordered, and on the way. As soon as it comes, I suspect I’ll be looking for a new laptop bag as well, but we’ll see how this one fits in my existing bag.

    Now to learn a bit more about Hyper-V.

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