A job failed but you cannot find the SQL Agent Job History? John Sterrett explains this common problem he sees in the field and what to do about it.
Running SQL Server on an Azure Virtual Machine
SQL Server on an Azure virtual machine keeps instance control while moving storage and hosting to Azure; learn disk, backup, and sizing checks.
SQL SERVER – Finding the Last Backup for All Databases – Notes from the Field #016
When did you take your last database backup? Tim Radney shares a simple script that shows the last backup for all databases on a server.
SQL SERVER – Expanding Your Skills – Notes from the Field #015
Busy day job but want to grow your career? Brian Kelley shares his advice on expanding your skills and keeping up with new technology.
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 – 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.
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.