Technical Article

Mirroring Job Switcher

I wrote this so that jobs associated with a mirrored database will run on the principal and not on the mirror.  Please send your comments on what implications I might be missing - I would appreciate that greatly.This procedure works in conjunction with a WMI alert you will setup in SQLSEVERAGENT -> Alerts ->Mirroring Status […]

You rated this post out of 5. Change rating

2007-09-04 (first published: )

465 reads

Blogs

How to Learn SQL Without Quitting Your Day Job

By

Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...

SQL Server 2025

By

Microsoft announced on November 2024 a preview for SQL Server 2025 another major release...

Advice I Like: Apologies

By

How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...

Read the latest Blogs

Forums

Influencing a Local AI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Influencing a Local AI

Data API Builder Operations

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data API Builder Operations

SQL Clustered Resource in online pending for about 3-5 mins before coming online

By PJ_SQL

Hello! SQL Clustered resource used to come online during manual or automatic failover in...

Visit the forum

Question of the Day

Data API Builder Operations

What types of database operations does the Data API Builder support?

See possible answers