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.

tak-30092

2018-11-14 (first published: 2018-11-12)

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

Rinu George Philip

2018-11-09 (first published: 2018-10-24)

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

Nicholas Williams

2018-11-01 (first published: 2018-10-22)

901 reads

Blogs

Drop Database Objects Practically Risk-Free!

By administrator

FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to...

Lengthen a Primary Key–#SQLNewBlogger

By Steve Jones

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

Setup SQL Server Alert to get automatically notified of database blockings

By SQLPals

Suppose you want to or need to know anytime your SQL Server is experiencing...

Read the latest Blogs

Forums

Protecting Data Between Services

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Protecting Data Between Services

User Mapping Issues

By DHeath

I have a server that is version 12.0.6214.1 and here is my issue. I...

SQL browser and port number

By John Deupree

We have several new servers running SQL 2014.  Some servers are single instance servers...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers