Running a Command Line SQL Compare Comparison

Recently a customer was looking to automate some of their SQL Compare checks, but they wanted to do this in a dynamic way, since they needed to do this...

Ten Database Commandments

An article on database advice catches Steve's eye.

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...