SQL PASS Summit 2017: Day 1 Keynote Thoughts and Memories

Whee! It’s the first day of the main SQL PASS Summit conference and I made it to the keynote early for the first time ever. The hype says we’re going...

The Death of SQL Server Service Packs

SQL Server Service Packs are going away, starting with SQL Server 2017. I talk about why I think this is a good thing, and discuss Cumulative Updates, Service Packs,...

Love and Hate for SSMS

People have strong feelings about SQL Server Management Studio: they love it AND they hate it. In this week’s episode, I talk about why people have such conflicting feelings...

How Do I Analyze a SQL Server Execution Plan?

A query is slow, and you figure out how to collect the query execution plan. Now what? In this video, I talk “big picture” about what execution plans are,...

Do I Need to Master PowerShell?

As a SQL Server DBA, do you need to be a master of PowerShell scripts? In this 9 minute episode, I talk about how much you need to know...

How Can the SQL Server Resource Governor Help You?

MANAGING ‘NOISY NEIGHBORS’ IN SQL SERVER If you’ve been managing databases for any length of time, you’ve probably had to contend with the “noisy neighbors” scenario. In this scenario,...

Speaking on Consolidated Essential Performance Health Check using PowerShell - SQLSaturday (Portland)

Speaking on Consolidated Essential Performance Health Check using PowerShell - SQLSaturday (Sacramento)

Speaking on Consolidated Essential Performance Health Check using PowerShell - SQL User Group

AlwaysOn Availability Groups Synchronous Replica Readable Secondary Data Access Latency

With SQL Server AlwaysOn Availability Groups, when you configure a secondary in synchronous-commit mode for read-only access, there can be data access latency. If you make changes to your...