Database Fundamentals #16: Removing Data With T-SQL

Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.

How it Works
In the same way...

Updated YouTube Channel

Hello all,
I’ve recently updated my YouTube channel. I’m going to be posting a lot more videos up there. If you...

Getting Started in a SQL Server 2017 VM in Azure

You say you’re ready to dip your toes in the Azure ocean? Come on in, the water’s fine!
Oh, you want...

Statistics Use, Extended Events and Execution Plans

Query tuning ain’t easy.
Figuring out which index is getting used is one step, and generally simple, look at the execution...

Snow, Heathrow Airport, Disaster Recovery

I recently flew from Boston to the UK through the Heathrow airport. It just happened to be on the day...

SQL Server Automatic Tuning and sys.dm_db_tuning_recommendations

In Azure SQL Database for quite some time and now available in SQL Server 2017, Microsoft has put a lot...

Query Store Wait Statistics with sys.query_store_wait_stats

The second best thing to questions that people ask is when I sit down to write a book. It’s so...

Execution Plan Metrics and Units of Measure

Have you ever looked at the properties inside an execution plan and wondered what the units of measure were? I...

SQL in the City 2017

Redgate is once again hosting a live, virtual event for SQL in the City. We’re going to give you a...

Why I Use AdventureWorks for Demos

I know that when some people see AdventureWorks, their vision turns all red around the edges, their blood pressure spikes...