Kenneth Urena shows how to use Stretch Database, the SQL Server 2016 feature that moves cold table data to Azure while your queries keep working.
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.
SQL SERVER – Data Lineage Tracking in ETL Processes – Notes from the Field #124
Tim Mitchell answers the question every ETL developer hears, ‘Where did this data come from?’, and shows how to add data lineage tracking to ETL processes.
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.