2023-09-01
459 reads
MS SQL Server Agent
Create an HTML Report on the Status of SQL Server Agent Jobs
SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set of tasks and commands at specified intervals, ensuring the database is up-to-date and performing optimally. As a database administrator, it is essential to regularly monitor the status of SQL Server jobs. One way to do this is […]
2023-05-03
8,036 reads
MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases
This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
2022-02-22 (first published: 2022-01-25)
7,552 reads
Compare MS SQL Agent jobs on two servers
During a database migration or a side by side database upgrade project we need to migrate the MS SQL Server Agent jobs. This script compare jobs by names and shows unmatched jobs.
2018-01-25 (first published: 2018-01-20)
3,256 reads
Blogs
Focus on Core Skills
By Brian Kelley
Core skills depends on the position, but the point is that ensuring you have...
A New Word: Zverism
By Steve Jones
zverism – n. the wish that people could suspend their civility and indulge in...
SQL Server Source Control on a $0 Budget
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
Forums
Move Files SSIS Task
Hi I have a task in my SSIS package that moves files from source...
Migrating mission critical database from SQL on Prem to Azure SQL
We are migrating our environments to Azure, it will be a mix of SQL...
The Inefficiencies of Kubernetes
Comments posted to this topic are about the item The Inefficiencies of Kubernetes
Question of the Day
The Backup Space Needed
How do I calculate the amount of space needed for I/O buffers during a backup operation?
See possible answers