Logshipping Report
Get Logshipping report only when secondary is more than certain time behind Primary.
2017-11-14 (first published: 2017-10-27)
493 reads
Scripts
Delete Change Tracking table data sys.syscommittab
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)
925 reads
SQL Server procedure to script tables
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,042 reads
2017-10-05 (first published: 2017-10-02)
16,741 reads
SQL Agent jobs that run SSIS packages
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,099 reads
Add new Databases to a AG Setup with PowerShell
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,010 reads
CDC watchdog for databases in AlwaysOn AG
Stored procedure to ensure CDC job will be started once failover happen.
2017-08-25 (first published: 2017-08-22)
830 reads
SQL Server Agent Jobs Statistics
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,196 reads
Script DB Level Permissions v4.3
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
15,609 reads
2017-07-24 (first published: 2017-07-12)
644 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
SQL Server Automated Backup & SAN Replication Solution
Comments posted to this topic are about the item SQL Server Automated Backup &...
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers