Subscribe to SQL Server Magazine:
    http://lists.sqlmag.com/t?ctl=8BF5: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.

Blow Auditors Away with SQL Compliance Manager!
    http://lists.sqlmag.com/t?ctl=8BF8:7B3DB

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

ALERT: Hackers New Trick: Search Engine Hacking/Web App Worms
    http://lists.sqlmag.com/t?ctl=8BED:7B3DB

Tableau Software
    http://lists.sqlmag.com/t?ctl=8BFC:7B3DB


April 28, 2005

1. Perspectives

  • To GoLive!, Or Not to GoLive!
  • 2. SQL Server 2005 Watch

  • Seeing the CLR's Potential
  • 3. News & Views

  • Vote and Win in SQL Server Magazine's Readers' Choice Awards
  • Results of Previous Instant Poll: Specialization
  • New Instant Poll: Going Live?
  • 4. Events and Resources

  • Get a Quick Start In Mapping Your Oracle Database-Management Skills
  • Get Ready for SQL Server 2005 Roadshow in a City Near You
  • Ensure SQL Server High Availability
  • 5. Featured White Paper

  • Get Rapid and Reliable Data and System Recovery
  • 6. Peer to Peer

  • Hot Tip: Tempdb Affects Query Performance During Autogrow
  • Hot Article: Partitioned Indexes and Querying Metadata
  • In a Nutshell: Favorite Personal SQL Server Site
  • Hot Threads
  • 7. Announcements

  • You Be the Judge!
  • SQL Server Magazine Gives DBAs and Developers What They Need
  • 8. New & Improved

  • Access All SQL Server Metrics
  • Search SQL Server for Words and Sentences
  • Sponsor: Blow Auditors Away with SQL Compliance Manager!
    Do you need to ensure compliance to Sarbanes-Oxley, GLBA, HIPAA, Basel II, or other audit standards? Do you need to track who does what, when on your SQL Servers? Then you need Idera SQL Compliance Manager--auditing and continuous compliance for SQL Server. Designed in partnership with major auditing firms and SQL Server DBAs at Fortune 500 companies, Idera's SQL Compliance Manager provides low overhead data collection, a comprehensive repository of audit data, a central management console, pre-defined compliance reports and powerful forensic analyses. What's more, it deploys quickly and even audits itself.

    To find out more about SQL Server auditing and Idera's SQL Compliance Manager, download the white paper "The 7 Steps to Successful SQL Server Auditing" at
        http://lists.sqlmag.com/t?ctl=8BF8:7B3DB

    1. Perspectives


    To GoLive!, Or Not to GoLive!
        by Brian Moran, brian@sqlmag.com

    Last week, in "Beta Software Goes Live1" ( http://lists.sqlmag.com/t?ctl=8BEB:7B3DB ) I wrote about Microsoft's new GoLive! license, which lets users deploy the SQL Server 2005 Express Beta in a live production environment. I wondered if Microsoft might be exposing itself to some potential customer wrath and asked what you thought. I received an insightful reply from my colleague Douglas McDowell, director of business intelligence operations for Solid Quality Learning, who writes a BI-focused commentary in SQL Server Magazine UPDATE--Special Edition. Here's what he had to say:

    "I think it's pretty stinkin' smart. Will some folks get burned and mad? Yes, but I venture to say not many. And Microsoft will squelch any backlash with surgical support as needed. At this point, I think Microsoft has done more bug triage and general testing on SQL Server 2005's core RDBMS components, which encompasses Express Edition, than it ever did on SQL Server 2000 or SQL Server 7.0, so the product is pretty darn stable. Plus, the customers who are looking at the 'new MDSE' generally won't be as worried about a ton of critical data anyway. These are folks who want to put a guinea-pig application on SQL Server 2005, and this preliminary Express license lets them get past a boss who won't even let them play with beta software. Microsoft marketing said 'Hey, let's make a smoke-and-mirrors offering that will get a few more people using Express and will also give customers premature confidence, so when the full product releases to manufacturing (RTMs) they'll have a sense that it was ready a long time ago but we wanted to be sure it was okay to use in production.' In addition, every time someone clicks 'accept' to download Express with a GoLive! license, Microsoft marketing can say it has another existing production deployment. Then, when the Microsoft technology specialists and account executives start to push clients to upgrade shortly after the SQL Server 2005 RTM, they can say, 'It's not new software! The RDBMS has been released for XX months and we have XX,XXX production deployments.' Anyway, just more proof that Microsoft is the world's best marketing firm that happens to make software."

    So my dear readers, now what do you think? Whether 'tis nobler in the mind to suffer the slings and arrows of boring old MSDE or take arms against a sea of troubles and trick your boss into rolling out beta software and the sexy new features in SQL Server 2005 Express? To GoLive! or not to Golive!, that is the question.


    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 Server training CD.
        http://lists.sqlmag.com/t?ctl=8BF7:7B3DB


    2. SQL Server 2005 Watch


    Seeing the CLR's Potential
        by Matt Nunn, mattnunn@microsoft.com

    Combating a mixed reception, the SQL Server Common Language Runtime (CLR) is poised to change the way we work with databases. Data is at the core of most modern computer systems and SQL Server 2005 is set to blur the traditional boundaries of the n-tier model. A key driver that's changing the way we think about tiers in computer architecture is the inclusion of the CLR in SQL Server 2005. The SQL Server CLR is one of the most talked about features of SQL Server 2005, and it draws strong opinions from all camps--from those who want to turn it off forever to those who want to use it for everything. People's reactions to the integration of the CLR into SQL Server 2005 are interesting. One member of the SQL Server development team was giving a presentation about CLR integration when a member of the audience stood up and called out, "Is T-SQL dead?" This question prompted us to build an entire session called "No...T-SQL Isn't Dead!" In contrast, I had a conversation with an ASP programmer who had just found out about SQL Server CLR integration and immediately decided that this would not be a great place for him to store all of the .NET assemblies for his Web site. In his May Preparing for SQL Server 2005 column "Seeing the CLR's Potential," Matt Nunn talks about how the SQL Server CLR can provide security, reliability, and performance benefits that extended stored procedures can't. Read this article today at
        http://lists.sqlmag.com/t?ctl=8BEA:7B3DB

    Sponsor: Hackers New Trick: Search Engine Hacking/Web App Worms
    Web application worms utilize a known exploit, apply worm methodology and then leverage the power of search engines to accelerate effectiveness. These attacks mark the beginning of a new generation of worms targeted at Web applications. Are your Web apps vulnerable? Easily test your applications for over 5,100 Web app vulnerabilities and attack methodologies with our complimentary WebInspect 15-day product trial, that delivers a comprehensive risk report!
         http://lists.sqlmag.com/t?ctl=8BED:7B3DB

    3. News & Views


    Vote and Win in SQL Server Magazine's Readers' Choice Awards
    It's time to cast your vote in SQL Server Magazine's 2nd annual Readers' Choice Awards! By voting for outstanding products, companies, and services, you'll have the opportunity to reward excellence and make your voice heard. The September 2005 issue of SQL Server Magazine will feature your favorite products and your choice of companies that provide the best products and services. Readers must log in to vote, so you must be a registered SQL Server Magazine Website user. Logging in to the site and completing the form is really easy this year. You can even return and complete the survey at your leisure so that you don't have to worry about completing it all in one sitting. After voting closes, we'll draw from participants winners for 2 iPod Shuffles (512MB versions) and 10 SQL Server Magazine t-shirts. Voting ends May 15 so cast your vote today!
        http://lists.sqlmag.com/t?ctl=8BF1:7B3DB

    Results of Previous Instant Poll: Specialization
    "What area of SQL Server specialization do you think is most important?" Here are the results from the 110 votes:

  • 34%   Business Intelligence (BI)
  • 18%   Data Transformation Services (DTS)
  • 11%   ADO and ADO.NET
  • 26%   Programming
  • 11%   None of the above
  • New Instant Poll: Going Live?
    "Will you take advantage of Microsoft's new GoLive! license and use SQL Server 2005 Express beta software in your production systems?" Go to the SQL Server Magazine home page ( http://lists.sqlmag.com/t?ctl=8C00:7B3DB ) and submit your vote for

  • Yes, I can't wait to get started
  • Maybe, I want more information first
  • No, I'll wait for the RTM
  • 4. Events and Resources


    Get a Quick Start In Mapping Your Oracle Database-Management Skills
    Sign up now for this free, on-demand Web seminar. Learn about the similarities and differences between Oracle and SQL Server and get a preview of real-world tips and techniques for managing these associated technologies. Register now!
        http://lists.sqlmag.com/t?ctl=8BDF:7B3DB

    Get Ready for SQL Server 2005 Roadshow in a City Near You
    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. Attend and receive a 1-year membership to PASS and a 1-year subscription to SQL Server Magazine. Register now!
        http://lists.sqlmag.com/t?ctl=8BEC:7B3DB

    Ensure SQL Server High Availability
    In this free Web seminar, discover how to maintain business continuity of your IT systems during routine maintenance and unplanned disasters. Learn critical factors for establishing a secure and highly available environment for SQL Server including overcoming the technology barriers that affect SQL Server high availability and Microsoft's out-of-the-box high-availability technologies such as clustering, log shipping, and replication. Register now!
        http://lists.sqlmag.com/t?ctl=8BE1:7B3DB

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


    5. Featured White Paper


    Get Rapid and Reliable Data and System Recovery
    Even under the best circumstances, performing a bare-metal recovery from tape is tedious and unreliable. In this free white paper, learn how you can achieve unprecedented speed and reliability in recovering systems and data.
         http://lists.sqlmag.com/t?ctl=8BDE:7B3DB


    6. Peer to Peer


  • Hot Tip: Tempdb Affects Query Performance During Autogrow

  •     by Brian Moran, savvy@sqlmag.com

    The execution time for a particular stored procedure increases 500 percent when we restart SQL Server. Our tests account for the effect of data caching, and the stored procedure's execution plan doesn't change. We don't see drops in performance from our other stored procedures, and the slow procedure's performance returns to normal eventually. How can we tune the slow procedure's performance?

  • Read the answer to this question today at

  •     http://lists.sqlmag.com/t?ctl=8BE9:7B3DB

  • Hot Article: Partitioned Indexes and Querying Metadata

  • In "Native Partitioned Tables and Indexes," Itzik Ben-Gan began his coverage of native partitioning in SQL Server 2005 and the related T-SQL code. He's covered the motivation for partitioning, SQL Server 2005's enhancements, and how to create partitioned tables by creating a partition function, partition scheme, and a partitioned table or index. This month, in his T-SQL 2005 column "Partitioned Indexes and Querying Metadata," Itzik Ben-Gan continues his coverage with partitioned index considerations and querying metadata information. Read this article today at
    http://lists.sqlmag.com/t?ctl=8BE8:7B3DB

  • In a Nutshell: Favorite Personal SQL Server Site

  • As a SQL Server MVP, Kevin is exposed to a lot of talented people, many of whom have personal blogs, Web pages, or both. In this week's blog "One of My Favorite SQL Server Personal Sites," Kevin Kline praises Narayana Vyas Kondreddi's Web site, http://lists.sqlmag.com/t?ctl=8BFF:7B3DB . Kondreddi covers diverse and useful topics for the SQL Server professional. Among Kevin's favorites are Kondreddi's articles at http://lists.sqlmag.com/t?ctl=8BF0:7B3DB and the code library at http://lists.sqlmag.com/t?ctl=8BF9:7B3DB . These sections and other resources, such as a plethora of product reviews, promise to keep you busy for some time. The neat thing about these resources is that they'll either save you time on the job or extend your capabilities, and sometimes both! Let Kevin know what you think of Kondreddi's site and tell him about some of your favorite SQL Server sites today at
         http://lists.sqlmag.com/t?ctl=8BEE: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=8BF3:7B3DB

    Development: T-SQL Mass Inserts and Error Trapping
         http://lists.sqlmag.com/t?ctl=8BE2:7B3DB
    Performance: Table Fragmentation
         http://lists.sqlmag.com/t?ctl=8BE7:7B3DB
    Administration: SQL Cluster Problem
         http://lists.sqlmag.com/t?ctl=8BE5:7B3DB
    T-SQL: Cursor Performance
        http://lists.sqlmag.com/t?ctl=8BE4:7B3DB
    DTS: Dynamic SQL in DTS Transaction
         http://lists.sqlmag.com/t?ctl=8BE6:7B3DB
    T-SQL: OSQL and Leading Spaces
         http://lists.sqlmag.com/t?ctl=8BE3:7B3DB

    Hot Spot


  • Tableau Software
  • Tableau is Business Intelligence software that helps people visually query and interpret the information in databases. We call this process "visual analysis." It enables users to transform raw data into smart decisions using a drag and drop process that creates vivid, interactive visualizations.
        http://lists.sqlmag.com/t?ctl=8BFC:7B3DB

    7. Announcements


  • You Be the Judge!
  • Your favorite products are on trial in the SQL Server 2005 Readers' Choice Awards. Cast your vote now and you could win an iPod Shuffle or a SQL Server Magazine T-shirt. Voting ends May 15, so don't miss out!
         http://lists.sqlmag.com/t?ctl=8BF2:7B3DB

  • SQL Server Magazine Gives DBAs and Developers What They Need

  • With SQL Server 2005 right around the corner, remember that SQL Server Magazine is on target to deliver comprehensive coverage of all betas of the new product and the final release. If you aren't already a subscriber, now is the time to subscribe. Act now and save 47% off the cover price, plus get the new Reporting Services poster:
        http://lists.sqlmag.com/t?ctl=8BF6:7B3DB

    8. New & Improved


        by Dawn Cyr, products@sqlmag.com

  • Praise a Product, Get a T-Shirt!

  • Have you used a product that saved you time or made your job easier? Tell us about it! If we print your story in the Hands On department, we'll send you a SQL Server Magazine t-shirt. Send your product success story to handson@sqlmag.com.

  • Access All SQL Server Metrics

  • AdventNet announced ManageEngine Applications Manager 6.0, enterprise-ready, Web-based application-management software that facilitates monitoring of databases, servers, services, Web sites, and custom applications. The product's SQL Server Monitoring feature manages SQL Server 2000 servers and ensures optimal access to all the metrics that SQL Server exposes for the database engine and each database instance. The product monitors multiple SQL Server components, including memory utilization, buffer manager statistics, connection statistics, cache details, lock details, SQL statistics, latch details, and access method details. The software's monitoring capabilities include alert generation based on thresholds you set; performance graphing and reporting; connection tracking; and identification of locking activity by user. ManageEngine Applications Manager is priced at $995, and a free 30-day trial download is available. For more information, contact AdventNet at 888-720-9500, 925-924-9500, or sales@adventnet.com.
        http://lists.sqlmag.com/t?ctl=8BE0:7B3DB

  • Search SQL Server for Words and Sentences

  • BDS announced SQL Digger 2.0, a free SQL Server search engine that lets you search all your stored procedures, views, UDFs, and triggers for a word, multiple words, or a sentence. The tool finds the objects in which you used the search strings and highlights them in a preview screen to show you where the words are located in the T-SQL code. The tool also lets you drag the contents of any found object to any receiving container (e.g., Query Analyzer, Word). And the latest release comes with an added print functionality with Multi Database Search. Other new features of the tool include the ability to limit the search to a specified object type and print the T-SQL code from the found objects. The tool uses Windows authentication and requires the .NET Framework 1.1. For more information or to download the free tool, visit
        http://lists.sqlmag.com/t?ctl=8BFE: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