Technical Article

Job Run Duration

This script gives you an idea on how long the processing time is for your SQL jobs. It will depend on how many records are being retained on the sysjobhistory table (scripts defaults to the last 30 days--may not find any history at all).One may find it useful when there are so many sql jobs […]

4.9 (10)

You rated this post out of 5. Change rating

2003-02-06

5,689 reads

Blogs

Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger

By

I wrote a post recently about pruning branches in git. That’s part of the...

Microsoft Fabric shortcuts

By

I talked about Microsoft Fabric shortcuts in my blog post Microsoft Fabric – the...

Develop and Test Your Rollback Plan

By

he rollback plan... what to do when things go wrong to get back to...

Read the latest Blogs

Forums

Blocking question

By SQL Guy 1

Hi all, We have a SSIS package that does 2 things in parallel: moves...

can I monitor auto stats updates through extended events?

By Eric Mamet

We have pretty big tables very sensitive to stats with many updates. Our systems...

SSIS upgrade

By Sailor

I have about 40 packages that are dtsx files that were created with SQL...

Visit the forum

Question of the Day

Post Restore Tasks for the Resource Database

I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?

See possible answers