Everyone wants a highly available system, but achieving 4 or 5 9s of uptime is hard to do. Especially when you have cost limitations. New author Mark Cook takes a look at how his company analyzed the challenges and which method they chose along with some implementation details.
2006-05-25
5,299 reads
Not the traditional overview here. Steve Jones takes a look at the various high availability technologies from a different perspective.
2006-05-24
17,992 reads
Disaster recovery solutions is always a concern with SQL Server and when a new or unique solution comes up, we like to get it out there. New author Kevin Parks brings us a look at his way of using a USB hard drive and Windows PE to ensure recovery.
2006-05-18
8,736 reads
Ensuring the availability of your database servers is becoming more important all the time. Fortunately you have more choices than ever. Bilal Ahmed looks at some of the possible solutions available for SQL Server.
2006-04-26
5,435 reads
Testing is key to ensuring a process actually works when it comes time to implement, rather than finding out when time may be of the essence. This holds true for testing SQL Server restores as well.
2006-04-24
2,625 reads
Building a highly fault tolerant and available SQL Server is expensive and difficult. This brings about unique challenges for small businesses who often lack the resources of large enterprises. Bilal Ahmed and Shivan Bindal discuss the various ways of building redundancy and the challenges of each.
2006-02-21
5,988 reads
Building a highly available system is hard. This short white paper from Sonasoft shows some of the differences between a cluster and their standby server product.
2005-10-28
10,572 reads
The second installment of this series discussed the cost of maintaining systems with various levels of downtime, ways data can be lost, and what constitutes a backup. In this installment, I discuss how to configure your hardware to minimize the need to restore a backup.
2005-09-29
2,398 reads
2005-09-16
2,192 reads
2005-09-06
2,093 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Think there's a reason why this is still in preview, but have someone manage...
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
This is a generic question. To the moderators, I wasn't sure where to place...
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers