Office 365 Released to General Availability

June 28th, 2011 -- by John Ano

This morning, Steve Ballmer announced that Office 365, which includes SharePoint Online, has been released worldwide for general availability today.

Office 365 is Microsoft’s newest offering in the cloud. It combines the Office application suite, SharePoint Online, Exchange Online and Lync. It improves and expands on the successful Business Productivity Online Suite (BPOS).

Ballmer focused on the small and medium business segment as an important target market for Office 365, citing a statistic that segment of businesses are responsible for two-thirds of job growth.

The demo started with SharePoint Online and Office integration, showing off co-authoring in real time, so that changes one author makes to a Word document can be seen by another author as edits are being made. That demo also showed ubiquitous access and collaboration via Office Web Apps and the PC-based rich client.

Microsoft also demonstrated One Note with Windows 7, again showing how real-time collaboration is done with Office 365 cloud services. Microsoft indicated that iPhone and Android devices can also access Office 365.

Virtual conferencing with Lync was showcased with a demonstration of full audio-video conferencing with desktop collaboration on shared documents. Lync is the successor to LiveMeeting and Office Communicator.

Web site authoring for small businesses using predefined template and the Office Ribbon showed the ease of in-place editing, allowing users to edit their web site pages just like they would edit a Word document.

bluLink has run much of its own IT infrastructure on BPOS since 2009, employing a mix cloud services well as on-premise versions of SharePoint 2007 and SharePoint 2010. We’ve been working with Office 365 beta, and are in the process of migrating our infrastructure from BPOS to Office 365.

As a Microsoft Partner, bluLink helps small and medium companies adopt and capitalize upon business productivity solutions based on SharePoint and Office 365. A summary of our services can also be found on Pinpoint, a service directory of Microsoft Partners.

For more information on Office 365 visit http://office365.microsoft.com.

Posted in Announcements, Cloud Services, Office 365, SharePoint 2010 | No Comments »

Access Services, SharePoint 2010

November 16th, 2010 -- by John Ano

For years, small and medium business users needing desktop database capabilities have turned to Microsoft Access. Over the product’s 18 year history, Access has developed a great combination of performance and functionality. On the flip side, as a desktop database Access has its own challenges bridging over from the desktop to the web paradigm. It takes a lot of work to share and manage a database with a large number of users using a custom web front end. You’d typically need to set up an IIS web server and develop with ASP.NET to build the web application, pages, forms and scripts.

With Access 2010 and SharePoint 2010 Access Services, sharing an Access database application to a large number of users just got a lot easier. Just publish the database to a SharePoint site with a few simple steps. Well, this is more likely the case for smaller, simpler database migrations. Caveats aside, Microsoft offers recommendations to support those larger more complex database applications too.

If you’ve worked with Access in SharePoint 2007, you know that the entire database file saved as a file in the document library and database tables were converted into SharePoint lists on the server. This integration model works best on small databases with small user bases. SharePoint 2010 and Access 2010 improve the integration model with better database centralization, web access, manageability and even performance to expand the range of integration scenarios. With this latest round of improvements, organizations have a lot more opportunity to leverage existing investments in Access.

You can now choose varying degrees of integration depending on the complexity of your existing Access database. In the simplest case, Access 2010 can push a database directly into SharePoint lists. This is largely unchanged from how Access 2007 published databases to MOSS 2007. All of the user interface elements like queries, forms and reports remain in their native format within the ACCDB file. With the database tables now in SharePoint lists, users can leverage SharePoint’s data management services like versioning, permissions and the recycle bin. Users can also perform normal SharePoint operations on those database tables, just as they would with any other SharePoint list. In this simple-case scenario, the ACCDB database file, which still contains the interface components, is uploaded to a SharePoint document library just as in the SharePoint 2007 paradigm. The key difference with Access 2010 is in improved performance, specifically with local caching. The Access client application is still where the majority of user interaction will occur. The biggest benefit of moving to SharePoint in this scenario is taking advantage of the centralized services available to the database tables that now reside on the server.

Taking integration between Access 2010 and SharePoint 2010 to the next level is where the power of Access Services comes in. In this more advanced scenario, the front-end Access interface components (queries, forms, and reports) now run on the SharePoint Server as components within the Access Services application model. Using the Publish to SharePoint wizard, compatibility checks are run to ensure that tables and integrated components are configured to work within SharePoint’s application model requirements. Once compatibility tests are passed, database tables are still pushed to SharePoint lists, a new SharePoint site is created for the published database, and the interface components now run in the context of Access Services on the SharePoint Server. Once the database has been successfully published to the server, you now have the ability to extend the functionality of your Access database using SharePoint’s web capabilities to broaden the reach of your data to users across the network , AND still retain the ability to work with your data using the rich Access client application. This hybrid usage model is going to be the migration path of choice for many organizations because the web interface supports a core subset of database functions, so the client application still plays an important role for a number of users. Modifying the design of a published database also requires the Access application and but you’ll still use the browser to make structural changes to the underlying SharePoint lists.

Are you considering migrating your Access database application to SQL Server? This might be a recommended migration path if the complexity of your Access database poses compatibility problems with SharePoint. This too is a supported migration path in SharePoint 2010. If your organization has a shared SQL Server available, you can migrate your complex database tables to SQL, and still integrate your Access database interface components with SharePoint Access Services. Smaller organizations that may not have the resources to support a standalone SQL Server for this purpose may choose to leverage the SQL Server supporting the SharePoint farm. As a best practice, the database server behind the SharePoint farm should be dedicated for SharePoint data only to limit risk of another application downing the server and possibly losing or corrupting data. Some organizations do support shared SQL Servers, and you may have to ensure compliance with IT policy and governance as part of an approved migration. Another point to consider is licensing — depending on your application usage model (which users, which devices) your SQL Server client licensing requirements may also change.

