SQL Server Magazine Web Exclusive October 21, 2004 SQL Server Magazine UPDATE, October 21, 2004—SQL Server 2005 Technology Previews InstantDoc ID 44292 by Various authors

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@list.windowsitpro.com to your list of allowed senders and contacts.

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.

This Issue Sponsored By

XPrime Database Accelerator for SQL Server
    http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMGB0AF

LiteSpeed for SQL Server
     http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMPY0Al

Take Control of Your SQL Code with DB Ghost
    http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BLbB0Af


October 21, 2004


1. Perspectives

  • Technology Previews Deliver Pre-Beta 3 Peaks at SQL Server 2005
  • 2. News and Views

  • Microsoft Fixes DBCC CHECKDB Error in SQL Server 2003 SP3
  • Results of Previous Instant Poll: Hours Per Week
  • New Instant Poll: Community Technology Previews
  • 3. Announcements

  • Master the SQL Server Universe!
  • SqlJunkies Has What Developers Need
  • 4. Peer to Peer

  • Hot Tip: SQL Server Tools Return Different Results
  • Hot Article: Visual Studio Team System
  • Hot Threads
  • 5. Hot Spot

  • Take Control of Your SQL Code with DB Ghost
  • 6. Events Central

  • Join Itzik Ben-Gan, William Vaughn, and Gert Drapers in Brussels!
  • 7. New and Improved

  • Cut Scripting Time
  • Analyze Web Data
  • Sponsor: XPrime Database Accelerator for SQL Server
    Improve SQL Server performance by 500%! Learn how to Scale-Out SQL Server to 512 Xeons and 2TB RAM.
        http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMGB0AF

    1. Perspectives


  • Technology Previews Deliver Pre-Beta 3 Peaks at SQL Server 2005

  •     by Brian Moran, brian@sqlmag.com

    Microsoft has announced a change in SQL Server 2005 beta programs. Don't worry—it's not a delay; the change will get new SQL Server 2005 betas to you sooner rather than later. In an email to SQL Server 2005 beta testers last week, Microsoft Senior Vice President Paul Flessner said that as part of the company's efforts to work more closely with beta testers during the product-development cycle, the SQL Server team decided to release Community Technical Previews (CTPs) for SQL Server 2005. "The SQL Server 2005 CTPs are interim builds of SQL Server 2005 between major betas that will enable you to test and experiment with new features as they are added to the product without having to wait for the next beta," Flessner's memo explained. "Your involvement during the development cycle will ensure that we ship a better product."

    So what's a CTP release? Let's not mince words: It's beta software. Essentially, Microsoft has decided that it has made enough improvements to SQL Server 2005 since Beta 2's release to make the product valuable and stable for testing and learning purposes. As Flessner noted, Microsoft based its decision to release CTP builds for SQL Server 2005 on the helpful feedback that the development team received during SQL Server 2005 Beta 1's limited community release. The company hopes to release more than one CTP version between now and the official public beta, Beta 3. That decision depends on how much feedback the community gives the SQL Server development team. Microsoft developers are using the CTPs to get more feedback about how to improve the product, so let's give it to them! A lot of work goes into a CTP release, so it's not worth Microsoft's time to produce one unless we provide feedback that the SQL Server team can use to make the final release better. If Microsoft doesn't get much feedback, we might have to wait for the next beta to get any new bits.

    Users who have access to the SQL Server 2005 download area on BetaPlace ( http://www.betaplace.com/ ) received the first CTP last week, and within the week, MSDN Universal, Enterprise, and Professional subscribers will be able to download the CTP from the Microsoft Developer Network (MSDN) Subscriber Downloads site. I haven't explored the CTP release yet, but here are a few enhancements Microsoft told me to expect:

  • SQL Server Integration Services (formerly, Data Transformation Services—DTS) improvements in designer performance, error messages, and consistency between component UIs.
  • Analysis Services performance improvements in cube processing as well as enhancements to queries and the MDX debugger; faster and more accurate data mining algorithms; greater flexibility and customization in the usage of Actions and Key Performance Indicators (KPIs); better error handling and error messages; and UI improvements.
  • Performance and quality improvements in the SQL Server engine
  • Is Beta 2 upgradeable to CTP, or will you need to reinstall SQL Server 2005 to Beta 2? Because Microsoft doesn't perform beta-level testing on CTPs, the company recommends not running the CTP on the same machine as the betas—you should keep them separate. Of course, Virtual PC from Microsoft (or other virtual machine technology) is a great way to deal with multiple software versions on one physical machine. If you're wondering about SQL Server 2005 ship dates, Microsoft is still planning to release Beta 3 in the first quarter of next year and the final product next summer.

    2. News & Views


  • Microsoft Fixes DBCC CHECKDB Error in SQL Server 2000 SP3

  • Microsoft has released a hotfix for a 8649 error message that might occur when you execute the DBCC CHECKDB statement in SQL Server 2000 Service Pack 3 (SP3). The error message looks like "Server: Msg 8649, Level 17, State 1, Line 2 The query has been cancelled because the estimated cost of this query (381) exceeds the configured threshold of 50. Contact the system administrator." This problem occurs because the DBCC CHECKDB statement checks the server-wide query governor cost-limit time setting, but it ignores the session time setting QUERY_GOVERNOR_COST_LIMIT that's set by the SET QUERY_GOVERNOR_COST LIMIT statement. Because of this error, you can't use maintenance plans with the query governor cost-limit server setting and a reasonable database size and you can't perform a database integrity check in a database maintenance plan. To learn more about this error and the supported hotfix, read the Microsoft article "FIX: You receive a "Msg 8649" error message when you execute the DBCC CHECKDB statement in SQL Server 2000 Service Pack 3 (SP3)" at
        http://support.microsoft.com/?kbid=840208


    LiteSpeed for SQL Server
    Make LiteSpeed a part of your disaster recovery plan. LiteSpeed is a rapid backup and restore solution from Imceda software that compresses data to up to 95% of its original size. Don't entrust your data to untested imitations, LiteSpeed is the industry leader that has won awards and the praise of thousands. Try LiteSpeed for free, tell us what you think, and we'll send you a free T-Shirt. Go to:
         http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMPY0Al


  • Results of Previous Poll: Hours Per Week
  • "How many hours do you work in a typical week?" Here are the results from the 360 votes:

  • 19%   Up to 40 hours
  • 55%   41-50 hours
  • 18%   51-60 hours
  • 6%     61-70 hours
  • 2%     More than 70 hours
  • New Instant Poll: Community Technology Previews

  • "Will you download SQL Server 2005's new Community Technology Previews?" Go to the SQL Server Magazine home page ( http://www.sqlmag.com ) and submit your vote for

  • Yes, I plan to download the CTPs
  • I don't know yet if I will download the CTPs
  • No, I don't plan to download the CTPs
  • I don't think I have access to the CTPs
  • 3. Announcements


    Master the SQL Server Universe!
    Order the newest version of the SQL Server Magazine Master CD and receive portable access to more than 5 years of SQL Server Magazine article archives. As an added bonus, you'll also receive exclusive scripting and security content—a $30 value—for free. Subscribe to this helpful resource today:
        http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMPZ0Am

    SqlJunkies Has What Developers Need
    SqlJunkies is your online community resource for original tutorial and how-to articles for developing applications with SQL Server 2000 and Yukon; peer-to-peer help and networking through discussion forums and newsgroups; technology tips and pointers from expert bloggers; and the latest in SQL Server-related events and news.
         http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BFll0AR

    4. Peer to Peer


  • Hot Tip: SQL Server Tools Return Different Results
  • by Brian Moran, savvy@sqlmag.com

    Q. When I use different SQL Server tools to return statistics information about an event, I sometimes receive widely varying results. For example, when I run Listing 1 in Northwind with Query Analyzer's Show Server Trace option turned on, the server trace shows that the SQL:StmtCompleted event performed 185 reads. However, Figure 1 shows the event's statistics when I execute the query with STATISTICS IO enabled—1711 total reads. And if I use SQL Server Profiler to trace the query's execution, I get 1721 reads for SQL:StmtCompleted. Which result is correct, and why do the tools return different results?

    Find the listing, figure, and answer to this question today at
    http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMPa0At

  • Hot Article: Visual Studio 2005 Team System

  • At TechEd 2004 in San Diego, Microsoft thrust Visual Studio fully into the enterprise development space by introducing the newest version, Visual Studio 2005 Team System. Like previous versions, this product supports application development in any of the .NET languages, including Visual Basic .NET (VB .NET), C#, J#, and C++. But Microsoft has added several enterprise-oriented team development and project-management features to put the product on par with any enterprise-level development tool. Microsoft plans to release Team System when it releases single-user editions of Visual Studio 2005 in mid-2005. In his October SELECT TOP(X) column, "Visual Studio 2005 Team System," Michael Otey shares Visual Studio 2005 Team System's five most important enterprise-oriented features. Read this article today at
        http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMPb0Au

    Hot Threads: Check out the following hot threads, and see other discussions in our 30 SQL Server forums.
    http://www.windowsitpro.com/sqlserver/forums/

    Distributor Can't Connect to Subscriber
    http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMPc0Av
    Preventing Client Connection to Enterprise Manager
    http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMPd0Aw
    Declaring Variables Inside a View
    http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMPe0Ax
    Subquery Performance Tuning
    http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMPf0Ay
    Errors in Stored Procedure Syntax
    http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMPg0Az
    DTS Losing Records Without Reporting Errors
    http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMPh0A1

    5. Hot Spot


    Take Control of Your SQL Code with DB Ghost
    DB Ghost is the ONLY true database change manager for SQL Server on the market and makes one database the same as another every time, not just sometimes, but every single time. VSJ Magazine's review concluded that DB Ghost "goes further than any rival software." Get your free evaluation copy:
        http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BLbB0Af

    6. Events Central


  • Join Itzik Ben-Gan, William Vaughn, and Gert Drapers in Brussels!

  • Learn from SQL Server Magazine experts at Europe's premiere SQL Server event—Brussels SQL Server Day on October 26. Join Microsoft and SQL Server Magazine for a free, full-day event that gives SQL Server users the tools they need to unleash the power of SQL Server 2000, deploy SQL Server Express, and get ready for SQL Server 2005. Register now!
         http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMPi0A2

    See the complete Windows IT Pro Network guide to Web and live events
        http://www.winnetmag.com/events/

    7. New & Improved


        by Dawn Cyr, products@sqlmag.com

  • Cut Scripting Time

  • Red Earth Technologies announced Superior SQL Builder 1.5, a SQL scripting tool that lets you build complete SQL scripts without typing code. The product's scripting technology lets you quickly transform database data by using an intuitive interface that simplifies the script-building process. By using the integrated scripting environment, you eliminate the need to cut and paste individual queries to form a solution, and the environment lets you view complete SQL scripts. The product's new features include the automation of database connections and the inclusion of new script templates that let you eliminate syntax, logic, and typographical errors when developing SQL scripts. SQL Builder 1.5 supports SQL Server, Microsoft Access, Oracle, and MySQL. A fully functional evaluation version of the product is available at the company's Web site, and online program registration costs $349. For more information, contact Red Earth Technologies at 61-7-5534-6551 or sales@redearthtechnologies.com.
        http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BMPj0A3

  • Analyze Web Data
  • Sane Solutions announced NetTracker 7.5 SMB and NetTracker 7.5 eBusiness, Web-data analysis applications that use your SQL Server database to provide users with scalable Web analytics and open access to your Web data warehouse. Both products use an open database schema to let users easily extract data for integration with other business data through third-party solutions such as business intelligence (BI), customer relationship management (CRM), sales force automation (SFA), or contact-management tools. The products provide custom reporting features and enterprise Web-data-management options. Pricing for NetTracker 7.5 SMB starts at $7500, and pricing for NetTracker 7.5 eBusiness starts at $25,000. For more information, contact Sane Solutions at 401-295-4809, 800-407-3570, or sales@sane.com.

         http://list.windowsitpro.com/cgi-bin3/DM/y/ehwx0McMHC0Kj40BJPs0AA

    Contact Us


  • About the newsletter—letters@sqlmag.com
  • About technical questions—http://www.sqlmag.com/forums
  • About product news—products@sqlmag.com
  • About your subscription—sqlupdate@sqlmag.com
  • About sponsoring SQL Server Magazine UPDATE—Kate Silvertooth, ksilvertooth@sqlmag.com
  • SQL Server Magazine 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://secure.pentontech.com/nt/sql/index.cfm?promocode=00

    Manage Your Account You are subscribed as #EmailAddr#. To unsubscribe from this email newsletter, click here /#Mailing:UnsubEmail

    To make other changes to your email account such as changing your email address, updating your profile, and subscribing or unsubscribing to any of our email newsletters, simply log on to our Email Preference Center.
        http://email.winnetmag.com/winnetmag/winnetmag_prefctr.asp

    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 2004, Penton Media, Inc. All Rights Reserved.