Power BI Custom Visuals Class (Module 15 – Table Heatmap)

In this module you will learn how to use the Table Heatmap Power BI Custom Visual.  The Table Heatmap has...

SQLChat on Wednesday, Webinar on Thursday!

I’m participating in two community activities this week. One is a #SQLCchat on Twitter and the other is a webinar...

Speaking at IT/Dev Connections in October

I’m proud to be speaking at this year’s IT/Dev Connections conference in Las Vegas during the week of October 10th!...

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...