SQL Server Magazine UPDATE, April 19, 2007--Keep Your Eye on DPM

SQL Server Magazine UPDATE, April 19, 2007--Keep Your Eye on DPM

The beta release of Microsoft System Center Data Protection Manager 2007 touts some significant improvements over the 2006 version of DPM. Although another beta is in the works before the final release, this product is worth watching.

"Does your organization use Microsoft System Center Data Protection Manager?" Go to the SQL Server Magazine home page ( http://www.sqlmag.com ) and submit your vote for:

  • Yes, it’s the only data protection package we’ve used.
  • Yes, it replaced a third-party tool we used before.
  • No, we use a third-party data protection package.
  • No, we have our own data-protection setup.
  • No, we’re evaluating data-protection options.

To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add [email protected] to your list of allowed senders and contacts.


April 19, 2007

1. Perspectives

2. SQL Server Watch

  • Product Watch: CA and Guardium

3. Hot Threads

  • Help NoFxPT work with distributed transactions in SQL Server and IBM DB2 tables.
  • Help cubehead find the license mode of a SQL Server 2005 database.
  • Help thehitman debug T-SQL in SQL Server 2005.
  • PLUS--Cast your vote for the Best Light Database Tool in the Windows IT Pro Community Choice Awards!

4. Hot Articles

  • Q&A: sp_HelpArticle Lists Publication Articles
  • Editorial: BI: Pass the Status Quo
  • In a Nutshell: New Windows Live Search Macro for SQL Server

5. Events and Resources

  • Centralize File Consolidation, Migration, Replication, and Failover
  • Manage Compliance Across Multiple Regulations and Standards
  • Protect Your Business in the Face of Disaster

6. Featured White Paper

  • Automated Data Protection

7. Announcements

  • Introducing a Unique Security Resource
  • Grab Your Share of the Spotlight!

8. Web Community


SPONSOR: Microsoft


Protect SQL Server with Microsoft’s Data Protection Manager
Learn how you can use Microsoft System Center Data Protection Manager (DPM) v2 to extend the native SQL Server feature set to provide continuous data protection with byte-level replication and integrity checking. From business case to recovery scenarios, this whitepaper demonstrates how DPM v2 will integrate with your SQL Server infrastructure.
Download your version of the white paper now.




Keep Your Eye on DPM
by Brian Moran, [email protected]

Have you checked out the beta of System Center Data Protection Manager (DPM) 2007? You should. DPM 2007 Beta 1 has substantially improved features across the board, but some of the SQL Server features are sure to be particularly attractive to many users. I’d be willing to bet that many of you aren’t familiar with the existing version of DPM even though it’s been around since 2004, when it was launched as Data Protection Server. The FAQ for DPM 2006 explains that DPM is a server software application that’s designed from the ground up to optimize disk-based backup and recovery. Let’s fast forward to the home page of DPM 2007 and review some of the major feature enhancements, with a particular focus on the SQL Server world.

Read the full article.

**** SPONSOR: SPI Dynamics ****

ALERT: “How A Hacker Launches A Web Application Attack!”--White Paper
Learn how to defend against Web Application Attacks with real-world examples of recent hacking methods such as: SQL Injection, Cross Site Scripting and Parameter Manipulation. Learn step-by-step vulnerability testing methods for your own Web Applications and guidelines for establishing best administration and coding practices. Download *FREE* white paper from SPI Dynamics for a complete guide to protection!




by Blake Eno, [email protected]

Quickly Determine the Status of Your Databases
CA announced CA Insight Database Performance Monitor (DPM) for Distributed Databases, a performance analysis and diagnostic tool for its Database Management solution. Using a single window, CA Insight DPM for Distributed Databases lets you monitor real-time and historical performance metrics for all distributed databases across your enterprise. The status of each database is represented as a single, color-coded and numeric indicator, letting you quickly see what databases require immediate attention. The software also lets you view specific database server conditions, such as locking, inadequate free space, I/O bottlenecks, high CPU utilization, and inadequate memory. For more information, contact CA at 631-342-6000 or 888-423-1000 or http://www.ca.com.

Protect the Sensitive Information That Resides on Your Databases
Guardium released Guardium DBLP, a solution that automatically locates and classifies sensitive information in databases, whether you use SQL Server, IBM DB2, Oracle, IBM Informix, Sybase IQ, or Sybase ASE. Guardium then prevents unauthorized activity to your data based on real-time policies and continuous comparison to normal activity. For example, Guardium monitors traffic both to and from database servers. So, if a database query returned thousands of credit card numbers, Guardium DBLP would immediately identify it. For more information, contact Guardium at 781-487-9400 or 877-487-9400 or http://www.guardium.com.




Join the discussions and share your expertise with your peers on our forums! New this week:

SQL Server General Discussion: SQL Distributed Transactions

SQL Server 2005 General Discussion: Find License Mode

Database Design and Development: Debugging T-SQL in SQL Server 2005

Windows IT Pro Community Choice: Best Light DB Tool




Q&A: sp_HelpArticle Lists Publication Articles
by Microsoft’s SQL Server Development Team

Q. I need to see all the articles for a given publication in my replication setup. Is there a system stored procedure that lists all a publication's articles?

Read the answer to this question today.

EDITORIAL: BI: Pass the Status Quo
BI is definitely not just Microsoft hype. The value in BI technologies is how they help businesses obtain more information from their data. Read this article today and post your comments.

IN A NUTSHELL: New Windows Live Search Macro for SQL Server
If you're a fan of the MSDN online search tool for SQL Server 2005 Books Online (BOL), check out the new search tool. Read the blog and post your input today.




Gain control over the growing amount of file data in your enterprise. Learn how File Area Networks (FANs) can help you centralize file consolidation, migration, replication, and failover. Download this eBook and start streamlining your file management projects today!

One common set of controls can help you manage compliance across multiple regulations and standards. Download this free IDC white paper and find out how to map controls to the appropriate regulations and save time and expense in demonstrating compliance.

You can't prevent nature from throwing floods, hurricanes, and earthquakes at your IT systems. You can't always control what people might do to your systems, either. Download this free eBook and learn to protect your business in the face of both natural and human-made disasters.

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




Built-in SQL Server data protection features aren't enough. Learn to use an automated data protection solution that provides 24x7 availability to meet today's critical business demands.

**** HOT SPOT: AppDev ****

SQL Server 2005 BI courses--BUY 1, GET 1 FREE
Learn SQL Server 2005 Business Intelligence from the nation's leader in developer training--Buy 1 CD-ROM or DVD-ROM course, get 1 FREE! Choose from Reporting Services, Analysis Services, Integration Services or any of our 70+ other courses. Step-by-step instruction by industry experts, plus printable courseware, hands-on labs, sample code. Hurry, offer ends 4/30/07. Order now.




Introducing a Unique Security Resource
Security Pro VIP is an online information center that delivers new articles every week on topics such as perimeter security, authentication, and system patches. Subscribers also receive tips, cautionary advice, direct access to our editors, and a host of other benefits! Order now at an exclusive charter rate and save up to $50!

Grab Your Share of the Spotlight!
Nominate yourself or a peer to become IT Pro of the Month. This is your chance to get the recognition you deserve! Winners will receive over $600 in IT resources and be featured in Windows IT Pro. It's easy to enter--we're accepting June nominations now, but only for a limited time! Submit your nomination today.





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

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.