2019-05-03 (first published: 2015-05-15)
1,578 reads
2019-05-03 (first published: 2015-05-15)
1,578 reads
If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.
2019-05-03 (first published: 2015-06-01)
2,017 reads
Server principal 'xx\yy' has granted one or more permission(s). Revoke the permission(s) before dropping the server principal. (Microsoft SQL Server, Error: 15173). If you are gett
2019-05-03 (first published: 2016-09-16)
2,701 reads
2019-05-03 (first published: 2015-05-05)
2,158 reads
IF you have need to schedule job to cleanup backup files older than N days, you can use my written script.
2019-05-03 (first published: 2015-06-04)
629 reads
SCRIPT TO DELETE OLDER THAN N' DAYS BACKUP FROM A DEFAULT BACKUP DIRECTORY. IF DAYS = 0, PROVIDED,
IT WILL DELETE ALL BACKUP FILES FROM THE BACKUP LOCATION.
2019-05-03 (first published: 2015-03-16)
5,309 reads
IF you want to delete the SQL Instance folder of your SQL Named instance after uninstall of your SQL Server Instance, then the script will help you. Note: I did an extra step by using / taking data (INSTALLSHAREDDIR) from your .INI file.
2019-05-03 (first published: 2015-03-23)
703 reads
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2019-05-03 (first published: 2015-06-03)
1,601 reads
If you have a requirement to enable email notification to all the SQL Jobs, then you may use my script.
2019-05-03 (first published: 2016-09-20)
1,002 reads
If you have a requirement to create Proc/Tables, etc to a SQL Server taking .SQL scripts from a central location (UNC), then you can use my script.
2019-05-03 (first published: 2015-05-18)
2,478 reads
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers