Email Alerts
-
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
-
Step 4: Deploy consolidated databases in a production environment
There is a multitude of ways to migrate user databases to the consolidated SQL Server environment. Get some methods in this step excerpted from Chapter 2, 'Planning your SQL Server consoli... Step-by-Step Guide
-
Step 3: Test your SQL Server consolidation
Once determining which databases go on each stack, watch data access and usage patterns so you can group databases on consolidated SQL Servers for optimal performance. Get help in this step excerpted from Chapter 2, 'Step-by-Step Guide
-
Step 2: Analyze consolidation candidate databases and servers
Analyze each SQL Server and its user databases to determine their performance characteristics, resource requirements, dependencies and how to migrate them. Get help in this step excerpted from Chapter 2, 'Step-by-Step Guide
- 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
-
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
-
Coding for seamless SQL Server database mirroring
SQL Server database mirroring can provide high availability to your database. Expert Roman Rehak shares his favorite pieces of code for flawless mirroring. Tip
-
Configuring SSRS the easy way
Demystify the SQL Server Reporting Services (SSRS) configuration process. Get an overview of this tool and guidelines for how to set up each screen in SSRS from industry professional Roman Rehak. Tip
-
Manage, query SQL Azure Federations using T-SQL
Can SQL Azure help you manage “big data?” SQL Azure Federations enhances traditional partitioning, says Roger Jennings. Part 1 of this two-part series looks at using T-SQL to make federated tables. Tip
-
Is cloud-based business intelligence a safe bet?
Cloud-based business intelligence has its attractions, especially for SMBs having a hard time supporting any BI in-house. But don’t forget to ask some crucial questions. Tip
-
Five things in SQL Server not in SQL Azure
With the excitement over the cloud, it’s easy to forget that Microsoft’s cloud database, SQL Azure, is not for everyone. Learn the five major differences between SQL Azure and SQL Server. Tip
-
When up isn’t enough: Techniques for scaling SQL Server out
Scaling SQL Server out is not easy; that’s why most businesses choose to scale up their databases instead. But some applications give you no choice: You’ve got to look at options for scaling out. Tip
-
Three easy ways to improve SQL Server performance
A sluggish database does no one any good. Consultant Don Jones offers tips to improve SQL Server performance. 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
-
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
-
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
-
Coding for seamless SQL Server database mirroring
SQL Server database mirroring can provide high availability to your database. Expert Roman Rehak shares his favorite pieces of code for flawless mirroring. Tip
-
Configuring SSRS the easy way
Demystify the SQL Server Reporting Services (SSRS) configuration process. Get an overview of this tool and guidelines for how to set up each screen in SSRS from industry professional Roman Rehak. Tip
-
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
-
Manage, query SQL Azure Federations using T-SQL
Can SQL Azure help you manage “big data?” SQL Azure Federations enhances traditional partitioning, says Roger Jennings. Part 1 of this two-part series looks at using T-SQL to make federated tables. Tip
-
Is cloud-based business intelligence a safe bet?
Cloud-based business intelligence has its attractions, especially for SMBs having a hard time supporting any BI in-house. But don’t forget to ask some crucial questions. Tip
-
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
- 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.