Category: Blog

  • Everki Versa Long Term Review

    A couple years I was looking for a new laptop bag. I settled on the Everki Versa, which I’ve been using on my travels for 2015/2016. It’s been quite a few, which you can see on my speaking CV.

    I decided to write a long term review of the bag, since a friend was recently looking at the eBags Pro laptop bag. I have to admit, that one looks good, but I wanted to stop and evaluate what I thought of mine.

    Warning: lots of pix, and a little long.

    Tl;dr: I like the bag, and love the sunglasses case.

    The Front

    Here’s my bag. It’s got a souvenir mini-bat next to it for scale. I got that from SQL Saturday 403 in Louisville.

    Photo Aug 23, 12 28 26 PM

    When you look at it, there’s a small front pocket (on top here) that doesn’t have a closure. However, it has a magnetic catch, so it’s useful for putting stuff in and it won’t fall out. Here’s what I put in it.

    Photo Aug 23, 12 28 54 PM

    I keep a small Redgate notebook and pen, and will stuff boarding passes in there. I also drop my phone in here when I’m going through airport security. The magnet is strong enough to keep stuff in, but not annoying when I need it. A view of my stuff back in.

    Photo Aug 23, 12 29 09 PM

    Behind this is a small zipper pocket. I tend to keep pens, a small screwdriver, and a sharpie in here. My passport also lives in here.

    Photo Aug 23, 12 29 33 PM

    My wallet often goes in here when I travel, since it’s big. There are a few random other items, business cards, misc small stuff goes here. I don’t use this a lot, but I know I’ve got pens and the passport here. Here’s the pocket from the side.

    Photo Aug 23, 12 29 20 PM

    Next, there’s a small zipper pocket on top. If you look at the first picture, it’s the zipper at the top of the picture. I drop quick things here, like my keys when I travel and my car ticket.

    Photo Aug 23, 12 31 28 PM (1)

    This is a small pocket, so I also can drop headphones in, but I keep this stuff in there. Extra lip balm, change, headphone earpieces, gum, and a small flashdrive. Easy to get to.

    Photo Aug 23, 12 32 09 PM

    Side Pockets

    There are two side pockets. One is supposed to be for a water bottle, but it’s small. If I had one annoyance, it’s that there isn’t a decent water bottle pocket.

    Photo Aug 23, 12 30 17 PM

    This is a 24oz bottle, small compared to the ones I usually carry and refill, but none of those will fit here. There is a loop to keep this from falling out. There’s also a small mesh pocket in here where I have a travel LED flashlight.

    That is the left side (when I’m carrying). The right side is more important to me and has a few things inside.

    Photo Aug 23, 12 30 35 PM

    This is my tech power pocket. In here I have these things:

    Photo Aug 23, 12 30 57 PM

    Two batteries, two cords, and US wall and car adapters. This lets me get to these things quickly on the go.

    Inside

    The main pocket for me is the center one. Here it is open, and you can see there’s a few things. There is a little divider, but I often find myself pushing it down when I shove stuff in. Not super useful, but if has a few pockets where I can organize.

    Photo Aug 23, 12 35 55 PM

    I love the orange. It really makes things easier to find. I’m not sure I’d get a bag without the orange inside (unless is were hot pink or neon yellow).

    What’s inside?

    Photo Aug 23, 12 36 42 PM

    Here’s what’s inside. At the bottom of the picture, I have two pencil bags that my kids no longer use. These are handy for keeping things. One is a presenter bag with video adapters, presenter remote, an SSD for VMs, and wireless HDMI. The other has misc stuff, like microUSB power, a couple batteries, watch charger, misc cords, and a few other things I’ve picked up. I carry a 3ft HDMI cable, my power adapter, a spare set of earbuds, a 3 outlet power plug (with USB), a worldwide power adapter, batteries, a mouse, and a deck of playing cards (thanks to Ike Ellis).

    In the mesh zipper pocket above, I have 3 zip loc bags. One has spare US currency, one has spare Europe currency, and one has a few meds (aspirin, allergy stuff, Nyquil). This is where things go in and out all the time.

    There also is a laptop pocket in the back. This is against my back, but is nicely padded. You can see my leather tablet case and a scarf in here.

    Photo Aug 23, 12 39 00 PM

    What’s nice is this opens wide. I’ve only done this a couple times for airport security since many of them still want my laptop out. So, I just pull it.

    Photo Aug 23, 12 37 54 PM

    My laptop is about Surface Pro sized, and the leather case holds a mini keyboard inside the pocket. It can hold the Z Canvas keyboard on the tablet.

    Photo Aug 23, 12 38 31 PM

    There’s a separate pocket to the inside of this pocket. My scarf, hat, and gloves live here, since I’ve forgotten those items on trips and it’s a pain to go buy new ones. Here’s the tablet/laptop.

    Photo Aug 23, 12 38 18 PM

    I used to carry a 13” laptop in here fine.

    The Back

    There are two straps on this one, but more importantly, a pass through for a roller bag handle.

    Photo Aug 23, 12 39 16 PM

    This is required for me. I’m often just dealing with carry on luggage and want my bags secured together. Slipping a handle through here works well. However, I can get the straps in. They quickly unclip.

    Photo Aug 23, 12 39 22 PM

    I’ve only stuffed them through a few times. It’s not overly helpful, but it has been nice on some small planes to secure them when the bag is under a seat.

    Photo Aug 23, 12 40 01 PM

    The Hard Case

    The other day I was heading to San Antonio and forgot my prescription glasses case. I couldn’t find it. So, I grabbed my glasses and dumped them in here:

    Photo Aug 23, 12 33 35 PM

    This is my favorite feature. This is a small zipper pocket on top of the backpack that has a hard formed shell. You can see it from the inside pocket here. It’s the ribbed case, and it’s hard, like a hard case shell. No changing shape here. Perfect for glasses.

    Photo Aug 23, 12 34 18 PM

    That’s what I put in there. Here’s the contents:

    Photo Aug 23, 12 35 12 PM

    I carry driving sunglasses and a super cheap pair to run in. My spare earbugs go in, and usually crackers or a protein bar in case I need it. I’ve added my other glasses at times, and I don’t worry about them getting broken, or more likely, bent. Having that hard case is excellent.

    The Traveling Bag

    How has this worked while I’ve had it? It’s been one of the best bags I’ve had. It’s not too heavy (though not light), and carries lots of stuff. It’s easy to fit in overheads, and I haven’t run into a plane that it doesn’t get overhead or under the seats, even small, 30-50 person jets.

    I can’t really see any wear and tear, though from my list I see I’ve had about 50 trips with it. Nothing has broken. Zippers work great. The top handles are solid (there are two), and I’m pleased with the performance.

    I also say that I’ve gotten better at ensuring that I pack consistently. Power is always in the right pocket, water in the left. Keys in the small top, glasses above that.

    This was the most expensive laptop bag I’ve owner, but it’s lasted much longer than a few others I’ve had and seems very durable. I’m pleased.

  • PoSh on Ubuntu

    I heard about the PowerShell announcement recently where the platform is porting over to Linux and OSX. I think this is part of the SQL Server on Linux project, where I assume we’ll start to see the functionality that we have on Windows appear on Linux platforms. OSX is a surprise, but since more and more people run Macs, this makes sense. Hopefully we’ll see SQL Server Developer on OSX at some point.

    I’ve got an Ubuntu VM, so I decided to see how well this works, so I picked the Ubuntu 16.04 package and found the instructions I ran on my VM. You can see how this worked in the image below.

    2016-08-18 12_37_14-Ubuntu 64-bit SQL Server - VMware Workstation

    Now that I’ve got the package downloaded, I can start PowerShell pretty simply:

    2016-08-18 12_38_51-Ubuntu 64-bit SQL Server - VMware Workstation

    What can I do? Well, let me grab a short PoSh script I have. This is from the Advent of Code, and it’s a .ps1 for me. Here it is interactively.

    2016-08-18 12_49_53-Ubuntu 64-bit SQL Server - VMware Workstation

    If I make a .PS1, then I can paste in the original code:

    2016-08-18 12_51_09-Ubuntu 64-bit SQL Server - VMware Workstation

    and if I execute this:

    2016-08-19 11_07_01-Ubuntu 64-bit SQL Server - VMware Workstation

    That’s pretty cool.

    I haven’t explorer the extent of the PoSh support, and I don’t think there is SQL Server support yet for the SMO namespaces, but I’m sure it’s coming.

    If you’re a Linux person, or an OSX person, I’d encourage you to play a bit and see what you think of the port.

  • Rounding Challenges–#SQLNewBlogger

    Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

    Rounding is an interesting activity, and one that I think people sometimes don’t pay enough attention to. Recently I saw a problem that intrigued me and I spent a few minutes looking at the issues.

    Let’s suppose you have data like this for pricing.

    0.3

    0.7

    1.2

    1.6

    How would you round this data? If you use a simple ROUND(n,0) function, you get this:

    0.0

    1.0

    1.2

    2.0

    Now, that’s fine, but what if you want this:

    0.3

    1.0

    1.2

    2.0

    That’s a bit more challenging. I’ll leave the solution out, but note that if I ROUND(n, 1), I get this.

    0.3

    0.7

    1.2

    1.6

    That’s not quite right either. ROUND() is using the number of decimals I’ve given it, but in some cases, I might want to round up. In this case, I only round up when we’re at .5 or higher, but don’t round down. In those cases, I need to limit rounding. This could be done in a WHERE clause, or with a function (be really careful of scalar functions).

    The important part is knowing that I really want this:

    ROUND(0.3, 1)

    ROUND(0.7, 0)

    ROUND(1.2, 1)

    ROUND(1.6, 0)

    How I get these is up to me, and there are a few ways, but really I want to be sure that I understand how ROUND() works and then apply it appropriately for my situation.

    SQLNewBlogger

    This is a quick one, literally about 6 minutes to write. About a minute of that was playing with formatting. Understanding functions, and knowing how they affect data is important to show your knowledge.

    Also, make sure that you know how to solve something like this if you write about it. I’d encourage you to write the solution as well as remember it. Someone might ask you in an interview Winking smile

  • Remember the Alamo (with a SQL Saturday nearby)

    This past weekend was the first SQL Saturday in San Antonio, TX. I was lucky enough to get the chance to go, and I was happy to do so. I like to support new events in new cities, and hopefully I can help keep them going in the future.

    I went a day early. Traveling Friday during the day would have eaten up most of my day, so I got a late flight down Thursday night and spent Friday learning about SSIS from Tim Mitchell, as well as getting a little work done here and there.

    Photo Aug 13, 1 19 02 PM

    The facility for the SQL Saturday was Texas A&M University – San Antonio. It’s a small, but beautiful school. The entrance to the campus is above. Below, the doors greeted me as I walked up, opening automatically.

    Photo Aug 12, 4 12 01 PM

    Friday night the speakers had a nice dinner, with live entertainment.

    Photo Aug 12, 6 15 24 PM

    And we each received a cowboy hat to wear. Some fit better than others.

    Photo Aug 12, 6 27 17 PM

    As much as I’d like SQL Saturdays to be cost-conscious and slimmer, I am not complaining if organizers decide to do more. I just don’t want anyone that puts on a SQL Saturday to think that myself or other speakers won’t come. We will.

    In fact, we had a nice discussion about this at our dinner. We don’t volunteer and teach for food or gifts. We do it because we enjoy it.

    Anyway, the event was fun. There were over 300 registrations and I think there were 200+ people out for a day of learning. I delivered my Branding Yourself for a Dream Job talk to a full room. I heard a couple people say they didn’t come in because there weren’t chairs.

    Photo Aug 13, 11 56 40 AM

    Please, always come in. Unless the Fire Marshall stops you, I have no issue with you standing in the room, sitting on the floor, or finding a space anywhere.

    I had some nice chats with people, which is one of the reasons I like these events. I attended a fun talk from Chris Hyde on R, which was a good way to open the day. I also saw Tim Costello do a fantastic Agile Data Warehouse talk, including the live affixing of post-it notes to the projector screen to demonstrate how to analyze your requirements. Go see Tim if you can. He does a good job and has a lot to teach.

    Photo Aug 13, 12 33 50 PM

    I did leave a touch early, since I hadn’t had a chance to go by the Alamo and know almost nothing of Texas History. I wandered over, too late for a tour, but I had the chance to see the compound and the beautiful gardens, as well as learn a bit about the siege, battle, and how Texas was formed.

    Photo Aug 13, 2 27 49 PM

    It was interesting, and if you get an hour when you’re in San Antonio, go by.

    Photo Aug 13, 2 31 01 PM

    I hear the tour is really good, and hopefully I’ll get back someday and get the chance to experience it.

    Photo Aug 13, 2 32 07 PM

    The after party was fun, though I saw relatively few attendees there. I think fewer people come when there isn’t a place near the venue, but I enjoyed myself before getting to the hotel and ready for an early flight.

    A good couple days in San Antonio, but back to work today. Sporting my hat.

    Photo Aug 15, 8 16 07 AM