MS Ireland SQL 2008 R2, Office 2010 and SharePoint 2010 “Launch”

Today sees the the technical preview road show of Office 2010, Sharepoint 2010 and SQL 2008 R2 by Microsoft Ireland.  I’m attending the Dublin event and blogging the highlights.  You can still register for the Belfast, Cork and Galway events so make sure you attend if you can.  I’ll update this post as the afternoon moves along so come back later if you want to read more.

The event kicks off with Enda Flynn (Technical Audience Manager in the DPE team).  Enda tells us that the software will be available on volume licensing on May 12th and on the shelves in June.  The Office 2010 beta is stiff available and a Zune HD draw is running for people in Ireland.  Information about this is available when you download (check the site).

Office 2010

Patrick Herlihy is a partner technical specialist in MS Ireland focusing on the UC and BI stuff and will be up next.  The focus on his presentation is management, security and cost effectiveness.

Deployment Options

Lots of ways:

  • Install
  • Terminal services
  • App streaming
  • Web streaming

Server Integration:

Just a few examples:

  • Presence: Office Communication Server
  • Security: AD Rights Management Services
  • On premises hosting with SharePoint


This is now called SharePoint Workspace.  Very useful for sharing data with people outside of the office.  Has offline access.  I’ve used Groove once before on a collaboration project.  It’s a little different but it works well.

Services More Discoverable to End Users

  • End users can see services offered by IT through Office Backstage.
  • End users can also create their own applications in Excel and publish them to SharePoint.


There is online webcasting available.  Video is easier.


Lots of new stuff.  Mail tips, e.g. a warning if you try to send an email to all staff.  Conversation view is enabled by default.  Better integration with OCS.

Office Web Apps

You can use online versions of Office 2010.  You host this on premises with SharePoint.  It supports non-MS browsers.


Think of this as an expanded File menu that is better presented for end users.  Things are easier to find, whether it be the ability to save in another format or save to the SharePoint server – the latter was always an issue in the past.

SharePoint Workspace Offline

This will work with Office on Windows Mobile 6.5 or higher (or whatever it is called this week).  So now you can have docs on SharePoint, sync them to your laptop for home use, or even sync them to your phone for completely mobile use.  They’ll all sync with SharePoint.  The office, the firewall, and the organisation (forest membership) are no longer boundaries to secure data access.


The trend of attacks is that attacks is that they are increasingly attacking applications more than anything else.  The network and OS transport layers are at the bottom, i.e. least attacked.  Between them and applications are the core OS libraries.

Office 2010 has “increased security” – you’ll probably need to search to get the details.  All of this is manageable using GPO.  An example is Protected View.  Office 2010 can detect documents that are sourced from elsewhere and protect you from them.  You have to verify that the doc expected/OK before it has full functionality.

Document Inspector can be controlled using GPO.  It will run every time a doc is saved.

Accessibility Checker is exposed by Backstage.  This can run against documents (by policy) to ensure a document is accessible compliant.


Disk requirements go up by just 1.5GB from Office 2010.  All other requirements are the same.  There are native 32bit and 64bit versions.  Watch out for plugins on 64bit editions.  There is still a problem there.  32bit is still recommended.

It stats up very fast – event the old CTP does.

You can install using GPO startup scripts.  You cannot install using traditional MSI/transform via GPO like you could with XP/2003.  So it’s the same as with Office 2007.  Can install using ConfigMgr or App-V.  You will need App-V 4.6 (the latest version) if you want to do app virtualization for Office 2010.

As usual, there will be an extensive GPO management options.


Office now has the same licensing as Windows.  You use either a MAK or a KMS key.  *wait for you reaction here*

Deployment Planning

  • Use MAP v5.0 (still a beta on Connect) to assess readiness for Office 2010.
  • Office Environment Assessment Tool (OEAT) – checks 3rd party add-ins for compatibility.  It uses an online library to warn you.  It’s kind of a similar model as with ACT.
  • Office Compatibility Code Inspector (OCCI) – will inspect custom code that is written.
  • Office Migration Planning Manager – Identify macro issues, migrate office files to OpenXML


There is a pre-packaged “productivity hub” SharePoint site library with training content for end users. You can load it on SharePoint 2010 to teach users how to use SharePoint 2010 and Office 2010.

Office Ribbon Here is a new plug-in.  It’s a game of some sort to challenge and  teach users how to use the ribbon.  We have a few laughs here when Patrick shows us how little he uses MS Word for formatting :)  MS folks do live in Outlook after all.

SharePoint 2010

Aidan Nolan (they keep saying Aidan is up next and I keep double taking thinking WTF!!! I’m not presenting today!) from MS Ireland is up next.

Sales Pitch

  • Connect and empower people
  • Cut costs with a unified infrastructure
  • Rapidly respond to business needs

Gains for the IT Pros

IT productivity

  • Streamlined central admin
  • Management & health monitoring
  • PSH support

Scalable unified infrastructure:

  • Manage and control server resources – large list management
  • Improve data management and availability – high availability
  • Scalable services architecture

Flexible deployment:

  • Quick and simple installation and configuration – configuration wizards
  • Smooth and predictable upgrade – visual upgrade
  • Manage and control custom code – sandboxed solutions
  • Improved features – group policy block and AD marker

We now get a demo of functionality in SharePoint 2010.  Simple things like the ability to stretch an image, context sensitive ribbon, are big wins here, making it much more end user friendly.  The ribbon in SharePoint is just like an Office ribbon.  There is a theme gallery where you can easily update Office themes (templates).  Popups aren’t hidden away like previous versions of SharePoint.  The interface is much more responsive to mouse movement.  Fast Search brings back previews.  You can select the type of content you want to see, e.g. PowerPoint documents, people, etc.  There is a preview where the content can be browsed inline in the search results.  It also links to duplicate content.

Central administration is completely redesigned.  Health is front and centre.  You can see detected faults along with proposed resolution steps. 


  • 64 bit only – that’s the entire farm.  Dual CPU
  • 8GB minimum for a role
  • 80 GB disk minimum
  • SQL 2005 x64 SP 2 with CU 12, SP3 with CU 2
  • SQL 2008 x64 Std SP1 + KB970315
  • X64 W2008 SP2 Standard or W2008 R2 Std
  • There’s a crap load of s/w pre-requisites.  There is a pre-requisite tool to do all the detection work for you.  It will download and install all the bits required.  Nice time saver.


  • Prerequisites
  • Install the binaries
  • Configuration Wizard
  • Server Farm Configuration Wizard – a new tool to create new site collection and set up service accounts.


  • Silverlight 2
  • Level 1 browser like IE7.  Includes specified versions of Safari and FireFox.

Upgrade Path

  • In place upgrade: supposed to be next – next – next.  A restart of the process is possible.  All timeouts are removed – reported as a big problem before.  Sites are unavailable during upgrade and retain the URL after the upgrade.  Farm settings are inherited.  Customizations are retained.  Entire farm is offline for some time.
  • Database attach: Can attach content, SSP and Project.  Cannot attach Configuration or Search DB’s.  What you do is install an entirely new farm and attach to existing databases.  Can upgrade many content DB’s at once.  Can consolidate farms.  You lose settings and customizations from old farm(s).  It requires lots of engineering time and bandwidth.  You need direct access to the DB servers – problem in huge organizations where there are DBA teams/depts.
  • Hybrid: Do a bit of both in-place and attach.  Maintain settings and customizations.  Multiple content DB’s at once.  Requires time and direct access.

Gradual upgrade is not supported.  Note that you cannot upgrade from 32bit to 64bit.  That requires a migration.

Normally an upgrade retains the 2007 appearance.  You can do a visual appearance upgrade too.  It is a one way operation.

Introducing PowerPivot for Excel/SharePoint

By Bob Duffy MVP (SQL) and DB architect (not MS).  Bob is one of those guys with a big brain that makes you feel sick with jealousy.  Nice guy too.

