Playing with Pivot

I’ve been working on some skills, trying to grow some of my T-SQL, and started to mess with the PIVOT...

Testing is Your Best Investment

One of the things that can make a big difference in how well your software performs is testing.

The Flash Database

What is the impact of flash storage on databases? There are quite a few, but this week Steve Jones asks if SQL Server should do more to take advantage of them.

PIVOT

The ALS Ice Bucket Challenge

A few friends challenged me yesterday, including Grant Fritchey and Aaron Bertrand. Last night, when I got to the Denver...

Biml

Updating tsqlt

I was looking to write a new test with the tsqlt framework recently. I wanted to isolate a stored procedure’s...

Yet Another Attack Vector

The lack of progress in amending our laws to handle the digital revolution in our leaves may leave us open to unexpected attacks.

SQL in the City 2014

It’s official, we have a couple 2014 SQL in the City events scheduled, covering two countries this fall. Both events...

Disconnecting Auditing

Currently we have system administrators responsible for securing our systems, including the auditing capabilities. However that's not the best way to ensure that we can protect our systems.