Tools for proactive DBAs: after many AlwaysOn Availability Group projects, John Sterrett hears the same two questions and answers both in this Notes from the Field episode.
SQL SERVER – Finding Last Backup Time for All Database – Last Full, Differential and Log Backup – Optimized
An optimized script from SQL expert TheSQLGuru that shows the last backup time for all databases, covering the last full, differential and log backup.
Moving SSRS Reports to a New Server
Moving SSRS reports to a new server requires the ReportServer databases, encryption key, data source checks, and subscription rehearsal.
SQL SERVER – Finding Jobs Shrinking Database Files – Notes from the Field #023
Many shops have had jobs shrinking database files for years. Tim shares a simple script to find those jobs so you can deal with them.
SQL SERVER – Last Full Differential and Log Backup Finish Times
I check backup time separately for full, differential and log backups. One latest timestamp cannot describe the entire recovery chain.
SQL SERVER – SSIS Data Flow Troubleshooting – Part1 – Notes from the Field #019
SSIS data flow problems look simple but are hard to fix. In part 1, Andy Leonard explains how to troubleshoot the SSIS Data Flow Task.
Storing Images in varbinary(max): Size, Reads and Backups
Store images in varbinary(max), read file bytes with OPENROWSET, inspect LOB allocation, and evaluate backup and retrieval costs.