A New Word: Vaucasy

vaucasy – n. the feat that you’re little more than a product of your circumstances, that for all the thought you put into shaping your believes and behaviors and...

Finding Server Roles

Singular or Plural

A debate that might be worth having in the database community.

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?