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: 2018-11-12)
3,301 reads
2018-03-26
737 reads
2017-06-26
832 reads
Server principal 'xx\yy' has granted one or more permission(s). Revoke the permission(s) before dropping the server principal. (Microsoft SQL Server, Error: 15173). If you are gett
2019-05-03 (first published: 2016-09-16)
2,125 reads
SQL Server Database Mirroring offers two methods for exchanging data: synchronously and asynchronously. Sometimes there may be a need to switch between modes for an existing mirror and in this tip we will look at how this can be done.
2015-08-03
3,376 reads
2015-07-15
1,384 reads
In this article, I describe some steps a DBA can take to check for mirroring on SQL Server, give a status of the mirroring state and some options for resolving any problems with the transaction log that might be caused by Database Mirroring.
2014-11-06
8,498 reads
2013-12-13
1,756 reads
2013-11-12
1,798 reads
2013-03-27
1,943 reads
Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...
By DataOnWheels
Making multilingual reports in Power BI requires a lot of different elements. Translations can...
By Steve Jones
Today’s coping tip is to make a meal using a recipe or ingredient you’ve...
I have 2 tables . tblStudentMarksOriginal - StudID, Subject, Marks 101, english, 91 101,...
I am using sql server 2017. I am trying to use the in operator,...
Comments posted to this topic are about the item Basic Checks on a New...
Ask SSC