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
SQL Server Magazine
2. News & Views
3. Events and Resources
4. Featured White Paper
5. Peer to Peer
7. New & Improved
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:
by Brian Moran, [email protected]
Microsoft News from Tech Ed 2005
I attended the Microsoft Tech Ed 2005 conference in Orlando, Florida last week and want to share Microsoft's most important SQL Server announcements with you. The company has finally nailed down the SQL Server 2005 launch for November 7. SQL Server 2005 has been in the works for a long time. For me, now that Microsoft has announced a fixed launch date, the product feels much more real because I know that it will soon be in the hands of the community. That's exciting because SQL Server 2005 includes an incredible number of new features that will greatly enhance the flexibility and power that we have when architecting solutions on top of SQL Server. The countdown begins!
Speaking of getting SQL Server 2005 into users' hands to build production applications... Microsoft announced that seven customers are already running SQL Server 2005 beta versions in live production environments. And that doesn't include the 80 applications (or more) that Microsoft has spread across 10 SQL Server 2005 instances managing multiple terabytes of data within the company. The company anticipates having more than 20 external customers running live on SQL Server 2005 before product launch in November.
Microsoft also released the SQL Server 2005 June Community Technology Preview (CTP) at Tech Ed. Each subsequent CTP release makes the product richer in fully implemented features and more stable. Based on Microsoft's release of world record TPC-C and TPC-H numbers, the company has made significant progress in terms of scalability. Early versions of a beta are never tuned for performance. Microsoft is more worried about making it work, than making it run fast. But performance clearly becomes a more important topic as the product moves closer to release to manufacturing (RTM) and we can expect even better numbers from SQL Server 2005 on these tests by the time that the product ships. I'll leave exploring the implications of these numbers for a future editorial, but I want to share a few highlights. The SQL Server 2005 TPC-H numbers show a 162 percent performance gain over SQL Server 2000. The new TPC-H scores show a 38 percent higher performance than Oracle's best score on a 16X Intel Itanium 2 server for 20 percent less cost. On the TPC-C side, SQL Server 2005 has regained the world record on a Windows platform by posting a score that tops the one million transaction-per-minute (TPM) mark. This score is 7 percent higher for 35 percent lower cost than Oracle's best result on a 64-processor Itanium 2 server.
Last week, I discussed the license-model changes for SQL Server Reporting Services (see "Microsoft's Reporting Services 180" at http://lists.sqlmag.com/t?ctl=C62D:7B3DB ). Here's a quick summary: Reporting Services will ship in all editions of SQL Server 2005, and Report Builder will be included in the product's Enterprise, Standard, and Workgroup Editions.
Finally, the SQL Server Migration Assistant (SSMA) for Oracle is now available for download at http://lists.sqlmag.com/t?ctl=C631:7B3DB . SSMA is a toolset that will automate Oracle-to-SQL Server application migration.
Download the newest CTP and keep exploring. SQL Server 2005 will be here before you know it, and time is growing short to make sure you're ready for it.
SQL Server Magazine
Get 2 Sample Issues of SQL Server Magazine!
Every issue of SQL Server Magazine includes intelligent, impartial, and independent coverage of the SQL Server facets. Our expert authors deliver how-to articles and quick solutions that will help you do your job better. Try two, no-risk sample issues today, and find out why 30,000 SQL Server professionals rely on SQL Server Magazine for answers each month!
2. News & Views
Results of Previous Instant Poll: Microsoft TechEd
"Did you attend the Microsoft TechEd conference in Orlando, Florida?" Here are the results from the 54 votes:
New Instant Poll: Benchmarks and TPC-C Scores
"Do you pay attention to public benchmarks and TPC-C scores?" Go to the SQL Server Magazine home page ( http://lists.sqlmag.com/t?ctl=C63D:7B3DB ) and submit your vote for
3. Events and Resources
Celebrate the Launch of SQL Server 2005 Nov 7-10, 2005 at Mandalay Bay in Las Vegas
Microsoft will give every attendee a copy of SQL Server 2005 and Visual Studio 2005. SQL Server Magazine Connections is co-located with Microsoft ASP.NET & Visual Studio Connections. Register by July 15 to get a free night at Mandalay Bay call 800-438-6720 for details.
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!
Microsoft SQL Sever 2005–For Every Tier Of Your Business Intelligence Application
In this free Web seminar, you'll learn about the anatomy of business intelligence and how each portion maps to the SQL Server 2005 toolset. Plus–get all you need to know about Integration Services, the relational engine, Analysis Services, Reporting Services, and Notification Services, as well as sharing steps to integrate all components with third-party applications, Microsoft Office, and Microsoft SharePoint.
Get The SQL Server BI Essentials
This eBook will give you a solid foundation for understanding where BI has come from and where it's headed. You'll learn about what's coming in SQL Server 2005 and help validate what you already know. Download this free eBook now to get the wealth of BI tips and techniques you shouldn't be without.
See the complete Windows IT Pro Network guide to Web and live events.
4. Featured White Paper
Instant Recovery and Data Protection for SQL Servers
One of the most common database management systems for Microsoft Windows servers is SQL Server. Depending on your environment, your SQL Server may be your most critical application. In this free white paper, learn the data protection strategies you need to really protect your database, compare the costs, evaluate alternatives and more!
5. Peer to Peer
Hot Tip: SP3 Changes Debugging Functionality
by Microsoft's SQL Server Development Team, [email protected]
Q. I'm trying to debug a T-SQL stored procedure, but when I start debugging, after getting the parameter dialog box from Query Analyzer, I get the following error message:
Server: Msg 504, Level 16, State 1, Procedure sp_sdidebug, Line 1 \[Microsoft\]\[ODBC SQL Server Driver\]\[SQL Server\]Unable to connect to debugger on TAO (Error = 0x800706ba). Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered on DMAHAPATRA1. Debugging disabled for connection 72.
I have SQLDBREG.EXE installed on the client and registered on DMAHAPATRA1. Do you know what the problem might be?
Read the answer to this question today at
Hot Article: Running SQL Server in a VM
Are you trying to use virtual machine (VM) technology for production tasks such as SQL Server system consolidation? Are you testing the SQL Server 2005 beta? Are you using a VM to run database demonstrations on your laptop? If you answered yes to any of these questions, you're concerned about performance. In his June SELECT TOP(X) column "Running SQL Server in a VM," Michael Otey shares five tips to maximize SQL Server performance in a VM. The tips apply to SQL Server running under Microsoft Virtual PC 2004, Microsoft Virtual Server 2005, and VMware's Workstation and GSX Server. Read this article today and post your comments at
Hot Threads: Check out the following hot threads, and see other discussions in our 30 SQL Server forums.
Administration: Reading a Trace File Without Stopping SQL Server
T-SQL: Creating a View
Performance: Query Performance
Security: Setting Up Windows Authentication
Replication: Error 7212--Executing Remote Stored Procedure Fails
DTS: Cannot Find Specified Package Error
SQL Server Magazine Monthly Online Pass = Quick Answers!
Sign up today for your Monthly Online Pass and get 24/7 online access to the entire SQL Server Magazine article database, including exclusive subscriber-only content. That's a database of over 2,300 SQL Server articles to help you get all the answers you need, when you need them. Sign up now for just US$5.95 per month:
Be a Part of the 2005 MCP Hall of Fame
Are you a top-notch MCP who deserves to be a part of the first-ever MCP Hall of Fame? Nominate yourself or a deserving friend and get the fame you deserve by becoming a part of this influential community of certified professionals. You could win a VIP trip to Microsoft and other valuable prizes. Last day for nominations is June 30, so sign up now:
7. New & Improved
by Dawn Cyr, [email protected]
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 [email protected]!
Transfer XML Data
HiT Software announced Allora 4.1, software that enables bi-directional data transformation between XML and any database. Allora's graphical mapping tool, extensive APIs, runtime middleware engine, and graphical user interface offer a convenient way to export data from any relational database to XML or map and transform XML data to relational data. The main enhancement in the latest release is the multiple SELECT feature. Previous releases of the product could perform complex database-to-XML transformations by using a single SQL query. The new release offers an option to work with multiple sub-maps that join in realtime with XSL, a W3C language for transforming XML documents. With the multiple SQL query approach, Allora 4.1 can enable heterogeneous database migration. Rather than using database-specific SQL dumps or flat files that can't contain table relationships or constraints, you can persist your complete database structure and data into XML for easy access or transport and recreate the database on any other database platform at a minimum cost. Other enhancements in the Allora 4.1 Mapper include support for namespace definitions, complex database expressions, NetBeans 4.1, and stored procedures in Oracle packages. Allora 4.1 works with more than 20 different databases, including SQL Server, Oracle, IBM DB2, Sybase, and MySQL. A fully operational trial version of the software is available from the vendor's Web site. For pricing and other information, contact HiT Software at 408-345-4001 or [email protected]
Use XQuery for Data Integration
DataDirect Technologies announced the beta of DataDirect XQuery, an embeddable XQuery implementation for XML applications that need to process both XML and relational data sources. XQuery is a W3C standard native XML query and transformation language. Because most types of data can be represented as XML, you can use XQuery to query other types of data--such as relational data--by using an XML view of a relational database. This ability is important because many Web applications need to integrate information from multiple sources, including data found in Web messages, relational data, and various XML sources. DataDirect XQuery simplifies working with XML and relational data together, allowing Java developers to programmatically invoke and process XQuery expressions against any major relational database including Microsoft SQL Server, Oracle, and IBM DB2, directly from within their Java applications. DataDirect XQuery installs easily; it does not require its own server infrastructure, and it is scalable from desktop to enterprise applications. To register to participate in the DataDirect XQuery beta program or for more information, contact DataDirect at 800-876-3101 or 919-461-4200.
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.
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.