The Mangled Outer Join

Making a Matrix

How Serverless is Working in Azure SQL Database

When Azure SQL Database introduced the serverless option, I decided to try it. I moved one of my databases to the tier, though I had to move to a...

Product Platform Teams

Today Steve notes that DevOps isn't going to eliminate Ops, even if developers support their own applications.

T-SQL Tuesday Gifts (#121)

It’s that time of month. I missed last month while traveling, but I wanted to get back in the party. This month, Mala has invited us to talk about...

What's a page split?

Data for Defense

The Microsoft Threat Intelligence Center actively works to track the world's hackers and help warn us when we become the object of their attacks.

Upgrading Windows 10 Home to Pro

I use Hyper-V and a few other things that require Windows 10 Pro. When I got my new laptop, it had Windows 10 home on it. Not a big...

Using All Your Tools

Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.

Cleaning up the [NOT] NULL for Columns with SQL Prompt 10

SQL Prompt 10 is out and there are a few interesting things that have changed in the product. One of these is the Quick Fixes, inspired by some other...