In this show, we share some client stories from recent projects:

One nice thing of being a consultant Another consolidation project with a client implemented with views Performance recommendations from a client project Trivial optimization vs.Simple Parameterization Some challenges when working with MySQL

In this show:

* The challenges of consolidation projects * What is the Remote Query Harden error with Availability Groups * PASS Summit precons * Describe your profession in one sentence * What if Clippy came to SSMS? * The right ways to manage open transactions

In this show, we talk about:

• Our sessions at the GroupBy conference
• Another difference between the old and new Cardinality Estimators
• Lightweight Profiling in SQL Server 2016 SP1
• Sign Matan's wife is married to a DBA
• SSDT 2017
• A cool SSMS shortcut