Tail log backup confuses many people, even with the new hints on the restore screen. Learn how to back up and recover the tail end of a transaction log.
SQL SERVER – Finding Out What Changed in a Deleted Database – Notes from the Field #041
What changed in a database that no longer exists? Brian Kelley shares a real story on finding out what changed in a deleted database.
SQL SERVER – SSIS Parameters in Parent-Child ETL Architectures – Notes from the Field #040
Tim Mitchell reviews how to use SSIS parameters in Parent-Child ETL architectures, a very common design pattern in SQL Server ETL work.
Developer’s Life – Disaster Lessons – Notes from the Field #039
Mike Walsh shares disaster lessons from his own life, a non-technical post about what to do when disaster hits you as a person, not your servers.
SQL SERVER – Andy Defines Basic RDBMS: Isolation in Processes – Notes from the Field #038
Andy explains isolation in processes, a basic RDBMS idea, with fresh eggs from his family’s chickens. A fun way to learn the fundamentals.
SQL SERVER – Beginning Contained Databases – Notes from the Field #037
Beginning contained databases: syncing users and logins is a pain with database mirroring. John Sterrett explains how a contained user needs no login.
SQL SERVER – What is Biml and How Can it Help Me with SQL Server BI? – Notes from the Field #036
What is Biml, and how can it help with SQL Server BI? Reeves Smith explains Business Intelligence Markup Language and how it adds automation to BI work.