Don't Use Code Coverage

Code Coverage is a metric that Steve Jones sees often misused.

Using xp_delete_file

First, this is an undocumented proc, and there’s nothing in BOL on this. Second, it’s a holdover from previous versions,...

Smalldatetime

Getting a New R Package–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Simplified Networking with a Wsky USB NIC

I used to share an office with my wife. We both needed Internet connections, with both desktops needing Ethernet cables....

Why Don't You Unit Test Code?

This Friday Steve Jones wants to know what you think of testing code and why you don't do it.

Fun Conversions

Compound FKs with SQL Data Generator

This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it,...

Teaching Quickly

Steve Jones talks about learning, teaching, and the need to not waste anyone's time.

Enabling Database Containment for an Instance – #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...