Scripts

Automatically Failover (Enable or Disable) Jobs Based on HADR Role

If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.

2018-11-14 (first published: )

438 reads

Disk Space Check

I was using this script to check disk space on individual servers for quite some time. And now since I started to use registered servers for MS SQL, I thought of a little modification to the script.

4 (3)

2018-11-09 (first published: )

626 reads

Blogs

SQL Server Containers Are Boring

By

Not really, but sort of. The beauty of containers, at least in a dev/test...

Public Role Permissions – Back to Basics

By

If you are being serious in your role, then the amount of times you...

It’s interesting how an OR short circuits.

By

I recently did a post on the case expression short circuting and received a...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Notification of zero records in a table

By Budd

There is a JAVA app that clears and reloads a staging table, but occasionally...

Always on AG and SQL Upgrade

By Admingod

Looking to upgrade from SQL Server 2014 to SQL 2016 which has always on...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers