/* SQL Works: Office
Showing posts with label Office. Show all posts
Showing posts with label Office. Show all posts

Monday, October 15, 2012

Logitech K810 - one keyboard for phone, tablet and computer

I love this idea, but more for the fact that I could pair both my laptops to this one keyboard and switch between them without having to plug/unplug anything. It's a keyboard that can be paired with up to three devices, including computers, tablets and phones, and hot swapped between them.

Logitech K810 write up from geekbeat.com

They are not out yet, full details from Logitech here:
Logitech Product page
But preorders are available for $99 USD, no number pad, but I might still sign up

Friday, October 12, 2012

You probably need a new keyboard

Need a new keyboard? So did I, so I checked a few out, went to Best Buy and opened a lot of boxes to test the keys, went to Staples and did the same, then shopped around Newegg, TigerDirect and Amazon looking for the best prices of course, and I ended up with an HP Elite Wireless V2 keyboard (ended up getting it at Best Buy). I may have some bias here because I have an HP Elite book that I like a lot, but this is one of the best keyboards I have ever used. It is very thin, but very rigid and strong, the keys are easy to use and feel great over long periods of use (8+ hours a day). If you haven't gotten a new keyboard lately, do yourself a favor and get a better one, if you are a professional and spend 8 or more (sometimes many more) hours in front of the keyboard every day you owe it to yourself to get a decent one. The link in this image is the best price I could find.

The Elite V2 is also very thin and light, you could bring it with you on a plane if you had to and you really wouldn't be giving up much space in your carry on. Overall this seems to be the best value in this price range, you can spend a hell of a lot more if you really wanted to (see example below) but for someone who is just looking for a tool to do their work, this is the way to go in my opinion.

For those who have more money than sense, please click here:

Optimus maximus keyboard Art Lebedev

How is the role of the 'Analyst' changing in a data driven world?

     I remember the days when I was considered a top notch resource when it came to answering data driven questions. My Excel sheets were sparkling, my PowerPoint slides were beautiful, and my MS Access database was driving it all. In those days, when you needed to know how many widgets the sales team had sold, you asked them for their results sheet, and probably received it by email. When you needed to see attendance records for the call centers, they replied with their own spreadsheet, and a few paper based updates perhaps. After you had all your data collected and entered or imported to Access you could do with it what you pleased, and get some results worth sharing. But those days are gone, over the last 10 years I have witnessed an amazing transition from the scenario I describe above to the new paradigm of the 'Analyst' as power user and SQL dabbler. The data companies house internally is larger and more broad than ever before and growing quickly, and in order to present informed conclusions about a business, market or customer group, you need to be able to intelligently ask questions of these large stores of data.
     Enter the new 'Analyst', someone who is expected to know how to interact with databases like never before and to collate and present data from varied sources. Where a job description from those bygone days might have read "requires advanced MS Office suite knowledge" it is typical now to see requirements similar to "Must be familiar with SQL querying and tools such as SQL Server, Toad for SQL or PC SAS in order to gather results".

Tuesday, September 25, 2012

Error 1406 installing Office Pro Plus 2010

After a recent computer upgrade I was faced with re-installing the Office 2010 Pro Plus suite, which I had the discs for and assumed would be a no brainer. Upon happily inserting the CD and expecting to hit 'GO' and grab a snickers I was suddenly faced with this:
Error 1406 cannot write the assembly value screenshot
ERROR 1406: Setup cannot write the value Assembly to the registry key

After some reading about how I did not have sufficient permissions to alter my registry, and knowing this was not true, I tried a theory and disabled my anti-virus software (AdAware AntiVirus free edition) and the installation worked without an issue. I have also read references to WebRoot SpySweeper blocking registry changes as well, so if you are facing this same problem, before you go changing registry permissions, try disabling your anti-virus software, it may just work. Don't forget to turn it back on...

If you found this useful, please hit the +1, it's free!