October 2007
In this issue


Training Seminar
Employee Profile
What Should be Secured
Ask Sparky
Notice to Excel & SP Users
Sometimes You Need a Pro
Event Announcements
Outlook How-to-Geek
Managed Services
 

Special Pointsof Interest


Event Announcements

Business Continuity & Disaster Recovery Seminar - Free - Tuesday, October 23, 2007
8-11:30 a.m.
See feature story for event information and directions to register. RSVP Required.

Wisconsin Wolves - Madison's only professional all-women football Team - Saturday, October 20, 2007.  Kick off at 7:05 pm at the Middleton High School football field at 2100 Bristol Street.  For more information, visit http://www.wiwolves.com/

October's High Tech Happy Hour - Thursday, October 25, 2007.  5:00 pm to 7:00 pm at Zimbrick European Building at 2300 Rimrock Road, Madison.  For more info, visit www.hthh.org

Building BOOm at the Children's Museum - Members of the Madison Area Builders Association and their families are invited to join MABA at the Madison Children's Museum on Thursday, October 25, 2007 from 5:30 to 8:30 for pizza, soda, and access to the entire museum including the Building Boom Exhibit.  Costumes highly encouraged!  Visit www.maba.org for more information or to register.


Use Outlook Rules to Prevent "Oh No!" After Sending Emails
by Julie Vike

Let me guess, like me you have probably had those moments where you’ve hit the send button of an email and you have a mini panic attack when you’ve realized an error and instead of being able to catch it in the Outbox, the email has already been sent. &$%@!
We love fast technology and I should hardly be cursing it but if you’ve been in this situation, you know what I’m talking about.
Save yourself from those panic attacks and outbursts of vulgarities by setting a rule that allows a specified amount of time between the outbox and the sent folder. For instructions, refer to my newest favorite bookmark.

The How-to-Geek.


Did You Know. . .

There are many other keyboard shortcuts available to you in Windows XP and Windows Vista. To learn about them, click Start, click Help and Support, and in the search box type "keyboard shortcuts" to view information about other types of shortcuts.


Do You Need
Managed Services?

Four questions for you to answer

Are managed services a better choice than the way you are doing things now? Like everything else in your office, the answer will depend on how you want to measure it.

Your first step is to answer these four questions.


"When all is said and done, more is said than done."

-Lou Holtz


Madison Office
Applied Tech Solutions, Inc.
203 South Paterson Street,
Suite 500
Madison, WI 53703
Ph: 608.257.6051
info@appliedtech.us

Stevens Point Office
Applied Tech Solutions, Inc.
1313 Second Street
Stevens Point, WI 54481
Ph: 715-344-3703
info@appliedtech.us

Is there anything you'd like
to see in the BrainBank?
Share your suggestions,
comments and general
feedback by clicking
here.

Business Continuity & Disaster Recovery
Training Seminar -
October 23, 2007

YOU, OR SOMEONE FROM YOUR COMPANY,
SHOULD ATTEND THIS EVENT!

As business become more dependent on IT, your risks increase from disruptions caused by catastrophic weather, national emergencies, civil unrest, malicious attacks and poor IT management.

According to industry research, 93 percent of companies that lose their data for 10 days or more due to a disaster file for bankruptcy.

The speaker for this event is nationally known Chris Squier (CISSP). Chris is the Information Security Advisor, Educator and Advocate for the Fortune 500 listed Ingram Micro, the world’s largest IT Logistics and Distribution Company. He travels extensively across North America speaking to organizations of all sizes on the subjects of information and holistic security. His goal is to take the often complex and confusing world of security and present it in a practical way so that everyone can benefit, regardless of their experience level. In addition to helping tens of thousands of audience members learn how to better protect themselves, Chris has appeared in several top industry publications, including CRN and the Channel Advisor. Chris has also consulted for such publications as eWeek’s Channel Insider Magazine.

Join us for the no-cost, vendor-neutral seminar where we will provide education about the risks of data loss and learn how to plan for your business continuity.

Date: Tuesday, October 23, 2007 No cost to attend
Time: 8:00am to 11:30am - Continental Breakfast Provided
Location: Quality Inn and Suites—Conference Center 2969 Cahill Main - Madison, WI

RSVP Required.
Click here to register. Please RSVP by October 19, 2007
For more information, contact Julie Vike at 608-257-6051 or vike@appliedtech.us


Employee Profile
Cory Rammer, Systems Specialist

Cory’s interest in computers peaked thanks to computer games. (So, parents, don’t harp too much on your child, they just may end up with a Statistics degree and a MCSA certification from PC Pro Schools (MCSA: Microsoft Certified Systems Administrator) like Cory!)

A transplant from Kewaskum, Wisconsin, Cory studied at the UW-Madison and later at PC Pro Schools. Before coming to Applied Tech, Cory managed the network and the point-of-sale system for all of the Pizza Hut of Southern Wisconsin restaurants. It was this experience that provided Cory with the skills and desire to further his computer know-how and to demonstrate his scholarly talent. Cory’s time is split 70/30 working from our offices assisting with help desk calls and internal support and then providing onsite support for our customers, respectively.

Cory recently announced that he and his wife, Nichole, are expecting their first child in May 2008. This child can look forward to family camping trips, watching Dad at volleyball and being entertained by Dad and uncle Ryan letting loose on their guitars. (Cory – you two might want to start practicing the cords of twinkle, twinkle, little star). Cory and his wife make exhaustive efforts to keep up with their TV shows, Heroes, Lost, 24, and Boston Legal to name a few!


What Should Be Secured?

I, (Jack Safrit, President, Axxys) recently attended an IT security conference in Chicago and the keynote speaker's address reminded me that IT people and business owners often have different views on what are your company's assets and what constitutes adequate security. Dave Stelzl, author of The House & the Cloud, simplified the security model for business by comparing a business's security to a home. We “Protect” our home with doors, windows, locks, and fences. However, we all know that these security measures do little to stop a determined or skilled burglar. The next ingredient is the ability to “Detect” a security breach. In a home we put in alarm systems, motion detectors, subscribe to monitoring services and support neighborhood crime watch groups. Finally, the most important provision of the security model is the “Response.” We have a dog that will bite the thief, some people will have a gun ready for intruders, others rely on the police to respond and others purchase insurance to replace lost items and repair any damage.

Using the house as your business scenario you must ask three questions.


Ask Sparky

Do you have an IT question or concern that you’ve been hung up on? Now’s your chance to “Ask Sparky”!  Sparky is what we loving call our company logo.  Sparky is our fearless leaders who encompasses all that is IT. Applied Tech works hard at keeping IT as pain-free as possible and Sparky is with us every step of the way! Send your IT questions to Sparky at sparky@appliedtech.us.

Amy  asks:
"I’m pretty good at Excel but feel that there must be a better way to separate data in a cell versus inserting a line and having to cut-n-paste or delete and re-type into the new cell. Please tell me there is a better, faster way!!  Click here to read the answer.

Steve asks:
"What is a Trojan Horse virus?" Click here to read the answer.


Notice to 2007 Excel & Sharepoint Users:

Microsoft has recently addressed an issue in Excel 2007 and Excel Services in Office SharePoint Server 2007 through the following hotfixes:

1. Excel 2007 hotfix package: October 3, 2007 (KB 943075)
2. Excel Services in Office SharePoint Server 2007 hotfix package: October 3, 2007 (KB 943076)
The hotfixes are available to download at the links above and will be included in the Microsoft Office 2007 Service Pack 1 (SP1) and in an upcoming Public Update (release dates are currently unavailable). We encourage you to install these updates as soon as possible.

Who is affected?
All customers and users of Excel 2007 and Excel Services in Office SharePoint Server 2007 are affected. Versions prior to Excel 2007 are not affected.

What is the issue?
The Excel team was made aware of an issue with the display of calculation result numbers within the ranges of 65534.99999999995 to 65535 and 65535.99999999995 to 65536. (Try entering = 850*77.1 into a cell.) Investigation into these reports determined that many calculations resulting in a number within these ranges actually displayed the incorrect value 100,000. This is not due to a calculation error but a flaw with the display of this calculation. The hotfixes as described in KB 943075 and KB 943076 will address this issue.


Sometimes You Need A Pro
Buying and installing a new server

So, you're going to run to your favorite PC store and slap in a new server? Unless you are a certified IT person, allow us to politely offer this piece of advice:

"No slapping without a professional, please."
In past issues of  Applied Tech Brain Bank we have offered advice on when to upgrade your server. This time we focus on avoiding the big mistakes once you do. There are decisions to be made about hardware, software, network connections and, perhaps, most important of all, whom to entrust with getting it up and on its feet.

Make the right choice, and your new server be running smoothly from the first day. Make the wrong choice and it won't. Committed "do-it-yourselfers", who pride themselves in being "do-it-yourselfers", are inevitably the most likely  to end up calling in the cavalry. 

Read more