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:
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
What's new in SQL 2005--40% OFF new course!
Dashboard Development and Deployment--A Methodology for Success
November 3, 2005
2. SQL Server 2005 Watch
3. News & Views
5. Events and Resources
6. Featured White Paper
7. Peer to Peer
9. 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, firstname.lastname@example.org
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!
2. SQL Server 2005 Watch
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
3. News & Views
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.
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
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
"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:
"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
4. Events and Resources
.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.
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.
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!
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!
5. Featured White Paper
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.
6. Peer to Peer
by Brian Moran, email@example.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?
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
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
Administration: Log Shipping
T-SQL: Debugging a Stored Procedure in Query Analyzer
Performance: SQL Mail
Security: Justifying a Permanent User Between Oracle and SQL Server
SQL Server 2000/7.0 General Discussion: Insert Problem with Partitioned View
SQL Server 2005 General Discussion: Confused About Install
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.
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:
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:
8. New & Improved
by Blake Eno, firstname.lastname@example.org
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@example.com!
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 firstname.lastname@example.org.
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.
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.