Email Alerts
-
SQL Server Standard Edition: Why it's worth the cost
Should your IT shop consider a move to SQL Server Standard Edition? Expert Robert Sheldon explains the pros and cons you should know. Feature
-
More predictions on 2013 SQL Server trends from Denny Cherry
What can you expect from Microsoft in 2013? Find out which SQL Server trends can be anticipated this year from SQL Server expert Denny Cherry. Feature
-
Denny Cherry's 2013 predictions (and wishes) for SQL Server trends
What new developments will SQL Server users see in 2013? Expert Denny Cherry predicts SQL Server trends to expect this year. Feature
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
Stylish SQL Server hardware every well-dressed computer is wearing
You want your SQL Server computer in top shape, so dress it in the newest duds. Learn about the latest trends in SQL Server hardware and make your server the talk of the town. Feature
-
Four tips on boosting SQL Server scalability
SQL Server scalability is high on the list of system properties, and scaling up is easier than scaling out. Follow these four tips and you’ll be on your way to optimum performance. Feature
-
FAQ: SQL Server 2008 high-availability services
Microsoft MVP Ross Mistry answers frequently asked questions about using SQL Server 2008 to offer high-availability services to customers. Project FAQs
-
SQL Server consolidation: Why, when and how to consolidate SQL Servers
To get control of SQL Server sprawl, you must consider consolidation. This new SearchSQLServer.com expert e-book, Consolidate SQL Servers for availability, scalability and cost savings, by SQL Server MVP Hilary Cotter will introduce you to the... E-Book
-
Fast Guide: Clustering in SQL Server
Clustering can increase reliability and uptime in a client/server environment. As a DBA, you have many options to choose from when it comes to clustering. When a server fails, should you totally rely on a complete fail-over design? What's the best wa... Fast Guide
-
Chapter 2: Planning your SQL Server consolidation
This SearchSQLServer.com expert e-book, "Consolidate SQL Servers for availability, scalability and cost savings" by SQL Server MVP Hilary Cotter, will introduce you to the worlds of server and storage consolidation. In Chapter 2, Hilary teaches you h... Chapter Download
- See more Essential Knowledge on SQL Server High Availability, Scalability and Reliability
-
Big data a big deal for SQL Server 2012, users say
SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users. News | 11 Apr 2012
-
SQL Server 2012 ‘virtually’ out, Microsoft talks features, licensing
With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are. News | 14 Mar 2012
-
Microsoft bulks up SQL Server scalability to rival buff competition
Better SQL Server scalability and lower costs have furthered Microsoft’s reach in recent years, industry observers say, and that’s good, because the competition is big and knows the turf well. News | 02 Mar 2012
-
Are data warehouses made for the cloud?
Cost and scalability benefits might make data warehousing seem like a perfect fit for cloud computing, but storage limitations with Azure could slow deployments. Article | 23 Oct 2009
-
Microsoft OKs virtualized SQL Server clusters: News in brief
In an about-face, Microsoft will now support failover clustering for SQL Server instances running in a virtual machine. Article | 19 May 2009
-
Up or out? Deciding on SQL Server scalability
SQL Server scalability brings with it many questions, but prime among them is this: Should you buy more servers or bulk up the ones you have? Tip
-
SQL Server high availability: Natural enemy of virtualization?
Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon. Tip
-
SQL Server virtualization: When it's just not a good idea
Virtualizing SQL Server is a good idea for many IT shops, but it's not for everyone. Robert Sheldon explains when it might not be a good choice. Tip
-
Splitting SQL Server backups to multiple files
Splitting database backups helps save space and run your SQL Server backups more efficiently. Get tips for executing this from Ashish Kumar Mehta. Tip
-
Maximize SQL Server database performance by streamlining your data
Roman Rehak shows you some quick and easy ways to streamline and improve performance of your SQL Server databases. Tip
-
The pros and cons of virtualizing SQL Server environments
What are the pros and cons of virtualizing SQL Server environments? Basit Farooq takes you through the potential good, bad and the ugly. Tip
-
Preparing for your SQL Server scale-out
It's never too early to prepare for a SQL Server scale-out. Read this tip from Roman Rehak to learn three popular ways to scale out SQL Server. Tip
-
Index tuning for the reluctant DBA
Many reluctant DBAs find index tuning intimidating. Read this article by Don Jones to learn why index tuning is a must for your SQL Server shop. Tip
-
Virtualizing SQL Server? What to keep in mind
Thinking about virtualizing SQL Server? Roman Rehak gives you a rundown about what you should keep in mind when planning your migration. Tip
-
In-memory SQL Server: The implications of integration
How is in-memory SQL Server different from SQL Server with a bunch of RAM? SQL Server guru Serdar Yegulalp explains what to know before you install. Tip
- See more Tips on SQL Server High Availability, Scalability and Reliability
-
Merge replication to keep SQL Server databases in sync
Keep SQL Server databases in sync with merge replication and limit connectivity issues. Use this resource for help setting up merge replication. Ask the Expert
-
Synchronize databases on two separate active servers
Synchronize databases on separate servers without using SANs. Learn options for server failover in SQL Server including log shipping, database mirroring and replication. Ask the Expert
-
Configure log shipping between SQL Server 2000 and 2005
Have you upgraded to SQL Server 2005 and need to configure log shipping between SQL Server 2000 and SQL Server 2005? Learn about that possibility. Ask the Expert
-
Determining number of servers needed for large member site
Database servers needed for a site with thousands of users can vary depending on a number of factors, including your necessary level of load application as detailed by SQL Server 2005 expert Adam Machanic. Ask the Expert
-
Configuring SQL Server clusters
SQL Server Expert Adam Machanic recommends two books on the topic of high availiabilty to help install SQL Server on two systems with the same database and the same database structure. Ask the Expert
-
Active/active or active/passive clustering?
SQL Server expert Jeremy Kadlec helps one reader decide between active/active and active/passive clustering for his database. Ask the Expert
-
Clustering in SQL Server 2000 explained
Ask the Expert
-
database mirroring
Database mirroring is the maintenance of redundant copies of a database to ensure continuous data availability and minimize or avoid downtime that might otherwise result from data corruption or loss, or when the operation of a network is partially c... Definition
-
Ensuring high availability of SSAS databases
In part three of this series, Baya Dewald hones in on the administrative side of SQL Server Analysis Services, with details on the various methods on high availability for SSAS. Video
-
FAQ: How to offer high-availability solutions with SQL Server 2008
Expert Ross Mistry discusses the different ways that SQL Server 2008 can provide high-availability solutions in this FAQ podcast. Podcast
-
Podcast: Log shipping in SQL Server: Basics to best practices
SQL Server database administrator Eric Johnson explains how to back up your primary database and restore it to a secondary server through log shipping. He'll explain log shipping setup via SQL Server Management Studio. Get the details on how to set u... Podcast
-
Database mirroring in SQL Server 2005 2
What is database mirroring in SQL Server and how can it benefit your environment? SQL Server database administrator Eric Johnson starts by outlining the three roles involved in database mirroring: principle, mirror and witness. He goes on to share th... Podcast
-
Up or out? Deciding on SQL Server scalability
SQL Server scalability brings with it many questions, but prime among them is this: Should you buy more servers or bulk up the ones you have? Tip
-
SQL Server high availability: Natural enemy of virtualization?
Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon. Tip
-
SQL Server virtualization: When it's just not a good idea
Virtualizing SQL Server is a good idea for many IT shops, but it's not for everyone. Robert Sheldon explains when it might not be a good choice. Tip
-
Splitting SQL Server backups to multiple files
Splitting database backups helps save space and run your SQL Server backups more efficiently. Get tips for executing this from Ashish Kumar Mehta. Tip
-
Maximize SQL Server database performance by streamlining your data
Roman Rehak shows you some quick and easy ways to streamline and improve performance of your SQL Server databases. Tip
-
The pros and cons of virtualizing SQL Server environments
What are the pros and cons of virtualizing SQL Server environments? Basit Farooq takes you through the potential good, bad and the ugly. Tip
-
SQL Server Standard Edition: Why it's worth the cost
Should your IT shop consider a move to SQL Server Standard Edition? Expert Robert Sheldon explains the pros and cons you should know. Feature
-
Preparing for your SQL Server scale-out
It's never too early to prepare for a SQL Server scale-out. Read this tip from Roman Rehak to learn three popular ways to scale out SQL Server. Tip
-
More predictions on 2013 SQL Server trends from Denny Cherry
What can you expect from Microsoft in 2013? Find out which SQL Server trends can be anticipated this year from SQL Server expert Denny Cherry. Feature
-
Denny Cherry's 2013 predictions (and wishes) for SQL Server trends
What new developments will SQL Server users see in 2013? Expert Denny Cherry predicts SQL Server trends to expect this year. Feature
- See more All on SQL Server High Availability, Scalability and Reliability
About SQL Server High Availability, Scalability and Reliability
High availability and reliability is a must for most large enterprises, and that doesn't exclude the database. There are several different high availability database solutions for Microsoft SQL Server, such as failover clustering, replication, and database mirroring. This topic page provides resources on a wide variety of high availability techniques for SQL Server 2005 and 2008. Here you'll find tips on high availability methods like log shipping and managing scalable shared databases, along with other tips covering overall best practices for high availability with Microsoft SQL Server. This page also includes details on SQL Server scalabilty strategies, with advice on scalability for all Microsoft SQL Server releases.