Anthony Bressi


SQLServerCentral Article

Scheduled MS Cluster Failovers using Automation Server Objects

SQL Server clusters are great tools to ensure that your servers are highly available. However there are some times when you'll want to manually perform a failover for testing, maintenance, etc. New author Anthony Bressi brings you a technique and code to allow you to use VB 6.0 to build a small program to automatically do this.

5 (1)

You rated this post out of 5. Change rating

2004-12-06

4,876 reads

Blogs

Getting Started with the MSSQL AI Agent in VS Code

By

Recently I was working in VS Code and I saw a walkthrough for the...

From Chaos to Clarity: How Microsoft Purview Streamlines Data Governance

By

In today’s digital landscape, data is both a strategic asset and a potential liability....

Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework

By

I’m excited to announce the release of a new open-source project that fully automates...

Read the latest Blogs

Forums

Change Tracking Data Retention Options

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Change Tracking Data Retention Options

Requiring Technical Debt Payments

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Requiring Technical Debt Payments

Using the FP-Growth Algorithm to Mine Useful Patterns in Data

By Daniel Calbimonte

Comments posted to this topic are about the item Using the FP-Growth Algorithm to...

Visit the forum

Question of the Day

Change Tracking Data Retention Options

If I am running this code:

ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);
What are the possible choices for xxx?

See possible answers