Search This Blog

Thursday, June 16, 2016

Kingston DataTraveler Locker + G3 Encrypted USB Flash Drive

Most people now own at least one USB flash drive.  If you're like me, you probably own dozens of them and when you have that many you are apt to lose track of them.  If you have the wrong kind of information on the drive, this could be detrimental to you or your company.

Kingston offers a Kingston DataTraveler Locker + G3 Encrypted USB Flash Drive that is an excellent, low-cost, alternative to the unencrypted USB drives that most of us are using today.  This drive encrypts the data you put on the USB drive and requires a password to unlock/decrypt the information.  If you lose the drive or someone steals it, they will not be able to get to the information on the USB flash drive.  The drives use AES 256 bit encryption; which at this time is very strong encryption.  The drives also have an antivirus engine that runs on them in order to reduce the chances of you infecting your USB drive or computer with a virus.

You can order the drive by clicking the following link:


If you store any sensitive information on your USB drives for either personal or business reasons you should be ordering this drive today.  At a little over $1 per GB these drives are an excellent value.

The encryption software is built into the drive itself, making it simple to setup and use.  While we do not use this on my network (because of Internation Trade in Arms controls) the USB drive offers a free service, clevX USB to cloud backup.  For small businesses and personal users, this is a great feature.

When you plug the drive into your PC the first time it will mount as a drive letter and mount a secondary drive with the encryption software on it.  Just click the drive on the left with the Kingston icon to start the setup.


The setup will ask you to set a password on the device.  Make sure you don't forget this password because there is no way to recover it once you forget it.  Once you put in the password you want to use the system will ask you to put in Contact Info so that if someone finds the drive they can get your contact info to return the drive.  I recommend putting a phone number and/or email on the details pane.  Make sure your password is not derived from any of the information you put in your contact information.


Once you complete the setup the system will ask about the cloud backup. If you want you USB to be backed up for you click Accept and follow through the prompts.



Once you have setup your USB drive password and contact info you can eject your drive and use it anywhere.  When you insert the drive in a PC, you will again click the Kingston logo drive that is loaded, but this time, it will ask you to input the password instead of the setup.  Once the password is correctly entered, your data is available to you!  




Tuesday, March 29, 2016

HippoRemote Great Alternative For Buggy Bluetooth Mouse



I've used a Mac Mini as my home theater computer for several years with an Apple Bluetooth mouse and keyboard.  We bought a new home and moved in last August and after moving I started having problems with my Bluetooth mouse and keyboard.  The seating is four feet further from the equipment cabinet than it was in our last home but previously (with an older model Mac Mini we had it just as far away and didn't have any issues.  Now, the mouse is jumpy, if it works at all.  The keyboard is slow and unresponsive.

Since this machine is used primarly as my home theater machine I don't do a lot of typing on it.  I was going to replace the bluetooth with an external USB version to see if it was better but then I discovered this little gem of an iOS application, HippoRemote.  Amazing.  This app works like a charm.  Install a little application on the PC or Mac that you want to control and set a password.  As long as the PC/Mac and the device you're using to control it (your iPhone or iPad) is on the same wireless network, you can use your device as a mousepad and keyboard.  



HippoRemote works great for our Home Theater.  We use Plex, Netflix, Hulu and more and it's great to just have a remote mouse on our phones to control the machine.   This app would work great for conference rooms and training rooms as well.  

Here are the setup instructions from the application developer:

  1. Download and run HippoConnect.
  2. Toggle the switch to turn HippoConnect on.
  3. Assign a password.
  4. You can now quit HippoConnect. It will keep running in the background.
  5. Make sure your iPhone/iPod/iPad is connected to Wi-Fi and start HippoRemote.
  6. Tap on your Mac’s name in the Detected Serverssection, enter the password and start remoting!

Lynda.com Pro license changes expensive for small businesses

I first saw Lynda.com at MacWorld in San Francisco, I think in 2007 or 2008.  I loved what I saw and I signed up my company for five licenses while at the show.  I've been a Pro subscriber ever since and have administered Lynda.com accounts for at leat 8 years at this point.

The thing that appealed most to me was that we could buy 5 or 10 licenses and then shuffle the licenses from user to user.  You could create users in their (terribly designed) admin interface and make the license active or inactive.  If you had 5 licenses you could have 5 active users.

The reason this model was appealing is that we could offer up open training to anyone for anything, whether it was for their existing job or for a hobby they wanted to explore off work hours and it didn't really matter what they did with it unless it was a mandatory training per their supervisor or job.

  • If I assigned a user an account and they logged in once and watched five minutes of video and then never logged in again, no problem.   This happened quite often actually.
  • If someone wanted to watch 20 minutes worth of video just to learn more about excel pivot tables, great.  
  • If I wanted to know how to create a mask in Illustrator, awesome.
LinkedIn bought them and bam... they jack with the accounts and cost skyrockets because of their new licensing rules.

Our account rep called me about renewing our licenses and informed me on the phone that we would need 3-4 times the accounts thus costing 3-4 times what we previously paid for it.   I explained that changing our pricing to up to 4x the original cost was something that would require budgeting and that we were unable to buy the other accounts.  She was rude about the questions we had about licensing.  I thought it was just me but later my employee told me he felt like she was insinuating we were somehow stealing from them before with the previous licensing.

Now with the new licensing at Lynda.com you can switch accounts only four times after it's originally assigned; that means a total of five users for one account.  The last time you assign a user to an account, they get the account for the remainder of the subscription.  You can't swap it back to one of the other four that were originally assigned to it.

This makes no sense.  Why orphan an account with the final user?  I understand them wanting to make more money but the way they went about it was silly.  My guess is this is the first wave of completely eliminating swapping users on accounts.  This completely eliminates the ability for us to let users use it for just a couple of videos, unless we want to lose an account switch for that one use.  We will now likely refer them to online videos on YouTube or other sources.

I was also surprised to see they designed a new admin interface to track the account moves and yet made no improvements to the interface or user experience when they changed it.  It's still clunky and confusing and badly designed.

My recommendation to Lynda.com is to change the licensing to be 3 users per account with unlimited swaps between those three accounts and fix the horrible administrator interface so that it's easy to use.

Thursday, February 25, 2016

Downgrade from Microsoft SQL Enterprise to Standard & Keep all settings / databases

I had a request to upgrade one of our SQL Servers from SQL 2005 to SQL 2008 R2.  Upon looking at the SQL 2005 server I realized it had the Enterprise version rather than the Standard version installed.   We are not using Enterprise functions and our license is for Standard so I needed to get this server to the Standard version before upgrading it to SQL 2008 R2 as you cannot upgrade from Enterprise to Standard, it must be Standard to Standard or Enterprise to Enterprise.  I would imagine this would work for any type of downgrade such as Developer to Standard, etc.

I successfully uninstalled 2005 Enterprise, reinstalled 2005 Standard and then upgraded to 2008 R2 Standard.  All databases, logins, settings, etc were still present when completed.

To change from Enterprise to Standard:

First and foremost, make sure you have a full backup of your server. I am not responsible if you hose your server, back it up.  :)

  1. Document server collation (right click server in Management Studio > Properties) as you must set it to the same when you install the Standard version later.  Mine was set to SQL_Latin1_General_CP1_CI_AS.  This is important as it determines how your server orders items in the databases so it's critical it's the same during the Standard install.  
  2. Document Version.  This tells you what the latest service pack and/or update that is installed on the server as you need to get Standard to this same version later.   Here is an article on how to determine your version number.  Find the year of SQL server and click the link to the right of it that says SQL Server xxxx Builds and there you can find out which updates were installed last.  https://support.microsoft.com/en-us/kb/321185


  3. Stop all the SQL Server services
  4. Copy all of the system databases to another location as a backup for later as we will need to copy them back once we have reinstalled the software.  My system databases are stored apart from the others so I backed up the entire Data folder that contained them.  The databases I backed up were templog, msdblog, ssdbdata, model, mastlog, master, and dismdl.  Be sure to backup both the ldf and mdf files.
  5. Uninstall SQL Server completely.  Uninstall components but document which components.  I saw another post where someone said to leave the shared components but you should not do this as I ran into an issue with the upgrade to 2008 R2 in that it detected that Integration Services were originally installed with the Enterprise version and this caused the upgrade advisor to fail the upgrade.  I had to later go back and remove this component and then reinstall it to fix this issue.

  6. Install SQL Server Standard.  Remember to choose the correct collation.  I should note that when I reinstalled mine that it listed the version as SQL_Latin1_General_CI_AS and did not include the words CP1 as in my original setup.  Once installed though it listed it correctly so just make sure you get the options correct.  Also make sure to install the correct components that you uninstalled previously.

  7. Download and install the updates necessary to bring your newly installed SQL version up to the same one as it was previously.
  8. Stop the SQL Server services if they are running
  9. Copy all the system databases back into the SQL Server folder where they were previously, you can just overwrite the ones that are there from the new install.
  10. Start the SQL Server services
  11. All databases should now be present and you should be able to create or use an ODBC and connect to them to test.  
Once I completed these steps I upgraded to 2008 R2 Standard through normal procedures.  As I said previously I had originally left the shared components installed and this then triggered an error that meant I could not upgrade because it was not an approved path.  After reading through the logs I determined this to be the fault of Integration Services so I went to the control panel > Programs and Features and I clicked Change on the 2005 SQL Server install and uninstalled IS, then reinstalled it by running the 2005 Standard install again and only choosing Integration Services.  Once complete I ran 2008 R2 Standard upgrade and everything went smoothly.

Monday, February 8, 2016

Setup Plex to Transcode using RAM & Speed Up Plex

My family uses my Plex server from several locations so there are times I will have multiple videos transcoding on my machine which can cause delays and slow transcoding.  I noticed that even though my main disk was SSD, it could not keep up with transcoding more than two streams at a time.

I found some info on this on reddit and then searched around a bit before I found the entire process I would need to do this so that it created the disk on every startup.

My system is Windows 7 Pro so these directions are for Win 7 but can likely be adapted for other OSes with a little research.

Since my machine has an extreme amount of RAM in it I use 32gb of the ram as a disk on startup and then set my Plex to use this to transcode videos. Mind you, I will not use all of this space for transcoding but I'm not using this RAM for anything else right now and I plan to move my Temp space for Windows and some browser files to this ramdisk in the future.  The great part is that it can be changed anytime by editing the batch file we will create below.

Keep in mind, that doing this takes active RAM (memory) away from your system so if you only have 2gb of RAM and you're running Windows this probably isn't a great solution for you without upgrading the RAM on your system.

It's really easy to make this change.

Create your RAMdisk batch file


  • First, download and install IMDisk here:  http://www.ltr-data.se/opencode.html/

  • Then open a notepad file and put this line in it:
    • imdisk -a -s 2g -m T: -p "/fs:ntfs /q /y"
Customize this line to your system by changing the 2 to whatever number of gigabytes of ram you want to use for this disk.  If you want to use mb instead then just change the 2g to 512mb intstead.

The T: is the drive letter so you can change this to any letter you want.  


  • Save the notepad file to your hard drive to a location like C:\ImdiskStartup and name it imdisk-startup.bat

Setup a Startup Task to create your RAMdisk on every boot

  • Search for Task Scheduler on your PC and open it
  • Open Task Scheduler Library > Microsoft > Windows and then make sure Windows is highlighted.  Then right click in the empty pane and click Create New Task
Settings for task:

General
Name:  Doesn't really matter, named mine 'IMDisk RAM startup'
Description:  Not required
Security Options:  Click Change User or Group, type SYSTEM in all Uppercase and click OK.  This should change the user account to NT AUTHORITY\SYSTEM
Check the box that says "Run with highest priveledges" 

Triggers
Click New > On Begin the task choose At startup and click OK

Actions
Click New > Click Browse > Browse to the .bat file you saved earlier in the C:\IMdiskStartup folder (imdisk-startup.bat), choose the file and click OK

Conditions
Turn off Start the task only if computer is on AC power

Settings
Click box for Run task as soon as possible after a scheduled start is missed

Click OK to save the schedule

Change Plex to use the new RAMdisk

  • Login to your Plex server and go to Settings > Server > Transcoder
  • Click Show Advanced
  • Change Transcoder Temporary Directory to your new drive letter
  • Click Save


Friday, September 4, 2015

Dell Monitors Are A Ripoff for Businesses - Buy monitors elsewhere

We are a mostly Dell shop with several hundred Dell PCs.

I stopped buying Dell monitors at work about a year ago. Why?


  1. They are overpriced, check and compare the specs to what you can purchase on Amazon, at Best Buy, etc.  You will ALWAYS find a better monitor at a better price.
  2. They purposely devise their warranty replacements in a way that make using the warranty ridiculously painful
This is not the first time I have had this issue.  We typically order our computers in multiples.  Sometimes we will get stacks of them in our offices all on the same day/same order.  We do not deploy the monitor with the computer it was shipped with originally.  We typically pull the PCs out of the boxes, run them through our build process, put the monitors in the stock room and then deploy the machines as needed.   Most times, the user already has a monitor or two and we may or may not replace those depending on the age of the monitor when we give them a new PC.

Here's where Dell screws the customer/business.  If you have a Dell monitor go bad, no matter what the age, they want you to give them the service tag of the machine it was shipped with originally.  Given most businesses do not pair them up upon receiving them this allows Dell to screw over their business customers by demanding a service tag.  They put the problem in the customers lap rather than documenting the serial number when shipped so as to associate it with the order number.  

If you do not have the original service tag with which it was shipped they will not replace it.

It seems like a convenient way for Dell to complete screw their larger business customers out of warranty replacements.

Anyway, we started buying really nice HP monitors at 15-20% less than the Dell prices and we don't have to track what PC they come with to get a warranty replacement.  You should too.


Thursday, April 30, 2015

Group Policy Import Fails w/ Error "Directory Not Empty" Solution

I exported a policy from one site and tried to import it into another domain.  It failed with an error due to the policy having one auth item in it that wsa not for the new domain.  I removed that part of the policy, exported it again and then tried to import it and then I received a "Directory Not Empty" error and it failed the import.  

This is apparently caused by DFSR replicated a temp directory for AD.  

I found all sorts of solutions online that didn't work or were overly complicated.

The solution is to create a new GP in the domain and then try the import again.  Delete the old one you tried to import to and caused the failure.  Importing a policy overwrites the original so deleting this shouldn't be an issue.