Search Results for “failover cluster”

  1. Home
  2. Search Results
Failover Clustered Instances

Training Week: Announcing Edwin’s New Class on Failover Clustered Instances

Clustering, Company News
2 Comments
This week, we’ve got a bunch of announcements about new training classes. Next up, Edwin Sarmiento: his 3-day Always On Availability Group class has been getting great reviews: “This class is fantastic. There is no filler, and no needless repetition, so be prepared to pay attention the entire duration. Edwin clearly is very passionate about…
Read More
Pocket Square

SQL Server Failover Clusters

Microsoft SQL Server Failover Clusters The options for high availability can get confusing, and we bet you’re having a hard time finding simple information on what a cluster does and the most common gotchas when planning a cluster. In these articles, we’ll explain what clusters are, what they’re good for, and why we like to…
Read More

An Introduction to SQL Server Clusters

Clustering
335 Comments
The options for high availability can get confusing. I was lucky enough to begin working with SQL Server clusters early in my career, but many people have a hard time finding simple information on what a cluster does and the most common gotchas when planning a cluster. Today, I’ll tell you what clusters are, what they’re…
Read More
Pocket Square

Cluster Node

Clustering helps you achieve higher availability by wiring up more than one server to the same set of shared drives.  If one server has a catastrophic problem like failures in Windows, the motherboard, the memory, the network cards, etc, then SQL Server will automatically restart on another server connected to the same storage. Clustering is…
Read More

Do You Have to License Your Standby SQL Server?

Licensing
23 Comments
Businesses who need high availability and disaster recovery usually want three servers: A primary SQL Server where all the writes & reads take place A high availability SQL Server sitting right next to the primary, in the same data center, keeping up with its writes, and A disaster recovery SQL Server sitting in another city…
Read More
Office Hours Podcast

[Video] Office Hours 2018/12/19 (With Transcriptions)

Videos
0
This week, Erik, Tara, and Richie discuss disaster recovery, Python vs C# for SQL Server, whether you should perform log backups on primary or secondary on AGs, why Postgres is so popular, using mount points for tempdb, attention events, database corruption, MERGE statements, restoring a table from a database, features they look forward to in…
Read More
Office Hours Podcast

[Video] Office Hours 2018/11/14 (With Transcriptions)

Videos
0
This week, Tara, Erik, and Richie discuss using Docker in dev environment, in-place upgrades, disaster recovery, the minimum amount of CPU and RAM for new SQL Server VMs, troubleshooting long-running SQL agent jobs, dbcc checkdb running longer than normal, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe…
Read More
Office Hours Podcast

[Video] Office Hours 2018/10/3 (With Transcriptions)

Videos
1 Comment
This week, Tara and Richie discuss database corruption, CLR, DBCC issues, adding identity columns to databases, distributed transactions, tracking how recently a procedure was executed, maintenance plans, recompiling stored procs, parameter sniffing issues, troubleshooting replication with Always On, forecasting database growth and estimating capacity issues, tools for database growth forecast reports, RCSI, and much more.…
Read More
Menu