SQL Prompt – Killing the Detail Box

I love SQL Prompt and use it constantly. When I don’t have it, my code writing process slows to spurts...

Pre-built or Ad Hoc

Steve Jones talks about the ad hoc nature of some NoSQL databases and whether that's something that most users want.

Temp Table Names

April Blogging Challenge 2 – Primary Key in CREATE TABLE

The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to...

The CTE Problem

A New Use Case for SQL Prompt – Shrinking Code

I thought this would work, but I wasn’t sure. I saw some code the other day like this:
DECLARE@charASCHAR(1);

SET@char=NULL;

SELECTISNULL(@char, 0);

SELECTCOALESCE(@char, 0);

SET@char='E';

SELECTISNULL(@char,...

Kanban

Steve Jones talks about organizing and tracking work with kanban and how that might help you.

What is Database Continuous Integration?

This is an introductory article to explain what Continuous Integration (CI) is and how it can be used in database development.

BULK INSERT first row

The Devil's in the Details

This week Steve Jones notes that the little details can sometimes have a big impact in your code.