SQL Server High Availability, Scalability and Reliability

MUST READ SQL Server database replication tutorial TIP - SQL Server replication methods include snapshot, merge and transactional replication. Learn how to choose a method, set up SQL replication and avoid the 'gotchas.' Database mirroring setup in SQL Server 2005 TIP - SQL Server 2005 database mirroring allows you to automatically mirror database contents. Learn how it works and how to get it up and running with Management Studio. SQL Server consolidation: Why it's an optimization technique TIP - SQL Server consolidation benefits are high availability and lower licensing costs. Here's what to expect for hardware needs, system monitoring and SQL licensing.

EXPERT TECHNICAL ADVICE: 1 - 3 of 57

	SQL Server high availability: Options and caveats Submitted By: SearchSQLServer.com | 17 Nov 2009 TIP - DBAs have several techniques to choose from for ensuring SQL Server availability. Deciding on the right one for you is all about evaluating the costs versus the benefits.

	Top load balancing methods for SQL Server Submitted By: SearchSQLServer.com | 29 Jun 2009 TIP - There are a number of way to achieve load distribution in SQL Server. Learn about some of the key methods, including merge replication, log shipping and server farm deployment.

	Maintaining high availability of SQL Server virtual machines Submitted By: SearchSQLServer.com | 15 Jun 2009 TIP - Learn to take advantage of Hyper-V and Windows 2008 in order to achieve fault-tolerant and highly available SQL Server virtual machines.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER HIGH AVAILABILITY, SCALABILITY AND RELIABILITY

REFERENCE & LEARNING: 1 - 3 of 25

	FAQ: SQL Server 2008 high-availability services SearchSystemsChannel.com | 30 Mar 2009 PROJECT FAQS - Microsoft MVP Ross Mistry answers frequently asked questions about using SQL Server 2008 to offer high-availability services to customers.

	FAQ: How to offer high-availability solutions with SQL Server 2008 SearchSystemsChannel.com | 30 Mar 2009 PODCAST - Expert Ross Mistry discusses the different ways that SQL Server 2008 can provide high-availability solutions in this FAQ podcast.

	Tutorial: Migrating to SANs from local SQL Server disk storage SearchSQLServer.com | 23 Jun 2008 SPOTLIGHT - Storage area networks (SANs) improve SQL Server performance. Set up SANs on SQL Server with these best practices on migrating to, and configuring SANs.

	VIEW ALL REFERENCE & LEARNING ON SQL SERVER HIGH AVAILABILITY, SCALABILITY AND RELIABILITY

WHITE PAPERS

Reduce CPU Usage with 'SMART' SQL Published by: BMC Software, Inc | 30 Nov 2009 WHITE PAPER - This paper discusses how and why to design SQL that will reduce the number of times calls are made to DB2. We'll look at how to write SMART applications rather than writing applications that act like generic I/O modules to DB2, properly tune SMART SQL, and how to exploit SQL and application features in DB2 on z/OS version 8 and 9.

Presentation Transcript: Data Warehousing Basics for SQL Server Analysis Services Published by: Flowerfire, Inc. | 25 Nov 2009 PRESENTATION TRANSCRIPT - In this transcript of the "Data Warehousing Basics for SQL Server Analysis Services" webcast, learn how to build your data warehouse for your SQL Server environment. Discover the necessary steps involved and learn about major concepts, including relational data warehousing and supported SQL Server Analysis Services (SSAS) storage formats.

	Techfocus SQL Server 2008 Migration: Evaluate the Value of a SQL Server Upgrade Published by: SHI | 24 Nov 2009 EBOOK - SQL Server 2008 has many compelling features, but not all of them are necessary. See what's a good fit for your enterprise and what can wait.

	VIEW ALL WHITE PAPERS IN THIS TOPIC

DOWNLOADS: 1 - 1 of 1

	Podcast: SQL Server high availability options Published by: SearchSQLServer.com | 27 Aug 2007 PODCAST - In this podcast series, you'll get the basics and best practices for each SQL Server high availability option including database mirroring, replication and log shipping.

	VIEW ALL DOWNLOADS ON SQL SERVER HIGH AVAILABILITY, SCALABILITY AND RELIABILITY

NEWS: 1 - 3 of 5

	Are data warehouses made for the cloud? SearchSQLServer.com | 23 Oct 2009 ARTICLE - Cost and scalability benefits might make data warehousing seem like a perfect fit for cloud computing, but storage limitations with Azure could slow deployments.

	Microsoft OKs virtualized SQL Server clusters: News in brief SearchServerVirtualization.com | 19 May 2009 ARTICLE - In an about-face, Microsoft will now support failover clustering for SQL Server instances running in a virtual machine.

	SQL Server 2005 Database Mirroring primer SearchSQLServer.com | 21 Feb 2006 INTERVIEW - Edgewood Solutions' Greg Robidoux answers some common questions about Database Mirroring in SQL Server 2005.

	VIEW ALL NEWS ON SQL SERVER HIGH AVAILABILITY, SCALABILITY AND RELIABILITY

WEBCASTS: 1 - 3 of 5

	Delivering Enterprise Storage & Server Management for SQL - Vendor Webcast VIEW WEBCAST PREMIERED:   20 JUN 2006, 14:00 EDT (18:00, GMT) SUMMARY:   This Webcast will cover high performance server profiles for SQL, improving application performance with Veritas Storage Foundations for Windows and how to improve the availability of your SQL application.

	Better Management Techniques for SQL Server Environments - Vendor Webcast VIEW WEBCAST PREMIERED:   07 JUN 2006, 14:00 EDT (18:00, GMT) SUMMARY:   In this webcast, learn how to reduce the hassles of managing multiple SQL Servers. Gather knowledge on how multiple server consolidation using cluster file systems can make your life easier.

	Forrester Research on Oracle Real Application Clusters - Vendor Webcast VIEW WEBCAST PREMIERED:   26 APR 2006, 09:00 EDT (13:00, GMT) SUMMARY:   In this Webcast, hear from industry expert Noel Yuhanna, Senior Analyst at Forrester Research, who will discuss Oracle’s RAC and how it delivers an innovative solution for organizations to achieve their high availability and scalability requirements.

	VIEW ALL WEBCASTS ON SQL SERVER HIGH AVAILABILITY, SCALABILITY AND RELIABILITY

	SEE ALSO - Topics Related to SQL Server High Availability, Scalability and Reliability:  Microsoft SQL Server Tools and Utilities, Microsoft SQL Server Installation, SQL Server Interoperability, SQL Server Replication, Microsoft SQL Server Performance Monitoring and Tuning, SQL Server Stored Procedures, SQL/Transact SQL (T-SQL), SQL Server Backup and Recovery, SQL Server Security