Subscribe to SQL Server Magazine:
    http://lists.sqlmag.com/t?ctl=3CB:2621E7


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=70F5:2621E7

Find & Fix Bad SQL: New Quest White Paper
    http://lists.sqlmag.com/t?ctl=93DF:2621E7

SQL Server MVPs Say It's a Must-Have Tool
     http://lists.sqlmag.com/t?ctl=93E0:2621E7


May 5, 2005

1. Perspectives

  • SSMA: Migration Made Easy
  • 2. News & Views

  • SQL Server's Double-Digit Growth
  • Results of Previous Instant Poll: Going Live?
  • New Instant Poll: Other Databases
  • 3. Events and Resources

  • Get Ready for SQL Server 2005 Roadshow in Europe
  • Get Excited About SQL Server 2005 Reporting Services
  • Get Ready for SQL Server 2005 Roadshow in a City Near You
  • 4. Featured White Paper

  • Configuring Blade Servers for Your Application Needs/p>

    5. Peer to Peer

  • Hot Tip: Using SQL Server with Large Amounts of Memory
  • Hot Article: The High Availability Puzzle
  • In a Nutshell: New Pronouncements By Jim Gray
  • Hot Threads
  • 6. Announcements

  • You Be the Judge!
  • SQL Server Magazine Monthly Pass = Quick Answers!
  • 7. New & Improved

  • Get SQL Server 2005 Programming Training
  • 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=70F5:2621E7

    1. Perspectives


  • SSMA: Migration Made Easy

  •     by Brian Moran, brian@sqlmag.com

    Several weeks ago, Microsoft announced its acquisition of DB Best, provider of a leading suite of Oracle-to-SQL Server database-migration tools. This acquisition is the foundation for Microsoft's new SQL Server Migration Assistant (SSMA). SSMA defines and automates all the major steps in the database-migration process and provides comprehensive assessment reports, one-click conversion of all schema and data, one-click conversion of almost all database-resident business logic, and automated testing of the converted code. All these capabilities are available from within a single migration IDE. Currently, SSMA supports database migration only from Oracle to SQL Server 2000. Microsoft intends to support IBM DB2, but hasn't specified a time frame for this support. Microsoft says that the SSMA release to manufacturing (RTM) should happen sometime in the second half of this year, timed to coincide with SQL Server 2005's RTM. So, how will SSMA simplify your life? Here's a quote from the FAQ about SSMA:

    "With a single click, SSMA converts all database objects, including stored procedures, functions, triggers, views, packaged procedures, packaged functions, and sequences. SSMA also provides context-sensitive warnings and output messages. The conversion engine encapsulates Microsoft's patent-pending technology that represents one of the most complete PL/SQL to T-SQL conversion capabilities available."

    Sounds like magic! To be honest, I'm not an Oracle person, and it's been many years since I migrated data from one database platform to another. I'm not in a position to say whether this is a great product, but from reviews I've read and people I've spoken to at Microsoft, the SSMA solution looks like it will unquestionably save you a tremendous amount of time during an Oracle-to-SQL Server conversion. It won't be totally automated, and I strongly suspect you'll want to do some performance tuning when it's all said and done, but I think you'd be crazy to do an Oracle-to-SQL Server migration without the support of a tool like this.

    SSMA's primary Web site, http://lists.sqlmag.com/t?ctl=93E1:2621E7 , provides background information and lets you sign up for an SSMA beta that's currently underway. A detailed white paper is available at http://lists.sqlmag.com/t?ctl=93E2:2621E7 , and you can find the SSMA FAQ at http://lists.sqlmag.com/t?ctl=93E3:2621E7 .


    Find & Fix Bad SQL: New Quest White Paper
    Performance problems slowing you down? Optimize your database. Find and fix bad SQL with Quest Central for SQL Server. Download our new white paper now
        http://lists.sqlmag.com/t?ctl=93DF:2621E7


    2. News & Views

  • SQL Server's Double-Digit Growth

  • Microsoft's earnings for the third quarter of fiscal year 2005 show that for the eleventh consecutive quarter, SQL Server saw double-digit growth and contributed to a healthy quarter for the Server and Tools group. Microsoft believes there are several factors contributing to strong database revenue growth: enterprise data management platform; integrated business intelligence, developer, and management tools; manageability; high availability; sophisticated business intelligence (OLAP, reporting, and extraction, transformation, and loading--ETL); and continuing strength in the OLAP market. Moving forward, customers using SQL Server and Windows Server will also benefit from the multi-core policy announced last year. This policy lets customers license SQL Server on a per server basis. In addition, Microsoft was the first database vendor to enable customers to utilize passive failover servers with SQL Server without requiring an additional license for passive servers.

  • Results of Previous 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?" Here are the results from the 58 votes (deviations from 100 are due to a rounding error):

  • 7%    Yes, I can't wait to get started
  • 16%   Maybe, I want more information first
  • 78%   No, I'll wait for the RTM
  • New Instant Poll: Other Databases

  • "What other databases does your organization use besides SQL Server?" Go to the SQL Server Magazine home page ( http://lists.sqlmag.com/t?ctl=3D1:2621E7 ) and submit your vote for

  • Oracle
  • IBM DB2
  • Sybase
  • MySQL
  • Other
  • 3. Events and Resources


  • Get Ready for 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 1-year membership to PASS and 1-year subscription to SQL Server Magazine. Register now!
        http://lists.sqlmag.com/t?ctl=93E4:2621E7

  • Get Excited About SQL Server 2005 Reporting Services

  • In this free Web seminar, explore the new features associated with Microsoft SQL Server 2005 Reporting Services. You'll discover how to offer the "single version of truth" in your enterprise-reporting environment with the integration of Reporting Services 2005 and the Analysis Service 2005 Unified Dimensional Model (UDM). Plus, you'll discover Report Builder and more. Sign up today!
        http://lists.sqlmag.com/t?ctl=93E5:2621E7

  • 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 1-year subscription to SQL Server Magazine. Register now!
         http://lists.sqlmag.com/t?ctl=93E6:2621E7

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

  •      http://lists.sqlmag.com/t?ctl=5778:2621E7


    4. Featured White Paper


  • Configuring Blade Servers for Your Application Needs

  • Blade servers are the next evolutionary step for the server market. They pack a lot of function into a small space, conserve power, and are flexible. From setting up storage, configuring a file-and-print server, a Web server, an email server, a database server, or a terminal server, you'll learn all the tips you need in this free white paper.
        http://lists.sqlmag.com/t?ctl=93E7:2621E7


    5. Peer to Peer


  • Hot Tip: Using SQL Server with Large Amounts of Memory

  •      by Brian Moran, savvy@sqlmag.com

    Q. What's the best way to configure SQL Server to handle large amounts of memory, and how do I know when to use the /3GB switch?

  • Read the answer to this question today at

  •     http://lists.sqlmag.com/t?ctl=93E8:2621E7

  • Hot Article: The High Availability Puzzle

  • Of all a DBA's missions, none is more important than ensuring that vital business services are available to end users. All of your high-end scalability hardware and modern .NET coding techniques will make little difference if users can't access data. Unplanned downtime for an application or the database server can cost an organization dearly in money and reputation. Outages for large online retailers or financial institutions can cost millions of dollars per hour, and when users can't access a site or its vital applications, the organization loses face and customer goodwill. In his June editorial "The High Availability Puzzle," Michael Otey writes about how creating a highly available environment requires more than just technology. True high availability combines platform capabilities, effective operating procedures, and appropriate training of everyone involved with the system. Read this article today at
        http://lists.sqlmag.com/t?ctl=843B:2621E7

  • In a Nutshell: New Pronouncements By Jim Gray

  • Jim Gray, a distinguished engineer in Microsoft's Scalable Servers Research Group and leader of Microsoft's Bay Area Research Group (BARC), is one of the preeminent scholars of the relational database world. Gray is directly responsible for many important innovations in the relational database world, especially his seminal work around transactions and transaction processing. In this week's blog "New Pronouncements By Jim Gray," Kevin Kline writes about the pleasures of meeting and getting to know Gray, who is currently working on astronomy-related projects, helping to build an open online database of astronomic data. Gray's latest discourse in ACM's Queue is "A Call To Arms," one of the more challenging monologs on database technology and futures that Kevin has encountered. Take a look at it ( http://lists.sqlmag.com/t?ctl=93E9:2621E7page=1 ) and let Kevin know what you think today at
         http://lists.sqlmag.com/t?ctl=93EA:2621E7

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

  •      http://lists.sqlmag.com/t?ctl=3D8:2621E7

    Administration: Maintenance Challenge
         http://lists.sqlmag.com/t?ctl=93EB:2621E7
    Performance: Please Help! Connections Dropping
        http://lists.sqlmag.com/t?ctl=9401:2621E7
    T-SQL: Copy Related Rows Stored Procedure
        http://lists.sqlmag.com/t?ctl=93ED:2621E7
    Security: Database Compatibility Level
        http://lists.sqlmag.com/t?ctl=93EE:2621E7
    Data Access: Extracting Data
        http://lists.sqlmag.com/t?ctl=93EF:2621E7
    General Discussion: OpenRowset Again
         http://lists.sqlmag.com/t?ctl=93F0:2621E7

    Hot Spot

  • SQL Server MVPs Say sqlSentry Is a Must-Have Tool

  • "You'll never know how you lived without it" -- "It's a must-have in the DBAs arsenal" -- "This is a product that every DBA should use" -- "Comprehensive and productive" -- "This is the answer to the busy DBA's prayers" -- Read more...
        http://lists.sqlmag.com/t?ctl=93F1:2621E7

    6. 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=843F:2621E7

  • SQL Server Magazine Monthly Pass = Quick Answers!

  • Sign up today for your SQL Server Magazine Monthly Pass and get 24x7 online access to every article on the SQL Server Magazine Web site, including exclusive subscriber-only content. That's a database of over 9000 SQL Server articles to help you get all the answers you need, when you need them, for just $5.95 per month! Sign up now:
         http://lists.sqlmag.com/t?ctl=93F2:2621E7

    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.

  • Get SQL Server 2005 Programming Training

  • Silico-Magnetic Intelligence announced its new training series, "Microsoft SQL Server 2005 Programming," a full-motion video and audio training course on seven CD-ROMs. In the series, database developers can learn techniques for programming and database design to take advantage of new SQL Server 2005 features such as Management Studio, recursive queries, integrated projects, and output pivoting. The CD-ROM format provides a convenient learning environment for the student and is a cost-effective way to acquire database knowledge and administration and programming skills. Each CD-ROM chapter is broken into units, typically 10-20 minutes long, that students can replay as many times as needed. Students learn effectively from the full-motion video, which shows such images as mouse movements in Management Studio, database scripts as they run in Query Editor, and database object scripting. The course is priced at $695. For more information and a free test-drive, contact the distributor at sales@sqlusa.com.
        http://lists.sqlmag.com/t?ctl=93F3:2621E7

    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