A hex string is just a printed hash, and it costs twice the space. Here is the round trip, the index sizes and the traps.
Page Restore: Fixing a Few Corrupt Pages Without a Full Restore
Rehearse page restore on a test database, identify damaged page IDs, apply the backup chain, and verify storage and database consistency.
SQL SERVER – Migration of SQL Server 2012 Database Mirroring to AlwaysOn Availability Group
Migration of SQL Server 2012 database mirroring to AlwaysOn Availability Group can be tricky. Here is the setup and the migration process, step by step.
Agent Tokens in Job Steps: Job Name, Step and Start Time
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.










