A copied job should log its own name, not the old one. Agent tokens do that, if you escape them the right way.
SQL Puzzle – A Quick Fun with Bit Wise Operator – Part 2
Part 2 of my quick fun with Bit Wise Operator puzzle uses OR. Why does SELECT 1 | 100 return 101? Leave your answer in the comments.
SQL Puzzle – A Quick Fun with Bit Wise Operator
A quick Friday SQL puzzle on the Bit Wise Operator: SELECT 10 & 10 returns 10, so why do 10 & 0 and 1 & 100 both return zero?
SQL SERVER – Learning SSIS – Where Do I Start? – Notes from the Field #014
Where do you start when learning SSIS? I asked SSIS expert Andy Leonard, and he shares how a novice developer can learn it from the beginning.
SQL SERVER – Retrieve All the Data from VARCHAR(MAX) Column
SSMS will not display all the text in a long VARCHAR(MAX) column. Here is how I retrieve all of it by exporting the data to a text file.
Backing Up MySQL, Explained for SQL Server DBAs
Backing up MySQL means choosing logical or physical copies and retaining binary logs for point-in-time recovery, then testing restores.
9 Things You Should be Doing with Your Backups – Backup Tips – SQL Server Backup Tips
Nine SQL Server Backup tips every DBA should follow, starting with the simplest one: never keep backups on the same physical drive as the database files.