Spy Journal 3.0 Filtering the web for you

SBS2008

We have our new server commissioned and running.

Hardware Specs

• ASUS TS700-E4/RX8 Intel Core Xeon Server
• 2 x Intel Quad Core Xeon 5405 1.6GHz CPU
• ASUS Server Mainboard
• 32GB of ECC Fully Buffered DDRII RAM (4 x 8GB)
• 12 DIMM slots support Quad channel DDR2 533/667 FBD up to 48GB
• ASUS Pedestal Server Chassis with 730W Power Supply
• 2 x 300GB Seagate SAS Hard Drives
• 2 x 1TB Seagate Drives 24/7
• up to 8 hot-swap SAS or SATAII HDDs
• Onboard RAID 0, 1, 1E
• Hardware RAID 5 via optional ZCR RAID card
• 2 PCI-X 133/100 MHz (one support ZCR RAID card)
• 2 PCI-E x 8 slots
• 1 PCI-E x 16 (x8 link)
• ASUS 16x DVD-RW Drive
• Dual Intel Gigabit LAN
• ASUS ASWM 2.0 & Server Anti-virus License
• 3 Years Hardware Warranty
• Powerware 5110/1500VA UPS

We are running SBS2008 which works very nicely. We found that there is a dearth of how to’s out there on the web in relation to a number of specific configuration issues we came across but we seem to have solved most of them now. We did use Philip’s excellent SBS 2008 setup list as a starting point. We also found lots of good helpful stuff on his website. we were both doing similar migrations from SBS 2003. In our case we didn't use any migration tools but manually moved data and mail. I actually copied every users mail out of exchange into a PST file, and then re-imported them into the new box from the PST file. The main reason for this was to avoid bringing over corrupted profiles and other bits and pieces from the old server. The value of this paying off already with quick profile load times and no errors.

Here are some useful SBS2008 articles from Philip:

There’s been a lot of things happening this week. Not the least being the possibility of a swine flu pandemic. Read on for a scientific explanation of swine flu.

General Microsoft News

• Amit has written article explaining How to Download Images from an Outlook Email.Tip – one of the options works for PowerPoint also.
• Sarah Perez lets us know that PhotoZoom Becomes DeepZoomPix. This is now using Silverlight. I believe this technology has also changed inside PhotoSynth in order to allow Mac users better access to the technology.
• She also lets us know how to Twitter in Excel – how to actually run twitter in side an Excel client.
• Windows 7 Beta keys are still available. The Release Candidate itself is due shortly. From the Windows Team Blog:

I’m pleased to share that the RC is on track for April 30th for  download by MSDN and TechNet subscribers. Broader, public availability will begin on May 5th. Link for rest of article.

I have had a bunch of pretty cool Excel things to post up – and finally got around to clearing my flagged items and browser windows.

Conditional Formatting

I have written a couple of articles on Conditional formatting in Excel 2007 with lots of readers comments and requests for help. They are the two most read articles on this site.

• Conditional formatting in Excel 2007 - entire row colours
• Excel 2007 Conditional Formatting

I was very interested then to come across this article on Joseph’s site by Amit Velingkar where he shows you how to change the automatic colour ranges that are used in Excel 2007 for conditional formatting. He even includes some VBA code for this.

Mine did. Today. Very frustrating as was trying to produce quotes.

After looking into templates, trying to replace images with another image, trying a second pc with the same problem, and then when i tried a third pc with the same document but a different user and it was fine, I started to panic my profile was screwed up in some way.
I Googled it and found this page on the first hit.

http://en.kioskea.net/forum/affich-29382-ms-word-not-displaying-page-numbers-images

The answer was very simply:

Click the Office orb on LH side and then in the main main drop-down click Word Options at the bottom.
Click the Advanced Tab
Under the Show Document Content section untick the "Show picture placeholders (tickbox)

Fixed – whew!