Review of The Way

The Way, starring Martin Sheen and directed by Emilio Estevez has been on my want to watch list for a while, kept putting it off because it looked like (and sometimes is) a sad movie. Tom (Martin) gets a call that his son was killed in Europe on the first day of walking the Camino, a popular ‘walk’ destination that can take weeks to months to complete. Tom ends up deciding to do the walk that his son had planned and along the way spreads the ashes of his son. Along the way he meets some interesting people and has an interesting journey, part farewell, part re-invention. That doesn’t really do it justice. Its designed to move you and it does, but in a way that isn’t pushy.

I don’t know that I’ll ever do the entire walk, but it’s something I’d like to go see now that I know about it.

Posted in Misc | Tagged , , | Leave a comment

SQLSaturday Philadelphia, Cocoa Beach, Orlando, and Charleston

I’ll be attending and presenting at SQLSaturday #200 in Philadelphia in June, then I’ll be attending the first ever SQLSaturday in Cocoa Beach in late July, and then I’ll definitely be at SQLSaturday Orlando on September 21st. No plans for April, in May I may drive up to attend SQLSaturday in Jacksonville. August I think will also be an off month. I’ve submitted sessions for SQLSaturday Charleston in October – I’ll be driving up from Orlando on the way to Charlotte for the Summit, we’re planning to stop in Charleston for a couple days to see the sites.

It doesn’t seem like much until I write it down, then I see that I’m staying close to my goal of doing one big event each quarter. Slowing down on the travel has been good.

Posted in SQL Community | Tagged , | Leave a comment

Assorted Links for April 13, 2013

  • Consider adding Troy Hunt to your feed list
  • Great post about the role of staffing firms in your job search and saying no to offers that aren’t good enough
  • VoltDB claims to the be the fastest OLTP database – anyone out there tried it?
  • I don’t want to work at Valve (nothing against them, just don’t want to move), but I think I’d like to work at a company that has their philosophy – read their new employee handbook to see if you would (it’s worth your time to read).
  • If you’re using the Intel HD 4000 integrated graphics there is an updated driver that is supposed to improve performance by 10%.
  • Can’t find a laptop with enough horsepower? Maybe try a Stealth box.
  • Free burritos for a year isn’t a bad deal and dirt cheap marketing!
  • Simple and effective standing desk from steel pipe. Check out the Kee Klamps for a lot of options if you’re going to build one.
  • Seagate to stop production of 7200 RPM laptop drives – SSD’s taking over that market (and with good reason!).
Posted in Misc | Tagged , , , , , | Leave a comment

How Much Power Does Your PC Use?

I can’t say I’ve ever worried too much about how much power my PC uses. I care about battery life on a laptop and like laptops that use a lower wattage transformer because it’s smaller and lighter. Power to servers only mattered as far as “do we have it” and making sure the appropriate 110v/220V outlet was available. For the most part power consumption is a cost of doing business.

I only paid any attention to it recently because I was curious about the efficiency of the Ivy Bridge CPU’s and wanted to compare my brand new I7 workstation with my old machine. Turns out the old machine used 145 watts at idle. The new one? My test meter shows it bouncing between 47 and 52 watts at idle. A nice savings, though as I mentioned in my series of posts about the build I don’t expect it to add up to a lot – but every little bit helps. Note also that sleep mode is less than 1 watt on the new machine.

I then ran across this post on AnandTech about their recent server upgrades and the resulting power savings. It’s impressive. I doubt it justifies a server refresh just based on the power savings, but if you combine that with using fewer U’s of rack space and more processing power, that gets more interesting.

Posted in Hardware | Tagged , , | Leave a comment

Failing to Overreach

I’m not sure what put this phrase in my head, though I think in part it came from various posts by Seth Godin, and it represents something – a doubt maybe – about whether I’m doing enough.

I think of myself as fairly conservative when it comes to taking risks. Others might not agree, but the conservative part comes from me thinking I can do this. If I think I can get there, if I think extra effort will make the difference, then I’m in. It doesn’t seem like a huge risk when I decide to do it.

It’s hard to assess fairly. Risks, at least the ones that turn out ok, look smaller in hindsight. There’s also a difference between being out of the comfort zone and real risk, though emotionally they feel very similar.

I don’t know that I want to take risk for the sake of risk, or get out of my comfort zone (which is larger than it used to be) just because, but I am thinking that maybe there is another 10% or 20% edge to the envelope that I could push. Not sure how to get there. Not intuitive to take a risk that you don’t think will work. Maybe it’s a re-calibration, thinking that since I’m mostly succeeding on the risks I take that I can adjust the dial the next time I’m making a decision.

I’m not sure what that will look like yet. I think right now it’s the mental preparation for the next time I need to make one of those risk decisions.

Posted in Misc | Tagged , , , | Leave a comment

Mo-SQL On A Stick

If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed to – depending on your view or the product I suppose – make databases simpler, break out of the transaction database paradigm, scale out across hundreds of machines, make it easy to change the db design (or not require one). I think some of the problems no-sql tries to solve are real, others reflect a lack of awareness/training/tools on how and why relational databases could not just solve the problem, but solve it better.

It’s hard enough at times to explain the differences in features and costs between SQL Server and Oracle (and MySQL and Access, etc, etc), but now we have to explain paradigms to people that really don’t care – they want fast or cheap, and they want to focus on the UI, the part that people see,that they pay for.

Months ago I decided the answer was what it often is when it comes to software,a combination of abstraction with incremental improvements in the state of database technology (standing on the backs of, if not giants, at least of programmers). The result will go live later this week, but I wanted to give you a sneak peak. Dubbed Mo-SQL, it has a feature set that you won’t believe! Let’s take a look:

  • It’s both fully relational and not. You can have rich tables with constraints, or you can toss out the constraints with a simple create table [name] as any syntax (aka a poor table). Rich tables are fully logged, poor tables are not (they can’t afford the overhead).
  • Backup is done by a simple copy/paste of the database, restores are done the same way. If you need point in time restore ability (remember that few seem to think they need this) you just set up a job to backup the database more frequently.
  • As you might have guessed from the title of the post, it will run from a USB stick – not earth shaking, but it solves the configuration issue nicely. It also makes locking up the data at night easy, just put the USB stick in a lockbox (ditto for off site backups).
  • All versions of structured query languages are supported, no more learning a new variation, just use the one you know. That same feature also fixes the need for query optimization – any query that is estimated to take more than 5 seconds is paused while turbo mode is engaged to optimize the data – not the query. It’s a major change under the hood, but I think you can see where it makes sense – why should a query be slower because of how the data is organized or the volume? Big data? Bad data? No problem!
  • I almost forgot the best part, scale out. No complex config here. Just run the optimized USB cables (same idea as premium HDMI cables, the wires are super good quality) from machine to machine, no IP hassles, no firewalls. Need a mesh topology? Just add a USB hub to the mix (and hubs can host hubs, etc).

Will it succeed commercially? I think it depends on the commercial. It’s going to be hard to convince working DBA’s that a game changer like this can really work, and I think probably the same for the No-SQL’ers, but I think that will change as more and more teams have the SQL/No-SQL conversation. Eventually someone will get tired of the back and forth and put the Mo-SQL option on the table, which should lead everyone to smile, especially if the meeting is on April 1st!.

Posted in SQL Community | Tagged | 2 Comments

Office Space–Not The Movie

I’ve worked in a lot of different offices and office layouts over the years. Looking back I’ve been lucky (or not as you prefer) to not spend much time in a cube, almost always having my own workspace or sharing it with one other person. I’ve helped assemble furniture, move computers, and run cables from my own classroom for teaching SQL to big call centers.

Some of that work was done on the cheap. Sometimes IT did it all. Sometimes we boxed it up, movers moved it, then we unboxed it. Sometimes the furniture people did the cube and desk building, sometimes we did it. Mostly someone else figured out the where of the building and the general layout, then we helped with the details.

Most of the offices I’ve worked in have been ordinary. Not bad, not great, just ordinary, more defined by the work or the pace or the people than by the environment.

I was thinking about all of that recently, thinking of how I’ve changed over the years. One part of that is that my own style has changed. Ten years ago I spent most of my day in my office doing my work,leaving for the occasional meeting and for lunch. It was work space,refuge, and maybe a little bit prison cell. There was nothing unusual about that pattern then or now, it’s helpful to have your own space and helpful for people to be able to find you. It’s also rare – maybe less so now than years ago – to have other locations where you can work in the building without booking meeting space.

Working solo changed me. I’ve learned to vary where I work, even if it means moving from home office to dining room, or from back office to classroom. Different chair, different view, different noise all help me at times to focus or refocus. It doesn’t seem like moving should make a difference, but it does. Coding and detail work I want no distractions. Writing is better when there is coffee, music, background noise. Calls require quiet and room to pace while talking. Unless I’m truly immersed in something for the day I almost have to get up and move, take the laptop to a different location even if only for a half an hour.

The other part is I think for the first time I’ve been working in office space that is ordinary in most ways, yet not. The cubes and desks are all routine. What’s different is the informal meeting spaces and quiet thinking chairs where you can just grab a chair if its open (and there is almost always one). Combined with a “real” cafeteria downstairs that has the same wifi coverage as the floor I usually work on and I have a range of options for getting out of the office without leaving the office. That does sometimes make it harder for people to find me(good at times, bad at others) but I’m not that hard it to find via phone or email or IM.

I think it’s the first time I’ve been in a a professionally designed space. Lots of little touches that elevate normal. It was also the first time I had seen a completely hands off move – you put your knick knacks in a box, the movers did all the rest. I’m sold on both, at least as long as I’m not paying the bill and maybe even then. It was interesting to watch everyone explore the new space. Big enough you could get turned around and that some hand written arrow signs were needed the first few days, people soon adjusted and life was back to normal in a matter of weeks.

No office or work space is perfect. The list of things I want or prefer varies based on a lot of things, but here is a start:

  • Natural light. I truly dislike being in an office that doesn’t have a window or is close to a window.
  • Good (emphasis on good!) cafeteria on site, within a couple minute walk, OR a nice set of restaurants close by. I worked with one client that had neither, was not fun – I like to have the option to take a lunch break.
  • I prefer a parking lot over a garage. Covered parking is nice, but when returning from lunch it’s a pain to scroll upward hoping to find a space – by comparison it’s a breeze to scan a parking lot for a vacant spot.
  • Well maintained, but not over zealous about tape and pins on the wall. I’ve had the range of this, and it’s not fun – though it sometimes pays well – to work in old beat up facilities.
  • Free coffee. Or a good coffee place close by. Why make everyone bring their own coffee maker?
  • Ice machine too. Life is too short to want ice to find out that some other knucklehead used the last ice in the tray and didn’t fill it.
  • Wifi everywhere. I only connect a cable if I need to move a large file from/to my laptop, which means almost never. I don’t want to carry a cable and hunt for jacks.

I won’t always have the option to make job or client choices based on the office space, but it’s something I pay more attention to now. I’m a lot more likely to take work where the environment is comfortable and supporting. It’s never the only factor – money, commute time, work all matter, but I don’t think I thought about the environment at all ten years ago. Now I do.

Posted in Misc | Tagged , | Leave a comment

We Need a Place for SQLFamily News

I’m writing this because I was thinking about a member of the local PASS chapter on the way home last night, a friend who lost his spouse to illness after a long and happy marriage. I had known about her illness, but only knew that she died because he chose to write something on his blog. I saw the post and forwarded it on to some of the other members that knew him so that we could offer thoughts and support during a tough time.

