Subscribe to SQL Server Magazine: http://lists.sqlmag.com/t?ctl=1315D:1036D


To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add SQLServerMag_UPDATE@lists.sqlmag.com to your list of allowed senders and contacts.

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 SQL Server Magazine UPDATE.

SEPTEMBER SPECIAL -- Get 44% off SQL Server Magazine!
    http://lists.sqlmag.com/t?ctl=1315A:1036D

Free .NET or SQL Server Training CD!
    http://lists.sqlmag.com/t?ctl=13163:1036D

The new Microsoft Visual Studio 2005 Team System
    http://lists.sqlmag.com/t?ctl=1316A:1036D

FREE Product Trial: Protect Your Web Apps from Hackers
    http://lists.sqlmag.com/t?ctl=13158:1036D


September 8, 2005

1. Perspectives

  • WinFS: More Than Just a New Feature
  • 2. SQL Server 2005 Watch

  • Microsoft Releases WinFS Beta 1
  • 3. News & Views

  • Results of Previous Instant Poll: SQL Server Express
  • New Instant Poll: WinFS Beta
  • 4. Events and Resources

  • Roll Back Data to Any Point in Time, Not Just to the Last Snapshot or Backup
  • Discover SQL Server 2005 for the Enterprise. Are you prepared?
  • Get Ready for SQL Server 2005 Roadshow in Europe
  • Avoid The 5 Major Compliance Pitfalls
  • Consolidate Your SQL Server Infrastructure
  • 5. Featured White Paper

  • Is Your Exchange Server 2003 Environment Well Cared For?
  • 6. Peer to Peer

  • Hot Tip: Fine-Grained Permissions in Analysis Services
  • Hot Article: SQL Server 2005's APPLY Operator
  • In a Nutshell: A Rave on U.S. Culture
  • Hot Threads
  • 7. Announcements

  • Get Access to Every SQL Server Magazine Article on CD
  • Register Now for the 2005 PASS Community Summit
  • 8. New & Improved

  • Automate Database Building and Deployment
  • Sponsor: SEPTEMBER SPECIAL - Get 44% off SQL Server Magazine!
    Get SQL Server Magazine and get answers! Act now to get an entire year for just $39.95--that's 44 percent off the cover price! You will also gain exclusive access to the entire SQL Server Magazine article database (over 2300 articles). BONUS: The Top SQL Server 2005 Tips handbook (over 60 helpful tips). This is a limited-time, risk-free offer, so click here now:
        http://lists.sqlmag.com/t?ctl=1315A:1036D

    1. Perspectives


  • WinFS: More Than Just a New Feature
  •     by Brian Moran, brian@solidqualitylearning.com

    Last week, Microsoft announced the beta availability of WinFS, a new filesystem that bridges the gap between traditional file systems, unstructured data in formats such as email, and traditional databases. Of course, I know what WinFS is because its roots go back to the early days of SQL Server 2000, when Microsoft first started talking about something called SQLFS. Arguably, WinFS traces its conceptual roots to the earliest days of Windows NT (circa 1994), when Microsoft was planning an upgrade called Cairo (which never materialized) that would include an object-oriented file system. WinFS was slated to be part of Longhorn, but Microsoft pulled it from Longhorn release plans last year. Like many people, I assumed that Microsoft had relegated the WinFS to the vaporware backburners for the indefinite future.

    I like to think I'm a bit of an insider for SQL Server-related news at Microsoft, so I was surprised to learn last week that WinFS Beta 1 is available to MSDN subscribers and will eventually be available for Vista and possibly Windows XP, as well as Longhorn. (Beta 1 bits work on Windows XP Service Pack 2--SP2--but Microsoft hasn't said what platforms WinFS will support at its release.) I've gotten my hopes up about WinFS; the potential for ground-breaking change in the way we interact with unstructured data through WinFS is so great that I can't help but get a tiny bit excited about a pending release. Microsoft says that WinFS will still be in beta when Vista ships, reciting the company mantra, "It will ship when it's ready."

    WinFS is more than "just another new feature." The product truly has the potential to change the way we manage and interact with the vast amount of information that's not stored in a traditional database. A recent blog entry by Shishir Mehrotra, who runs the Microsoft WinFS product-planning team, provides an anecdotal story about how we might use WinFS in the real world. You can read the entire text of this blog entry at http://lists.sqlmag.com/t?ctl=13160:1036D . Mehrotra deftly describes how WinFS uses a query builder and an information model to make an employee's email inbox work more like a relational database--thus making it easier for the employee to efficiently manage her mail. The blog explains WinFS as a "relational filesystem" that lets applications store data that's more complex than a typical file.

    Interested in learning more about WinFS? Check out the MSDN WinFS site at http://lists.sqlmag.com/t?ctl=1315E:1036D . MSDN subscribers can download the WinFS beta bits, the URL also offers links to great WinFS resources, including:

  • detailed Channel 9 video interviews with members of the WinFS development team
  • the WinFS team blog area
  • the WinFS newsgroup
  • WinFS creates the potential for entirely new classes of applications that would have been almost impossible to build from the ground up without the platform plumbing that Microsoft now provides.


    Free .NET or SQL Server Training CD!
    Become more efficient and effective with AppDev's award-winning training. Get a FREE .NET or SQL Server training CD (a $95 value) and see why developers have voted AppDev THE BEST!

    Click the link below for your free CD-ROM.
        http://lists.sqlmag.com/t?ctl=13163:1036D


    2. SQL Server 2005 Watch


  • Microsoft Releases WinFS Beta 1

  • On Monday, August 29, Microsoft released to MSDN subscribers the first beta version of its integrated data platform, WinFS. Billed as a "preview of WinFS," the beta has been released at an early stage in the product's development to elicit input from beta testers. Nevertheless, Microsoft reports that the beta does include the core capabilities that the product will contain at its final release. The WinFS data model lets users define complex concepts such as items and relationships. The model also includes object APIs to help developers program in the platform and a set of core schemas that enable sharing of information between applications. WinFS Beta 1 runs on Windows XP Service Pack 2 (SP2). Future betas and consumer technology preview (CTP) releases are planned. For more information, visit the Microsoft Data Access and Storage Developer Center at
        http://lists.sqlmag.com/t?ctl=1315E:1036D

    Sponsor: The new Microsoft Visual Studio 2005 Team System
    Microsoft Visual Studio 2005 Team System is the new, more efficient way to develop as a team. This tool facilitates communication between development and operations throughout the entire software lifecycle. The result is a more predictable development process. Your team will take advantage of:

  • Improved solutions for operations (model applications and validate their intended environments).
  • Functions that check your code for security issues and coding errors.
  • Collaboration among all members of your software team (including architects, developers, testers, and operations managers).
  • Customization of with over 450 supplemental products from over 190 partners.
  • Discover the new Visual Studio 2005 Team System. Communicate. Collaborate. Create.

    Get the free Visual Studio 2005 Team System Beta
        http://lists.sqlmag.com/t?ctl=1316A:1036D

    3. News & Views


    Results of Previous Instant Poll: SQL Server Express
    "What would you use SQL Server Express for?" Here are the results from the 41 votes:

  • 2%   Keeping track of collections such as entertainment media (CDs, DVDs, etc.)
  • 56%   Small business database
  • 17%   Teaching/learning database principles
  • 10%   Other
  • 15%   I have no use for SQL Server Express
  • New Instant Poll: WinFS Beta
    "Will you participate in the WinFS Beta?" Go to the SQL Server Magazine home page ( http://lists.sqlmag.com/t?ctl=13169:1036D ) and submit your vote for

  • Yes, I'm already working with it
  • Yes, I'm planning to download it soon
  • No, I'm not an MSDN subscriber
  • No, I'm not interested
  • 4. Events and Resources


  • Roll Back Data to Any Point in Time, Not Just to the Last Snapshot or Backup

  • Have you ever lost data that was saved right after your last backup? Most of us have. Continuous, or realtime, backup systems provide realtime protection, but are they right for you? In this free Web seminar, you'll learn about the design principles that underlie continuous data protection solutions, how to integrate them with your existing backup infrastructure, and how best to apply continuous protection technologies to your Windows-based servers.
        http://lists.sqlmag.com/t?ctl=13153:1036D

  • 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--making your job easier. Find out how to leverage SQL Server 2005's new capabilities to best support your business initiatives. Register today!
        http://lists.sqlmag.com/t?ctl=13156:1036D

  • Get Ready for 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://lists.sqlmag.com/t?ctl=13155:1036D

  • Avoid The 5 Major Compliance Pitfalls

  • Based on real-world examples, this Web seminar will help C-level executives, as well as IT directors and managers, avoid common mistakes and give their organizations a head start toward ensuring a successful compliance implementation. Register today and find out how you can avoid the mistakes of others, improve IT security, and reduce the cost of continually maintaining and demonstrating compliance.
        http://lists.sqlmag.com/t?ctl=13157:1036D

    Consolidate Your SQL Server Infrastructure
    Shared data clustering is the breakthrough consolidation solution for Microsoft Windows servers. In this free Web seminar, learn how shared data clustering technology can reduce capital expenditures by at least 50 percent, improve management efficiency, reduce operational expenses, ensure high availability across all SQL Server instances, and more. Find out how you can reduce the Total Cost of Ownership (TCO) for SQL Server cluster deployments by as much as 60 percent over three years. Sign up today!
        http://lists.sqlmag.com/t?ctl=13151:1036D

    See the complete Windows IT Pro Network guide to Web and live events.     http://lists.sqlmag.com/t?ctl=13165:1036D


    5. Featured White Paper


  • Is Your Exchange Server 2003 Environment Well Cared For?

  • Get the bare and necessary facts you should know to maintain your Exchange Server 2003 environment, including critical strategies for predicting and responding to failures. Plus, you'll receive useful information about implementing proactive measures, such as preventive database maintenance, to ensure that your investment is well protected.
        http://lists.sqlmag.com/t?ctl=13150:1036D


    6. Peer to Peer


  • Hot Tip: Fine-Grained Permissions in Analysis Services

  •     by Carl Rabeler, carl@solidqualitylearning.com

    As an administrator for a SQL Server 2000 Analysis Services instance, can I delegate permission to a Windows user or group to process an Analysis Services cube or dimension without also granting permissions to view the data in the cube or dimension?

  • Read the answer to this question today at

  •     http://lists.sqlmag.com/t?ctl=13154:1036D

  • Hot Article: SQL Server 2005's APPLY Operator

  • SQL Server 2005 introduces APPLY, a handy new operator that's used in a query's FROM clause. The APPLY operator basically lets you apply a table expression to every row of an outer table. In his August T-SQL 2005 column "SQL Server 2005's APPLY Operator," Itzik Ben-Gan explains this cool new operator and its benefits and gives you some ways you can put it to good use. Read the entire article today at
        http://lists.sqlmag.com/t?ctl=13152:1036D

  • In a Nutshell: A Rave on U.S. Culture

  • Kevin Kline enjoys the perspective on U.S. culture that he gets when he travels internationally, and consequently he also enjoys hearing the perspective of foreigners visiting the United States. In this week's blog, Kevin points to a rave from a visiting family and invites you to enjoy the writer's humorous perspective. Take a look at the blog and let Kevin know what you think today at
        http://lists.sqlmag.com/t?ctl=13159:1036D

  • Hot Threads: Check out the following hot threads, and see other discussions in our 30 SQL Server forums.

  • http://lists.sqlmag.com/t?ctl=1315F:1036D

  • SQL Server General Discussion: SQL Server Failover Cluster

  •     http://lists.sqlmag.com/t?ctl=1314E:1036D
  • Career Development and Job Opportunities: Database Developer-Downtown Seattle

  •     http://lists.sqlmag.com/t?ctl=1314C:1036D
  • Administration: Definitions of Process Statuses

  •     http://lists.sqlmag.com/t?ctl=1314A:1036D
  • T-SQL: Grant SELECT Permission

  •     http://lists.sqlmag.com/t?ctl=1314B:1036D
  • Performance: Error: 17832, Severity: 18, State: 7

  •     http://lists.sqlmag.com/t?ctl=1314F:1036D
  • Data Access: Deadlock for Remote SELECT Statement

  •     http://lists.sqlmag.com/t?ctl=1314D:1036D

    Hot Spot


  • FREE Product Trial: Protect Your Web Apps from Hackers

  • WebInspect 5.5 employs threat agents to simulate attackers analyzing your web applications, formulating attacks and applying them to determine if vulnerabilities exist. Run a FREE Test of your Web Apps via our FREE 15 Day Product Trial that delivers a comprehensive vulnerability report.
        http://lists.sqlmag.com/t?ctl=13158:1036D

    7. Announcements


  • Get Access to Every SQL Server Magazine Article on CD

  • The SQL Server Magazine Master CD goes a step further by offering portable access to the entire SQL Server Magazine article database--more than 2500 articles! The newest issue includes BONUS SQL Server 2005 tips; sign up now, and SAVE 25%. Offer ends 9/30/05, so subscribe now:
        http://lists.sqlmag.com/t?ctl=1315B:1036D

  • Register Now for the 2005 PASS Community Summit

  • The 2005 PASS Community Summit, September 27-30 in Grapevine (Dallas), Texas, is your final chance to obtain in-depth information on Microsoft SQL Server 2005 before its upcoming official launch. Register now for the LARGEST user-driven SQL Server educational event! Click here:
        http://lists.sqlmag.com/t?ctl=13161:1036D

    8. New & Improved


        by Dawn Cyr, products@sqlmag.com

  • Share Your Story and Get a T-Shirt!

  • Have you used a product that saved you time or made your job easier? Tell us how your favorite product solved a SQL Server problem for you, and if we print your submission in the magazine's Hands On department we'll send you a SQL Server Magazine t-shirt. Send your email today to handson@sqlmag.com!

    Innovartis announced DB Ghost 4.0, change-management software for SQL Server databases that automates the process of building and deploying SQL Server databases directly from any source-code control system. The software connects to a source-code control system and extracts the latest definitions of the database objects and lookup data. The product then uses these definitions to build and verify the integrity of the database code and uses the verified code to compare and synchronize your target database and generate a change script. The complete DB Ghost toolset consists of a series of modules that you can plug into existing tools or combine as a bundled toolset at a discounted price. Pricing for DB Ghost Professional Edition, which includes Innovartis's Scripter, Builder, Schema Compare, and Data Compare, starts at $350. For complete module and pricing information, contact Innovartis at 44(0) 208-241-1762 or enquiries@innovartis.co.uk.
        http://lists.sqlmag.com/t?ctl=13168:1036D

    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.
    http://www.sqlmag.com/rd.cfm?code=00ep214xeb

    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.