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 Developer .NET UPDATE.

Microsoft SQL Server 2005 Analysis Services Migration
http://www.windowsitpro.com/go/whitepapers/proclarity/sqlserver2005?code=devtop1007

Filtering the Spectrum of Internet Threats: Defending Against Inappropriate Content, Spyware, IM, and P2P at the Perimeter
http://www.windowsitpro.com/whitepapers/stbernard/internetaccess/index.cfm?code=dev1007middle

SQL Server Magazine's Fall Special
https://store.pentontech.com/index.cfm?s=9&promocode=eu215aud


1. Developer .NET Perspectives

  • Workflow Today and Tomorrow
  • 2. Events and Resources

  • Windows Connections 2005 Conference - October 31 - November 3, 2005
  • Discover SQL Server 2005 for the Enterprise. Are you prepared?
  • Get Ready for the SQL Server 2005 Roadshow in Europe
  • Deploy VoIP and FoIP Technologies
  • 3. Featured White Paper

  • Build a Superior Windows File Serving Environment
  • 4. Announcements

  • Become a VIP Subscriber!
  • 5. New and Improved

  • Take the Guesswork Out of Remembering Table Names and Relationships

  • Sponsor: Microsoft SQL Server 2005 Analysis Services Migration
    Microsoft SQL Server 2005 Analysis Services offers many performance improvements and benefits for existing SQL Server 2000 Analysis Services users. If you are planning a migration to Analysis Services 2005, you can't afford to ignore this paper! Download your free copy now and get all the tips and real-world examples you need to make migration faster and easier.
    http://www.windowsitpro.com/go/whitepapers/proclarity/sqlserver2005?code=devtop1007


     

    1. Developer .NET Perspectives


    by Bill Sheldon, bills@interknowlogy.com

     

    Workflow Today and Tomorrow
    In my last column "Direct from PDC05" (http://www.windowsitpro.com/articles/articleid/47765/47765.html), I covered some of the announcements Microsoft made at the Professional Developers Conference 2005 (PDC05). Since then I've spent some time at the Microsoft 2005 MVP Global Summit. Between the two events let me assure you there are some amazing products coming out of Redmond in the next 2 years. However, all those amazing products can result in some confusion. For example, how does Windows Forms integrate with Windows Presentation Foundation (formerly code named Avalon), and how does Windows Workflow Foundation integrate with Microsoft BizTalk Server 2006? The fact is you have to sit down and really pull all the pieces together to understand whether you're following the correct path for the future. While I'm going to save the discussion of Windows Presentation Foundation for a future column, I'd like to talk about the relationship between Windows Workflow Foundation and BizTalk Server 2006. Microsoft is releasing BizTalk 2006 in November, alongside Visual Studio 2005 and SQL Server 2005.

    This joint product launch is going to consist of a series of events. In addition to the primary launch on November 7 in San Francisco, Microsoft is hosting several other smaller launches in 50 countries around the globe. You can find more information about these free events at http://www.microsoft.com/events/2005launchevents/default.mspx. The events are free (in case you missed that) and will operate similar to the model used for Microsoft's Developer Days. So mark your calendar and register before they fill up.

    Microsoft didn't stop at the November 7 launch events. It's also working with hundreds (if not thousands) of local user groups to support the launch of these products at the user group level.

    For those of you who aren't familiar with BizTalk Server, the joint product launch will actually be promoting BizTalk Server's third release. (For background information about BizTalk Server, go to http://msdn.microsoft.com/biztalk/getstarted.) BizTalk Server 2006 introduces several new features, including better integration with XML Web Services, an implementation of the Web Service Extensions (WSE) 2.0 security standards, integration with Microsoft SharePoint Portal Server, and integration with email services, as noted on BizTalk Server 2006's beta Web page at http://www.microsoft.com/biztalk/evaluation/bts2006beta.mspx. The fact is that BizTalk Server 2006 is a major release and it's one of the first products to leverage Windows .NET Framework 2.0.

    Since its first release, BizTalk Server has included an orchestration engine, which you can loosely consider a workflow engine. This brings us to the question of how Windows Workflow Foundation impacts BizTalk Server. The first item to note is that the development teams that worked on BizTalk 2006's orchestration engine are working on many of the features in Windows Workflow Foundation. Windows Workflow Foundation can, in fact, be seen as an extension of the existing BizTalk model and represents the next step in extending BizTalk Server's reach.

    When BizTalk Server was first launched, it was considered one of the more expensive server products from Microsoft. Given that its goal is handling the plumbing of interfacing businesses, BizTalk Server's target market has always been the enterprise. As such, the BizTalk orchestration engine isn't something an individual will leverage, nor has it played much of a role in the development of applications for the end user. This is where the Windows Workflow Foundation comes in. Windows Workflow Foundation is targeting the individual's desktop. With the recent growth of workflow systems such K2, Microsoft recognized that BizTalk Server's existing target (i.e., the enterprise) was leaving the company out of an important market: the desktop. To reach that market, Microsoft is introducing Windows Workflow Foundation. Windows Workflow Foundation will let developers set up a framework of steps that a given set of data elements must pass through, then let developers build their applications around that data flow.

    Windows Workflow Foundation is part of the WinFX suite of technologies, which will ship next year. These technologies include the Windows Communication Framework (formerly code named Indigo), which will enable a common distributed communications model. At this point, most of the information about Windows Workflow Foundation is available from the Windows Vista Development Center at http://msdn.microsoft.com/windowsvista/building/workflow.

    Microsoft plans to release Windows Workflow Foundation as part of next year's Microsoft Office 12 and Windows Vista push. Note, however, that while Microsoft is releasing Windows Workflow Foundation next year, it's not releasing a new suite of tools to leverage the Windows Workflow Foundation technologies. Although BizTalk Server 2006 won't be aware of Windows Workflow Foundation technologies, don't expect that to remain the case for the next release of BizTalk Server. At that time, I expect that BizTalk Server's plumbing will be able to fully leverage those technologies.

    The key is that Microsoft is rolling out products on a predictable cycle (release order, not scheduled date). These cycles allow for a product to be brought up to the current level of technology and for other products to then leverage or expand on that technology. Thus, after the release of Windows Workflow Foundation, the BizTalk Server 2006 team will look at integrating this technology with the next version of their tool suite. The bottom line is that if BizTalk Server 2006 fits your integration model, use it in confidence; rest assured that over time BizTalk Server will continue to be integrated with other technologies released from Microsoft.

    Finally, just a side note, you might have noticed I didn't associate Windows Workflow Foundation with the "WWF" acronym. It's not because of the fact that this designator is well known in the United States for wrestling but because that combination of letters is copyrighted by the World Wildlife Fund.


    Sponsor: Filtering the Spectrum of Internet Threats: Defending Against Inappropriate Content, Spyware, IM, and P2P at the Perimeter
    Because of the proliferation of Web-based threats, you can no longer rely on basic firewalls as your sole network protection. Attackers continue to evolve clever methods for reaching victims, such as sending crafty Web links through Instant Messaging (IM) clients or email, or by simply linking to other Web sites that your employees might surf. This free white paper examines the threats of allowing unwanted or offensive content into your network and describes the technologies and methodologies to combat these types of threats. Get your free copy now!
    http://www.windowsitpro.com/whitepapers/stbernard/internetaccess/index.cfm?code=dev1007middle


     

    2. Events and Resources


    (brought to you by SQL Server Magazine)

     

    Windows Connections 2005 Conference - October 31 - November 3, 2005
    At the Manchester Grand Hyatt in San Diego, Microsoft and Windows experts present more than 40 in-depth sessions with real-world solutions you can take back and apply today. Register now and attend two conferences for the price on one!
    http://www.winconnections.com

    Discover SQL Server 2005 for the Enterprise. Are you prepared?
    In this free half-day event, you'll learn how the top new features of SQL Server 2005 will help you create and manage large-scale, mission-critical enterprise database applications and make your job easier. Find out how to leverage SQL Server 2005's new capabilities to best support your business initiatives. Register today!
    http://www.windowsitpro.com/roadshows/sqlserverdba/index.cfm?code=1005emailannc

    Get Ready for the SQL Server 2005 Roadshow in Europe
    Back By Popular Demand - Get the facts about migrating to SQL Server 2005! SQL Server experts will present real-world information about administration, development, and business intelligence to help you implement a best-practices migration to SQL Server 2005 and improve your database-computing environment. Receive a one-year membership to PASS and one-year subscription to SQL Server Magazine. Register now.
    http://www.windowsitpro.com/roadshows/sqlservereurope/index.cfm?code=1005emailannc

    Deploy VoIP and FoIP Technologies
    Voice over Internet Protocol (VoIP) is the future of telecommunications, and many companies are already enjoying the benefits of transporting VoIP networks to significantly reduce telephone and facsimile costs. Join industry expert David Chernicoff for this free Web seminar to learn the 'ins and outs' of boardless fax in IP environments, tips for rolling out fax and integrating fax with telephony technologies, and more!
    http://www.windowsitpro.com/go/seminars/voip/?partnerref=1005emailannc

     

    3. Featured White Paper


     

    Build a Superior Windows File Serving Environment
    In this free white paper, get the tools you need to provide a scalable, highly available CIFS file service using inexpensive, industry-standard servers that you can add to incrementally as demands require, while retaining the management simplicity of a single server and a single pool of exported file systems.
    http://www.windowsitpro.com/whitepapers/polyserve/fileserving/index.cfm?code=1005emailannc


    2005 Watch: SQL Server Magazine's Fall Special
    You won't want to miss any of the upcoming fall issues! Subscribe now and you'll discover the best tools to keep your SQL Server systems tuned, the related ins and outs of SQL Server 2005, ways ADO.NET 2.0 solves your problems, and much more. You'll also gain exclusive access to the entire SQL Server Magazine online article database and SAVE 44%. Order now:
    https://store.pentontech.com/index.cfm?s=9&promocode=eu215aud


     

    4. Announcements


    (brought to you by SQL Server Magazine)

     

    Become a VIP Subscriber!
    Get inside access to ALL the articles, tools, and helpful resources published in Windows IT Pro, SQL Server Magazine, Exchange and Outlook Administrator, Windows Scripting Solutions, and Windows IT Security--that's more than 26,000 articles at your fingertips. Your VIP subscription also includes a valuable one-year print subscription to Windows IT Pro and two VIP CDs (includes the entire article database on CD). Sign up now:
    https://store.pentontech.com/index.cfm?s=1&promocode=eu275auv

     

    5. New and Improved


    (by Karen Bemowski, products@sqlmag.com)

     

    Take the Guesswork Out of Remembering Table Names and Relationships
    Atadore released PromptSQL, software that adds SQL IntelliSense-like features to Visual Studio 2005, Visual Studio .NET 2003, SQL Server 2005 Management Studio, and Query Analyzer. PromptSQL reduces the amount of time it takes to write SQL code because it takes the guesswork out of remembering table names, column names and types, and the relationships between tables. PromptSQL provides name-completion for databases, users/schemas, tables, views, and stored procedures and displays tool-tip help on these objects. It also makes JOIN suggestions based on primary/foreign key relationships and suggests JOIN ON conditions based on the same principle. PromptSQL licenses cost $25 per user. Evaluation copies are available.
    http://www.promptsql.com

     

    Contact Us


     

     

  • About Developer .NET Perspectives -- bills@interknowlogy.com
  • About technical questions -- http://www.sqlmag.com/forums
  • About product news -- products@sqlmag.com
  • About your subscription -- Developer_dot_NET_update@sqlmag.com
  • About sponsoring an UPDATE -- contact Richard Resnick, rresnick@sqlmag.com, or Lisa Kling, lkling@sqlmag.com
  • 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 2005, Penton Media, Inc. All Rights Reserved.