2019-05-03 (first published: 2015-05-15)
1,607 reads
SQl Hunt
- Interests: Like to make friendship with people.
Copy Backup Files to Remote Shared Location and Delete them periodically
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,072 reads
Create EndPoint
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)
3,099 reads
2019-05-03 (first published: 2015-05-05)
2,331 reads
Delete Backup Files From Default Backup Location
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)
658 reads
Delete Backups Older than N Days
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,591 reads
Delete SQL Instance name from default backup location
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)
724 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
2019-05-03 (first published: 2015-06-03)
1,650 reads
Enable Email Notification to all SQL Jobs
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,053 reads
Execute All .SQL Script easily
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,523 reads
Blogs
Advice I Like: Art
By Steve Jones
Superheroes and saints never make art. Only imperfect beings can make art because art...
Why Optimize CPU for RDS SQL Server is a game changer
One feature that I have been waiting for years! The new announcement around optimize...
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
Forums
The AI Bubble and the Weak Foundation Beam
Comments posted to this topic are about the item The AI Bubble and the...
data type gets lost in data flow
Hi, in a simple oledb source->derived column->oledb destination data flow, 2 of my...
i noticed the sqlhealth extende event is on by default , so can i reduce
hi, i noticed the sqlhealth extended event is on by default , and it...
Question of the Day
The Read Committed Snapshot Isolation behaviour
I am currently working with Sql Server 2022 and AdventureWorks database. First of all, let's set the "Read Committed Snapshot" to ON:
use master; go alter database AdventureWorks set read_committed_snapshot on with no_wait; goThen, from Session 1, I execute the following code:
--Session 1 use AdventureWorks; go create table ##t1 (id int, f1 varchar(10)); go insert into ##t1 values (1, 'A');From another session, called Session 2, I open a transaction and execute the following update:
--Session 2 use AdventureWorks; go begin tran; update ##t1 set f1 = 'B' where id = 1;Now, going back to Session 1, what happens if I execute this statement?
--Session 1 select f1 from ##t1 where id = 1;See possible answers