SharePoint 2010 gives business users the ability to build their own database applications using Microsoft Access 2010, affording them administrative control of their own database application within the robust functionality, security and permissions model of SharePoint. IT administrators also win because database applications can be centrally supported and managed to a consistent service level. Through the CA UI and PowerShell scripts, IT administrators can monitor and tune the performance of Access Services to ensure operational conformance to the desired service level.

Requirements

SharePoint Server 2010 Enterprise is required. Neither SharePoint Foundation nor the Standard edition support Access Services.
SQL Server 2008 R2 Reporting Services add-in is also required.
Enterprise CALs are also needed.
SQL Server 2008 R2 Report Server may also need to be deployed depending on business requirements. Small deployments with a single web front end server can run a lightweight version or “Local Mode” configuration that only requires the installation of the SSRS add-in to the SharePoint deployment, but limits users to viewing reports. The default configuration recommended for Reporting Services is known as Connected Mode and requires SQL Server 2008 R2 Report Server to be deployed in addition to the SSRS add-in.

A quick note about Access and the new Office Web Application offering — even though Access is part of the Office Professional Suite, Access Services and SharePoint’s integration with the Access client have no relationship to the Office Web Application offering. Office Web Applications are online versions of Word, Excel, PowerPoint and OneNote. Office Web Apps are not required to deploy or use Access Services.

Deployment Considerations: Performance and Capacity

Access 2010 improves on linked database performance compared to Access 2007 on MOSS. 2010 utilizes an improved local cache mechanism that greatly reduces the data load over the wire after the first transaction. Between better caching, fewer web service calls, more efficient bulk queries, users should notice significant performance gains with Access 2010. Compared to performance of Access 2007 on MOSS, form open and data load times showed roughly 60% faster times, to as much as an order of magnitude better performance.

SharePoint 2010 offers a new service architecture that didn’t exist in MOSS 2007, along with a wealth of other non-Access service applications for the enterprise user. A small farm deployment will typically want a dedicated application server to run a few SharePoint services such as Access Services, Excel Services, Visio Graphics Service and so on. Your farm’s performance and capacity needs will depend on your application workloads. Partners like bluLink Solutions can help you analyze business requirements to estimate the extent to which you should scale your application servers up and/or out.

As far as server-side performance goes, Microsoft has a created great set of performance and test whitepapers for SharePoint 2010, including one for Access Services. You can download this document in Word format at:

http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=fd1eac86-ad47-4865-9378-80040d08ac55

This paper contains a lot of useful information, but a couple of points stood out to me so I thought I’d mention it here:

1. Access Services is a stateful service application, unlike typical SharePoint client-server interactions. Cursors and record sets are kept in memory between requests to accommodate common, long-running Access usage patterns, inferring that memory capacity could be a limiting resource. However, the test team found that CPU utilization on the application server was the typical bottleneck for most scenarios. Scaling up a multi-proc capable server is the first remedy, followed by scaling out with an additional application server once the server had maxed out CPU capacity. The test team went on to say that SharePoint Server’s recommended application server hardware requirements including those for memory were sufficient for application servers running Access Data Services.

2. Microsoft’s test profile is based on a farm dedicated only to Access Services. In the real world, we would expect some smaller organizations to run several service applications such as Excel Services on the same application server. Keep in mind the standard disclaimer, “your mileage may vary” when planning your service application deployment.

Summary

Access Services is another example of Microsoft’s stronger integration between the Office application suite and SharePoint Server 2010. Existing Access databases can be quickly ported over to SharePoint Server 2010, giving organizations the opportunity to leverage previous investments in Access applications. It puts the power of extensible online database applications in the hands of SharePoint end users, while still giving IT the ability to centrally support and manage service availability of Access databases across the organization.

Tags: Access 2010, Access Services, performance, SharePoint 2010, SharePoint Service Apps
Posted in Access Services, Database Applications, Office Web Apps, SharePoint 2010, SharePoint Service Apps | 2 Comments »

Office 365 Announced

October 27th, 2010 -- by John Ano

Microsoft recently announced Office 365 has gone to beta testing. If you are hearing about it for the first time, Office 365 is Microsoft’s next step in evolving toward cloud-based products and services. At its core are the cloud versions of flagship products SharePoint and Exchange. Also included is Lync, the new brand for Office Communication Server and Live Meeting. None of these products are new to the cloud – they have been offered via Microsoft Online Services for the last two years as the Business Productivity Online Suite or BPOS. bluLink has used BPOS since the beginning, and we’ve been very pleased with the offering and SLA.

Part of the excitement with Office 365 is the upgrade of each server to the 2010 version. It’s no surprise we are most excited about the enhancements SharePoint 2010 brings to the cloud, but there are some great new capabilities rolling out with Exchange 2010 Online and Lync.

Rounding out the Office 365 offering is something new: Office Web Apps. Word, Excel, PowerPoint and OneNote will soon have an online version that will let you work with documents directly in the browser, and tightly integrate with SharePoint 2010.

Even though the official release date is not set, Microsoft forecasts general availability of Office 365 in 2011. Beta 1 is underway, and we are talking with partners and customers about planning and adoption strategies now.

I’ll be bringing more news and technical deep dives in upcoming blog entries.

To learn more, visit http://office365.microsoft.com.

Tags: BPOS, Cloud Services, Office 365, Office Web Apps, SharePoint 2010
Posted in Announcements, Cloud Services, Enterprise 2.0, Office 365, Office Web Apps, SharePoint 2010 | No Comments »