Author: way0utwest

  • The Jarvis–Standing Desk Update

    I started using a standing desk a few years back. While visiting the Redgate Software office, I saw one of my coworkers standing and using boxes of books to lift their keyboard and mouse. I tried that.

    My first desk from 2012.

    It worked OK, and I found myself adding and removing books to experiment with the process. I first moved upstairs, swapping the desk in the basement for the one upstairs. I added flooring to make things easier on my legs.

    Things were fine for a few years, and then last year, I upgraded the platform to a piece of furniture. This was really to give me stability, a place for coffee ( probably the most important) and just a bit more space. That worked OK.

    Photo Aug 24, 10 43 42 AM

    However I’ve found myself getting a bit worn out at times. I often work most of the day standing, and there are certainly days my knees or back will ache. I do switch over and sit at the kitchen counter, or on a couch with my laptop, but those aren’t ideal. What I’d really like is a desk that’s a desk. I could also use space for my laptop, as I’ll use two machines at times.

    With that in mind, I started looking at motorized desks. I saw Tim Mitchell get one for his home office, and found someone that rated desks. The Jarvis was well rated, and it wasn’t too expensive. An IKEA desk is around $500, so this wasn’t much more.

    Fortunately I work for a company that values employees, and they do allow for some work related infrastructure. Redgate agreed to buy my desk, and I ordered it immediately. Of course, it wouldn’t ship and arrive until I was gone, but I came home to find boxes in my office. I began unpacking and assembling.

    Well, actually I started clearing a space in the office. I needed room to assemble, while I continued to work during the couple days I put things together.

    Photo Jan 26, 1 35 01 PM

    I’m somewhat handy, but this assembly was easy. There are feet (to the right and left) and then two legs (middle) with a brace (top middle) that connect together. Lots of Allen screws, but no real tools needed.

    Photo Jan 26, 2 01 17 PM

    I got the bamboo top you see above, with grommets in it for wires. I wasn’t sure about the grommets, and haven’t used them a lot, but they are nice for a few things.

    Photo Jan 26, 2 30 27 PM

    Getting things together felt good, and once I installed the lift, I was ready to try things.

    Photo Feb 25, 11 29 56 AM

    Unfortunately, one of my legs didn’t work. The desk lowered, but wouldn’t reset or go back up. A quick call to Ergo Depot got me support, a few things to try, and then a replacement shipped the next day. Once again, I left town, not having a desk to use.

    However the leg arrived and was ready for me when I returned. I managed to swap out the leg with minimal hassles, and without taking everything apart. Once back together, the lift mechanism worked great. I started moving things over and getting setup late one night.

    Photo Feb 06, 6 57 40 PM

    I really just duplicated my existing setup, with the exception that I’d ordered a CPU holder to store and lift my desktop with the desk itself. It’s below the desk to the left.

    Here we have the current setup, raised:

    Photo Feb 25, 11 23 30 AM

    and lowered:

    Photo Feb 25, 11 24 11 AM

    I did find that I wanted my monitors offset to the right, which took a few days to determine. I’ve moved the monitors up and down a bit, trying to find a good height relative to the desk.

    I’m also still torn on whether I want the keyboard at desk height. I can change the height, and I use a few different settings, but I think I may get a keyboard tray that lets me lower the keyboard slightly and also get more desk space to use.

    I’ve moved over my mat, which is a bit of a pain when I switch back to the chair. I still have to work out some sort of process to make this easier.

    However overall I like the setup. I usually raise the desk if I check things at night, and start the next day standing. If I have webinars or calls, I often lower the desk and sit, and usually after lunch (often yoga or running), I’ll eat at my desk and lower it for the afternoon.

    I think I’ve benefitted from not sitting for long periods of time, and plenty of people see my at events, where I often avoid sitting, even in sessions. However I also know I need a balance, and a motorized, standing desk has helped me feel better.

    If you can afford it, I’d urge you to get one. However I’d suggest you start with boxes of books, and see what works for you.

  • A Good Use for Hadoop

    Netflix is an amazing company. I’ve been a customer for over a decade, starting with the well known red envelopes that moved DVDs through the mail. Since then I’ve continued to subscribe as a streaming company and have enjoyed quite a few of their original programming efforts.

    However I’ve also been fascinated by the way in which Netflix has made use of technology to grow a unique kind of company. They own very little, having used Amazon’s AWS to host their infrastructure and mostly serve content they acquire from contracts with various media companies. They are famous for their Chaos Monkey approach, having machines randomly fail to test the fault tolerance of their entire infrastructure. I read recently about the closing of their last, small data center, so outside of employees’ laptops, they keep all systems in the cloud.

    However I ran across a post on the scale of their data flow, and it’s amazing. Apparently their events are generating 1.6PB a day of data. That’s incredible, and a scale at which very, very few of us will ever work. Personally, I think that’s interesting, but I’d prefer not to be working on a PB of changing data a day, but I might feel differently if I worked at a company like Netflix that has obviously been successful with dealing with data at that scale.

    The post notes that they put this data into Hadoop, where it can then be queried. I’ve often wondered what the domains are for using Hadoop. Most of the people I know that have tried it aren’t really working at large scales. I think that a well built ETL process would allow their data to easily work in a SQL Server data warehouse, and possibly even the Azure SQL Data Warehouse. However at 1.6PM a day, Hadoop seems like a much better choice.

    I’m curious how often that data is queried. Is most of that 1.6PB actually used in reporting, or is much of it lost in the shuffle and ignore? Is there a process to aggregate some of this raw data and then delete the older values? Can 1.6PBx365 actually be useful in analyzing your business? I’m sure some is, but wouldn’t a lot of those events lose their value over time?

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 3.7MB) podcast or subscribe to the feed at iTunes and LibSyn.

  • Grabbing Fitbit Data

    Recently the T-SQL Tuesday topic was Power BI. A cool topic, and an interesting application.

    I saw Rob Farley build a dashboard based on his Fitbit data. That was intriguing, so I went to get my data. I’ve worn a Fitbit for a couple years, recently having lost it. However, when I went to export my data from Fitbit, I found this.

    2016-02-17 10_46_02-Fitbit Data Raw Export

    Notice two things. One is the top announcement that my data belongs to me. Then notice the bottom left note that I can get 31 days of data.

    Jerks, but feel free to substitute another word yourself.

    Then I found this Fitbit Data Export site. I connected and ran this, which grabbed my data. I appreciate there’s a Github link with the source code, though I have no idea of what’s in Github corresponds to what’s running in Azure. After reading The God’s Eye View, it’s a little nerve wracking to use a service to connect somewhere that I have data stored, but Fitbit exposes some of this publically anyways, and besides, it’s not critical data for me.

    In any case, I had a CSV of my data, which I am now going to upload into Power BI and play with it. Adding a CSV is straightforward.

  • SQL Server 2016: The Data Protection Version

    I’ve spent a few years working with SQL Server encryption and security, trying to educate people on the various capabilities involved. There are some nice features available in the platform that can help you run a more secure SQL Server, but there has been a lot of room for improvement across the last few versions. The openness of the platform is somewhat tempered by the need for each of us to write a fair amount of code to properly secure our databases. That is the hard part as many developers don’t write secure code.

    That is changing a bit. I am really excited about the SQL Server 2016 release in that there are a number of data protection mechanisms that are going to greatly expand how we can protect our data moving forward. From Row Level Security to Always Encrypted to Dynamic Data Masking, the number of new features that will help make security a bit easier is growing dramatically.

    I certainly think Microsoft is definitely encouraging and supporting better, more secure coding practices. If you look in Books Online at MSDN, there is now a Security Center that covers a number of topics and organizes information in a much better way. Security has seemed like an afterthought in past documentation. From Encryption to SQL Injection to Auditing to even Metadata Visibility, it seems like the next version of SQL Server on premise, and in Azure, really is taking security more seriously.

    I look forward to watching the platform evolve and security increasing over time. It does seem as though SQL Server has the fewest security holes in the platform, but I hope that many of us can take advantage of the changes in SQL Server over time and build applications that will be viewed as being secure as well.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 2.1MB) podcast or subscribe to the feed at iTunes and LibSyn.