Kenneth Urena shows how to use Stretch Database, the SQL Server 2016 feature that moves cold table data to Azure while hot data stays on premises. Microsoft has since discontinued it.
SQL SERVER – Why DBAs Need to Know about Kerberos – Notes from the Field #126
Not everyone knows about Kerberos. Many think it is a two headed dog from mythology, well that is true but when we talk about database,
SQL SERVER – Handling XML Documents – Notes from the Field #125
Stuart Ainsworth shares a client case of importing XML documents into a staging table and what he learned about using XQuery methods in SQL Server.
Data Lineage Tracking in ETL Processes: Notes from the Field #124
Data lineage tracking in ETL processes answers one question: where did this value come from? Tim Mitchell’s Notes from the Field lesson is kept, and a tested SQL Server example now traces a total back to its source rows, forward from one sale, and across two load runs.
SQL SERVER – Optimizing Tabular Models for Self-Service Reporting: Summarize By – Notes from the Field #123
Bill Anton explains how the Summarize By property helps you optimize Tabular Models for self-service reporting, where users build their own reports.
Hey DBAs – What Are You Assuming/Missing Today? – Notes from the Field #122
Hey DBAs, what are you assuming or missing today? Mike Walsh on why a good DBA watches every instance and is not afraid to say I do not know.
SQL SERVER 2016 – Enhancements with AlwaysOn Availability Groups – Notes from the Field #121
In Notes from the Field #121, Mike Lawell covers the SQL Server 2016 enhancements to AlwaysOn Availability Groups and why this feature keeps getting better.