Adding a Foreign Key in the CREATE TABLE statement–#SQLNewBlogger

I had someone ask this question recently and had to double check the syntax myself, so I thought this would make a nice SQL New Blogger post. Another post...

Can Data Save the World?

The authors of Freakonomics talk data science.

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.