{"id":10515,"date":"2010-04-12T13:25:24","date_gmt":"2010-04-12T13:25:24","guid":{"rendered":"https:\/\/aidanfinn.com\/?p=10515"},"modified":"2010-04-12T13:25:24","modified_gmt":"2010-04-12T13:25:24","slug":"ms-ireland-sql-2008-r2-office-2010-and-sharepoint-2010-launch","status":"publish","type":"post","link":"https:\/\/aidanfinn.com\/?p=10515","title":{"rendered":"MS Ireland SQL 2008 R2, Office 2010 and SharePoint 2010 \u201cLaunch\u201d"},"content":{"rendered":"<p>Today sees the the technical preview road show of Office 2010, Sharepoint 2010 and SQL 2008 R2 by Microsoft Ireland.&#160; I\u2019m attending the Dublin event and blogging the highlights.&#160; You can still register for the Belfast, Cork and Galway events so make sure you attend if you can.&#160; I\u2019ll update this post as the afternoon moves along so come back later if you want to read more.<\/p>\n<p>The event kicks off with Enda Flynn (Technical Audience Manager in the DPE team).&#160; Enda tells us that the software will be available on volume licensing on May 12th and on the shelves in June.&#160; The Office 2010 beta is stiff available and a Zune HD draw is running for people in Ireland.&#160; Information about this is available when you download (check the site).<\/p>\n<h5><strong><u>Office 2010<\/u><\/strong><\/h5>\n<p>Patrick Herlihy is a partner technical specialist in MS Ireland focusing on the UC and BI stuff and will be up next.&#160; The focus on his presentation is management, security and cost effectiveness.<\/p>\n<p><strong>Deployment Options<\/strong><\/p>\n<p>Lots of ways:<\/p>\n<ul>\n<li>Install <\/li>\n<li>Terminal services <\/li>\n<li>App streaming <\/li>\n<li>Web streaming <\/li>\n<\/ul>\n<p><strong>Server Integration:<\/strong><\/p>\n<p>Just a few examples:<\/p>\n<ul>\n<li>Presence: Office Communication Server <\/li>\n<li>Security: AD Rights Management Services <\/li>\n<li>On premises hosting with SharePoint <\/li>\n<\/ul>\n<p><strong>Groove<\/strong><\/p>\n<p>This is now called SharePoint Workspace.&#160; Very useful for sharing data with people outside of the office.&#160; Has offline access.&#160; I\u2019ve used Groove once before on a collaboration project.&#160; It\u2019s a little different but it works well.<\/p>\n<p><strong>Services More Discoverable to End Users<\/strong><\/p>\n<ul>\n<li>End users can see services offered by IT through Office Backstage. <\/li>\n<li>End users can also create their own applications in Excel and publish them to SharePoint. <\/li>\n<\/ul>\n<p><strong>PowerPoint<\/strong><\/p>\n<p>There is online webcasting available.&#160; Video is easier.<\/p>\n<p><strong>Outlook<\/strong><\/p>\n<p>Lots of new stuff.&#160; Mail tips, e.g. a warning if you try to send an email to all staff.&#160; Conversation view is enabled by default.&#160; Better integration with OCS.<\/p>\n<p><strong>Office Web Apps<\/strong><\/p>\n<p>You can use online versions of Office 2010.&#160; You host this on premises with SharePoint.&#160; It supports non-MS browsers.<\/p>\n<p><strong>Backstage<\/strong><\/p>\n<p>Think of this as an expanded File menu that is better presented for end users.&#160; Things are easier to find, whether it be the ability to save in another format or save to the SharePoint server \u2013 the latter was always an issue in the past.<\/p>\n<p><strong>SharePoint Workspace Offline<\/strong><\/p>\n<p>This will work with Office on Windows Mobile 6.5 or higher (or whatever it is called this week).&#160; 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.&#160; They\u2019ll all sync with SharePoint.&#160; The office, the firewall, and the organisation (forest membership) are no longer boundaries to secure data access.<\/p>\n<p><strong>Security<\/strong><\/p>\n<p>The trend of attacks is that attacks is that they are increasingly attacking applications more than anything else.&#160; The network and OS transport layers are at the bottom, i.e. least attacked.&#160; Between them and applications are the core OS libraries.<\/p>\n<p>Office 2010 has \u201cincreased security\u201d \u2013 you\u2019ll probably need to search to get the details.&#160; All of this is manageable using GPO.&#160; An example is Protected View.&#160; Office 2010 can detect documents that are sourced from elsewhere and protect you from them.&#160; You have to verify that the doc expected\/OK before it has full functionality.<\/p>\n<p>Document Inspector can be controlled using GPO.&#160; It will run every time a doc is saved.<\/p>\n<p>Accessibility Checker is exposed by Backstage.&#160; This can run against documents (by policy) to ensure a document is accessible compliant.<\/p>\n<p><strong>Deployment<\/strong><\/p>\n<p>Disk requirements go up by just 1.5GB from Office 2010.&#160; All other requirements are the same.&#160; There are native 32bit and 64bit versions.&#160; Watch out for plugins on 64bit editions.&#160; There is still a problem there.&#160; 32bit is still recommended.<\/p>\n<p>It stats up very fast \u2013 event the old CTP does.<\/p>\n<p>You can install using GPO startup scripts.&#160; You cannot install using traditional MSI\/transform via GPO like you could with XP\/2003.&#160; So it\u2019s the same as with Office 2007.&#160; Can install using ConfigMgr or App-V.&#160; You will need App-V 4.6 (the latest version) if you want to do app virtualization for Office 2010.<\/p>\n<p>As usual, there will be an extensive GPO management options.<\/p>\n<p><strong>Licensing<\/strong><\/p>\n<p>Office now has the same licensing as Windows.&#160; You use either a MAK or a KMS key.&#160; *wait for you reaction here*<\/p>\n<p><strong>Deployment Planning<\/strong><\/p>\n<ul>\n<li>Use MAP v5.0 (still a beta on Connect) to assess readiness for Office 2010. <\/li>\n<li>Office Environment Assessment Tool (OEAT) \u2013 checks 3rd party add-ins for compatibility.&#160; It uses an online library to warn you.&#160; It\u2019s kind of a similar model as with ACT. <\/li>\n<li>Office Compatibility Code Inspector (OCCI) \u2013 will inspect custom code that is written. <\/li>\n<li>Office Migration Planning Manager \u2013 Identify macro issues, migrate office files to OpenXML <\/li>\n<\/ul>\n<p><strong>Training<\/strong><\/p>\n<p>There is a pre-packaged \u201cproductivity hub\u201d 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.<\/p>\n<p>Office Ribbon Here is a new plug-in.&#160; It\u2019s a game of some sort to challenge and&#160; teach users how to use the ribbon.&#160; We have a few laughs here when Patrick shows us how little he uses MS Word for formatting :)&#160; MS folks do live in Outlook after all.<\/p>\n<h4><\/h4>\n<h4><u>SharePoint 2010<\/u><\/h4>\n<p>Aidan Nolan (they keep saying Aidan is up next and I keep double taking thinking WTF!!! I\u2019m not presenting today!) from MS Ireland is up next.<\/p>\n<p><strong>Sales Pitch<\/strong><\/p>\n<ul>\n<li>Connect and empower people <\/li>\n<li>Cut costs with a unified infrastructure <\/li>\n<li>Rapidly respond to business needs <\/li>\n<\/ul>\n<p><strong>Gains for the IT Pros<\/strong><\/p>\n<p>IT productivity<\/p>\n<ul>\n<li>Streamlined central admin <\/li>\n<li>Management &amp; health monitoring <\/li>\n<li>PSH support <\/li>\n<\/ul>\n<p>Scalable unified infrastructure:<\/p>\n<ul>\n<li>Manage and control server resources \u2013 large list management <\/li>\n<li>Improve data management and availability \u2013 high availability <\/li>\n<li>Scalable services architecture <\/li>\n<\/ul>\n<p>Flexible deployment:<\/p>\n<ul>\n<li>Quick and simple installation and configuration \u2013 configuration wizards <\/li>\n<li>Smooth and predictable upgrade \u2013 visual upgrade <\/li>\n<li>Manage and control custom code \u2013 sandboxed solutions <\/li>\n<li>Improved features \u2013 group policy block and AD marker <\/li>\n<\/ul>\n<p>We now get a demo of functionality in SharePoint 2010.&#160; Simple things like the ability to stretch an image, context sensitive ribbon, are big wins here, making it much more end user friendly.&#160; The ribbon in SharePoint is just like an Office ribbon.&#160; There is a theme gallery where you can easily update Office themes (templates).&#160; Popups aren\u2019t hidden away like previous versions of SharePoint.&#160; The interface is much more responsive to mouse movement.&#160; Fast Search brings back previews.&#160; You can select the type of content you want to see, e.g. PowerPoint documents, people, etc.&#160; There is a preview where the content can be browsed inline in the search results.&#160; It also links to duplicate content.<\/p>\n<p>Central administration is completely redesigned.&#160; Health is front and centre.&#160; You can see detected faults along with proposed resolution steps.&#160; <\/p>\n<p><strong>Requirements<\/strong><\/p>\n<ul>\n<li>64 bit only \u2013 that\u2019s the entire farm.&#160; Dual CPU <\/li>\n<li>8GB minimum for a role <\/li>\n<li>80 GB disk minimum <\/li>\n<li>SQL 2005 x64 SP 2 with CU 12, SP3 with CU 2 <\/li>\n<li>SQL 2008 x64 Std SP1 + KB970315 <\/li>\n<li>X64 W2008 SP2 Standard or W2008 R2 Std <\/li>\n<li>There\u2019s a crap load of s\/w pre-requisites.&#160; There is a pre-requisite tool to do all the detection work for you.&#160; It will download and install all the bits required.&#160; Nice time saver. <\/li>\n<\/ul>\n<p><strong>Process<\/strong><\/p>\n<ul>\n<li>Prerequisites <\/li>\n<li>Install the binaries <\/li>\n<li>Configuration Wizard <\/li>\n<li>Server Farm Configuration Wizard \u2013 a new tool to create new site collection and set up service accounts. <\/li>\n<\/ul>\n<p><strong>Client<\/strong><\/p>\n<ul>\n<li>Silverlight 2 <\/li>\n<li>Level 1 browser like IE7.&#160; Includes specified versions of Safari and FireFox. <\/li>\n<\/ul>\n<p><strong>Upgrade Path<\/strong><\/p>\n<ul>\n<li>In place upgrade: supposed to be next \u2013 next \u2013 next.&#160; A restart of the process is possible.&#160; All timeouts are removed \u2013 reported as a big problem before.&#160; Sites are unavailable during upgrade and retain the URL after the upgrade.&#160; Farm settings are inherited.&#160; Customizations are retained.&#160; Entire farm is offline for some time. <\/li>\n<li>Database attach: Can attach content, SSP and Project.&#160; Cannot attach Configuration or Search DB\u2019s.&#160; What you do is install an entirely new farm and attach to existing databases.&#160; Can upgrade many content DB\u2019s at once.&#160; Can consolidate farms.&#160; You lose settings and customizations from old farm(s).&#160; It requires lots of engineering time and bandwidth.&#160; You need direct access to the DB servers \u2013 problem in huge organizations where there are DBA teams\/depts. <\/li>\n<li>Hybrid: Do a bit of both in-place and attach.&#160; Maintain settings and customizations.&#160; Multiple content DB\u2019s at once.&#160; Requires time and direct access. <\/li>\n<\/ul>\n<p>Gradual upgrade is not supported.&#160; Note that you cannot upgrade from 32bit to 64bit.&#160; That requires a migration.<\/p>\n<p>Normally an upgrade retains the 2007 appearance.&#160; You can do a visual appearance upgrade too.&#160; It is a one way operation.<\/p>\n<p><strong><u>Introducing PowerPivot for Excel\/SharePoint<\/u><\/strong><\/p>\n<p>By Bob Duffy MVP (SQL) and DB architect (not MS).&#160; Bob is one of those guys with a big brain that makes you feel sick with jealousy.&#160; Nice guy too.<\/p>\n<p>The first bit is that you can bring in data into Excel 2010 from any source that you can get a data driver for.&#160; It also can run MUCH more rows and data than previous versions.&#160; The demo example has 1.4 million rows.&#160; Data can be cleansed at the entry point into Excel.&#160; Very useful because BI data can be a bit rough around the edges at times.&#160; You can filter out unwanted fields too.&#160; Bob runs through a demo and shows how flexible PowerPivot is for BI work with large volumes of data.&#160; The demo is very, very cool.&#160; 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.<\/p>\n<p>You can save locally or save to SharePoint to share with others.&#160; MIS will want to get involved here to assure that a BI application is valid.&#160; And that\u2019s possible thanks to the PowerPivot Gallery.&#160; Admins can manage PP\u2019s here.&#160; And users can subscribe to them.<\/p>\n<p>Bob went on to demonstrating the reporting capabilities of integrating with SQL 2008 R2.&#160; He put together with (what seemed like) a few mouse clicks a map that subscribed to the PP data from the gallery.&#160; It could even overlay a map from Bing.&#160; Then he pulled data from an RSS atom feed from elsewhere and joined it to compare and contrast how one metric affected another.<\/p>\n<p><strong><u>EDC and Lanuages<\/u><\/strong><\/p>\n<p>The end of the day was with two guys from the EDC in Dublin.&#160; One showed how you could integrate new languages into the Office hints.&#160; The other showed a video of using SharePoint 2010 MUI\u2019s.&#160; An admin would install and enable a language.&#160; Each user could then select the language of their choice in SharePoint.&#160; That could be displayed on the fly in the interface, including the dialog boxes.<\/p>\n<p>And that was the end of the session.&#160; The evening was all aimed at developers so I skipped that.<\/p>\n<\/p>\n<div style=\"padding-bottom: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; float: none; padding-top: 0px\" id=\"scid:0767317B-992E-4b12-91E0-4F059A8CECA8:5f4dd175-cdb8-4ab5-91eb-3becf0a7e99b\" class=\"wlWriterEditableSmartContent\">Technorati Tags: <a href=\"http:\/\/technorati.com\/tags\/Events\" rel=\"tag\">Events<\/a>,<a href=\"http:\/\/technorati.com\/tags\/Office\" rel=\"tag\">Office<\/a>,<a href=\"http:\/\/technorati.com\/tags\/SharePoint\" rel=\"tag\">SharePoint<\/a>,<a href=\"http:\/\/technorati.com\/tags\/SQL\" rel=\"tag\">SQL<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Today sees the the technical preview road show of Office 2010, Sharepoint 2010 and SQL 2008 R2 by Microsoft Ireland.&#160; I\u2019m attending the Dublin event and blogging the highlights.&#160; You can still register for the Belfast, Cork and Galway events so make sure you attend if you can.&#160; I\u2019ll update this post as the afternoon &hellip; <a href=\"https:\/\/aidanfinn.com\/?p=10515\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;MS Ireland SQL 2008 R2, Office 2010 and SharePoint 2010 \u201cLaunch\u201d&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[15],"tags":[177,186,191,192],"class_list":["post-10515","post","type-post","status-publish","format-standard","hentry","category-events","tag-events","tag-office","tag-sharepoint","tag-sql"],"aioseo_notices":[],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/10515","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10515"}],"version-history":[{"count":0,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/10515\/revisions"}],"wp:attachment":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}