Query Store, Force Plan and “Better” Plans

I am endlessly fascinated by how the Query Store works. I love teaching it at every opportunity too. Plus, almost...

24 Hours of PASS Summit 2016 Preview Edition this Wednesday

I’m very excited to be presenting in the opening slot for this year’s 24 Hours of PASS – Summit Preview Edition...

Archiving Azure SQL Database to a BACPAC

UPDATE: The other half of this scenario has been posted. Check out Importing a BACPAC to SQL Server.
Azure SQL...

Accidental DBAs, the Developer Edition

I recently spoke at the OKC SQL Saturday. I had an wonderful time and the organizers, volunteers and other speakers...

Sql Server – Listing all tables Metadata (Table Size, row count, Index Size)

Sql Server – Listing all
tables Metadata (Table Size, row count, Index Size)

Suppose you need to find out Table size, row
count , index...

Team Purple

This is Down Tools Week at Redgate Software, and I’m visiting the office. I had hoped to dive into a...

Sql Server - Top Slowest Queries or Resource Extensive Queries

Top
Slowest Queries or Resource Extensive Queries

Whenever your database is facing any performance issue or resource scarcity,
the first step should be...

SQL Server 2016 - Are you ready for upgrade?

SQL Server 2016 has been officially launched for a little more then three month, many people are feeling excited to...

The Non-Replicated Backup Mystery

I recently configured a backup job to run on the principal server of a mirrored pair. The idea was to backup...

October precon in Orlando: “The Lifecycle Approach: Maintenance Problems & Solutions”

On October 7 we will be presenting a full day of maintenance and backup learnin’! Register here: https://www.eventbrite.com/e/sql-saturday-564-the-lifecycle-approach-maintenance-problems-solutions-tickets-26867268724 And while you’re at...