The first bit is that you can bring in data into Excel 2010 from any source that you can get a data driver for.  It also can run MUCH more rows and data than previous versions.  The demo example has 1.4 million rows.  Data can be cleansed at the entry point into Excel.  Very useful because BI data can be a bit rough around the edges at times.  You can filter out unwanted fields too.  Bob runs through a demo and shows how flexible PowerPivot is for BI work with large volumes of data.  The demo is very, very cool.  Bob pulls in data from SQL, does graphing, slicing, selections and calculations (using macro) and then pulling in data from an RSS atom feed to join it.

You can save locally or save to SharePoint to share with others.  MIS will want to get involved here to assure that a BI application is valid.  And that’s possible thanks to the PowerPivot Gallery.  Admins can manage PP’s here.  And users can subscribe to them.

Bob went on to demonstrating the reporting capabilities of integrating with SQL 2008 R2.  He put together with (what seemed like) a few mouse clicks a map that subscribed to the PP data from the gallery.  It could even overlay a map from Bing.  Then he pulled data from an RSS atom feed from elsewhere and joined it to compare and contrast how one metric affected another.

EDC and Lanuages

The end of the day was with two guys from the EDC in Dublin.  One showed how you could integrate new languages into the Office hints.  The other showed a video of using SharePoint 2010 MUI’s.  An admin would install and enable a language.  Each user could then select the language of their choice in SharePoint.  That could be displayed on the fly in the interface, including the dialog boxes.

And that was the end of the session.  The evening was all aimed at developers so I skipped that.

Technorati Tags: ,,,

My Current Hyper-V & Writing Lab

I’m working on a couple of writing projects after work at the moment and I thought I’d talk a little bit about how I’m doing my lab work.  I’ve previously talked about how I’m using Hyper-V on my Dell E6500 laptop.  With a few projects going, you can imagine how far I’m pushing it!


At the moment, I’m using two laptop.  My old Sony Vaio is running Windows 7 and Microsoft Office 2007.  Why not 2010?  I’m using a customised ribbon that is version specific.  That allows me to use all the formatting that the publisher requires.

My Dell E6500 (Dual Core CPU, 8GB RAM) is running Windows Server 2008 R2 Datacenter edition from an 7200 RPM 250GB eSATA hard disk.  Normally it boots from Windows 7 using the internal hard disk.  But I’ve set up the BIOS to boot from eSATA first if it is found.  On there, I’ve enabled the Hyper-V role, configured the machine as a domain controller and installed VMM 2008 R2.  None of that is good production practice!  DNS is also enabled on the parent partition and uses forwarders for Internet name resolution.

The laptops are on my wifi network at home.  Hyper-V does not support wifi for virtual machine networking.  However, there’s a well known way to create an internal virtual network and bridge it with the wifi NIC in the parent partition.

I started out keeping my VM’s in a folder on the C: drive.  However, 250GB runs out pretty quick.  Compressing the VMM library did help a bit here.  I ended up using a USB 2.0 external drive for additional space.  Sure the performance sucks, but I’m doing lab work, not production server hosting!

The laptop has 8GB of RAM.  I want to make the very most of every MB of RAM.  So I enable RDP on my VM’s. That way I don’t even have to log into the Hyper-V laptop once things are up and running.

This allows me to work away on the documentation on my Vaio.  I can RDP from there onto my VM’s which are on the same network (with static IP’s).  I’m using a tool called MWSnap to capture screenshots to TIF files.  They auto save to a shared folder on the parent partition, which I copy over to the VAIO every now and then.

As much as I can squeeze out of this, I’m realistically looking at deploying more hardware.  I’m still going back and forth on pulling the trigger on that purchase.

Office/SharePoint and Visual Studio 2010 Launch Events

The official MS Ireland launch events for Office 2010/SharePoint 2010 and Visual Studio 2010 will be taking place this month.  You can find more details on the MS Ireland IT Pro blog:

It’s another road show like the last few events so you folks in Cork should expect some very tired people.  I’m not participating but I might be around on the afternoon of the 12th to meet some people who might be flying in.

Microsoft Ireland Partner Community Expert Event

I’m attending this day long event and will try to blog as I go along.

Morning Introduction

Conor Whickam, Partner Manager at Microsoft Ireland, opens the day to introduce the agenda.  This is meant to be an interactive session.  I was a bold boy at one of these this time last year so I’m shutting up.  I can hear sighs of relief.

Paul Rellis

Paul Rellis, the GM of Microsoft Ireland takes over with a keynote.  The theme is Microsoft = Productivity.  I guess this is a Business Intelligence year.  He starts talking about a famous human cannon ball called Armando?  The ringmaster was asked why he wasn’t replaced after he died.  It’s because he could find a person of the right calibre.  *Boom Boom*  MS invests in their people and “in their partners”.  MS wants partners to invest in their own staff as MS develops their staff.

The message about Azure/BPOS comes out.  Your two options are to install on premise or to install on Azure.  It’s a partner event but the hosting partners have already been had their ankles slashed.  MS needs to rethink that message.  Plenty of hosters are already pushing Linux more than Windows.  MS jacks up SPLA licensing costs (going up this year, at the end of each annual contract) while competing with their partners with aggressive sales.  CentOS and LAMP will continue to dominate the online market.

State of the Irish Market

Richard Moore now takes over to talk about the state of the Irish Market.  The opportunities include upgrade projects and end of life projects.

On the PC side:

  • 2010 will continue to see a decline until the second half of the year.  The low will be at 2005 levels.
  • Retail is continuing to take market share, growing by 10%
  • Up to 10% of national PC sales will be through the National Educational PC deal
  • Netbooks have not been as successful as predicted.  That’s because notebooks and netbooks do not have a great price differential.  However Telco’s may offer them at discount prices in combination with mobile broadband contracts.


  • Sales down from 40,000 to 30,000
  • IDC predicts another decline in 2010.  This may level out in 2011.
  • A spike in sales (to Dell, not HP!) in 2009 was caused by the MS data centre.


  • 2009 saw a massive slowdown with 4% drop.
  • 2010 predicting a .7% increase.
  • 2011 expected to be around 3.4%

The overall levels are back to 2005 numbers.  2010 will see small decrease or a levelling out.

New opportunities

  • Exchange 2010, Office 2010, SharePoint 2010
  • Server: upgrades and low end (continuing to sell)
  • Cloud computing


  • Lots of old deployments still out there.  70% of E2003 or older.
  • E2010 “offers cost savings” and productivity improvements.
  • Easier to support and maintain.
  • Access anywhere is a mature solution.
  • €15m in upgrade business out there.

Office 2010:


Current installation figures are:

  • Office 2007 (and Office 2010 Beta/RC) is at 30.1% of the Irish market
  • Office 2003 at 29.4%
  • Office 2000 is at 12.0%
  • Office XP 23.3%
  • Office 2000: 12%
  • Office 95/97: 1.4%
  • Other MS Office 1.2%
  • Non-MS products: 1.6%

Office and SharePoint go hand in hand and drive each others sales.

Server opportunities:

  • Windows 2000 end of life on July 13th
  • Virtualisation with Hyper-V very attractive

Server 2008 R2 Foundation:

The Irish market is dominated by small companies.  Server 2008 R2 Foundation would appear to fit in.  However, I don’t know about the fit.  The Irish SME is very happy with SBS.  EBS has been a flop here.

We now get the pitch on Forefront and how it is a future investment for partners.  Again, the Irish SME is stuck in yellow-box land.

Windows 7 Plans: 41% will be running Windows 7 by end of 2011

Now we get the BPOS talk.  See my previous posts on the Patriot Act.  Many are using BPOS as a complimentary add-on to their onsite installation.  For example, some users will use online service, IM will be used, etc.

He reckons there is a niche market for SAM (software asset management).  This is related to auditing and licensing compliance.  You’ll be as popular as a taxation auditor with IT on the customer site but you might make some money.

Partner Sales + Strategy

Karl O’Leary (Partner Sales) and Colin Cassidy (Partner Strategy and Program) now take over.

Colin says that their forecasts are usually pretty accurate.  Again, I’m asking that MS Ireland takes over running the country.  Paul Rellis does more for Irish business than our glorious leader, Brian Cowen.  And anyone who can crunch numbers anyway accurately is better than the Department of Finance. 

Some boring stuff now.  Taking a breather.

MS focusing on virtualisation and Exchange this year when it comes to the partner campaigns:

When you talk about Exchange leads to a conversation about the desktop.  That’s Office 2010.  That leads to Windows 7 and IE8.  Exchange will run on Server 2008/2008 R2.  It might be virtualised and that leads to Hyper-V.  This all needs security: ForeFront.  ForeFront is developed hand-in-hand with Exchange.  Then System Center is used to manage everything.  Don’t stop there.  Push productivity: Then you have Unified Communications (OCS) and SharePoint.  When you do OCS/Exchange then you talk about mobility, e.g. Smart Phones running Windows Mobile.  BTW, there’s something happening with Ballmer next week. 

MS Ireland going after VMware compete business with everything they have.  There is a pincer movement including HP and Dell.  Partners can choose the Bush principle: “You’re either with us or against us”.

4,000 Exchange upgrades are out there in Ireland now.  176,000 XP installations with support ending.  14,583 Windows 2000 installations with support ending.  That’s business to be had.

Partners Presenting

Gerry Kerr from CDsoft, Hyper-V and UC are their things.  Scott from Nitech are an infrastructure/dev partner working in BI.  A dude, Frasier, from Ergo as well.  They are field engineers who also say they do BI.  Oh boy, flashbacks of an awful part of the TechEd 2010 keynote.  I’m watching the doors to see if people are leaving … oh there we go 🙂

Gerry says something that I’ve been saying for over a year.  Hyper-V wins against VMware when you sell System Center, not virtualisation.  It’s the manageability that wins.

Louise Connaughton, EMEA Partner Support Group

Some stuff about what services you get as a partner.  That led into a coffee break which was sorely needed.

The Office / SharePoint Launch Wave

The 3 pillars of the combined solution are:

  • Best user experience: desktop, VDI, terminal services, phone, etc.  Office will also be online.  You can “round trip” between online Office and on-site office with document fidelity.
  • IT Choice: on site or online
  • Business Platform: Office, SharePoint, Dynamics, SQL, partners like Siebel and SAP

MS claims the ribbon is responsible for users using 4 times more features in Office 2007 than they did in 2003.  The ribbon is fully deployed in Office 2010.

2010 Launch

  • Partner readiness day (sales and marketing)
  • Partner IT road show in Dublin, Belfast, Shannon and Cork – similar to the Windows 7/Server 2008 R2/Exchange 2010 launch tour
  • A v-Launch

2010 PR:

  • nWOW microsite release
  • eBook with production quality video

Patrick Herlihy Demo

Patrick is the Exchange/BI techie in MS Ireland partner sales.  He’s now doing a demo of XP/Office 2003 VS Windows 7/Office 2010.

Barry McMahon

Barry (a MS sales person – Application Platform Lead) now talks about SharePoint’s role in BI.  Excel is the most valuable client application – agreed. I worked in a company where over 50% of business data was in spreadsheets.

Three contexts of BI

  • Organisational BI: Built and maintained by IT, for use by the company
  • Team BI: Built by the team, for the team
  • Personal BI: Built by me, for use by me (Excel lives here)

Excel (PowerPivot) with SQL enables and empowers that last one.  It’s made easier by PowerPivot.  Now you have an application. (you can add something called a Slicer to allow data selectivity).  That application can be published to SharePoint.  Here’s where your MIS department will pull their hair out, worried about application/data accuracy.

Here’s the pitch for WPC10 July 11-15th in Washington DC.  MS wants your money.


