Logshipping Report
Get Logshipping report only when secondary is more than certain time behind Primary.
2017-11-14 (first published: 2017-10-27)
575 reads
Get Logshipping report only when secondary is more than certain time behind Primary.
2017-11-14 (first published: 2017-10-27)
575 reads
With high transactions table the sys.syscommittab table does not gets deleted properly. Millions of backdated row remains. To delete the sys.syscommittab table below is the script.
2017-11-13 (first published: 2017-10-27)
941 reads
SQL Server procedure to script all tables in a given database to one or individual files on a given path.
2017-10-09 (first published: 2017-10-04)
3,087 reads
2017-10-05 (first published: 2017-10-02)
16,802 reads
Lists the job names and package names for jobs that execute SSIS packages (for packages stored in msdb).
2017-09-13 (first published: 2017-09-05)
2,123 reads
Some short & sweet PS code to add databases on AG Node 1 to AG Node2 and snap them in.
2017-09-12 (first published: 2017-09-07)
1,040 reads
Stored procedure to ensure CDC job will be started once failover happen.
2017-08-25 (first published: 2017-08-22)
882 reads
This script will give you a thorough report about sql server jobs based on historical data.
2017-07-26 (first published: 2013-09-25)
2,208 reads
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
15,704 reads
2017-07-24 (first published: 2017-07-12)
658 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers