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: )

612 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: )

809 reads

sp_what

Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.

*Dont you just love totally non subjective assessments like this?

4 (5)

2018-11-01 (first published: )

1,349 reads

Blogs

Batch Scripting SQLCMD–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

SQLpassion Online Training about Intelligent Query Processing

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

What the ???? T-SQL Tuesday #120

By

Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

Read the latest Blogs

Forums

Query to check when the AG is created

By ramyours2003

I need to find when the availabilty is created  in always on is any...

SSRS architecture choices

By phual

Hello everyone We've got a SQL Server 2017 install setup on a failover cluster....

Replication and Log shipping

By bornmanh

I have the following scenario. Server A has transactional replication setup to a subscriber...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers