SQL 2008 R2 Cluster Setup: Easy? Not So Much.
The SQL Server 2008 R2 setup program crashes sometimes leaving you with a "half installed" instance: this is about how I repaired the setup on a populated cluster.
2011-11-29
4,520 reads
Clustering
Tips for Upgrading a Cluster to SQL 2008 - Part 1
This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008
2011-11-14
3,036 reads
Automatic Alert Generation in the event of SQL Server Cluster Failover
We had a requirement where we were asked to generate automatic email notification in the event of a failover.
2011-10-06
4,698 reads
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 3
This article continues the series on how to create a 2 node Windows\SQL Server 2008 cluster with a look at slipstreaming the service pack and cumulative updates needed.
2011-08-12
5,686 reads
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2
Learn how to create a Windows\SQL Server 2008 virtual cluster. In this article learn about the Windows clustering setup.
2013-12-24 (first published: 2011-07-12)
9,682 reads
Getting the most out of your SQL Server 2008 Cluster
Gain an insight into how to use your SQL Server cluster for more than just high availibility in this article from Mark Jones.
2011-05-26
3,922 reads
2011-03-15
2,318 reads
Creating A SQL Server 2008\2008 R2 Failover Cluster
Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance
2013-12-23 (first published: 2011-01-19)
18,562 reads
Uninstalling a SQL Server Clustered Instance
I have installed and uninstalled several instances of SQL Server in the past. Today, I need to uninstall a SQL Server 2008 R2 clustered instance. I have never uninstalled a clustered instance of SQL Server before. Can you provide a how-to guide to uninstall a clustered instance of SQL Server 2008 R2?
2010-12-06
3,572 reads
How to Evict a Failed Node and Add it Back to SQL Server 2005 Cluster
Adding and removing nodes in SQL Server Clusters is not so difficult, and instructions on how to do so abound on the internet. However, mismanagement when adding/removing nodes can quickly become a 'gotcha' that wastes time. Bo Chen offers insight into some of those scenarios that are not normally covered in the standard online documents.
2010-04-26
2,048 reads
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
BCA KCU PANAKKUKANG Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi...
BCA KCU MAKASSAR Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...
BCA KCU AMBON Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers