Archive for the ‘Technology’ Category

A Better Wireless

Friday, May 11th, 2012

I recently did something for the first time – not something that I get to say often! I’ve mentioned on these pages before about the new office that one of our clients was opening and how they took the opportunity to upgrade their LAN room equipment. One thing I briefly touched on was the installation of a secure wireless network. Well, that network is now up and running and everyone is pretty pleased with the results.

Implemented with SonicWall SonicPoint technology, the wireless network consists of 3 access points distributed around the office. Each access point is capable of transmitting 802.11 A/B/G/N signals and can have multiple SSID’s on separate networks. Additionally, the entire thing is managed through the familiar and friendly SonicWall interface. The company needed Corporate private network access (to bring their laptop into the conference room with ease) and Guest access (to allow any office visitors to have access). We decided to publish two SSID’s for each network, one for 802.11 G connections and another for 802.11 N connections so users whose computers support 802.11 N are able to take advantage of the faster speeds. This is where the fun starts. While the Guest network uses the standard wireless passphrase, the Corporate network has been integrated with Active Directory for authentication.

Integrating with Active Directory does a few fantastic things for wireless network security:

  1. You are not relying on a pre-shared key that everyone knows and has to be changed often enough to protect the network from disgruntled former employees.
  2. It adds a layer of protection as users are not likely to share network passwords with other users or visitors – forcing them to go get the Guest network password.
  3. It allows network administrators to decide which user accounts can access the wireless – maybe desktop users don’t get to connect but laptop users do?
  4. It uses a certificate based authentication – that means that, if deployed correctly, computers must be configured as local domain members to connect. This restricts access to the network to devices that are managed to the corporate standard. Unsecure home laptops, iPhones and mobile devices need not apply – that’s what the guest network is for!
  5. The certificate authentication also allows for an encrypted session, meaning that the login and connection is just about as secure as connecting to the network through a cable. Granted, wireless goes through walls, so it’s not 100% the same, but it’s as close as you’ll be able to get.

In addition to the added security features, Active Directory integration also allows for a seamless login experience for network users. You simply find the network and hit connect. The authentication happens in the background and within a few seconds you’re connected!

While SonicWall SonicPoints are far from the only device that provides this level of integration, it is quickly becoming our preferred device. It’s easy to use, quick to deploy and meets the needs of our customers.

If you’re struggling with how to provide secure wireless access to the private network, let me know and we can talk about how to incorporate some of this technology.


5 Ways to Work Efficiently in Excel

Saturday, April 7th, 2012

Microsoft Excel 2010 is a powerful software tool, but as a computer support company we have found that most people only know the basics of how to use it.  Here are some  lesser-known Excel tricks that can help you work more efficiently.

  1. Hiding Information: There might be an occasion when you would like to hide certain data when printing an Excel spreadsheet. For example, maybe your spreadsheet includes confidential salary information. Fortunately, you can tell Excel not to print certain rows or columns by hiding them before you hit print. To hide rows or columns, click the corresponding number or letter then right-click on a highlighted row or column and click the Hide option. You can then choose the Unhide option to bring these columns and rows back into view.
  2. Timestamping: Should you wish to attach a date to your spreadsheet, you can use the Timestamp feature. Just hold Ctrl as you press the semicolon key. If you would like the current date and time hold down the Ctrl and Shift keys while pressing the semicolon.
  3. A Better-Looking Spreadsheet: Give your spreadsheet a fresh look by employing Excel’s Themes option. You will find this in the Excel Ribbon, at the top. Click it, and you’ll be given a huge selection of fonts, and color schemes that you can try first and then apply to your spreadsheet. It’s also possible to design your own!
  4. Tracking Trends: The newest version of Excel includes a feature called Sparklines. By employing this feature, you can create small charts that show trends in information. For example, you could use Sparklines to instantly determine how many software bundles each of your company’s salespeople sold in the first half of 2011.
  5. Conditional Formatting: This feature allows formatting only in cells that meet the criteria that you choose. For instance you could chose to have any dollar amount over 1,000 be a specific color.  This helps you view and analyze data faster.

As a Microsoft Gold Partner, Corporate Network Services can help you get the most out of your software investments.  Let us know if you need any assistance!


Time for a New iPad?

Thursday, March 22nd, 2012

Did you wait in line for the new iPad? How about pre-order? Are you just DYING to get one? I was, at first, then I started to think about it for a bit. Why? What am I going to do with the new iPad that I can’t do on my current one? Without a clear answer in my head, I did what I always do and asked the smartest people I know (my management team) their thoughts. What I found was pretty similar to what I was thinking.

To give you some background, I have an old and ugly iPad 1. It’s actually my second iPad. I found out pretty quickly that WiFi only was too limiting for me and I made someone at CNS very happy and got myself an upgrade. I use it basic things like email, Kindle, travel, and meeting notes. I don’t notice not having a camera and while iOS 5 made it a little sluggish, it’s generally a pretty good device.

Everything starts to unravel now that the new iPad has been launched. My old and ugly iPad 1, is now older and uglier. Common computer trends say that you should upgrade and replace when you are two versions behind (as I now am), but common trends also indicate that a device should last for three years and I’ve still got one to go. In today’s age of Bring Your Own Device and Consumerization of IT, there are simply no studies or good data to support when consumer devices should naturally expire and be replaced.

The best advice I got on the matter came from our Anvil Dataworks manager, Chuck Melton. Chuck suggested that its not the screen or the camera, but what you are going to do with it. He specifically mentioned that the increased RAM and CPU will make FileMaker Go users extremely happy and provide a noticeable improvement. I see that, and I’m all about the noticeable improvements! It stands to reason that any app that is memory or resource intensive would also benefit greatly.

In the end, I don’t really have a good answer. While the gadget fever is still running high, I’ve tempered that and will probably wait until the next iPad comes out before upgrading. For me, I don’t see the purpose. I think the industry is still trying to figure out what to do with these things. While new iPads are hip and sexy, they are also expensive and don’t replace your primary machine. Hip and sexy can only get you so far, and money talks!

What about you? Are you ready to upgrade? If so, what are your reasons?


Secure your data closet to protect your business

Monday, March 12th, 2012

We’ve talked a lot about data closets in this blog, and for good reason, they contain the backbone of your corporate IT services.  But we at Corporate Network Services have been concerned with something we have noticed at many customer sites—easy access to data closets. Why does this matter?  Because security threats and disasters don’t always come from tornadoes and hurricanes, they can also come from your own employees.

As a business owner, you hate to believe that employees might harm your company, but it’s true.  At one of our clients, two employees from two different locations got together to discuss how they could get around the content filter in the company’s network switch.  Maybe they wanted to buy concert tickets together on StubHub that Friday afternoon.  Maybe they wanted to look at baby pictures on Flickr.  Whatever it was, the company had already determined it didn’t want employees doing that since certain web sites were blocked.  What did these two employees do?  They took matters into their own hands.  They separately went into the data closet in their offices and physically pulled all the cables out of the firewall.  Problem solved, right?  WRONG!  This action of course took the network down! Not only were those two not able to buy tickets or look at pictures, no one was able to work.

Luckily, a CNS consultant was near one of the offices and fixed the cables within the hour.  The other office wasn’t repaired until Saturday morning (thus incurring over time charges).  Our client immediately installed locks on their server closet doors after this happened, and they instituted a new policy: any employee caught tampering with the company network will be dismissed.

How secure is your network from your employees?  If you’d like us to perform a security review for your company, let us know.


7 Interesting People to Follow on Twitter

Wednesday, March 7th, 2012

So now you are on Twitter, and you follow your family and friends, but you are sick and tired of learning about the latest restaurant your sister went to. You want to hear more interesting and worldly information.

 

Well, lucky for you, almost everyone has a Twitter now.  This can include celebrities, scientists, entrepreneurs, and legislators and you could follow them and hear what they’ve got to say.

 

Here are 7 interesting folks that will get you started if you are not sure whom to follow:

 

  1. Conan O’Brien: The late-night talk-show host happens to be one of the wittiest people around. He’s also a master of the absurd. That being said, his Twitter comments are always entertaining. You’ll be happy to know, too, that he never promotes his show through his Tweets.
  2. Marissa Mayer: You may not be familiar with Marissa Mayer, but she is the very first female engineer at Google. So if you want to get a glimpse inside the life and thoughts of a technology expert, follow @Marissamayer.
  3. Mike Massimino: Follow @Astro_Mike, if you need to get the inside scoop about NASA. Mike Massimino is an astronaut who recent made an appearance on The Big Bang Theory, which he then tweeted about.
  4. Rainn Wilson: Chances are you’ll know Rainn better as Dwight Schrute from The Office. If you find his character quirky and entertaining, you might also enjoy his tweets. Follow @Rainnwilson. Here is a recent Tweet from him: “If I had a bird, I would call it James VanDerBeak.”
  5. Ryan Penagos: Are you a comic book fan? If you are, you really should follow @Agent_M. Penagos. This is Ryan Penagos’ Twitter; he is the editorial director of Marvel Comics. He’s a lively Tweeter, updating his followers about his favorite comics and new video games that are being released.
  6. Barack Obama: You may or may not have voted for him but he is the Commander and Chief. Discover what’s on his mind on a daily bases @BarackObama.
  7. Bill Gates: Bill Gates has made an undeniable impact on the tech world. Learn what’s occurring in his life and about the charitable causes he and his wife support @BillGates.

What’s lurking in your LAN room?

Wednesday, March 7th, 2012

During any given year, we are certain to see at least four of our customers move into a new space. This could be a new branch office opening, moving the whole office to a new location or even merging two offices into a single new large office. Each of these has their own challenges, but they all have one thing in common – it becomes a great time to look at all of the forgotten devices in the network closet and make some upgrades.

Let’s face it, the network switch is the unsung hero of the network. Without it, you can’t get to the server or the Internet. Printing doesn’t happen, email won’t send, and forget about iTunes or Pandora. Being so vital, its funny that switches tend to be ignored and forgotten about. They sit in the LAN room, usually unseen and get cursed at when they break. Therein lies the rub, this switch is probably the most reliable piece of IT equipment in the entire office. I’ve seen 10 year old switches still working well. Great, right?

No, not great. Think of the network switch as a highway. Ten years ago, when you first built a network in the office, you probably built a one lane highway. Speeds were good then, but now with gigabit networking and Fiber based Internet connections that one lane highway just isn’t enough. Changing out that 10 year old workhorse for something new may seem like frivolous spending, but using the highway analogy, you’ll actually be adding some lanes on the beltway and giving yourself some more speed.

What else is back in that network closet? Firewalls? Wireless network devices? KVM switches? UPS batteries? Voicemail computers? The list could go on and on and is different for everyone. The result, however, is the same. These are workhorses that run well seemingly forever.

I am working with a client on a large move project right now. We are replacing almost everything except for the servers. The expense was minimal (in comparison to everything else they are buying) but they will get a huge gain in performance, capability and even some old equipment to use as shelf spares in the event something bad happens.

All this begs the question, what’s the single most forgotten item in your LAN closet?  And is it time to upgrade them?  If so, give us a call to discuss how you might be able to improve network performance by spring-cleaning your data closet.


Windows Phone – Transforming Microsoft

Friday, March 2nd, 2012

Microsoft is everywhere; their products are used the world over. And, Bill Gates, Microsoft’s chief, is among the most widely known names in the field of technology. That being said, Microsoft is missing one thing, it has never had a “cool” image. But the release of Windows Phone, Microsoft’s new smartphone software, may alter our perception.

Sure Microsoft’s products are everywhere but, in the eyes of the consumer, they’ve always fallen just short of ground breaking. Microsoft has had a handful of failed products in the past, for example, the Zune. Do you remember this little mp3 player? How about the Kin phone? These products and others have contributed to Microsoft’s less then cool reputation.

That said, Microsoft’s Windows Phone software has captured some interest. The Windows Phone has been received well by both critics and consumers.

Windows Phone draws praise for its vibrant on-screen typography and its mosaic of animated tiles on its home screen. This presents a visual contrast with the home screen of the iPhone. The operating system gets points, too, for making it easier for users to access social networks. When friends or family members post pictures, messages, or updates to Twitter or Facebook, the tiles representing these services pop into life on Windows Phone-equipped devices.

It is interesting that even with all these features, Windows Phone isn’t a big seller. This might be, in part, due to the phones that use Windows Phone as an operating system, many people think they are boring. Another contributing factor is that most wireless providers push iPhone and Android devices.

While sales may be lower then desired for Windows Phone the change it is making to Microsoft’s reputation could have a very favourable impact. Where the consumer is concerned, a little cool never hurt a business.


Business analytics can help improve business performance

Thursday, September 1st, 2011

Business analytics is one of the hottest topics in management today. Analytics, made visual with graphical dashboards, can provide a wealth of real-time information as to how a business is operating in simple-to-understand formats. Dashboards are windows into a company’s data, helping managers make decisions minute by minute!  We at Corporate Network Services and our sister company, Anvil Dataworks, believe in the power of dashboards to keep track of our work and impact productivity (what gets watched gets done!). If you want to learn how you can use a simple tool like FileMaker Pro to improve business operations by creating information dashboards for your management team, attend a free webinar on September 23 at 2:00 PM EST presented by Anvil Dataworks.  You’ll learn:

• Dashboard concepts
• Why choose FileMaker Pro
• Design considerations
• Charting with FileMaker Pro
• Warehousing data from other sources

REGISTER TODAY!

If you can’t wait for the webinar, check out this article reprint from FileMaker Advisor magazine, written by Anvil Dataworks manager and Certified FileMaker Developer Chuck Melton.


How to choose a good password

Monday, August 22nd, 2011

Choosing a good password can be difficult to do. In fact, as a network administrator, it’s the number one thing I hate doing. As a user, there are also a myriad of rules and requirements involving capital letters, numbers, and special characters. Check out this great video for some easy tips for creating a good, secure password!

 YouTube Preview Image


The SMB Security Concern

Saturday, August 13th, 2011

I’ve spent the past week at the Everything Channel XChange Americas event in Denver, CO. As an invited delegate, I was privy to a host of executive level briefings from a hundred different vendors. This morning, a VP from Symantec is addressing the crowd and reporting on chief security concerns for different size businesses. Their research shows that while attacks on enterprise companies are looking to recover actual data, attacks on Small Business companies are specifically targeted at recovering your online banking data!!

For about $400.00, an interested party can purchase a customized malware on the Internet black market. This sophisticated software waits and watches as you login to your banking sites, then reports your username and password back to the hacker. The software replicates, mutates and remains hidden. Check out some real life stories at http://krebsonsecurity.com/category/smallbizvictims/.

What can you do to protect yourself?
1. Keep your system clean. Use up to date anti-virus and anti-malware. Also ensure that these scans run regularly.
2. Change your banking password frequently. Weekly is not too often.
3. Make sure your bank uses multiple authentication methods. While asking a lot of questions or requiring a token can be annoying, it GREATLY lessens the chance that a hacker will gain access. If your bank doesn’t support this, change banks. It really is that important.