Can writing an XML-based language like BIML really help you? Reeves Smith explains the why of BIML and why it is worth learning for BI work.
Extended Security Updates Explained
Extended Security Updates give eligible older SQL Server releases limited critical security coverage while you complete a migration.
SQL SERVER – Tuning Queries is Sometimes Waste of Time – Notes from the Field #049
Brian Moran explains why tuning queries is sometimes a waste of time when you are trying to fix performance and scalability problems in SQL Server.
SQL SERVER – Building Technical Reference Library – Notes from the Field #048
Brian Kelley explains how to build a technical reference library: your own notes, code, settings and bugs you have hit, so help is always close at hand.
SQL SERVER – A Practical Use of Backup Encryption
A backup in the wrong hands is a data leak waiting to happen. Here is a practical example of Backup Encryption in SQL Server 2014 to keep your backups safe.
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.
Finding Databases Owned by Personal Logins and Fixing Them
Find databases owned by personal logins, review an approved replacement owner, and test dbo mapping and execution-context effects.