DavidOverton.com
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  

June 2007 - David Overton's Blog

  • SQL 2000/2005 June Downloads including Management Pack, JDBC Drivers, Virtual Hard Disks and Access Migration Assistant

    Microsoft SQL Server 2000 / 2005 Management Pack The SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log alerts and provides associated knowledge articles with additional user details, possible causes, and suggested resolutions. The Management Pack discovers Database Engines, Database Instances, and Databases and can optionally discover Database File and Database File Group objects. http://www.microsoft.com/downloads/details.aspx?FamilyID=8c0f970e-c653-4c15-9e51-6a6cadfca363&DisplayLang=en Microsoft SQL Server 2005 JDBC Driver 1.2 Community Technology Preview April 2007 In its continued commitment to interoperability, Microsoft has released a new Java Database Connectivity (JDBC) driver with SQL Server 2005. The SQL Server 2005 JDBC Driver 1.2 CTP April 2007 download is available to all...
  • If you want Windows XP Pro on a new machine, buy Windows Vista (Business or Ultimate) and then downgrade

    I’m not sure how many people are aware of this, but if you buy a Windows Vista Business or Ultimate then you can use a Windows XP CD (which you have legal access to) to load Windows XP onto that machine. When you need the product key / or need to activate, this will potentially fail, but a quick call to the activation centre with your Vista product key should give you all the details you need. Then when you are ready to put Vista onto that machine, you can do without the cost of buying it anew. Alternatively you can buy Windows XP today and should you ever want to load Vista, you can give more money to a shop to get a copy again. For further information go to http://oem.microsoft.com/script/sites/public/licensing.htm More information can be found in this one page document OEM Downgrade from Vista to Windows XP ttfn David Please Note the following (in legalese) Windows Vista Downgrade Rights Clarification Per the EULA and OEM DTOS Agreement, the end user customer is responsible for supplying media for the...
  • Microsoft Office Outlook Connector Beta (how to connect Office Live Basics or Windows Live Hotmail to Outlook)

    Don't you love the way the title of a product described what it is? While this product does what it says on the tin, it misses out the most important thing - what can you connect Outlook to. The answer is e-mail and contacts based on our Hotmail service, so this includes OfficeLive. If you sign up to one of the subscription OfficeLive services (i.e. you pay us to use it) then you get a connector which can do all this AND synchronise your calendar items too. Once in Outlook you can do all the searching, filing and manipulation you want to do. Today you can now download the beta of the next version of the Microsoft Office Outlook Connector. Download: Microsoft Office Outlook Connector (Beta) The Microsoft Office Outlook Connector is designed to let you access your Windows Live Hotmail account through Outlook 2003 or Outlook 2007. You will be able to download and install the Connector to sync up your email and contacts in Windows Live Hotmail for free. However, if you are a paid subscriber of MSN Premium, Office...
  • You can't use Outlook Web Access because you can't send or reply to mails. You've seen a server update will fix it, but you can't get the server updated - here is the simplest way to work

    I have to thanks Lauren for bringing this to my attention. She had found my posting on how to update Exchange so that this did not happen, but she could not get the SBS / Exchange Server updated. Her research said that using Firefox would fix the problem , but to me this was just a huge sledgehammer to crack a nut, so I guessed there must be a much easier solution and there is. Use "basic" or "light" mode. This may sound complex, but it is about as easy as it gets. Here is the Exchange 2003 login screen, simply select "basic" client and you are done. Here is the Exchange 2007 login screen, simply select "light" and you are done. Gosh, so easy. For the technically minded the issue comes from the Active-X control that Exchange is using. The answer is to either apply the update to the Exchange web components, or use a browser without the Active-X control. ttfn David Technorati tags: Outlook Web Access , IE7 , Internet Explorer
  • Can Windows Server 2003 R2 be added to a SBS 2003 SP1 (i.e. non-R2) domain - Yes

    [updated 14:52 27th June 2007] I got this question yesterday and while I will not name names, I felt this should go public. It is from a customer who I believe has been mis-informed by a partner about SBS 2003, SBS 2003 R2 and Windows Server 2003 R2. Here is the mail I got: To: David Overton I have a question concerning compatibility. I have a SBS 2003 with SP1 as my domain controller.... I am about to migrate to a new ERP package and have purchased 2 additional Windows Server 2003 R2 servers from XXXXXXXXXX. I have been told the new servers will not be able to join the Domain and I must upgrade my SBS 2003 to SBS 2003 R2. Is that true?? Here is my reply You have been mis-informed. Windows Server 2003 and Windows Server 2003 r2 interoperate without any difficulty. If you are trying to use a specific R2 feature such as remote printer management or FSRM then you might have to upgrade, but joining the domain is not a problem. Also, SBS 2003 R2 enables you to get some extra benefits from your CALs with regard to licensing...
  • Office XP, 2003, 2007 feature comparison for small businesses

    I saw this on the Small Business site in the US and thought it was an excellent tool as to what has changed between the versions of Office from XP through to Office 2007. Simply go to http://www.microsoft.com/smallbusiness/products/wowpc/CompareOffice.aspx and click out the tabs to get the details. Ttfn David Technorati Tags: Office System , Office 2007 , Office 2003 , Office XP , Comparison , Small Business
  • Spreadsheets and documents based on standards - OpenXML and ODF, ODF and Excel or all 3

    I have been using and referencing standards for a long time. They are great. C# is an ECMA standard for example as are parts of .Net which is how project Mono has managed to come great strides in delivering part of the .Net experience on non-Microsoft platforms. Also my 1st job out after University was writing document converters. So there are two things here - one, what is wrong with more than 1 standard - we have several for networks, several for character sets. Often one standard will work where another will not. Nearly always one standard is driven by an interested party. Open Office is very keen to see greater adoption of ODF. Microsoft is very keen to seen greater adoption of OpenXML. OpenXML is already a European standard (ECMA) and one of the nice things about that is the stability you are offered if you are developing against it. There is no requirement to have Office to use this file format. OK, so we could say "lets not use the European standard and create a similar one, but not quite the same"...
  • If you want to help shape Office 14 (the next version of Microsoft Office) tell us about yourself and see if you can get on the International Planning Panel

    I saw this and while it is old, thought you might like it: Participate in the Evolution of the Future Microsoft Office Versions Microsoft is committed to continue building solutions that address your needs and requirements. As part of the process for building future solutions, the Microsoft Office International Planning team is recruiting an international user panel. The goal for this panel will be to contribute in helping the Product Planning team get an in-depth understanding on users' habits, needs and requirements. We are convinced that listening to users' feedback is key to the development of great solutions and products. If you would like to participate, please complete the questionnaire. ttfn David Technorati Tags: Office 14
  • Best Practices for Exchange Server Public Folders

    I have been asked lots of questions about public folders recently and thought this little section here might come in handy. It is from the Best Practices for Exchange Server Public Folders site on Technet and is geared towards Exchange Server 2000/2003. I have snipped just the articles that I think are useful, so there are more on the page above including the ability to take the document offline. Which Solution Works for You? Before you deploy Exchange 2000 Server or Exchange Server 2003 public folders, you should make sure that the functionality that is provided by public folders meets your business needs. It is a good idea to evaluate the features and functionality that are provided by public folders and to compare them to the data repository solution that is provided by Microsoft Windows® SharePoint® Products and Technologies. For detailed information about both options, see Selecting the Appropriate Public Folder Solution . How to Select the Appropriate Client After you have decided to use public folders,...
  • "Vista, XP Users Equally At Peril To Viruses, Exploits" and then a lengthy retort from Roger A Grimes including the comment that the number of vulnerabilities over a given time for OSs were XP-28, Vista-11, Max OSX-101

    I have been RSS feed and news hunting and found this review in IT Channel News stating that Vista was no more secure than Windows XP. Then I read how things seemless slipped onto the system and I started to get frustrated that they must have turned off every security feature in Vista to get the results. There I was about to write a WTF reply when I found a HUGE one by Roger. There also seemed to be some confusion that Microsoft also still recommends anti-virus software for Vista. I tell people to buy AV software and not some complete "take over everything on your system" suite. Rogers reply is worth reading for sure - Microsoft is far from perfect, but turning off all the security features and then saying it is no more secure is just a little bit silly too. If you look at the number of found vulnerabilities in Windows XP (28) vs. Vista (11) this year, Vista wins again. If that seems like a lot, don't forget Mac OS X has had 101 in the same time period. Cute commercials, but not necessarily a stellar...
  • Windows Server SP2 (SBS 2003 (R2) with SP2 too) RSS/Checksum/TCP fix up now on Microsoft update

    Susan B has probably been at the forefront of SBS 2003 SP2 pains, so it is only right that it is her blog I see this posting on. SP2 RSS/Checksum/TCP fix up now on Microsoft update The Official SBS Blog : New SBS 2003 Updates released through Microsoft Update and WSUS: http://blogs.technet.com/sbs/archive/2007/06/08/new-sbs-2003-updates-released-through-microsoft-update-and-wsus.aspx New on Microsoft update is a sp2 patch that you should be installing BEFORE you install SP2. But the problem is that only gets MU'd offered up to you AFTER you install SP2. At that point in time there is a chance (especially with ISA on the box and broadcom nics) that you'll lose RDP/VPN. So I'm sticking with my recommendations from before.... SP2 RSS/Checksum/TCP fix up now on Microsoft update - E-Bitz - SBS MVP the Official Blog of the SBS "Diva" ttfn David Technorati Tags: Service Packs , SP2 , SBS 2003 R2 , SBS 2003
  • Do you want to IM (messenger) someone in the UK Partner team with a question, but not have their address - now you can try the Partner Bot. It is your Instant Messenger 'data digger' retrieving partner-related information and the answers you need

    This is a long intro, but I got the mail this morning from Alex that this is alive and kicking!!! Go have a conversation - it is even clever enough to know that if you ask for me, this is my blog!! I am very pleased to announce that the PartnerBot is now live. Partner Bot is your Instant Messenger 'data digger', which quickly retrieves partner-related information and shows you where you can find the answers you need. Simply type in your question and Bot will bring back an instant response. Add Bot as a buddy in your Windows Live Messenger contacts and it will always be available whenever you're logged in. Use Partner Bot to Help You Get answers quickly, whether you’re in the office or mobile Find partner resources, like blogs and marketing help, more easily How Do I Add Partner Bot to My Contacts? · Log-in to Windows Live Messenger · Click on 'Add a Contact' icon · Add '[email protected]' into Instant Messaging Address > Click here to find out more Please be aware that PartnerBot...
  • Darren Strange of Office 2007 / 12 fame talks about Max Office document converters and the the role of beta software

    I saw this and thought those of you with Mac customers might find this useful if Office 2007 is around or potentially around in their businesses. Also of note is the fact that beta, trial and RTM seems to be very blurred today. Do you ever deploy beta code? I do, often in small environments with big warning labels, but I do do it. Following on from some of your less than exuberant feedback about the new Mac converters, I looked into it. To summarise, the Mac BU have released the beta 1 of the file format converters of Office for Mac. You can download the converter for Word documents here . More info is at the ever useful macmojo blog First thing to point out is that this is a BETA and also that it is a BETA 1. There is a bug-ette in that apparently it doesn't handle some reserved characters from non-english languages or some special Unicode characters such as ™. Any docs that have these characters seem to screw up or don't convert at all. Apparently the issues with Unicode was documented in the help with...
  • Susan Bradley's found something that does good backup and virtualisation things - StorageCraft

    Susan's blog has recently come under my radar again (meaning I have time to read blogs), so I am posting lots of things from here. This one is a product which if your customer is DR minded could enable them to spawn a Virtual PC/Server and run the backup in it. An awesome addition. He took a backup image he had done of a server, he then fired up virtual pc and restored the backed up "real" server to a virtual one and flagging the "check for hardware changes and deal with it automatically" function that the IT pro version does. Very impressive and very cool. You can even mount the image and browse a read only version of the server if you need to extract data or what not. http://www.storagecraft.com/products/ShadowProtectIT/ Check it out... very cool. The biggest thing at New Orleans.. was not the throwing of the beads...but StorageCraft and Mark Crall - E-Bitz - SBS MVP the Official Blog of the SBS "Diva" ttfn David Technorati Tags: SBS 2003 R2 , Backup , DR , Virtualisation
  • Please, Please, Please fill in the SBS Community Survey for 2007 - if you don't tell us about it in the survey, how can we do more / less / fix it for you?

    It has been around for a little while now, but this is a MUST do for us - whether you think things are great or poor. Please fill in the survey and then we can stay up all night and look at the results using the latest holo-projection equipment to understand the multi-dimensional nature of what it takes to please our small business partners. If you don't fill it in, then my R2-D2 projection system will not be used and we will take the 3 replies (two posted by me as a test) and you only get one answer this year. OK, so this is a little humorous, but I hope you get the idea - we need the feedback to make things even better. Don't think you only need to answer it if you need to moan, or you think things are great. Confirming things either way (or even the fact that we have more than one type of partner out there) is all "goodness" as one of my managers used to say. Have I said enough yes? Fill it in, send it off, spank us if we don't respond! Announcing the SBS Community Survey for 2007! The...
  • Vlad Mazek - "What is service management" and "how to avoid being hit by a truck when it is most inconvenient"

    I love Vlad's straight talking. If you get a chance read the whole of the blog entry Vlad Mazek - Vladville Blog » Blog Archive » Windows Server 2003 SP2 EEULA & CYA because as far as I am concerned he is preaching to the converted. I will stand by my view that Service Packs are tested as much as possible, but you need to do your own validation (see Who should test software and service packs - I think vendors,customers and partners - others thi ) to ensure that your application vendor is also happy to support their products on that service pack. If you only have MS products, check the release notes AND SUPPORT.MICROSOFT.COM as both may well have important information. I've extracted part of Vlads process to avoid a bloody head - read his post for more as people like Susan Bradley wishes she had :-) However, a part of me wonders just how heavy the rock was. You know, the one that he was under since Microsoft started releasing service packs. As painful as the above is to read, and as painful as this...
  • BMS in the UK understands how to use the Business and Technology Assessment Toolkit - do you?

    I get asked about this quite a lot - so Microsoft has this thing, the "TAT". I've looked at it and it is just a bunch of questions. Yep, but you can change the questions and all the results are stored and if you know what you are doing, you can use it to build an IT strategy for your customers which means that you go back to them regularly and take their IT onto the next stage for their business. I don't think this is rocket science, but perhaps it is something that we don't do enough of - look for the opportunities in a programmatic way. Now of course, this could be a very slavish process, but at Steve says: The questions are now much more relevant to the SME market and you don’t feel so uncomfortable asking your customers. We don’t just run through all the questions one after the other but slot them in to the rest of the presentation. It feels less like the Spanish Inquisition that way! We’ve conducted several surveys so far and they don’t just have to be prospective customers. You can...
  • Whatever happened to FrontPage and what has it got to do with SharePoint Designer or Web Expression

    I seem to be being asked this a lot, so I thought I would pop up my simple answer: FrontPage has been both extended and then split into two products. We now have SharePoint Designer which is one child of FrontPage, but obviously ideally suited to modifying SharePoint (and OfficeLive) sites and then we have the “any type of web page editor” which is Expression Web. If you look at http://www.microsoft.com/products/expression/en/web_designer/fpwd_faq.mspx you will also see: How is Expression Web different from Microsoft Office FrontPage 2003? Expression Web builds on Microsoft Office FrontPage® 2003 technologies to provide an unprecedented level of support for creating standards-based Web sites. Valuable feedback from customers like you have helped us create a new product that fully supports Web standards such as Extensible Hypertext Markup Language (XHTML), cascading style sheets (CSS), and Extensible Markup Language (XML). If you are familiar with FrontPage, then you will find Expression Web easy to use. Expression...
  • SQL Server 2000 KB (Knowledge Base or Support) Articles

    SQL Server 2000 Standard Edition FIX: You may receive an assertion or database corruption may occur when you use the bcp utility or the "Bulk Insert" Transact-SQL command to import data in SQL Server 2000 http://support.microsoft.com/?kbid=933573 FIX: Error message when you use the sp_addarticle stored procedure to add articles to an existing transactional replication publication in SQL Server 2000: “Cannot create a file when that file already exists” http://support.microsoft.com/?kbid=932686 FIX: The Sqldumper.exe utility cannot generate a filtered SQL Server dump file when you use the Remote Desktop Connection service or Terminal Services to connect to a Windows 2000 Server-based computer in SQL Server 2000 http://support.microsoft.com/?kbid=928079 FIX: The sp_droparticle stored procedure performs very slowly if the @immediate_sync property is set to TRUE in SQL Server 2000 Service Pack 4 http://support.microsoft.com/?kbid=932674 SQL Server 2000 Analysis Services FIX: An access violation may occur...
  • Alistair likes Vista and found out that the Dell SATA drivers were making is go slow

    I was browsing the UKSBSG Yahoo Group (a group for UK Small Business Partners) when I noticed Alistair 's post in response to slow Vista systems and I thought I had to share: Hi, Just from experience, I had similar issues on Outlook 2007 and, to a lesser extent, Vista in general - especially on boot, which would take an age. I am using a Dell Dimension 9100, 2GB ram and SATA drives. One would think it would be pretty good, but behaved like a dog. The Microsoft fix made some little difference. What made a huge difference though was updating the SATA drivers on my Dell box. These were not listed under updates and I had to search for them, but it is chalk and cheese now. Persevere, once you have it right it's a dream: I have to say I love Vista, it is stable, runs all our legacy apps, line of business accounting apps, remote jobs and managed to blow away our desktop uptime record - still stable at 60 days uptime. XP struggled at 30. I do strongly suspect that naff drivers are a major factor in the bad press...
  • Windows XP and Windows Vista feature comparison for small businesses

    I saw this at http://www.microsoft.com/smallbusiness/products/wowpc/CompareWindows.aspx and thought this would be a great sales tool. While Vista has many new and unique features people often want to discuss how it compares to previous versions - this is a good place to start to go down that list. ttfn David Technorati Tags: Windows XP , Windows Vista , Comparison , Small Business
  • Quick Tip - how to run an application, but not let the writes go back to disk - try Sandboxie

    I have to admit I have not done any extensive testing, but this little tool seems like a good thing to have around! For more information, have a look at Sandboxie . About Sandboxie When you run a program on your computer, data flows from the hard disk to the program via read operations. The data is then processed and displayed, and finally flows back from the progam to the hard disk via write operations. For example, if you run the Freecell program to play a game, it starts by reading the previously recorded statistics, displaying and altering them as you play the game, and finally writing them back to disk for future reference. Sandboxie changes the rules such that write operations do not make it back to your hard disk. ttfn David Technorati Tags: Sandboxie , Tips , application testing
  • Sean Daniel on "Where's my next version of SBS?" - Cougar as was known

    I was browsing Vijay's blog and notices a link to Sean Daniel's blog discussing Cougar. While there are many details of Cougar still to be released and some I would imagine still to be decided, here are some of the most interesting things he said: There will be a migration too that will take you from your current SBS to Cougar on ANOTHER BOX. We are still working on this solution. The SBS Backup solution is being completely re-vamped. However, we have made the full switch, and the backup solution will no longer support backing up to tape. Using snapshot technology, the backups will be extremely quick using incrementals that can be scheduled as often as every 30 minutes. A copy of NTBackup will be able to extract files from the old SBS 2003 format, but no new data can be added. Cougar will need to be installed behind some kind of firewall and the single-NIC model will be the only mode. You must use a firewall in front of the SBS box, this can be a hardware router type item, or a software firewall such as...
  • Small Biz Thoughts by Karl Palachuk - advice on when to think about a 2nd server with SBS

    Some people still think that SBS only works in a 1 server environment, which is clearly not the case. Karl suggests that perhaps nothing more than SBS should run on an SBS box. Here is a little extract of his thoughts, but click on the link for more information. He might have a point!! "You can host your own internet site: web and email! In addition, you've got all the benefits of Server 2003 and Exchange! Firewall protection. Microsoft's most powerful database. Plus Remote Web Workplace and Sharepoint. And every one of these has been completely revamped and replaced in the last three years. It really is the best $600 product in history." "Golly Gee, Mr. Balmer, That's Swell!" Many people don't sell SBS Premium because . . . to be honest . . . we're already asking that little box with 4GB Max RAM to do an awful lot. Here are a few notes from a conversation with someone on the SBS development team. I don't have permission to attribute his comments, but I don't think...
  • What can Microsoft do to help your business as a Microsoft Partner

    It is rare that I copy a MS web page directly, but the information in here is amazing and worth spreading the news on. I found the Microsoft Partner Drive Your Business web site and not only does it have the information below. It also has references like " Read How a Partner Maintains 100% Growth Year After Year ". If you have seen one or two of them, don't fret - look at all six options and tell me if even one of them was a nice surprise for you. Are you looking for ways to strengthen your business performance? Find out how partners in the Microsoft Partner Programme are outperforming 12 out of 14 industry benchmarks through market differentiation. Find Out the Partner Pathway to Business Performance Is your company as profitable as it could be? Take a comprehensive assessment that measures your business performance across key indicators, including profit margins and revenue growth. Get Your Customised Business Report Increase your market visibility, generate sales leads, and promote your business...
1 2 3 Next >

(c)David Overton 2006-23