They broke us up into 4 groups for lunch so 4 different MS teams could come in to do Q&A sessions.  The first one was funny; I was a bold boy last year and we joked about it a bit.  I skipped the last one; the speaker’s voice goes through me like a rusty blade.

The rest of the day is being broken into different tracks.  I was going to skip the virtualisation track – there’s nothing I can learn about the MS line.  However, they have Citrix in and I’d like to learn what they’re up to.  Spoke to some person during the week from Citrix.  She wanted to hear my opinion on their message.  It’s now my stock answer: “Too much marketing; just tell me what the damned thing does because neither your site nor your presentations do”.  So here I am sat waiting for the virtualisation session.

I will do those sessions as different posts.

Office 2010 System Requirements

Curious about the hardware and operating system requirements for Office 2010?  Microsoft recently blogged about them.

The minimum hardware requirements are:


That is minimum.  Basically it’ll run but not great.  MS puts it this way.  If you’re running Office 2007 then you’ll be able to run Office 2010.  If you’re running Office 2003 there’s a good chance you can run Office 2010 (see above image).  If you have a dual (or more) core CPU Office 2010 will run fine.  New PC’s will run if superbly.

I’ve been running the CTP (pre beta) on a year old low-ish end Dell laptop.  It’s runs pretty well on that.

What about the operating systems?

Table of 32-bit operating systems that 32-bit Office 2010 supports.  Everything in the table is supported.  Those Operating systems are Windows 7, Windows Vista SP1, Windows XP SP3, Windows Server 2008, Windows Server 2003 R2 with MSXML 6.0.

Table of 64-bit operating systems. Those Operating systems are Windows 7, Windows Vista SP1, Windows XP SP3, Windows Server 2008, Windows Server 2003 R2 with MSXML 6.0.  32-bit Office 2010 is supported on all.  64-bit Office 2010 is supported on all except Windows Server 2003 R2 with MSXML 6.0

As you can see, Office 2010 will be the first version to have x86 and x64 versions.  Pretty much anyone buying Windows 7 on an OEM PC is 64-bit now.  And Windows Server 2008 R2 is 64-bit only.

Search Server 2008

I’ve never heard of this one before but it turned up on the Microsoft downloads last night.  Server Server 2008 Express is a free product you can download and install.

Search doesn’t have to be complicated
Bring enterprise search to your organization quickly and easily for FREE with Microsoft® Search Server 2008 Express. As an IT professional, you need a search solution that allows you to deliver the simple, easy-to-use experience your users expect while helping to meet the security and manageability requirements your IT environment demands. The download on this page has been updated to include Service Pack 2.
Note: In order to install Search Server 2008 Express on Windows Server 2008 R2, you must use this download. Previously available versions will not install.
Product Highlights
Quick to download and set up

  • Reduce your risk in choosing a search solution by starting with a free, full application you can download and set up to meet your needs immediately
  • Go from downloading to searching in minutes with a streamlined setup process

Easy to configure and maintain

  • Review common administrative tasks, search status, and settings in a single view
  • Manage content sources and search scopes, authoritative sources, key words, best bets, and other configurable relevancy settings through a powerful, easy-touse management console
  • Index common information sources with Indexing Connectors for file servers, Web sites, Microsoft SharePoint® sites, Microsoft Exchange Server public folders, as well as EMC Documentum, IBM FileNet, and Lotus Notes repositories
  • Monitor search performance and improve search relevance with query and results reporting
  • Help ensure that only the right people can find information with a search engine that utilizes your user authentication infrastructure for enhanced security

Powerful enough to meet your search needs

  • Empower your users to quickly find the information they need through a familiar, Web search-style interface
  • Deploy a search capability optimized for business data to deliver highly relevant results across intranet and public-facing Web site content
  • Scale your deployment to meet your needs with no preset document limits and continuous index propagation
  • Easily upgrade to a multiserver topology with Microsoft Search Server 2008 or Microsoft Office SharePoint Server 2007 as your enterprise search needs evolve

For more information on Microsoft enterprise search products, please visit

There also appears to be a commercial product offering more functionality.