Pagination in SQL Server

It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL...

TSQL Tuesday #62: Invitation to Healthy SQL – Why Page Verify?

I don’t think anyone’s ever been happy to get a support call at 11pm on a Saturday night. However this...

Discussing Security with Boris Hristov on SQLHangout #29

Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I...

Finding the reason for the error “Subquery returned more than 1 value”

First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In...

SQL Judo’s Monthly Challenge – January 2014 – Restore the Master

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:
The Louvre Museum has 8.5 million...

Finding a common AD group for a set of users.

I work for a large organization that over the last few years has been doing a LOT of reorgs. And...

Do you want to build an Audit?

So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql...

Playing with the log – VLF order while growing the log

The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of...

‘Twas 4:45 Friday

‘Twas 4:45 Friday, and all through the office

not a creature was stirring, not even the bosses.

The code was checked in,...