Product Watch
by Blake Eno, products@sqlmag.com
Learn How to Implement and Maintain a SQL Database
LearnKey released Microsoft Certified Technology Specialist Track (MCTS) for Structured Query Language (SQL) 2005 training. This learning track covers all prerequisites for the new Microsoft Professional Level Curriculum and is the foundation for SQL Server database administrators. In this course, you’ll learn how to write queries and implement and maintain a database. This is the entire material contained in Microsoft Exam 70-431, the certification test for SQL Server professionals. This course is taught by Microsoft Certified Professional Wayne Snyder and includes 15 sessions and approximately 45 hours of study. LearnKey's MCTS SQL Server 2005 series costs $1080 for individuals or $2695 for multiple seats. The learning track is available online, on DVD, and on CD-ROM. For more information, contact LearnKey at 800-865-0165 or vitsit http://www.learnkey.com.
Backup and Restore Tool
Databk.com announced SQL Server Backup 6.1, a backup-and-restore utility for SQL Server 2005. The software supports full database backup, differential backup, and transaction log backups with data compression and 128- or 256-bit encryption. The product's email reports provide information about an unfinished or finished backup or restore job. SQL Server Backup supports multiple SQL Server instances and can restore a database to a point of failure. The software also deletes expired backups automatically. SQL Server Backup is priced at $79.95. Volume discounts are available. For more information, contact Databk.com at support@databk.com or sales@databk.com.
This Month’s Focus: SQL Server Management Tools: T-SQL and SQLCLR Debugging
Learn the magic key for enabling cross-process debugging: http://www.sqlmag.com/Articles/ArticleID/42211/42211.html.
Sponsor: Innovartis
ISV? Database version upgrades painful?
DB Ghost Packager Plus enables ISVs to develop an installer for their customers containing the new version of their product that will automatically bring any target database to the same level as the source database. ISV customers just launch the Packager Plus installer.exe, choose the location and name of the database, set the basic settings, and click—it’s done. Excuse the cliche, but it really is as simple as that. Download our 14-day Free Trial.
3. Hot Articles
Reader to Reader: Stored Procedure Searches for Strings
Send your SQL Server code, comments, discoveries, and solutions to r2r@sqlmag.com.
Here's a stored procedure that searches the syscomments, sysobjects, syscolumns system tables in the local database for any reference to the string you specify. Read the full article at http://www.sqlmag.com/Articles/ArticleID/50250/50250.html.
T-SQL 2005: An Upgraded UPDATE
Enhancements to UPDATE in SQL Server 2005 help avoid deadlocks caused by simultaneous database requests. Read this article today and post your comments at http://www.sqlmag.com/Articles/ArticleID/93729/93729.html.
Puzzled by T-SQL: Using the RECOMPILE Query Hint to Solve Parameter Sniffing Problems
Sometimes you find that a tool designed to solve one problem is helpful in solving other problems as well. Read how Itzik Ben-Gan accidentally discovered that the new SQL Server 2005 RECOMPILE query hint can help solve parameter sniffing problems. Post your comments on the blog today at http://www.sqlmag.com/article/articleid/94369/sql_server_blog_94369.html.
Hot Threads:
4. Events and Resources
How will compliance regulations affect your IT infrastructure? Help design your retention and retrieval, privacy and security policies to make sure that your organization is compliant. Download the free eBook today!
Now that Microsoft and Novell have announced their alliance, you can't miss an opportunity to learn about new ways to manage Windows and UNIX/Linux networks efficiently. Register now for TechX World—free online December 14—and learn how to manage your heterogeneous environment. Topics include task automation and scripting, data access and application management, file and print sharing, and security and access considerations. Register today!
After disaster strikes, does recovering your data feel like digging for buried treasure? Test your disaster-recovery skills, and you could win! Each week, we'll give away a USB flash drive to one lucky treasure hunter. You'll also be entered to win the full treasure chest, including Bose headphones! Test your skills now!
Learn about the advantages for each alternative to traditional file servers and tape storage solutions, and make the best choice for your enterprise needs. On-Demand Web Seminar.
Learn to differentiate between alternative solutions to disaster recovery for your Windows-based applications and to ensure seamless recovery of your key systems--whether a disaster strikes just one server or the whole site. On-Demand Web Seminar.
Bonus: Register for any Web semina—live or on-demand—during the month of November, and you could win a PS3! View a full list of eligible seminars at http://www.windowsitpro.com/events/Index.cfm?Filter=webSeminars&fID=1.
See the complete Windows IT Pro Network guide to Web and live events.
5. Featured White Paper
TCO of an Email Archive
What’s the true cost of an in-house email archiving solution, and how does it compare to the cost of an outsourced solution? Find out from independent researchers what the TCO of both solutions really is and how the management of an in-house solution can strain IT budgets and staff. Download your copy of this whitepaper today!
Hot Spot: Intercerve
SQL Sentry Adds Support for Oracle!
vent Manager delivers “Outlook-style” visibility and functionality to easily manage intricate and voluminous job streams, including support for geographically distributed deployments and configuration of powerful event chains. Download a full trial today!
6. Announcements
SQL Server Performance Tips, Articles, and Forums
Get hundreds of free tips and articles on SQL Server performance-tuning and clustering. And get quick and accurate answers to your performance- and cluster-related questions in our forum. All from the SQL Server performance and clustering authority: SQL-Server-Performance.com.
Make Your Mark on the IT Community!
Nominate yourself or a peer to become IT Pro of the Month. This is your chance to get the recognition you deserve and be acknowledged in the IT community. Winners will receive more than $600 in IT resources and be featured in Windows IT Pro and the TechNet Flash email newsletter. Entering is easy—we're accepting December nominations now for a limited time! Submit your nomination today: http://www.windowsitpro.com/go/itpromonth.
SharePoint Pro Online—LIVE!
Join us for this premier virtual event for developers and administrators of SharePoint products and technologies. Brought to you by MSD2D and the Windows IT Media Community, this event will demonstrate, showcase, and exhibit the premier companies in the SharePoint market. The conference will bring industry experts to the desktops of attendees, educating them on various SharePoint topics. To register: http://events.unisfair.com/rt/sharepoint?code=mix.
7. Web Community
Contact Us
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 2006, Penton Media, Inc. All Rights Reserved.
End of Article
Prev. page
1
[2]
next page -->
