These data features empower business users to publish information from Office Applications. The expanded Business Connectivity Services do much the same for Line-of-Business information. In the past (with the old Business Data Catalog), you could read data from, say, SAP applications. Now, it's possible to read, update, delete and search repositories.
In a simple test, I connected directly to a SQL database – and was able to update tables from a SharePoint site. Creating this test scenario was very straightforward using the improved SharePoint Designer 2010 (which will continue to be free). For instance, the Office Ribbon and a simple form for connecting to the SQL database enabled me to build the required functionality in about five minutes.
IT managers may cringe at allowing business users this type of power. Recognizing this concern, Microsoft includes a number of "safe" out-of-the-box customizations within SharePoint Designer, so sites can be tailored with little risk. Administrators can further lock down the type of site changes users can make with SharePoint Designer.
For developers, new SharePoint tools in Microsoft Visual Studio 2010 should reduce the work of designing Web Parts and other advanced customization. I used one of the new SharePoint 2010 templates to create a data query Web Part – which was debugged and uploaded to my SharePoint Server with a few keystrokes in Visual Studio.
In MOSS 2007, these types of modifications meant the farm administrator had to trust your code. But SharePoint Server 2010 introduces a new Sand-box Solutions feature. Put simply, it isolates code and restricts resources, such as memory, SQL access and CPU. So there's little concern that poor coding will degrade the server farm's performance.
Administrators can celebrate
Even with extensive planning, upgrades are never easy – at least not in my experience moving to MOSS 2007 from earlier versions. But stepping up to 2010 will be far less of a hassle. For starters, existing sites can convert with the existing MOSS 2007 user interface, including any customizations. Then, site stewards can preview and switch to the new user interface when they're ready. There's also an upgrade checker that helps you identify custom code that might be replaced with out-of-the-box SharePoint 2010 features.