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 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.

Breaking Through the Dissimilar Hardware Restore Challenge

St. Bernard
Filtering the Spectrum of Internet Threats

March 2, 2006

1. Perspectives

  • Using a SAN or SATA Drives--Benefits Versus Price

    2. News & Views

  • Windows Server 2003 R2 Enterprise Edition as a Database Platform Seminar
  • Results of Previous Instant Poll: Wikis
  • New Instant Poll: BOL

    3. Events and Resources

  • DevConnections--Register Now
  • Web Seminar: Windows Server 2003 R2 Enterprise Edition
  • Web Seminar: Rethinking SQL Server Backup and Restore Strategies
  • Windows IT Pro Toolkits

    4. Featured White Paper

  • Learn About Complying with the PCI Data Security Standards

    5. Peer to Peer

  • Hot Tip: Updating an Oracle Trigger for SQL Server 2000
  • Hot Article: Feature Pack 2005
  • In a Nutshell: Friday at PASS Europe 2006
  • Hot Threads

    6. Announcements

  • Save 50% Off the SQL Server Magazine Master CD
  • SQL Server Magazine--SAVE 58%

    7. New & Improved

  • Replicate Data Across Heterogeneous Databases
  • Simplify and Centralize SQL Calculations

    Sponsor: Symantec

    Breaking Through the Dissimilar Hardware Restore Challenge
          Failure of a computer’s hardware is inevitable. Before you replace any hardware you need to have a rapid system recovery solution in place. In this free white paper, you'll learn about recovery to virtual computer environments, hardware migration strategies, hardware repurposing for optimal resource utilization, meeting recovery time objectives, increasing disaster tolerance, and more.

    1. Perspectives

    Using a SAN or SATA Drives--Benefits Versus Price
          by Brian Moran,

    Interested in learning how you can achieve faster database I/O performance at 1/40th the price of a high-end SAN? Then you must read the March SQL Server Magazine article "Pare Down and Power Up," at Read it and you’ll learn how Rich Johnson and his colleagues at Microsoft Consulting Services leveraged the work of Dr. Jim Gray, a senior researcher and manager of Microsoft's Bay Area Research Center, to build a 24TB data warehouse capable of more than 2.2GB per second for sequential reads and 2.0GB for sequential writes.

    Even if you don't have a strong background in hardware I/O, you’ll find that the 2.2GB-per-second throughput is probably as good as or better than any database throughput numbers you can achieve using a conventional SAN solution, regardless of how much money you want to spend. How did Rich do it? He used Serial ATA (SATA) drives in a direct-attached storage system.

    This week’s editorial isn’t designed to fight the arguments that SAN advocates will raise regarding the availability and other manageability benefits of a SAN, and I’m certainly not going to attempt to address the issue of reliability of a SATA drive versus a SCSI drive. This week's column is simply about making you think. Sure, I’ll concede that a SAN is really nifty for all sorts of reasons. But let’s focus on the possibility of getting performance that equals or exceeds that of a SAN for 1/40th the price. Spending $50,000 rather than two million for a high-end, multiterabyte data warehouse will intrigue many people. All of a sudden, the extra benefits a SAN provides might not seem so attractive or cost-effective.

    The information Rich presents in his article won't make SANs obsolete, but it might make readers realize that many customer solutions will be better served by considering a direct-attached SATA-based solution. Over the next year, I expect a tremendous amount of FUD from system vendors that have vested interests in protecting the SAN status quo and their large profit margins. I also expect a lot of innovative solution providers to find ways to deliver reliable, available, highly scalable database I/O solutions by using the ideas presented in Rich’s article. Read the article and let me know what you think.

    P.S. You might want to also read the commentary from Douglas McDowell, "Are you ready for the "SQL Server Microwave"?," at .This article describes Rich Johnson's new prototype BI Server and storage platform he's been testing.

    ****** Sponsor: St. Bernard ******

    Defending Against Inappropriate Content, Spyware, IM, and P2P at the Perimeter
          Because of the proliferation of Web-based threats, you can no longer rely on basic firewalls as your sole network protection. Attackers continue to evolve clever methods for reaching victims, such as sending crafty Web links through Instant Messaging (IM) clients or email, or by simply linking to other Web sites that your employees might surf. This free white paper examines the threats of allowing unwanted or offensive content into your network and describes the technologies and methodologies to combat these types of threats. Get your free copy now!

    2. News & Views

    Windows Server 2003 R2 Enterprise Edition as a Database Platform Seminar

          Recently, Microsoft released Windows Server 2003 Release 2 (R2) Enterprise Edition, which includes many system changes. Database developers will be most interested in the Cluster service and Microsoft Metadirectory Service (MMS). Cluster service provides disaster tolerance and the ability to have as many as eight geographically dispersed servers working together and appearing as a single system. MMS used with Active Directory (AD) lets you link data sources together and manage the identity information from a central source. Learn how to use Windows Server 2003 R2 Enterprise Edition as a database-hosting platform for SQL Server 2005 Enterprise Edition and how this solution can support requirements for a large database. Register for this online seminar, which takes place on April 11, 2006, at 12 PM EDT, at

    Results of Previous Instant Poll: Wikis
         "Do you trust the content in wikis?" Here are the results from the 45 votes:
  • 27% Yes, I think they are good resources
  • 38% Yes, but I often double-check their facts
  • 22% Sometimes, but I take them with a grain of salt
  • 13% No, I don’t trust wikis

    New Instant Poll: BOL
          "Have you used SQL Server Books Online (BOL)?" Go to the SQL Server Magazine home page ( ) and submit your vote for:

  • Yes, I use BOL all the time
  • I have accessed BOL just to try it
  • No, I haven't used BOL

    3. Events and Resources

    DevConnections provides world-class education for developers, architects, DBAs, and IT professionals.

    WinConnections (2 conferences for the price of 1): April 9-12, 2006, Orlando, Florida,

    DevConnections (4 conferences for the price of 1): April 2-5, 2006, Orlando, Florida,

    DevConnections Europe coming to Nice, France, April 24-27, 2006.

    Web Seminar: Windows Server 2003 R2 Enterprise Edition
          Learn why new features in Windows Server 2003 R2, including large clustering, increased RAM, and 64-bit support make it the ideal platform for your collaboration tools. Live event: March 28; 12 PM EST

    Web Seminar: Rethinking SQL Server Backup and Restore Strategies
          Learn how to leverage new features in SQL Server 2005 to extend your existing backup and restore capabilities. View the on-demand Web seminar now!

    Windows IT Pro Toolkits
          Implement real-time processes in your email and data systems--you could also win an iPod Nano!

    4. Featured White Paper

    Learn About Complying With the PCI Data Security Standards
          Get the tips you need to prepare for and comply with the PCI Data Security Standard, including how to define the 12 major requirements and how those requirements affect IT.

    5. Peer to Peer

    Hot Tip: Updating an Oracle Trigger for SQL Server 2000
          by Microsoft’s SQL Server Development Team,

    Q. I previously used Oracle's BEFORE and AFTER triggers to update tables. Now that I'm using SQL Server 2000 it seems like I have to use INSTEAD OF triggers. Is this true?

    Read the answer to this question today at

    Hot Article: Feature Pack 2005
          Microsoft recently released a feature pack for SQL Server 2005 Server. In his March SELECT TOP(X) column "Feature Pack 2005," Michael Otey lists his 10 favorite features. Read this article today and post your comments at

    In a Nutshell: Friday at PASS Europe 2006
          Last week, Kevin Kline attended the 2006 Professional Association for SQL Server (PASS) European Conference in Spain. In his blog, Kevin lists some of the sessions he attended and links to two documents about troubleshooting SQL Server 2005 performance problems and PSS Service Center labs that Microsoft France's Patrick Guimonet highlighted during his sessions. Read his summary and find the links to the articles at

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

    Administration: Not enough server storage is available to process this request.

    T-SQL: Dropping ALL Triggers But the Trigger Names are Not Known

    Performance: Execution Plan, Index Order

    Security: Give a developer permission to create a server login and govern its permissions

    **** Hot Spot ****

    Microsoft Day at SQL Server Magazine Connections--Orlando, Florida, April 2-5, 2006
          Dive inside SQL Server 2005 with the Microsoft SQL Server Product Team. Learn directly from the source about Integration Services, SQLCMD, CacheSync; attend the three-part Project REAL series; and more. Register online or call 203-268-3204 or 800-899-5325 for more info.

    6. Announcements

    Exclusive March Offer--SAVE 50% Off the SQL Server Magazine Master CD!
          Subscribe today and get portable, high-speed access to the entire SQL Server article database on CD--a searchable library that includes every SQL Server Magazine article written since March 1999. The newest issue also includes BONUS SQL Server 2005 tips. This is a special, one-time-only offer that will not be repeated. Order now:

    SQL Server Magazine--SAVE 58%
          SQL Server Magazine is a must-have in 2006! Subscribe now and plug into the #1 guide to building world-class applications. Along with loads of how-to articles, timesaving advice, and expert tips and solutions, you'll gain exclusive access to the entire online SQL Server Magazine article library FREE. This is a limited-time offer, so order now:

    7. New & Improved

          by Blake Eno,

    Replicate Data Across Heterogeneous Databases
          HiT Software announced DBMoto 5, a data-replication solution for your enterprise servers and desktops that supports SQL Server 2005, Oracle, IBM DB2, MySQL, Microsoft Access, and PostgreSQL. DBMoto consists of Enterprise Manager, a GUI that lets you define your replication tasks, and DBMoto Engine, DBMoto's processor, which optimizes your replication and synchronization tasks. Other new features include Visual Basic.NET scripting, Secure Sockets Layer (SSL) encryption, and real-time replication monitoring. A free trial is available. For more information, contact HiT Software at or 408-345-4001.

    Simplify and Centralize SQL Calculations
          AppFusion announces Advanced Modeling, a new component for its business intelligence (BI) and collaboration platform. This product lets you treat relational data as multi-dimensional arrays so that you can easily perform complex SQL calculations. Advanced Modeling eliminates the need for complex SQL JOIN and UNION statements and lets you perform hierarchical or customized financial modeling, time-series analyses, and iterative calculations. In addition, the product lets you manage all the calculations within the BI and Collaboration Dashboard. For more information, contact AppFusion at 858-587-2574.

    Contact Us

    About the
    About the
    About technical questions--
    About product
    About your
    About sponsoring an issue of SQL Server Express UPDATE--Richard Resnick, or Lisa Kling,

    SQL Server Express 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.

    Manage Your Account

    You are subscribed as %%$email%%. To unsubscribe from this email newsletter, click here

    To manage your email account, simply log on to our Email Preference Center.

    View the SQL Server Magazine Privacy Policy.

    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.