Taking Backup Of All DBs
Wrote the script to take compressed backup with combining many other features.
2019-05-03 (first published: 2015-04-29)
1,032 reads
SQl Hunt
- Interests: Like to make friendship with people.
Taking backup of the databases to the Active server alone
If you have Always On and need to stop running database backups to the stand by server, use the script.
2019-05-03 (first published: 2016-11-01)
270 reads
2019-05-03 (first published: 2015-03-30)
3,890 reads
Verify Login SID and Machine SID
This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.
2019-05-03 (first published: 2014-12-24)
1,626 reads
Disk Free Space Check
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2015-06-03
330 reads
Blogs
Updating SSMS is Easy (w/ v21)
By Steve Jones
I’ve been using the SSMS preview for v21. This is the next evolution of...
Execute Fabric Data Pipeline from Azure Data Factory
In the blog post Call a Fabric REST API from Azure Data Factory I...
Master SQL Server Query Tuning in Just Two Days! Online Live Training – June 17 – 18, 2025
I’m excited to announce that on June 17 – 18, 2025, I’ll be running...
Forums
importing from PowerQuery... but with multiple powerqueries
I finally got the PowerQuery source to "show" in SSIS (so I can see...
Third party backup softwares
Hi Team, Can you someone suggest a few good third part backup tools, with...
2022 SSIS PackageFormatVersion?
Recently I upgraded my ssis package from 2016 to 2022, but package format version...
Question of the Day
The Monitor Server
What does the monitor server do in log shipping?
See possible answers