Saturday, March 8, 2014

Reviewing the Acer C720 Chromebook

I was pleasantly surprised at how well I liked the Acer Chromebook C720 after getting to use one over the weekend. It is snappy, responsive, and is instantly on when opening the lid. The chromebook recently became the new laptop for my mother who is 72 old and had previously clung onto an old Windows XP netbook for almost a decade, unwilling to upgrade for fear of change and having to learn something new.


 I had recommended she get a new laptop because Windows XP end of life was coming soon and there wouldn't be anymore security updates for her computer after that. The new computer she upgraded to was the Acer Chromebook C720. It offered some great features that made it stand out from other laptops. Here are some photos and some of the features I liked about this little chromebook.



The Pros

  • It looks great. The slim design makes it very sleek and lets it blend in anywhere, whether its sitting on the kitchen table, office desk, or on a coffee table.
  • The weight and balance when holding it makes it feel very lightweight, very possibly the lightest laptop I have ever carried before.
  • If you are used to having your cell phone or tablet turn on instantly for you then you will appreciate when you open the lid on this chromebook and it is instantly on and ready to go.
  • The battery life on this chromebook is just a bit less than found in an iPad tablet, about 8 hours. While not much less than an iPad battery, for a laptop to be used by your mother, or grandmother, it certainly is good enough battery life for them to enjoy.


The Cons
  • The confusing minimize and maximize buttons are difficult to figure out and are not located how a typical Windows user expects.
  • The difference between Chrome Store and Google Play Store app tripped me up at first as I tried to install a Google Play store app on the chromebook.
  • The 100GB Google Drive free offer was not readily available.  To redeem it I had to use the following link to get it.
  • Lack of notifications that the computer needs a restart to complete a software update should of been more apparent.

Conclusion

The Acer Chromebook C720 laptop has style and is very good at what it does. It doesn't do everything that some other laptops might do, but sometimes just doing a few things really well is all that you want out of a computer. It is a computer that you can recommend to your mother, or grandmother, and they will absolutely love it.

I would even recommend it as the perfect online banking computer that an individual or small business might use for doing nothing other than online banking. This would help protect your bank account by limiting exposure from use of a compromised computer what can get infected through opening emails, visiting malicous websites, or running infected applications.

Amazon currently has the Acer C720 Chromebook (11.6-Inch, 2GB) available for sale here.

Friday, March 7, 2014

Windows 8 Scheduled Task to Move Files

It's important to try to automate as much as possible in the day to day activities of your IT job or else you risk wasting lots of time in managing the little things of the job. This means you need to write scripts to get things done for you and scheduling these scripts to run as often as needed.

Today I'm going to share a neat little one liner on how to move files around quickly and scheduling the task to run as often as you want to.  Lets say you have a directory called C:\Nightly and you want to be able to move files out of this directory on a daily bases into another directory called C:\Archive. If the files in this directory are rather large you should try to avoid using a copy operation because it will take a long time.This is where the MOVE command really shines as it is an instant operation.

To begin, create a new file called something like movemyfiles.bat and add the following line to it:

move /Y "C:\Nightly\*.*" "C:\Archive\"

This will move everything inside C:\Nightly into C:\Archive. Now open the Task Scheduler and create a New Basic Task. After clicking through the next buttons and when asked What action do you want to perform select Start a Program. Select your movemyfiles.bat file and your all finished scripting this task.




Thursday, March 6, 2014

Getting Exchange Online Working With Android Phone

I recently made the switch from an iPhone 4 to a Moto X android phone. During the changeover I hit a minor stumbling block. I couldn't add an Exchange Online account to my new android email. This task was trivial on the iPhone but I had to spend some time messing around with the settings to get Exchange Online to work. Here are the steps you can use if your trying to do the same:

Step 1
Open the Email App. Don't confuse the Gmail App with the Email App.



Step 2
Type your Exchange Online email address and password, instead of clicking Next you will want to click the Manual Setup button instead.

Step 3
This will take you to the Account Setup menu asking you to choose what kind of email account this is. You should click the Exchange button.

Step 4
Here is where it can get tricky. You have to retype your Domain\Username to be your email address again, and make sure to put a backslash in the very front of of your email name, using the "\" symbol.

For the server name, type outlook.office365.com, and you can keep everything below here on their default settings if you want.


Step 5
After confirming everything after pressing the Done button you should be all set up to use your new Exchange Online account on your android phone!

Wednesday, March 5, 2014

Limitations of Emailing in Microsoft SQL Server

How many times have you written a stored procedure in Microsoft SQL Server and had it set to send out an email from inside it. Pretty cool, huh? I've been doing this for years and without a single problem, until today. I thought for sure I was going crazy. I was convinced there must be some weird character in my code that is truncating my email body somehow. What I was seeing was just half an email body come through and the other half was just missing, no errors getting thrown at all. I tried all sorts of things to see if it was something in the text that I was sending.

Forward three hours later, and I found this is a limitation of SQL Server. Microsoft has set the email body size that can be sent out through database mail to only 4000 characters. Now doesn't that just bust your buttons! That really stinks. It severely limits the usefulness of sending rich content like HTML through SQL Server database mail.

Now here is my best workaround. You have to send email using other means outside of SQL Server. It's not the solution I wanted but a solution nonetheless.

Tuesday, March 4, 2014

The Most Productive Work Monitor

I used to work all day long using three monitors. I had one 17 inch and two 15 inch monitors on each side. At the time, I thought it was a good solution that gave me a detailed look into just what I needed to see on each screen. I then started noticing even my 17 inch monitor wasn't giving me enough space to see everything across a web page or through a remote desktop connection. I was getting slowed down multitasking between remote desktop screens as they were completely filling my 17 inch screen from top to bottom.

Along came the Dell UltraSharp U2412M 24-Inch Screen LED-lit Monitor and it opened up everything for me. This is more than just your average 24 inch widescreen monitor. It's a 1920x1200 resolution monitor, this means it's taller than the typical widescreen monitor. Below is how it looks:


 You'll be able to then remote into another computer at a slightly lower 
resolution of 1920x1080 but still display the remote computer screen at full-screen, all the while allowing yourself to still see your own taskbar and desktop programs. This makes it a breeze to work between all your open windows without having anything get covered up.



Comparison of my 24 inch monitor next to a 15 inch monitor viewing the same website

I still like to have my 15 monitor right next to the big 24 inch screen, as shown in the picture above. This lets me move anything I need to type or pin into view off to the side while I type using the 24 inch monitor.

After demoing this monitor at work I bought 9 more of them for everyone in the office to each have one. Everyone has become much more productive since using them and never wants to go back to their smaller monitors.




Monday, March 3, 2014

Cooling a Small Server Room

If you are like most small businesses you most likely are running your servers out of a small closet room. This presents a problem for adequately cooling all your servers that you may have crammed in that room. Fortunately for you, I have found the best solution to overcome this dilemma, and it was worked great for over a year for us.  Our server temperatures now stay an almost constant 69 degrees F.

Picture of our small server room closet with portable air conditioner


Here's a rack of servers in our closet room. Notice the servers are positioned directly in front of the doorway.  This is done on purpose to let the servers pull as much air as possible through the doorway. The room temperature air, about 73 degrees F, is normally too warm for the servers to use to cool themselves so you need to mix it with cooler air. This is where a portable air conditioner comes into play that will blow cooler air in front of your servers. You will need a 14,000 BTU unit to adequately cool a small server room like this and you must get a unit with dual hoses. A quick search on Amazon will find you a unit like this which is exactly what you will need:

Whynter 14,000 BTU Dual Hose Portable Air Conditioner with 3M Antimicrobial Filter

The dual hoses are important because you will need to exhaust the hot air from the unit up into your attic or ceiling. I recommend a heat insulated foil tube to direct the hot air upwards. The intake hose will need to pull from an adjacent room for fresh air. You may be tempted to also close the closet door but you shouldn't. There is a certain amount of air flow you need for the servers and you can't achieve that with the door closed.

Also, a little fan behind the servers directing hot air upwards to the ceiling is very helpful. What we have done is to also remove the ceiling panel directly above this fan to help exhaust more of the hot air from behind the servers. It also helps pull cool air through the servers and out the back.

This setup has worked really great for us and has been in place cooling our server room for over a year now with zero problems. I can highly recommend it to anyone needing to cool their small server rooms.


Sunday, March 2, 2014

A Black and White Laser Printer for Your Office and Home!

It's not too often I find myself really impressed by a printer. Most are high maintenance machines that just suck through ink like a race car and cost you more money the longer you own it. That was before I found this gem of a printer for about $100, Brother HL-2270DW Compact Laser Printer with Wireless Networking and Duplex.



It has kept our whole office churning out pages without any hiccups at all for an entire year. It sips ink so sparingly we have yet to replace the large black toner cartridge. It helps the cartridge is massive in size when compared to the printer as the fewer times you have to replace it the more money you save. If you need to replace it,  the cost is very reasonable for about $45 found on amazon for a high yield cartridge, Brother TN450 High Yield Toner Cartridge - Retail Packaging - Black. I always recommend high yield over standard toner as the cost per page becomes lower the more you print.

Also, there is a toner saving setting when you log into the printer that can really extends the toner lifetime. We always like to keep a spare one next to the printer and I smile each time I see it, wondering how long it will be before we will need to use it.

It turns out I liked the printer so much that my wife and I now have one in our house. We print everything from taxes, to recipes, coupons and even photos. If your lucky enough to have a Netgear home router like this one, NETGEAR N750 Dual Band Wi-Fi Gigabit Router (WNDR4300), you can use the bundled software called Netgear Genie to turn it into an AirPrinter for iPhones and iPads.