Unexpected Windows 10

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

I...

Refactoring Mistakes Are Why We Write Tests

I wrote a short piece the other day trying to show how one can use tSQLt to test code. It’s...

Visualizing the Tally Table

I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem...

Changing NULL to NOT NULL – Dealing with Data

I wrote recently on how to alter a column in SQL Server from NULL to NOT NULL in a simple...

Reframing to Overcome Filtered Index Limitations

I’m continuing on with the Blogger’s challenge in this post.

Turning the Problem Around
In the last post, I wrote about limitations...

Unit Testing in Philadelphia

I’m helping teach a pre-conference session on Friday, June 5, 2015 at the Microsoft office in Philadelphia. This is an...

DB_Owner Querying for Database Options

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

PostgreSQL v SQL Server

A site that’s a comparison of the platforms.
http://www.pg-versus-ms.com/
Certainly some good arguments being made, but (admittedly) biased towards specific workload items...

Why Test Table MetaData Tests with tSQLt

I wrote at SQLServerCentral about using tSQLt to check table metadata. In essence we are testing the API of our...

Learn tSQLt and Unit Testing in Philadelphia

SQL Saturday #390 is in Philadelphia on June 6, 2015. This is my second time attending the event, and not...