This script was written to solve a problem where we needed to dynamically create bch files for Veritas Backups direct to tape backups. We needed to parse the sysdatabases daily and create the bch files that veritas would use to backup each server and database. This SQL Script uses xp_cmdshell to call a windows shell […]
2007-10-02 (first published: 2007-06-18)
440 reads
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
By Steve Jones
In order to generate migrations, we need to configure Flyway to use a shadow...
By Steve Jones
Today’s coping tip is to get back in contact with an old friend. This...
I would like to know what certifications or paths to choose in order to...
Hi all, I created Extended Events session to capture sql_batch_completed for duration>5 sec sending...
Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_DATE) AS 'Date', DD.STORE_CODE...
Ask SSC