Page Compression

Clean Code is Easier to Read – SQL Prompt

I saw a post recently that had query that looked like this:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b

where permission_name...

Resource Governor Pools

Networking and Connections

This quote says it all:

It’s from an article on the 9/11 memorial and how an algorithm was used to inscribe...

Patch Week

My email account started getting notices of Windows patches yesterday, indicating it’s patch week again. If you manage Windows devices,...

Dropping a Row

How important is it that your server record all changes to every row? Probably very important and that is one of the foundations on which RDBMS platforms are built. Steve Jones talks about this being a difference with some NoSQL systems, and why it might not be acceptable to most businesses.

T-SQL Tuesday #18 – My CTE

It’s time for T-SQL Tuesday again, and it’s number 18. Hard to believe it’s been a year and a half...

Identity Reseed

Tiered Storage

Storage costs are constantly rising, especially for databases as we gather more and more data. However not all of our data is necessarily the same priority or requires the same hardware. Steve Jones talks about the benefits you might get if you can tier your storage.

Performance Counters