Welcome to NetCal's blog.

We hope to share with you our thoughts on IT topics and issues encountered by businesses in the Bay Area.

Please feel free to contact us at 408-228-4488 or sales@netcal.com if you would like a quote for IT Support Services or a particular IT Solution.

Information/Advice for IT Professionals

As an IT Consultant, I often find myself mucking with the latest and greatest things before I would even consider recommending them to clients.  The down side to this is the time spent during a Saturday afternoon trying to install Windows 7 Professional 64-bit on my home desktop.  I was so impressed with the RC1 version, that I wanted to deploy it to my single desktop (can’t be worse than Vista… heheh)

Apparently, Windows 7 is very picky about the hardware/harddrive/partition/MBR it’s installed on.  When I ran the installation, my hard drive and the system partition would be displayed, but I could not get it to actually start the installation..

I tried the following, but to no avail:

  • Installed latest drivers
  • Deleted partition
  • Reformatted newly created partition
  • Removed external hard drive and USB key so the only thing left was a single 200GB HD and an IDE cdrom.
  • Using diskpart to set the new partition as an ACTIVE partition

Looking at the setup logs (Shift-F10 -> notepad \windows\panther\setupact.log), I saw a bunch of “not system disk”, “not primary partition”, “not enough space”, “not good enough” errors…

Finally, I tried to think outside of the box.  I decided to repair my MBR and Boot record the old fashion way.  I booted off a Windows XP SP2 CD and ran the recovery console.  Once in, I ran “fixmbr” and “fixboot”.  I then rebooted into Windows 7 setup and was able to click Next to continue with the Windows 7 Professional installation.

Hopefully, this technique would work for most of you.  If it still doesn’t work for you, try making sure there’s no USB keys or any other storage device connected when you install.

Sarbanes-Oxley Act update…

Since we have approximately 4 more months until the Sarbanes-Oxley Act (SOX) will be applied to all publicly traded businesses, I’d like to give everyone a little refresher course.  Although it won’t apply to most of our clients, the act proves to be a solid compliance guideline for any company.  Due to the trickling effects of larger businesses and the tightening of requirements from lenders and such, it’s not a bad thing to follow.

SOX Compliance Summary

Designed to:

- protect investors and creditors of public companies

Applies to:

- Publicly traded corporations with larger than $75 Million in Public Equity (expires Dec 2009)

- Documents and files pertaining to financial statement generation (atleast 5 years)

Provisions:

Section 404 – Requires management to report on the effectiveness of their internal financial controls and for outside auditors to attest to the management reports.

Section 802 – Makes it a criminal violation to alter, destroy, mutilate, conceal or make a false entry in a record, document or tangible object with the intent to impede, obstruct or influence any investigation or bankruptcy matter.

Section 1107 – Provides criminal penalties for retaliation related to an employee’s whistle blowing activities.

Section 301 – Requires the independence of audit committees.

Section 302 – Mandates that CEOs and financial officers certify financial statements.

Section 406 – Requires public companies to disclose whether they have adopted a code of ethics governing the behavior of senior financial officers.

General Business Process recommendations:

- Segregation of duties

- Establish a policy of archival and backup (onsite and offsite)

- Have independent party review books on a regular basis (CPA)

- Have good documented procedures

Quickbooks recommendations:

- Review Financial data using reports

- Setup user accounts with only necessary priviledges

- Implement audit trails

- Backup regularly (minimum retention time of 3 periods)

General Info:

Sarbanes-Oxley regulations require that an audit trail of log files and all pertinent documentation must be retained for five years. SOX defines which records are to be stored and for how long, focusing specifically on retention of audit and accounting records that relate to the generation of financial statement that will be submitted to shareholders and the SEC. Both paper and electronic versions of this documentation must be retained. SOX does not, however, specify how they are to be stored — best practices for data protection, disaster recovery and storage management pertain. That means the impact of Sarbanes-Oxley can be felt by nearly every component of IT operations, including messaging, storage, virtualization and even networking, so long as financial data or activity occurs on them. In turn, IT must be able to produce electronic records of these audit trails for compliance audits.

The IT departments of all public companies must be aware of the key requirements of SOX, including log management, backups and all relevant electronic communications. New platforms for communication enabled by Web 2.0 technologies like blogs, wikis and social networking are introducing all-new compliance headaches, as gigabytes of data are generated through messaging and sharing. If it pertains to finance and accounting, enterprise IT professionals must track and archive it for the inevitable visit by a compliance auditor looking for log files. Increasingly, compliance officers are using event log management software to track key moments where data enters or exits an enterprise, like email systems or the addition or departure of employees with access to sensitive financial data.

Below is a quick rundown of all the goodies in the new Service Pack for Windows 2008 and Windows Vista.  Of course, SP2 includes all hotfixes and other updates post SP1, but unlike traditional methods, Windows Server 2008 SP2 and Windows Vista SP2 uses the same Service Pack executable, which makes it easier to deploy.

Although this update provides minimal changes, it’s always recommended to do a test rollout before deploying in full.

Warning:

This was taken from Information about Service Pack 2 for Windows Vista and for Windows Server 2008

After you install SP2, a sound device or some other hardware device may no longer work. If this behavior occurs, just install an updated driver for the device. To do this for a sound device, follow the steps in the following Microsoft Knowledge Base article:

948481 How to troubleshoot sound problems that you experience after you install a Windows Vista Service Pack

What it has to offer:

  • Bluetooth 2.1 Support
  • Wi-fi – Uses Windows Connect Now technologies for wireless connectivity and improves on resuming wireless connectivity from a sleep state
  • Power Management – Microsoft touts a 10% increase in power management efficiencies
  • exFat file system extension – Now includes UTC timestamps which helps with file synchronization across time zones
  • Blu-ray data burning capability – Not for making movies, but for backing up files
  • Windows Search 4.0 – faster, better support for Group Policy, able to index encrypted files
  • VIA 64-bit processor support

Windows Server 2008 offerings:

  • Hyper-V 1.0 versus a prelease version
  • Addresses Terminal Server license key issues

Most useful part about SP2:

Service Pack Clean-up Tool (compcln.exe) – Deletes older versions of the RTM and SP1 based files

Requirements:

SP1 has to be installed prior to updating.

Where to get it:

Windows Server 2008 SP2/Vista SP2 (x86, 32bit)

Windows Server 2008 SP2/Vista SP2 (x86, 64bit)

I know everyone has been hearing this continuously for the last 3 years or so, but what does it actually mean?  How does it help the IT department and how does that help the business?  While the two words of Virtualization and Consolidation are separate topics, they often go hand in hand.  I believe the reason for this are to take advantage of new hardware capabilities and new virtualization technologies.  Lets say you bought a new server and wanted to consolidate and migrate all the data from your file server and your mail server.  You’ll essentially end up with a server with more utilization.  Sure, you’ll save a little on time and the electric bill, but that isn’t going to give you the “WOW” factor when it comes to analyzing your ROI. You’ll soon realize that consolidation usually will not fully utilize the full capabilities of your new hardware.  Unlike oil and water, implementation of Virtualization creates a symbiotic relationship with Consolidation.  One could also say it’s the catalyst to a higher ROI.

Why is there a push now?

  • 64-bit operating systems allow for a significant increase in memory
  • Multi-core CPUs creates effective use of processing power
  • VT-enabled CPUs support virtualization specific instruction sets which increase the effectiveness of hardware.
  • Microsoft is now in the market, which usually means it’s growing and here to stay.

Summary of benefits of Consolidation and Virtualization:

  • Lower TCO (power and cooling requirements, less physical assets, reduce time and resources need by IT staff, reduce licensing requirements)
  • Increased flexibility (backups, snapshots, migration, quicker provisioning of new servers)
  • Space savings
  • Makes use of the full capabilities of your new hardware
  • You already have the capabilities, you just need to implement it.
  • Fail-overs can be performed practically instantaneously
  • Upgrades to a new server in the future is greatly simplified
  • It’s much easier  to make  the  resulting  infrastructure resilient  for  business  recovery  and  continuity  solutions

When will you know it’s “GO TIME”?

  • You are trying to cut costs
  • You are trying to increase performance
  • You will be purchasing a new server
  • You spend too much time focused on maintenance
  • You are implementing a software “refresh”
  • Your servers have multiplied to where you have a management problem
  • You need IT to work projects that drive the business
  • Your backup solution is inefficient and ineffective
  • You have a need for a development environment

Backgrounder:

Like everything Microsoft, downloading and applying updates and patches are the key to keeping your computer running efficiently.  Today, we are focusing on Microsoft Office 2007 Service Pack 2.

It has been more than a year (December 2007) since Microsoft has released a single service pack to keep computers up-to-date without having to download a bunch of little patches.  This significantly reduces deployment times for any oganization.  Furthermore, while most service packs are just a compilation of previous released patches and fixes (through February 2009), Office 2007 SP2 will also include feature enhancements and performance enhancements.  Will the PDF support mean the end of downloading Acrobat Reader?  We’ll see…

Release Date:

End of April 2009.

Changes, Fixes, Patches, Enhancements:

  • Support for Open Document Format (ODF), XML Paper Specification (XPS) and Portable Document Format (PDF).
  • Improved Outlook Calendaring reliability.
  • Improved Outlook performance.
  • Enabling Object Model support for Charts in Microsoft Ofice PowerPoint 2007 and Microsoft Office Word 2007.
  • Improved cryptographic functionality by supporting all cryptographic algorithms offered by the operating system.
  • Improved functionality in Microsoft Office Excel 2007 charting mechanism.
  • Ability to ungroup SmartArt graphics (and as a result, the ability to add animations to them in PowerPoint 2007).
  • Ability for Visio 2007 to export UML models to an XML file compliant with the XMI standard.
  • Tool that enables the uninstallation of Office client Service Packs

Where can you get it?

Direct File Download Link

Downloads page link

Release info link