SQL Server Magazine

This Issue Sponsored By
This email newsletter comes to you free and is supported by the following advertisers, who offer products and services that might interest you. Please take a moment to visit these advertisers' Web sites and show your support for Scripting Central.

Thawte
http://www.windowsitpro.com/go/whitepapers/thawte/ssl?code=DEVTop0217

iAnywhere
http://www.windowsitpro.com/go/whitepapers/ianywhere/enterprisemgmt?code=DEVMid0217

1. Developer .NET Perspectives

2. Events and Resources

3. Featured White Paper

4. Announcements

Sponsor: Thawte

Secure Your Online Data Transfer with SSL
Increase your customers' confidence and your business by securely collecting sensitive information online. In this free white paper you'll learn about the various applications of SSL certificates and their appropriate deployment, along with details of how to test SSL on your web server.
http://www.windowsitpro.com/go/whitepapers/thawte/ssl?code=DEVTop0217

1. Developer .NET Perspectives
by Bill Sheldon, bills@interknowlogy.com

VSTO and SharePoint--A Winning and Possibly Profitable Combination
In my previous column "Ripple Has Become a Wave" (http://www.windowsitpro.com/SQLServer/Article/ArticleID/49304/49304.html), I invited readers to email me reasons why people might still be using COM in the business logic behind their Web sites. I received only one email. In it, the reader said that one reason might be that, "MS never updated the Office COM interface to .NET, requiring you to completely re-engineer your methods for providing Excel based reports to users or just use Interop." The reader went on to mention that "you have plenty of options to get around this limitation." I got the impression that the reader might not have a solid understanding of what Microsoft had and hadn't done regarding Office and its interaction with .NET.

I last mentioned the Visual Studio Tools for the Microsoft Office System (VSTO) in my August 2005 column "The Shifting Sands of Technology" (http://www.windowsitpro.com/SQLServer/Article/ArticleID/47478/47478.html). In case you're unfamiliar with VSTO, it's the replacement for COM interop. With VSTO 2005, you do anything that you can do with interop. And with a custom task pane, VSTO's capabilities go a long way beyond interop's capabilities. I was recently involved in a project for a small company in which we added custom research capability to Microsoft Word. Because we followed the Microsoft standards for publishing the actual search interfaces, the custom search was available not only from our own pane in Word but also from the research pane in any Microsoft Office product and in Microsoft Internet Explorer (IE) once you installed the search interfaces.

Microsoft Office 2007 (previously code-named Office 12), which Microsoft plans to ship by the end of this year, will bring enhancements to VSTO. In addition, developers will be better able to use the Windows .NET Framework to manipulate Office 2007 products. Some of the changes coming to products such as Microsoft Outlook are just amazing. You can read about Outlook's design changes and changes in programming capabilities in Sue Mosher's "A New Look for Outlook 12" (http://www.windowsitpro.com/Windows/Article/ArticleID/48710/48710.html). In addition, you can view slides that specifically address the new programmatic features in Outlook at http://www.cookcomputing.com/blog/archives/000489.html.

VSTO currently has two disadvantages, which Microsoft will hopefully eliminate or at least minimize in Office 2007. The first disadvantage is that VSTO capabilities in Outlook 2003 are limited compared with its capabilities in Word 2003 and Microsoft Excel 2003. The second limitation is that clients need to have Office Professional Edition 2003 installed for VSTO to operate. VSTO isn't available to clients using Office Standard Edition 2003.

In "The Shifting Sands of Technology," I discussed how VSTO impacts the development of Windows Forms applications, but I didn't discuss the impact that Office 2003 is having on Web applications. Although I briefly touched on this topic in my April 2004 column "SharePoint Portal Server 2003 and InfoPath--A Dynamic Duo" (http://www.windowsitpro.com/Windows/Article/ArticleID/42572/42572.html), that column mainly focused on Microsoft Office InfoPath 2003. Thus, I want to spend more time discussing SharePoint.

SharePoint lets you upload, version, and manage Office documents and other project documents straight out of the box. SharePoint, which is the focus this month's issue of Windows IT Pro magazine (http://www.windowsitpro.com/Windows/Issues/IssueID/815/Index.html), can be confusing in that there are actually two SharePoint products: Microsoft Windows SharePoint Services and Microsoft Office SharePoint Portal Server 2003. The differences between the products lie in which Microsoft product team owns the product and what each product costs and does.

In short, SharePoint Portal Server is a product from the Microsoft Office team and requires separate licensing associated with Office. Many companies that use SharePoint Portal Server get their licensing through their enterprise Office licensing. Not surprisingly, the SharePoint Portal Server home page is on the Office site at http://office.microsoft.com/sharepoint.

SharePoint Portal Server builds on Windows SharePoint Services, which most people consider the core SharePoint product. Essentially, Windows SharePoint Services creates independent project sites and SharePoint Portal Server ties these sites together under a common portal. SharePoint Portal Server also provides other features, which you can read about at http://support.microsoft.com/default.aspx?scid=kb;EN-US;830320.

Windows SharePoint Services is a component that's part of and included with all editions of Windows Server 2003. Thus, you'll find the Windows SharePoint Services home page on the Windows Server site at http://www.microsoft.com/windowsserver2003/technologies/sharepoint/default.mspx. Windows SharePoint Services lets you create project-based Web sites and is used in other Microsoft products. A good developer-focused example is Team Foundation Server (TFS). The TFS integration with Windows SharePoint Services is what sets up your project site so that you can combine your source code repository with a repository for project-related documentation.

Windows SharePoint Services' versatility at providing a standard Web interface for project teams has made it synonymous with collaboration. The Microsoft Small Business Server ships with Windows SharePoint Services already enabled so that small businesses can easily share internal documentation. Windows SharePoint Services is an "intranet in a box" for companies that are looking for a low-cost internal tool to manage their shared documents.

Microsoft recognizes that Windows SharePoint Services is an important tool in its collaboration platform and a direct competitor to existing collaboration tools, such as Lotus Notes/Lotus Domino. Perhaps that's why Microsoft recently purchased Groove Networks, a leading provider of workgroup collaboration software. Microsoft will be working to better integrate Windows SharePoint Services with tools such as Microsoft FrontPage and InfoPath. These improvements will make Windows SharePoint Services a more powerful platform by the end of this year. Working with VSTO, Windows SharePoint Services, and other Office system tools to develop collaboration, messaging, and other information-management solutions might even help your company net part of a $148 billion market, according to Microsoft Partner Capacity Research (https://partner.microsoft.com/global/competency/iwsolutions). For more information about Windows SharePoint Services as a part of a collaborative environment, check out TechNet's collaboration page at http://www.microsoft.com/technet/interopmigration/collaboration/default.mspx.

Sponsor: iAnywhere

Managing Mobility in the Enterprise
Is your mobile workforce set up for success? Mobile management is a key component for your mobile strategy, but inadequate levels can have severe consequences. This free white paper will help you identify the appropriate tools to manage it effectively, and avoid increases in TCO and more. Download it today and ensure your organization's mobility success!
http://www.windowsitpro.com/go/whitepapers/ianywhere/enterprisemgmt?code=DEVMid0217

2. Events and Resources
(brought to you by SQL Server Magazine)

Tips for Tuning SQL Server Systems
Let industry expert Brian Moran teach you the tips and tricks he's learned in 15 years of experience fine-tuning SQL Server systems. This is a Web seminar you won't want to miss! Live event: Tuesday, March 21, 2006; 12:00 EST
http://www.windowsitpro.com/go/seminars/quickshift/sqltuning/?partnerref=0215emailannc

Consolidation Solutions Designed for SQL Server
Learn to reduce both capital expenditures and operating expense by clustering and consolidating SQL Server databases. Attend the live Web seminar on March 9!
http://www.windowsitpro.com/go/seminars/polyserve/sqlconsolidation/?partnerref=0215emailannc

Microsoft Clustering Technology - Ensure That You're Protected
Use clustering technology to protect your company against network outages, power loss and natural disasters. Live Event: 2/28/2006; 12:00 EST
http://www.windowsitpro.com/go/seminars/xosoft/clustering/?partnerref=0215emailannc

Spam Fighting and Email Security for the 21st Century
Learn the best ways to manage your email security (and fight spam) using a variety of solutions and tips.
http://www.windowsitpro.com/go/ebooks/ironport/emailsecurity/?code

3. Featured White Paper

Breaking Through the Dissimilar Hardware Restore Challenge
Learn about recovery to virtual computer environments, hardware migration strategies, hardware repurposing for optimal resource utilization, meeting recovery time objectives, increasing disaster tolerance, and more.
http://www.windowsitpro.com/go/whitepaper/symantec/hardware?code=0215featwp

Hot Spot

SQL Server Magazine Connections Spring 2006
April 2-5, 2006, Orlando , FL. Over 45 sessions presented by Microsoft and industry gurus. Registration includes an exclusive day of presentations by the Microsoft SQL Server product team. Register and attend sessions at Microsoft ASP.NET, Visual Studio Connections free. Call 203-268-3204 or 800-438-6720 for info.
http://www.devconnections.com

4. Announcements
(brought to you by SQL Server Magazine)

The SQL Server Magazine Master CD has it all!
Get the SQL Server Magazine Master CD and get portable, high-speed access to the entire SQL Server article database on CD - that's a library of over 2,300 articles in one place! The newest issue includes BONUS SQL Server 2005 Tips and if you sign up now, you will get 25% off. Limited quantities are available, so order now:
https://store.pentontech.com/index.cfm?s=9&promocode=eu2862uc

Save 44% off the Windows Scripting Solutions Newsletter
For a limited-time, order the Windows Scripting Solutions newsletter and SAVE up to $30 off the regular price. You will get 12 helpful issues loaded with expert-reviewed downloadable code and scripting techniques, as well as hundreds of tips on automating repetitive tasks. You will also get FREE, unlimited access to the full online scripting article database (over 500 articles). Subscribe now:
https://store.pentontech.com/index.cfm?s=1&promocode=eu2662us

2006 Watch

Learn C# 2005 Now...Get a FREE training CD!
Start learning Visual C# 2005 today with cutting edge training from AppDev. We'll send you a C# 2005 training CD from our new course (a $115 value) -- FREE! Start learning now...click the link below for your FREE Visual C# 2005 training.
http://www.appdev.com/promo/RN00300

Contact Us

Developer .NET UPDATE is brought to you by SQL Server Magazine, the only magazine devoted to helping developers and DBAs master new and emerging SQL Server technologies and issues. Subscribe today.
https://store.pentontech.com/index.cfm?s=9&promocode=eu215xdb

View the SQL Server Magazine Privacy Policy
http://www.winnetmag.com/aboutus/index.cfm?action=privacy

SQL Server Magazine is a division of Penton Media, Inc. 221 East 29th Street, Loveland, CO 80538, Attention: Customer Service Department

Copyright 2006, Penton Media, Inc. All Rights Reserved.

End of Article