Find unused jobs
Job list cluttered?
This script will return a list of jobs that either have not run in X months or where the next schedule run date is older than today.
2013-07-24 (first published: 2013-06-25)
1,262 reads
Changing database mail account SMTP servers
This will generate a script that drops and recreates existing db mail accounts and change the smpt server.
2013-07-08 (first published: 2013-06-19)
807 reads
Report Server Report Usage
Get information about how often, how fast your reports run and how big they are.
2012-12-12 (first published: 2012-11-27)
1,607 reads
Blogs
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Summer Speaking Summary 2025
By alevyinroc
In the blink of an eye, summer has passed. I don’t know about you,...
From Chaos to Clarity: How Microsoft Purview Streamlines Data Governance
By Chris Yates
In today’s digital landscape, data is both a strategic asset and a potential liability....
Forums
Change Tracking Data Retention Options
Comments posted to this topic are about the item Change Tracking Data Retention Options
Requiring Technical Debt Payments
Comments posted to this topic are about the item Requiring Technical Debt Payments
Using the FP-Growth Algorithm to Mine Useful Patterns in Data
Comments posted to this topic are about the item Using the FP-Growth Algorithm to...
Question of the Day
Change Tracking Data Retention Options
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers