Subscribe to SQL Server Magazine:     http://lists.sqlmag.com/t?ctl=BDE0:7B3DB


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.

Free White Paper: NonDisruptive SQL Server Failover
    http://lists.sqlmag.com/t?ctl=BDD9:7B3DB

FREE SQL Server 2000 Training CD!
     http://lists.sqlmag.com/t?ctl=BDE4:7B3DB

Breakthrough Solution for SQL Server Consolidation
    http://lists.sqlmag.com/t?ctl=BDE2:7B3DB


June 9, 2005

1. Perspectives

  • Microsoft's Reporting Services 180
  • 2. SQL Server 2005 Watch

  • SQL Server 2005 News From Microsoft TechEd
  • 3. News & Views

  • Calling All Windows IT Pro Innovators!
  • Results of Previous Instant Poll: Online Training and Information
  • New Instant Poll: Microsoft TechEd
  • 4. Reader Challenge

  • June Reader Challenge Solution: Capturing Vital Information About Data Transformations
  • July Reader Challenge: Case Sensitive Settings
  • 5. Events and Resources

  • Find Out What's New in SQL Server Analysis Services 2005
  • Diagnose and Resolve Performance Problems
  • Get Ready for SQL Server 2005 Roadshow in Europe
  • 6. Featured White Paper

  • Optimizing Exchange: Strategies for Managing the Lifecycle of Email Data
  • 7. Peer to Peer

  • Hot Tip: Estimated Row Counts Affect Performance
  • Hot Article: Performing Base Conversions
  • Reader to Reader: Use TSQL to Backup and Restore SQL Server User Databases
  • In a Nutshell: Microsoft BI Webcast Series
  • Hot Threads
  • 8. Announcements

  • Exclusive OfferSave 44% off SQL Server Magazine
  • Exclusive Content for VIP Subscribers!
  • 9. New & Improved

  • Use Image Backups to Recover from Disaster
  • Provide Server Availability
  • Sponsor: Free White Paper: NonDisruptive SQL Server Failover 100% application availability is not impossible, nor impossibly expensive. Keep your users continuously connected to working applications, no matter whether a failure occurs in the operating system, a hardware component, a software application, or somewhere within the network. Neverfail's high availability and DR solutions are a clustering alternative designed to eliminate downtime, and provide a simple, costeffective solution for business continuity. View a demo or access a free whitepaper. http://lists.sqlmag.com/t?ctl=BDD9:7B3DB

    1. Perspectives


    Microsoft's Reporting Services 180
        by Brian Moran, brian@sqlmag.com

    This week, at Microsoft TechEd in Orlando, Florida, Microsoft turned a complete 180 in the way the company will license SQL Server Reporting Services and Report Builder. Microsoft was planning to include Report Builder in SQL Server 2005 Enterprise Edition but not Standard Edition or other less expensive SQL Server SKUs. I thought that was going to be a big mistake for Microsoft, and many people in the SQL Server community agreed with me. But this week, Microsoft Senior Vice President of Server Applications Paul Flessner announced that Reporting Services will be included in all editions of SQL Server 2005. In addition, the Workgroup and Standard Editions of SQL Server 2005 will include Report Builder.

    Report Builder is Microsoft's answer to end users' need for an ad hoc report writer they can use to build their own reports. Reporting Services is a great platform, but the product's current tool set for developing reports is geared toward the developer audience. It's not easy for an average reporting system end user to use to do their ad hoc report creation. I don't mean to oversimplify the issue, but Report Builder will provide an interface for average end users (i.e., users that have limited technical knowledge) to effectively build their own reports. Report Builder is nice, but it's probably not worth paying the $20,000 premium it would cost to move up from SQL Server Standard Edition to SQL Server Enterprise Edition. Instead, if Microsoft had stuck to its original plan, most customers would probably use thirdparty tools to fill their reporting needs. I suspect that Microsoft's turnaround concerning Report Builder means that the company recognizes there's tremendous benefit to letting all SQL Server usersincluding those using Standard Editionstandardize on Reporting Services as the reporting platform of choice (i.e., Reporting Services becomes the only reporting solution they need).

    Report Builder's inclusion in SQL Server 2005 Standard Edition, and the inclusion of Reporting Services itself in all editions, arguably gives the SQL Server community the ability to manage their entire reporting infrastructure, including ad hoc enduser access, with features that ship in the box. I think offering that ability is a wise decision on Microsoft's part.


    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 CDROMa $95 value! Click the link below for your free SQL Server training CD.
        http://lists.sqlmag.com/t?ctl=BDE4:7B3DB


    2. SQL Server 2005 Watch


    SQL Server 2005 News From Microsoft TechEd
    Tuesday, Microsoft officially announced that SQL Server 2005 will launch in November of this year. As part of his keynote address at Microsoft TechEd, Microsoft Senior Vice President of Server Applications Paul Flessner announced that SQL Server 2005, Visual Studio 2005, and BizTalk Server 2006 will be formally launched during the week of November 7. During the keynote address, Flessner also announced the June Community Technology Preview (CTP) for SQL Server 2005. The featurecomplete SQL Server 2005 June CTP is the first prerelease version of SQL Server 2005 available to the public and is available for download at http://lists.sqlmag.com/t?ctl=BDE3:7B3DB .

    Flessner went on to highlight details about new business intelligence (BI) functionality for SQL Server 2005, the new SQL Server Migration Assistant (SSMA), and the first benchmarks for SQL Server 2005. Flessner also outlined Microsoft's RFID initiative and the 2006 updates to the Windows Server System Common Engineering Criteria, technical standards designed to create consistency across Microsoft's server products and help reduce the complexity and costs associated with deploying and managing systems.

    Flessner also announced that SQL Server Reporting Services will be included in all editions of SQL Server 2005. In addition, the Workgroup and Standard Editions of SQL Server 2005 will include Report Builder, a Reporting Services enduser tool. Microsoft had previously planned to include the reporting tools only in SQL Server 2005 Enterprise Edition, but has included them in more editions in response to customer requests. The inclusion of the Report Builder tool in multiple editions of the upcoming SQL Server release means that organizations can provide business users with this simple reporting tool without having to invest in the fullblown Enterprise Edition of the new SQL Server release. The tool frees up SQL Server professionals by letting them provide users with limited access to data and create their own reports without requiring IT to customize report changes for them.

    >Sponsor: Breakthrough Solution for SQL Server Consolidation With ARMTech for SQL Server workload management technology from Aurema, you can improve system utilization and performance, lower TCO and say goodbye forever to the days of "one app, one server." The only workload management solution specifically designed to enable SQL Server consolidation; ARMTech delivers increased reliability, improved performance, and higher system utilization in Windows server environments. Download your free evaluation copy of ARMTech for SQL Server and start saving today!
        http://lists.sqlmag.com/t?ctl=BDE2:7B3DB

    3. News & Views


    Calling All Windows IT Pro Innovators!
    Have you developed a solution that uses Windows technology to solve a business problem in an innovative way? Enter your solution in the Windows IT Pro Innovators Contest! Grandprize winners will receive a host of great prizes and a writeup in the November 2005 issue. Contest ends June 24, 2005. To enter, go to
        http://lists.sqlmag.com/t?ctl=BDDC:7B3DB

    Results of Previous Instant Poll: Online Training and Information
    "What online training and information resources do you use most often?" Here are the results from the 66 votes:

  • 11%   Webcasts, Podcasts, or other instructorled classes
  •  6%   Selfpaced downloadable courses
  • 30%   Articles and whitepapers
  • 27%   SQL Serverrelated portal sites
  • 23%   Google searches
  •  3%   Other
  • New Instant Poll: Microsoft TechEd
    "Did you attend the Microsoft TechEd conference in Orlando, Florida?" Go to the SQL Server Magazine home page ( http://lists.sqlmag.com/t?ctl=BDE9:7B3DB ) and submit your vote for

  • Yes, I always attend
  • Yes, it was my first time
  • No, but I plan to attend next year
  • No, and I don't plan to attend
  • 4. Reader Challenge


  • June Reader Challenge Solution: Capturing Vital Information About Data Transformations

  •      by Umachandar Jayachandran, challenge@sqlmag.com

    You can read a recap of the problem and the solution to the June Reader Challenge "Capturing Vital Information About Data Transformations," at
        http://lists.sqlmag.com/t?ctl=BDD1:7B3DB

  • July Reader Challenge: Case Sensitive Settings

  • Now, test your SQL Server savvy in the July Reader Challenge, "Case Sensitive Settings " (below). Submit your solution in an email message to challenge@sqlmag.com by June 16. Umachandar Jayachandran, a SQL Server Magazine technical editor, will evaluate the responses. We'll announce the winner in an upcoming SQL Server Magazine UPDATE. The firstplace winner will receive $100, and the secondplace winner will receive $50.

    Here's the challenge: Marat, a software developer in a company that develops datamodeling applications, has an application that includes SQL Server 2000 modifications. One of the modifications lets users create databases on the server. As part of the databasecreation process, Marat wants to detect if the SQL Server supports the use of database names that are case sensitive. Help Marat determine this SQL Server setting so that the application can handle it appropriately.

    5. Events and Resources


  • Find Out What's New in SQL Server Analysis Services 2005

  • In this free Web seminar, gain an indepth understanding of the many new features and capabilities Microsoft has introduced in SQL Server 2005 Analysis Services. You'll learn about data source views, userdefined hierarchies, measure groups, KPIs and more! Plusget all you need to know about integration with Integration Services and Reporting Services and the new deployment and synchronization capabilities in SQL Server 2005 Analysis Services.
        http://lists.sqlmag.com/t?ctl=BDD0:7B3DB

  • Diagnose and Resolve Performance Problems

  • Maximizing application performance isn't easy, and database is only one component of today's complex, multitiered systems. In this free Essential Guide, learn how to follow a solid monitoring practice and troubleshoot issues before they get out of hand. You'll discover how you can ensure optimal SQL Server performance and satisfied users.
        http://lists.sqlmag.com/t?ctl=BDD8:7B3DB

  • Get Ready for SQL Server 2005 Roadshow in Europe

  • Get the facts about migrating to SQL Server 2005. SQL Server experts will present realworld information about administration, development, and business intelligence to help you implement a bestpractices migration to SQL Server 2005 and improve your databasecomputing environment. Receive a 1year membership to PASS and 1year subscription to SQL Server Magazine. Register now!     http://lists.sqlmag.com/t?ctl=BDD5:7B3DB

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


    6. Featured White Paper


  • Optimizing Exchange: Strategies for Managing the Lifecycle of Email Data

  • Manage missioncritical email data. Download this white paper!
        http://lists.sqlmag.com/t?ctl=BDD6:7B3DB


    7. Peer to Peer


    Hot Tip: Estimated Row Counts Affect Performance by Brian Moran, savvy@sqlmag.com

    Q. When looking at Query Analyzer's graphical showplan output, I see many cases in which the estimated row count differs significantly from the actual row count at a query level and for individual steps within the query. What does this mean and should I be worried?

    Read the answer to this question today at
        http://lists.sqlmag.com/t?ctl=BDD2:7B3DB

  • Hot Article: Performing Base Conversions

  • A frequent request that pops up in public SQL Server newsgroups is how to perform base conversions. That is, you store values as character strings containing digits in a given base and want to convert them to a target base. Typically, you need to store values in a nondecimal base when you have an application that works with nondecimal values. However, SQL Server doesn't support working with values expressed in a nondecimal base. Thus, you have a problem if you store such values and need to perform arithmetic manipulations, such as calculating the result of 1101 + 1010 expressed in base 2. In his June TSQL Black Belt column "Performing Base Conversions," Itzik BenGan explores how to convert a value in any given base to a decimal value so that you can apply any arithmetic manipulation. Read this article today and post your comments at
        http://lists.sqlmag.com/t?ctl=BDD3:7B3DB

  • Reader to Reader: Use TSQL to Backup and Restore SQL Server User Databases

  • In this month's Reader to Reader tip "Use TSQL to Backup and Restore SQL Server User Databases," Eli Leiba shares a couple of TSQL proceduressp_backup_databases and sp_restore_databasesyou can use to move all your user databases from one SQL Server machine to another with ease. The sp_backup_databases procedure performs a complete database backup of all user databases to the specified directory. The sp_restore_databases procedure restores those databases. Read this article today at
        http://lists.sqlmag.com/t?ctl=BDD4:7B3DB

    Share your SQL Server discoveries, comments, problems, solutions, and experiences with products and reach out to other SQL Server Magazine readers. Email your contributions (400 words or less) to r2r@sqlmag.com. Please include your phone number. We edit submissions for style, grammar, and length. If we print your submission, you'll get $50!

  • In a Nutshell: Microsoft BI Webcast Series

  • Microsoft has done a fabulous job of educating users about the next release of SQL Server. The company is doing far better than its ever done in the past and its also blowing the competition away in terms of the quality and quantity of educational content. The SQL Server team is now Kevin Kline's gold standard when judging vendor educational contribution to a major product release. Way to go, guys! If you need to learn more about business intelligence (BI), you should look into Microsoft's new series of BI Webcasts at http://lists.sqlmag.com/t?ctl=BDDB:7B3DB . You'll learn all kinds of stuff there, with lessons available in small, downloadable chunks. By the end of this series, you'll be able to manage the evolving BI needs of your organization with the SQL Server 2005 BI platform. If you attend one Webcast in the "Business Intelligence with SQL Server 2005" series and complete an evaluation, you'll receive the latest community technology preview (CTP) of SQL Server 2005 on CD. If you attend at least three Webcasts in this BI series and submit evaluations for each of them, you'll receive a SQL Server 2005 Tshirt. Take advantage of the series and let Kevin know what you think today at
        http://lists.sqlmag.com/t?ctl=BDD7:7B3DB

    Hot Threads: Check out the following hot threads, and see other discussions in our 30 SQL Server forums.
        http://lists.sqlmag.com/t?ctl=BDDE:7B3DB

    Administration: Is There a Way to Read the Transaction Log File?
    http://lists.sqlmag.com/t?ctl=BDCD:7B3DB
    TSQL: Building Dynamic WHERE Statement
    http://lists.sqlmag.com/t?ctl=BDCE:7B3DB
    Performance: Fastest Insert Possible
    http://lists.sqlmag.com/t?ctl=BDCB:7B3DB
    Security: Providing Only ERD Permission
    http://lists.sqlmag.com/t?ctl=BDCF:7B3DB
    Replication: Table Merge Replication with Auto Indexed Field
    http://lists.sqlmag.com/t?ctl=BDCA:7B3DB
    DTS: DTS Package Suddenly Running Very Slow
    http://lists.sqlmag.com/t?ctl=BDCC:7B3DB

    8. Announcements


  • Exclusive OfferSave 44% off SQL Server Magazine

  • Get SQL Server Magazine and get answers! Act now to get an entire year for just $39.95that's 44% off the cover price! You'll also gain exclusive access to the entire SQL Server Magazine article database (over 2,300 articles). BONUS: The Top SQL Server Tips Guide (over 60 helpful tips). Subscribe now:
        http://lists.sqlmag.com/t?ctl=BDE1:7B3DB

  • Exclusive Content for VIP Subscribers!

  • Get inside access to ALL of the content and vast resources from Windows IT Pro, SQL Server Magazine, Exchange and Outlook Administrator, Windows Scripting Solutions, and Security Administrator, with over 26,000 articles at your fingertips. Your VIP subscription also includes oneyear print subscription to Windows IT Pro and a VIP CD (includes entire article database). Sign up now:
         http://lists.sqlmag.com/t?ctl=BDDD:7B3DB

    9. New & Improved


        by Dawn Cyr, products@sqlmag.com

  • Share Your Story and Get a TShirt!

  • 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 tshirt. Send your email today to handson@sqlmag.com!

  • Use Image Backups to Recover from Disaster

  • UltraBac Software released a significant update to the Pro and Gold editions of its UltraBac Disaster Recovery (UBDR) 2.0 software. UBDR Pro and Gold use imagebased backup and disasterrecovery technology to provide fast recovery for Windows servers and workstations. The software uses image backups with a Windowsbased universal boot CD environment to restore one or more disk partitions even when no OS is available. With this new release, the software can now restore the image of a failed server to a virtual environment. This new physicaltovirtual (P2V) capability provides organizations the ability to quickly recover a machine's image and emulate the restored hardware configuration virtually. Administrators can also use the software to restore a physical server to a VMware virtual server by creating a virtual environment on a host server, then using the software to boot into the recovery wizard. After restoring to a virtual environment, administrators can plan a physical migration to a new hardware configuration if and when it's needed. P2V capability means customers can reduce their need for extra hardware for disaster recovery. Pricing for UBDR Pro starts at $595 per server and includes the ability to back up an unlimited number of workstations. For other pricing and information, contact UltraBac Software at 4256446000 or info@ultrabac.com.
        http://lists.sqlmag.com/t?ctl=BDE8:7B3DB

  • Provide Server Availability

  • Xlink announced ClusterReplica MSSQL Edition 2.1, clustering software that uses data replication to provide high server availability. The product uses snapshot technology to provide realtime, openfile data replication, including replication of SQL Server database files and Windows registry files. This resourceefficient solution replicates only the bytes that change and uses minimum network bandwidth and harddrive resources. New features in this release include a special tool that lets you extract system configurations for effective problem solving; improved performance of the cluster system's internal communication and data replication for better data protection and availability; and backtracing of database files to solve problems associated with corrupt files and ensure successful SQL Server failover. Pricing for ClusterReplica MSSQL Edition starts at &799. For more information, contact Xlink at 4082638201 or sales@xlink.com.
        http://lists.sqlmag.com/t?ctl=BDEA:7B3DB

    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—Richard Resnick, rresnick@sqlmag.com or Lisa Kling, lkling@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.
    http://www.sqlmag.com/rd.cfm?code=00ep214xeb

    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 2005, Penton Media