Checking the Servicves

Deploying Indexes with SQL Compare

I suspect many people assume this is the case, but a customer recently asked if SQL Compare handles indexes. It does, and this post shows the basics of index...

T-SQL Tuesday #168–Using Window Functions

I am the host for T-SQL Tuesday this month, and I hope that a lot of people like the topic. This idea actually came to me earlier this year...

Data Community Summit Week

I’m up in Seattle this week for the PASS Data Community Summit 2023. This is almost an annual event for me. I’ve missed a few since 1999, but not...

Gigging for a Career

The idea of working on just projects is tailor made for a data professional. Or is it?

High Deadlock Priority

No Degree Needed

Steve doesn't think you need a degree to work in technology and more companies agree with this all the time.

30 Years of SQL Server on Windows

Steve looks back at a 30+ year career of working with SQL Server.

A New Word: Heartspur

heartspur – n.  an unexpected surge of emotion in response to a seemingly innocuous trigger – the distinctive squeal of a rusty fence, a key change in an old...

Friday Flyway Tips – Adding the Type of Database Project

There was an update to Flyway Desktop which lets you see the type of database your project is associated with, and this post shows how to get this in...