That had me thinking, what if I had not seen the post? I read a few blogs, check in on Twitter when I can, but I could easily miss news like this, and that would bother me.

It has me wishing for a place where we can post SQLFamily news. Marriages, birth of children, deaths, maybe even birthdays and promotions and personal successes like passing an exam. It might also be a channel that we could use to gather support if someone we know needs help. No ads, no commercials, just stuff about us.

I’d like it to be low noise,something I can scan easily and can go scan backwards if I’ve fallen behind on reading. I’d like to be respectful of privacy – only publish things that people are ok with sharing,or maybe that they share directly via that channel. That means some amount of curating or moderating I think.

I don’t have a grand vision beyond that, or even a preference yet on how to do it. Maybe it’s something PASS could help with, maybe it’s something we should just do – if we in the SQLFamily think it’s a good idea. I hope you’ll comment on the idea, or blog about it, or discuss it on Twitter, is there something here that is worth doing and doable?

Posted in Misc | Tagged | 3 Comments

Speaking Tomorrow Night at MagicPASS

I’ll be driving south a few miles tomorrow night to talk to the great group at MagicPASS about the basics of statistics in SQL Server – what they are, how they can help (or hurt) performance, and how to maintain them. I’m looking forward to it, hope to see you there!

Posted in SQL Community | Tagged , | Leave a comment

Learning By Doing

I was recently talking with a friend about doing some research into a NAS solution for home and that I was trying FreeNAS out in a VM. He asked…why? Why not just buy one? He had one, a model I knew about, and said it was solid storage if maybe not the greatest at media streaming. So why would I consider building? To save money?

My answer was just to learn. I see something or run into a problem or  read a blog post about a solution and my interest is engaged. For this instance it was a combination of things; my router at home supports attached storage but it’s not redundant, I wanted something that would do iSCSI for when I want to mimic availability scenarios, and I was wanting to – finally – move some of the CD collection to disk and stream it around the house.

I started by reading about NAS. Lots of consumer/prosumer devices out there and you start to get an idea of various capabilities and price points. One that I liked from Synology has four drive bays and is $500 without the drives. What am I buying for $500? And given that it will run various plug-ins to extend it, what am I gaining or losing by not running a full ‘home server’ type scenario?

I’ll do more writing on the decision results I a later post, but what happened here is that I’m reading about NAS thinking to buy one, even at $500+, and then I run across FreeNAS. Free to try, free to use, why not load it into a VM just to see? Then I get into it and see that it uses ZFS and has some interesting RAID options. I mention this to my friend and he scoffs – who would use software raid?

It’s funny, I agree with him. I’ve used hardware RAID since I’ve been an IT guy,no one uses Windows software RAID (right or wrong). So now I’m challenging my own assumptions. As I write this I’ve been watching some video on ZFS and it’s interesting. It’s designed to make storage easy to use,and it’s designed to be robust – robust in a database robust kind of way, checksums everywhere to insure good data. I don’t know that I’m a convert to software raid yet, but ultimately it is software even if on a card. We’ll see!

I’m not done exploring FreeNAS or ZFS. I may look at OpenFiler, a product similar to FreeNAS. Maybe I’ll look at Storage Server, maybe not. I’m not – yet anyway – intending to  master the world of NAS or file systems or home servers, I’m just learning, following my interests in a way that makes the learning if not effortless at least pleasant.

It’s hard to know what I’ll learn that will matter in the long run. Or if I will do all this and still buy one off the shelf. It’s not the kind of research thing I can or want to do every time (well, maybe I would if time allowed), but I know that it has value and is worth the investment, I just can’t prove it before I do the learning.

Leave some time in your professional development schedule for some random learning. Install Oracle. Code something in F# or Ruby. Build a Linux server. Try Virtual Box instead of VMWare. You might be surprised of the value of a few hour investment.

Posted in Misc | Tagged , , , , | 1 Comment