SQL Server Magazine UPDATE, January 27, 2005--SQL Server 2000 Service Pack 4

Subscribe to SQL Server Magazine:

Our domain name has changed! To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add [email protected] 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.

5.25" Floppies * 8-Tracks * SQL Server 2000 JDBC

Free SQL Server 2000 Training CD!

Want a Perfect Release? Every Time?

January 27, 2005

1. Perspectives

  • Beta Testers Get SQL Server 2000 Service Pack 4
  • 2. News and Views

  • Share Your Product Success Story and Get a T-Shirt!
  • Results of Previous Instant Poll: RAID Storage
  • New Instant Poll: Data Integrity
  • 3. Events and Resources

  • Recovery-Management Strategies
  • Win a Harley at SQL Server Magazine Connections
  • 4. Peer to Peer

  • Hot Tip: Varying Event Durations Can Point to Compilation Problems
  • Hot Article: Building Better BI in SQL Server 2005
  • Kevin Kline's "In a Nutshell" Blog: Getting Ahead of the Curve on Yukon
  • Hot Threads
  • 5. Announcements

  • SQL Server Magazine Gives DBAs What They Need!
  • Nominate Yourself or a Friend in the MCP Hall of Fame
  • 6. New and Improved

  • Move Informix Databases to SQL Server
  • Get Data Integration for Small and Midsized Businesses
  • Sponsor: 5.25" Floppies * 8-Tracks * SQL Server 2000 JDBC
    Sure, they were great technologies once, but try using them today! Microsoft's JDBC driver for SQL Server 2000 is built on technology that's more than 3 years old. You wouldn't try to run your CD on an 8-track player. Why would you run your business application with an old JDBC driver? DataDirect presents today's JDBC--the SpecjAppServer/ECPerf leader. Featuring Windows Authentication support, J2EE certification, and advanced 3.0 specification compliance for SQL Server 2000 and SQL Server 7. The difference? Like comparing DVD to Betamax.

    Try DataDirect Connect for JDBC. You'll never go back. Read more:     http://lists.sqlmag.com/t?ctl=40B:7B3DB

    1. Perspectives

  • Beta Testers Get SQL Server 2000 Service Pack 4

  •     by Brian Moran, [email protected]

    A few weeks ago, Microsoft released SQL Server 2000 Service Pack 4 (SP4) to beta testers. Typically, service pack beta programs are by invitation only; however, SP4 is available to the general public. You can sign up for the beta program at http://lists.sqlmag.com/t?ctl=410:7B3DB . You'll also find information about how to get SQL Server 2000 Reporting Services SP2 and SQL Server 2005 Express SP2. Reporting Services SP2 includes many bug fixes and some useful enhancements, including client-side printing and new SharePoint Web parts for viewing and browsing reports on the Report Server.

    SQL Server 2000 SP4 is a large update. I counted 236 entries in the fix list--SP3 had only 82. My favorite fix is "FIX: "Performance monitor shared memory setup failed: -1" error message when you start SQL Server." I do a lot of performance monitoring and troubleshooting, and this annoying bug kept key performance counters from working if certain monitoring tools, such as (but not limited to) Performance Monitor, were running during a SQL Server reboot.

    SQL Server 2000 SP4 also introduces support for 64-bit AMD and Intel Extended platforms in Win16 on Win32 (WOW), which is a major new functionality. SP4 is the first service pack to support SQL Server's 64-bit release. Generally speaking, service packs contain bug fixes. It's rare to see such a major new feature added to a product in a service pack. Most people aren't using SQL Server's 64-bit version today; however, support for hardware platforms that can natively support 32-bit or 64-bit is a great feature. It lets you buy a machine today that will run 32-bit, but leverage your investment to take advantage of 64-bit when you need it. The beta nomination page doesn't have a complete list of SP4 fixes, but you can find the bug-fix list at http://lists.sqlmag.com/t?ctl=41E:7B3DB .

    It goes without saying that you shouldn't deploy a beta service pack on a production machine. In fact, many of you won't have the time to test or play with a beta service pack at all. I often wait until a service pack is released before mentioning it. In this case, I started early because I think it's important that you know about the new 64-bit support Microsoft added, in case you're in the process of making a new hardware decision. If you are, you might very well want to consider a platform that lets you run 32-bit today, but 64-bit in the future.

    Free SQL Server 2000 Training CD!
    See why AppDev was voted THE BEST by readers of SQL Server Magazine...get a FREE SQL Server 2000 Training CD-ROM--a $95 value! Click the link below for your free SQL training CD.

    2. News & Views

  • Share Your Product Success Story and Get a T-Shirt!

  • Have you used a product that saved you time or made your job easier? SQL Server Magazine is starting a new department featuring readers' favorite products. The Hands On page will let you share successes you've had with SQL Server-related products and services. Tell us your product-success story, and if we print your submission in the Hands On department, we'll send you a SQL Server Magazine t-shirt. Send your product suggestion with information about how the product helped you to products editor Dawn Cyr at [email protected] Please put the words "Hands On" in the subject line.
        [email protected]

  • Results of Previous Instant Poll: RAID Storage
  • "What kind of RAID storage do you use for SQL Server?" Here are the results from the 226 votes:

  •  7%   I don't use RAID
  • 14%   RAID 1
  • 58%   RAID 5
  • 18%   RAID 10
  •  3%   Other
  • New Instant Poll: Data Integrity

  • "Where do you usually enforce data integrity?" Go to the SQL Server Magazine home page ( http://lists.sqlmag.com/t?ctl=41D:7B3DB ) and submit your vote for

  • At the client
  • At the server
  • At the client and the server
  • Varies according to efficiency
  • I don't give much thought to data integrity
  • 3. Events and Resources

  • Recovery-Management Strategies

  • Learn how to improve business continuity and information lifecycle management with this analyst white paper, compliments of BMC Software. Discover the backup and recovery management strategies needed to keep mission-critical systems running. Download now!

  • Win a Harley at SQL Server Magazine Connections

  • March 20-23, Hyatt Grand Cypress Resort in Orlando, Florida. Don't miss this exciting event offering cutting-edge sessions by Microsoft and industry gurus. Attendees receive beta copies of SQL Server 2005 and Visual Studio 2005 and a chance to win a Harley-Davidson motorcycle! 800-438-6720 or 203-268-3204.

    See the complete Windows IT Pro Network guide to Web and live events.

    4. Peer to Peer

  • Hot Tip: Varying Event Durations Can Point to Compilation Problems

  •     by Brian Moran, [email protected]

    Q. When I use SQL Server Profiler to track performance problems, I sometimes notice large differences--as much as 2 or 3 seconds--between the duration for the SQL:BatchCompleted event and the SQL:StmtCompleted event. Why are the duration times different?

    Read the answer to this question today at

  • Hot Article: Building Better BI in SQL Server 2005

  • Microsoft General Manager of SQL Server Business Intelligence Bill Baker spoke to SQL Server Magazine about the new BI features in SQL Server 2005 and how they can help you streamline delivery of business-critical information. Read the exclusive interview, "Building Better BI in SQL Server 2005" today at?

  • In a Nutshell: Getting Ahead of the Curve on Yukon

  • In this week's blog, "Getting Ahead of the Curve on Yukon," Kevin Kline talks about the significant number and depth of improvements that Microsoft is making to SQL Server's next release. Microsoft has put a lot of effort into public training as well. By investing a few hours of time, you'll get a heads up on what's new in the next release. Kevin has been through every upgrade of SQL Server since version 4.21a and can attest that there has never been so much high-quality training material available so early in the product development cycle. Don't let it go to waste! Check out Microsoft's SQL Server 2005 Web site today and start reading, then tell Kevin what you think about SQL Server's upcoming release at

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

    Development: Sorting and Ranking Query Results
    T-SQL: Calculating Number of Days
    Performance: Decoding Profiler Statistics on Backup
    Administration: User-Permission Problem When Restoring Database
    DTS: Padding a Field with the STUFF() Function

    Hot Spot

  • Want a Perfect Release? Every Time?

  • DB Ghost builds directly from your source control system, validating your code as it builds, so the hassles of working with broken databases become a distant memory. DB Ghost can then compare and synchronize a target database giving you a perfect release. Every time. See for yourself:

    5. Announcements

  • SQL Server Magazine Gives DBAs What They Need!

  • Order SQL Server Magazine today and save 30% off the cover price! Along with these great savings, you'll receive free access to every article ever published in the magazine--online! That's a library containing more than 5 years of tips, tricks, and how-tos! Click here to order:

  • Nominate Yourself or a Friend in the MCP Hall of Fame
  • Are you a top-notch MCP who deserves to be a part of the first-ever MCP Hall of Fame? Get the fame you deserve by nominating yourself or a peer to become a part of this influential community of certified professionals. You could win a VIP trip to Microsoft and other valuable prizes. Enter now--it's easy:

    6. New & Improved

        by Dawn Cyr, [email protected]

  • Move Informix Databases to SQL Server

  • Ispirer Systems announced SQLWays 3.8, database-migration software that lets you transfer data, database schema, and business logic between different database platforms. The new release lets you migrate stored procedures and triggers from Informix Dynamic Server to SQL Server, Oracle, IBM DB2, Sybase, and MySQL database platforms. SQLWays 3.8 automatically converts most language constructions, including many specific Informix features--in particular, the Informix ability to return intermediate results from a procedure and resume the procedure's execution from the previous return point. Besides facilitating business-logic conversion, the product migrates Informix data and schema including tables, views, indexes, keys, relationships, constraints, and other table properties; provides advanced data-type mapping; and resolves identifier and reserved-word conflicts. Unlike solutions that depend on a combination of separate porting tools, SQLWays is an integrated solution that automatically resolves modifications between interdependent tables, views, and procedures. Pricing for SQLWays 3.8 starts at $295 for a 100-object license, and a free trial version is available at the vendor's Web site. For more information, contact Ispirer Systems at 877-734-7638, 770-319-2718,or [email protected]

    Get Data Integration for Small and Midsized Businesses
    DB Software Laboratory announced Visual Importer Pro 6.5.5, a comprehensive data-integration tool that lets you perform high-speed data transfers from text files and ODBC source databases into SQL Server 2000 and 7.0, Oracle, or ODBC target databases. The application combines extraction, transformation, and loading (ETL), and design capabilities in one environment to simplify the creation and deployment of complex data warehouses and marts. Along with simple record transfer within one system, the product allows for cross-system data extraction and loading, which you can streamline by using calculations for data formatting, concatenations, and loading cross and pivot tables. The product also supports loading of multiple files. The product's simple interface requires no specialized programming or database-deployment skills; and because all stages of data processing are automated, the application eliminates the need for regular intervention and upkeep. The product's simplicity makes it especially suited for small businesses, schools, libraries, and other organizations that require simple, inexpensive integration solutions. Pricing for Visual Importer Pro 6.5.5 starts at $150 for a single-user license. Registered customers receive free updates and technical support. A free 30-day evaluation version is available at the vendor's Web site. For more information, contact DB Software Laboratory at [email protected]

    Contact Us

  • About the newsletter—[email protected]
  • About technical questions—http://www.sqlmag.com/forums
  • About product news—[email protected]
  • About your subscription—[email protected]
  • About sponsoring SQL Server Magazine UPDATE—Richard Resnick, [email protected]
  • 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.

    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.

    View the SQL Server Magazine Privacy Policy.

    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.

    Hide comments


    • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

    Plain text

    • No HTML tags allowed.
    • Web page addresses and e-mail addresses turn into links automatically.
    • Lines and paragraphs break automatically.