This Issue Sponsored By

Free Trial of Lumigent Log Explorer
     http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BL4n0A1

Cluster-Class Availability for Your SQL Server
    http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BMbW0AQ

ALERT: Hackers Launching SQL Injection Attacks!
     http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BMGD0Ae


October 28, 2004

1. Perspectives

  • Microsoft's New Webcasts Prepare You for SQL Server 2005
  • 2. News and Views

  • Learn How to Stop Transaction Log Growth
  • Results of Previous Instant Poll: Community Technology Previews
  • New Instant Poll: SQL Server 2005 Webcasts
  • 3. Announcements

  • Free SQL Server Performance Tips and Articles
  • Get Free Access to the SQL Server Magazine Archives
  • 4. Peer to Peer

  • Hot Tip: Query Analyzer Doesn't Accurately Report I/O for UDFs
  • Hot Article: Synchronizing on Demand
  • Hot Threads
  • 5. Events Central

  • SQL Server Magazine Connections Conference
  • 6. New and Improved

  • Compress Backup and Recovery Times
  • Solve Performance Problems Proactively
  • Increase Developer Productivity
  • Sponsor: Free Trial of Lumigent Log Explorer
    Lumigent(R) Log Explorer(R) is the leading transaction analysis and online data recovery solution for SQL Server. It provides access to the database transaction log, giving you the ability to understand and resolve elusive database problems. With Log Explorer, you can:

  • Recover data while your database is online—No backups are needed
  • Selectively recover modified, deleted, dropped, or truncated data
  • Identify any data, schema, or permissions change
  • Repair data at various levels of granularity
  • Export transaction information for analysis and reporting
  • Receive alerts when key database events occur
  • Download today:
        http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BL4n0A1

    1. Perspectives


  • Microsoft's New Webcasts Prepare You for SQL Server 2005

  • by Brian Moran, brian@sqlmag.com

    If you want to learn about SQL Server 2005 and maybe win an XBox at the same time, sign up for Microsoft's free Webcasts, which start December 6 and end December 10. Microsoft will host three new Webcasts each day of the week, presenting 15 Webcasts in all. Topics include an overview of the new developer features in SQL Server 2005, an introduction to the new SQL Server Management Studio, T-SQL enhancements, XML in SQL Server 2005, ADO.NET 2.0 for SQL Server 2005, Service Broker, Reporting Services, Integration Services (formerly called Data Transformation Services—DTS), Analysis Services, and more. You can check the full schedule at http://msdn.microsoft.com/sql/2005webcasts/ . Then, starting in early January and running through SQL Server 2005's official release, Microsoft will begin a new series of SQL Server 2005 developer Webcasts. Microsoft plans to offer one new topic each week until SQL Server 2005 launches.

    Matt Nunn, a SQL Server product manager, says everyone who attends a Webcast will receive the currently available SQL Server 2005 Beta 2 Resource Kit and the Beta 3 Resource Kit when it ships. Also, the first 1500 people to participate in 5 or more Webcasts will receive a special, limited-edition SQL Server 2005 Webcast t-shirt. And all Webcast viewers will be entered in the Microsoft SQL Server 2005 Developer Preview Webcasts Sweepstakes. Each day in a random drawing, Microsoft will select one person to win a Microsoft XBox system (see http://msdn.microsoft.com/SQL/WebcastRules.aspx for official rules).

    I know that SQL Server 2005 is still a long time away from final release and you have a job to do today. However, SQL Server 2005 will introduce the most fundamental changes for SQL Server developers compared to any previous release of SQL Server technology. We'll get an entirely new development and management environment based on Visual Studio. And SQL Server 2005 will significantly change the way we build applications with its integration of native XML data type support and of the Common Language Runtime (CLR), along with a host of other development- and administration-oriented changes. Preparing a SQL Server 2005 rollout will be much more involved than the upgrade from SQL Server 6.5 to 7.0 or the upgrade from SQL Server 7.0 to 2000. There's no way you can become familiar with all these new features and technologies overnight, so if you want to be ready for SQL Server 2005 when it hits the market next summer, you need to begin updating your SQL Server skills today. And participating in these Webcasts, presented by the SQL Server developers who are building the new release, is a great place to start.

    2. News & Views


  • Learn How to Stop Transaction Log Growth

  • In SQL Server 2000, each database contains at least one data file and one transaction log file. If the transaction log file that corresponds to a SQL Server database is filled and you've set the option for the transaction log files to grow automatically, the transaction log file might become very large and you might run out of disk space. When a transaction log file grows until the log file uses all the available disk space and can't expand any more, you can no longer perform any data modification operations on your database. Additionally, SQL Server might mark your database as suspect because of the lack of space for the transaction log expansion. The Microsoft article "How to stop the transaction log of a SQL Server database from growing unexpectedly" shows you the steps to follow when the transaction logs expand to an unacceptable limit and provides the options that you can use to stop the transaction logs from growing unexpectedly. Read this article today at
         http://support.microsoft.com/?kbid=873235

  • Cluster-Class Availability for Your SQL Server

  • Has your business suffered a loss of business-critical data because your SQL Server was down? Neverfail for SQL Server proactively monitors the health of your entire SQL environment to provide true application availability. Neverfail for SQL Server is affordable and is easy to install and maintain. To learn how Neverfail's cluster-class high-availability solution for SQL Server can help your business save IT dollars and resources, access a free white paper and/or datasheet:
         http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BMbW0AQ

  • Results of Previous Poll: Community Technology Previews

  • "Will you download SQL Server 2005's new Community Technology Previews?" Here are the results from the 90 votes:
  • 36%    Yes, I plan to download the CTPs
  • 18%    I don't know yet if I will download the CTPs
  • 32%    No, I don't plan to download the CTPs
  • 14%    I don't think I have access to the CTPs
  • New Instant Poll: SQL Server 2005 Webcasts

  • "Will you attend any of Microsoft's new SQL Server 2005 Webcasts?" Go to the SQL Server Magazine home page ( http://www.sqlmag.com ) and submit your vote for
  • Yes, I will attend all 15
  • Yes, I will attend some
  • I don't know yet if I will attend
  • No, I don't plan to attend any
  • 3. Announcements


  • Free SQL Server Performance Tips and Articles

  • Hundreds of free tips and articles on SQL Server performance tuning and clustering. And get quick and accurate answers to your performance- and cluster-related questions in our forum. All from the SQL Server performance authority: SQL-Server-Performance.Com.
        http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BKEZ0Aw

  • Get Free Access to the SQL Server Magazine Archives

  • Order SQL Server Magazine today and get free, subscriber-only access to every SQL Server Magazine article ever written—that's over 5 years of tips, how-to's, and expertise! Along with your 12 issues, you'll also get a free Subscriber Benefits Card giving you access to special discounts, offers, and gifts. Bonus—act now and get 30% off the cover price! Click here:
        http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BMbX0AR

    4. Peer to Peer


  • Hot Tip: Query Analyzer Doesn't Accurately Report I/O for UDFs

  • by Brian Moran, savvy@sqlmag.com

    SQL Server tools report performance information in different ways based on how they calculate the metrics they measure. In most cases, minor discrepancies in the data that different SQL Server tools report don't matter. However, wrong answers lead to poor query-tuning decisions. And you can get a wrong answer if you're using Query Analyzer to analyze I/O for a query that includes a user-defined function (UDF).

    Read the rest of this tip today at
        http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BMbY0AS

  • Hot Article: Synchronizing on Demand

  • by Gary Zaika, garyzaik@microsoft.com

    Transactional replication helps maintain data availability, but if data becomes unsynchronized, you might not be able to quickly synchronize by using conventional techniques. In his November focus article "Synchronizing on Demand," Gary Zaika shows you how to synchronize selected data on the fly—without disrupting business. Read this article today at
        http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BMbZ0AT

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

  •      http://www.windowsitpro.com/sqlserver/forums/

    Dynamically Stripping Strings
    http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BMba0Aa Deadlock Error Doesn't Trigger Alert
    http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BMbb0Ab Transactional Replication Problem
    http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BMbc0Ac To Allow or Not to Allow Access to xp_cmdshell
    http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BMbd0Ad Can I Audit INSERT, UPDATE, and DELETE Failures?
    http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BMbe0Ae Inserting Multiple Rows from a Comma-Delimited List
    http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BMbf0Af

    Hot Spot

    ALERT: Hackers Launching SQL Injection Attacks! It's as simple as placing additional SQL commands into a Web Form input box giving hackers complete access to all your backend systems! Firewalls and IDS will not stop such attacks because SQL Injections are NOT seen as intruders. Download this *FREE* white paper from SPI Dynamics.
        http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BMGD0Ae

    5. Events Central


  • SQL Server Magazine Connections Conference

  • It's not too late to register for SQL Server Magazine Connections! Join us in Las Vegas November 7-10 and have your name entered into a drawing to win a Harley-Davidson motorcycle. Attendees receive the latest build of SQL Server 2005 Beta and Visual Studio 2005. Call 800-438-6720 or 203-268-3204.
        http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40ggP0Ai

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

    6. New & Improved


    by Dawn Cyr, products@sqlmag.com

  • Compress Backup and Recovery Times

  • Imceda announced LiteSpeed 3.2 for SQL Server, backup and recovery software that packs a variety of new features, including multiple compression levels and object-level recovery. LiteSpeed 3.2 compresses backup files as much as 95 percent, providing performance gains and decreasing storage requirements. The Object Level Recovery feature reduces restore times by letting you restore only the objects that you need. In addition, LiteSpeed 3.2 gives DBAs support for enterprise backup tools and 100 percent support for third-party applications. The product offers advanced performance tuning, dynamic deployment, and support for multiple encryption standards. LiteSpeed 3.2 is available to DBAs who are beta testing SQL Server 2005. For more information, contact Imceda at 781-229-6300, 888-763-7685, or info@imceda.com.
    http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BJZE0Av

  • Solve Performance Problems Proactively

  • VERITAS Software announced VERITAS i3 7.1, application-management software that lets IT administrators simultaneously compare performance and availability characteristics of complex applications over clusters and multiple instances. Like previous releases, VERITAS i3 7.1 comprises three parts: Insight, Indepth, and Inform. Of particular interest to SQL Server professionals is Indepth for SQL Server, which monitors and captures transactions as they enter and exit the database, letting you analyze details of performance. For example, you can capture a single transaction and analyze where it's consuming the most resources, then fix the problem before end users notice a slowing of performance. In addition, the latest release has a repertoire of more than 225 reports for sending performance information to management and developers. And the product's alerting function lets you know about hot spots that develop over time so that you can address performance problems before they affect your users' experience. VERITAS i3 7.1 is designed to work with SQL Server 2000 Service Pack 3 (SP3), and pricing for a 4-CPU environment starts at $9200. For more information and pricing details, contact VERITAS at 650-527-8000 or 800-327-2232.
        http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40KaT0AE

  • Increase Developer Productivity

  • ApexSQL announced ApexSQL Edit 2.10, an SQL code editor that helps SQL Server developers create, test, manage, and execute code. The product features an easy-to-use interface and is integrated with Visual SourceSafe, which reduces the time needed to create SQL-based stored procedures, tables, views, and queries and eliminates manual check-in and checkout. ApexSQL Edit also has Intellisense capability, which helps you expedite recalls of tables, stored procedures, columns, and column values. The product's automatic T-SQL formatting can support nearly unlimited formatting options and makes code easier to read. The product's development environment includes Visual Studio .NET-like collapsible regions, drag-and-drop filing from any source, graphical execution plans, short cuts and hot keys, and Quick Info from result sets. ApexSQL Edit works with SQL Server 2000 and 7.0 and will be available for SQL Server 2005. Pricing for a single-user license starts at $199 and includes free support and product upgrades. For more information about the product or other pricing options, contact ApexSQL at 866-665-5500 or sales@apexsql.com. Free 14-day downloads are available at
         http://list.windowsitpro.com/cgi-bin3/DM/y/eh5Y0McMHC0Kj40BGQt0AW

    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.