[Notes from Pinal]: Performance tuning is a complex subject, SQL SERVER – DMVs to Detect Performance Problems in SQL Server.
SQL SERVER – Becoming a More Effective DAX Developer with DAX Studio – Notes from the Field #134
Bill Anton walks through DAX Studio, the tool that makes writing, testing and tuning DAX easier for Power BI, Power Pivot and Tabular developers.
Free DBA Tools for SQL Server Professionals – Notes from the Field #133
Mike Walsh talks about free DBA tools for SQL Server professionals: the ones he likes and why free does not automatically mean good.
SQL SERVER 2016 – Encrypt Your PII Data – Notes from the Field #132
Mike Lawell found a client storing personal information in clear text. He explains how SQL Server 2016 encryption options can protect your PII data.
SQL SERVER 2016 – Getting Started with R Services and Forecasting – Notes from the Field #131
Eduardo Castro explains how to get started with R Services in SQL Server 2016 and use R to build a forecast from data in your database.
How to Use Zip With SSIS? – Notes from the Field #130
SSIS has everything for moving files except zipping them. Kevin Hazzard shows how to zip data files inside an SSIS package before sending them over FTP.
Pester the Tester: PowerShell Bugs, Beware! – Notes from the Field #129
Pester the Tester: Robert Cain shows how Pester, an open source testing framework for PowerShell, helps you catch bugs before they catch you.