SQL Server Magazine Web Exclusive DATE: November 3, 2005 TITLE: SQL Server Magazine UPDATE, November 3, 2005--RTM at Last! InstantDoc ID 48348 by Various Authors

Subscribe to SQL Server Magazine:
    http://lists.sqlmag.com/t?ctl=18771:285886


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 Disaster Recovery Toolkit for the SQL DBA
    http://lists.sqlmag.com/t?ctl=18779:285886

What's new in SQL 2005--40% OFF new course!
    http://lists.sqlmag.com/t?ctl=18776:285886

Dashboard Development and Deployment--A Methodology for Success
    http://lists.sqlmag.com/t?ctl=1876A:285886


November 3, 2005

1. Perspectives

  • RTM at Last!
  • 2. SQL Server 2005 Watch

  • Learn SQL Server 2005's New Developer Features
  • 3. News & Views

  • Sign Up Now for SQL Server 2005 Express eNewsletter
  • New Products, New Certifications
  • Results of Previous Instant Poll: Express Hobbies
  • New Instant Poll: Launch Events
  • 5. Events and Resources

  • The Main Event: CLR vs. T-SQL
  • Get Ready for the SQL Server 2005 Roadshow in Europe--Get the facts about migrating to SQL Server 2005!
  • Accelerate Time to Recovery with Minimal Data Loss
  • Exploit the Opportunities of a Wireless Fleet
  • 6. Featured White Paper

  • Microsoft SQL Server 2005 Analysis Services Migration
  • 7. Peer to Peer

  • Hot Tip: Granular Timing Statistics from Profiler
  • Hot Article: SQL Server 2005 is Here
  • In a Nutshell: More Stupid Developer Tricks
  • Hot Threads
  • 8. Announcements

  • SQL Server Magazine Monthly Online Pass = Quick Answers
  • The Windows IT Security Newsletter
  • 9. New & Improved

  • Boost SQL Server Performance
  • Secure Column-Level Data
  • Sponsor: Free Disaster Recovery Toolkit for the SQL DBA
    Written by SQL Server expert Brian Knight, this handy, "how-to" toolkit contains comprehensive first-hand advice and scripts for SQL Server DBAs that need to build and implement a successful disaster recovery plan. With his tips and quips, Brian walks the DBA through real-world scenarios using an easy, step-by-step approach. And as part of the download, you'll receive four scripts, which will greatly speed your recovery time! Download it today, compliments of Lumigent:
        http://lists.sqlmag.com/t?ctl=18779:285886

    1. Perspectives


  • RTM at Last!

  •     by Brian Moran, brian@solidqualitylearning.com

    You've probably heard by now: Last Thursday, October 27, Microsoft announced the SQL Server 2005 release to manufacturing (RTM). MSDN Universal subscribers can download SQL Server 2005 at http://lists.sqlmag.com/t?ctl=18775:285886 .

    Last week in "Launch Events: A Free Lunch" ( http://lists.sqlmag.com/t?ctl=18768:285886 ), I talked about what a big deal Microsoft is making of the launch events for SQL Server 2005, Visual Studio 2005, and BizTalk Server 2006. One of the reasons for the excitement about these launches is that, after a longer-than-expected wait, we finally get to enjoy the fruits of Microsoft's work over the past few years. Microsoft's "Better Together" theme, which the company has been using to promote these new releases, is now a reality. The integrated features of these three products are designed to help database professionals, developers, and end users work better together, and the new tools we have will fundamentally change the way we all work with data.

    I'll have plenty of interesting thoughts and ideas to share about specific aspects of SQL Server 2005 in the coming weeks and months, but this week, I feel that less is more. All I really want to say today is congratulations to the SQL Server team and all the folks at Microsoft who have poured their hearts and souls into this product over the past 5 years. Job well done.

    P.S. I hear the next release of SQL Server is codenamed Katmai. So, when does that ship?


    What's new in SQL 2005--40% OFF new course!
    Get up to speed on the new features and functionality in SQL Server 2005 with training from AppDev--voted the best by readers of SQL Server Magazine. Our new "Exploring SQL Server 2005" CD-ROM training course provides an overview of this exciting software release, and will help you become productive with new features as soon as possible. Order by 11/30 and get 40% off this 6-CD course. Click the link below to learn more and order now!
        http://lists.sqlmag.com/t?ctl=18776:285886


    2. SQL Server 2005 Watch


  • Learn SQL Server 2005's New Developer Features

  • Microsoft is offering developer training through its Virtual Workshop series, which lets students benefit from live, instructor-led training online. With the release of SQL Server 2005, developers will need to understand how the product's .NET integration, native support for XML, and other programmatic enhancements can benefit their applications. In a series of four Virtual Workshops, "SQL Server 2005 New Features for Developers," students will participate in lectures and Hands-On Lab exercises that will help them get up-to-speed with SQL Server 2005. Participants must be familiar with the .NET platform and have had experience using T-SQL and SQL Server 2000. For information and registration, visit
        http://lists.sqlmag.com/t?ctl=18770:285886

    3. News & Views


  • Sign Up Now for SQL Server 2005 Express eNewsletter

  • SQL Server Magazine announced the upcoming launch of a new free email newsletter, SQL Server 2005 Express UPDATE. Get up to speed with useful database projects and tips that illustrate the fundamentals of Microsoft's new free database offering. Whether you're new to SQL Server, have a small business database, need to understand SQL Server because it's the database underlying systems management tools, or want to develop your own database-enabled applications, this newsletter gets you up and running fast.

  • Download sample applications and code discussed in the articles.
  • Discover quick tips to help you work with SQL Server 2005 Express.
  • Learn about the latest patches, service codes, and updates for SQL Server 2005 Express.
  • Find out about products that integrate easily with SQL Server 2005 Express.
  • Get the most popular code from your peers.
  • Sign up today and stay up-to-date with bi-weekly information that will walk you through SQL Server 2005 Express step-by-step at
        http://lists.sqlmag.com/t?ctl=18772:285886

  • New Products, New Certifications

  • Coinciding with its release to manufacturing (RTM) of SQL Server 2005, Microsoft announced its new certifications. The company is offering certifications for multiple specializations, including Web developers, DBAs, system administrators, database developers, and business intelligence (BI) developers, in three series. The Technology Series certifications let IT professionals demonstrate that they can implement, build, troubleshoot, and debug a particular Microsoft technology. New Technology Specialist certifications are currently available for SQL Server 2005, BizTalk Server 2006, .NET Framework 2.0 Web Applications, .NET Framework 2.0 Windows Applications, and .NET Framework 2.0 Distributed Applications. The Professional Series credentials validate a comprehensive set of skills required to be successful on the job. Microsoft currently offers two Professional series credentials: Microsoft Certified IT Professional and Microsoft Certified Professional Developer. The Microsoft Certified Architect Program identifies top industry experts in IT architecture. The program offers two disciplines: one for infrastructure architects and one for solutions architects. The Certified Architect Program is a rigorous, competitive program that sets the highest standards of excellence for its participants. You can read about the Microsoft Certified Architect Program and other Microsoft certification programs at
        http://lists.sqlmag.com/t?ctl=18774:285886

  • Results of Previous Instant Poll: Express Hobbies

  • "Who do you know who would use SQL Server 2005 Express to create "hobby" databases (e.g., inventory of music CDs)?" Here are the results from the 60 votes:

  • 65% I'd use it
  • 3% My kids would use it
  • 2% My significant other would use it
  • 3% My friends would use it
  • 27% I can't imagine anyone I know using it
  • New Instant Poll: Launch Events

  • "Will you attend one of Microsoft's SQL Server 2005 launch events?" Go to the SQL Server Magazine home page ( http://lists.sqlmag.com/t?ctl=1877C:285886 ) and submit your vote for

  • Yes, I'll be in San Francisco on November 7
  • Yes, I'm attending a local launch event near me
  • No, but I'm attending a non-Microsoft event
  • No, it sounds fun, but I can't make it
  • No, I'm not into attending these kinds of events
  • 4. Events and Resources


  • The Main Event: CLR vs. T-SQL

  • .NET Common Language Runtime is bringing some very cool new capabilities to SQL Server 2005, and T-SQL is stronger than ever. This free Web seminar compares T-SQL and the CLR, including new features, pros and cons, performance tests, and risks, along with some guidance concerning when to use them. Register today to see Visual Studio in action and witness the staying power of T-SQL.
        http://lists.sqlmag.com/t?ctl=1876B:285886

  • Get Ready for the SQL Server 2005 Roadshow in Europe--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. Receive a one-year membership to PASS and one-year subscription to SQL Server Magazine. Register now.
        http://lists.sqlmag.com/t?ctl=18767:285886

  • Accelerate Time to Recovery with Minimal Data Loss

  • Learn how to meet Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) with a continuous, or realtime backup system. In this free, on-demand Web seminar, you'll discover how to roll back data to any point in time--not just to the last snapshot or backup!
        http://lists.sqlmag.com/t?ctl=18769:285886

  • Exploit the Opportunities of a Wireless Fleet

  • With the endless array of mobile and wireless devices and applications, it's hard to decide what you can do with the devices beyond providing mobile email access. It's even tougher to know how to keep it all secure. Join industry guru Randy Franklin Smith in this free Web seminar and discover what you should do to leverage your mobile and wireless infrastructure, how to pick devices that are right for you, and more!
        http://lists.sqlmag.com/t?ctl=18764:285886


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

  •     http://lists.sqlmag.com/t?ctl=18778:285886


    5. Featured White Paper


  • Microsoft SQL Server 2005 Analysis Services Migration

  • Microsoft SQL Server 2005 Analysis Services offers many performance improvements and benefits for existing SQL Server 2000 Analysis Services users. If you're planning a migration to Analysis Services 2005, you can't afford to ignore this paper! Download your free copy now and get all the tips and real-world examples you need to make migration faster and easier.
        http://lists.sqlmag.com/t?ctl=18763:285886


    6. Peer to Peer


  • Hot Tip: Granular Timing Statistics from Profiler

  •     by Brian Moran, brian@solidqualitylearning.com

    SQL Server Profiler is a great tool for analyzing performance, but I never see CPU or duration values between 0 and 10ms--zero shows up and ten shows up, but nothing in between. Is there a way to get more granular timing for online transaction processing (OLTP) systems that do a massive number of fast queries?

  • Read the answer to this question today at

  •     http://lists.sqlmag.com/t?ctl=18766:285886

  • Hot Article: SQL Server 2005 is Here

  • To help you understand the changes in SQL Server 2005 and how they might affect your business, the November issue of SQL Server Magazine is devoted to the launch of this much-anticipated release. In his November editorial "SQL Server 2005 is Here," Mike Otey gives an overview of the coverage and reassures SQL Server 2000 devotees that they won't be forgotten. Read this article today and post your comments at
        http://lists.sqlmag.com/t?ctl=18765:285886

  • In a Nutshell: More Stupid Developer Tricks

  • During an unseasonably hot week in London, Kevin collected a sizzling tale about another developer mishap. Read the story and send Kevin your tales of developer craziness--or defend developer integrity--today at
        http://lists.sqlmag.com/t?ctl=1876C:285886

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

  •     http://lists.sqlmag.com/t?ctl=18773:285886

    Administration: Log Shipping
        http://lists.sqlmag.com/t?ctl=1875D:285886
    T-SQL: Debugging a Stored Procedure in Query Analyzer
        http://lists.sqlmag.com/t?ctl=1875F:285886
    Performance: SQL Mail
        http://lists.sqlmag.com/t?ctl=1875E:285886
    Security: Justifying a Permanent User Between Oracle and SQL Server
        http://lists.sqlmag.com/t?ctl=18762:285886
    SQL Server 2000/7.0 General Discussion: Insert Problem with Partitioned View
        http://lists.sqlmag.com/t?ctl=18760:285886
    SQL Server 2005 General Discussion: Confused About Install
        http://lists.sqlmag.com/t?ctl=18761:285886

    Hot Spot


  • Dashboard Development and Deployment--A Methodology for Success

  • Business information carries little value unless it reaches the right person at the right time. This free white paper tells you what you need to know to remain competitive while improving the speed and quality of decision-making. Learn how a well-designed dashboard can provide critical information to decision makers, enable them to monitor the health of your organization and bring immediate ROI to your business.
        http://lists.sqlmag.com/t?ctl=1876A:285886p>

    7. Announcements


  • SQL Server Magazine Monthly Online Pass = Quick Answers

  • Sign up for a Monthly Online Pass and get online access to ALL the authors, articles, tools, and helpful resources published in SQL Server Magazine, including exclusive subscriber-only content. You'll have 24/7 access to a database of over 2300 SQL Server articles that will give you all the answers you need, when you need them. BONUS--Includes the latest digital issue of SQL Server Magazine. Sign up now for just US$5.95 per month:
        http://lists.sqlmag.com/t?ctl=1876E:285886

  • The Windows IT Security Newsletter

  • We've expanded our content to include even more fundamentals on building and maintaining a secure enterprise. Each issue features in-depth product coverage of the best security tools available, including expert advice on the best way to implement various security components. Plus, paid subscribers now get online access to our entire online security article database (more than 1900 articles). Order now:
        http://lists.sqlmag.com/t?ctl=1876D:285886

    8. New & Improved


        by Blake Eno, products@sqlmag.com

    Share Your Story and Get a T-Shirt!
    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 t-shirt. Send your email today to handson@sqlmag.com!

  • Boost SQL Server Performance

  • Quickshift announced Quickshift for Microsoft SQL Server, software that helps you increase performance for crucial business applications by optimizing data movement between your server's processor, memory, and storage subsystems. The product uses a virtual buffer cache to make data movement more efficient, and employs a unique set of patented algorithms that intelligently determine what data should reside in the cache. The product installs in minutes and is invisible to user applications and the OS. The UI makes the product easy to administer. Pricing for Quickshift starts at $999 per processor for the Standard Edition, and volume discounts are available. To learn more, contact Quickshift at 512-342-0474 or support@quickshift.com.
        http://lists.sqlmag.com/t?ctl=1877B:285886

  • Secure Column-Level Data

  • NetLib announced its Column Encryption Manager for Netlib Encryptionizer. Col-E for SQL Server lets you encrypt selected data columns so that you can protect specific data such as salaries, PINs, credit card numbers, and other sensitive data in your SQL Server 2000, 7.0, and Microsoft Access databases. The product lets you select columns to encrypt and determine who has read access to the encrypted columns. The product automatically maintains encryption integrity and keeps encryption keys separate from the data they protect. Repeating Values Protection (RVP), an additional feature, lets you deploy the product in as little as a few hours and adds an additional layer of security on top of Windows and SQL Server security. The product doesn't increase your database size and is transparent to most existing applications. Encryptionizer for SQL Server is licensed per-server and must be installed on each server in a cluster. Volume pricing and OEM licensing is available. Free, time-limited evaluation versions are available, and pricing for Netlib Col-E is available on request at 800-480-1604, 203 321-1278, or through the vendor's Web site.
        http://lists.sqlmag.com/t?ctl=1877D:285886

    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.
    https://store.pentontech.com/index.cfm?s=9&promocode=eu215xdb

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