Five Minute Refactoring

The debate over how to change code or solve a problem can create arguments that last for years. Steve Jones notes the idea of limiting debates to five minutes is interesting.

See Two Queries at Once in SSMS

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...

The Challenges of Space

CSS Engineers at Microsoft are reporting more space issues with database systems. Steve Jones has a few comments.

The Rename Game

How often do you rename things? It seems to be more common for some than others.

Checking Table Metadata with tSQLt

In this article on tSQLt, learn how you can use the AssertResultSetsHaveSameMetaData method from the framework to enforce your API.

FORMATing Dates

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...

Practical Hekaton

Steve Jones is searching for anyone that is using In-Memory OLTP tables in production.

Using the DAC with SSMS

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...

Unexpected Windows 10

This was strange. I noticed a new icon in the taskbar today. When I hovered over it, I saw this:

I...

Insert without a PK