The Exceptional DBA for 2011

Once again we’re running a contest to find the Exceptional DBA around the globe. I’ve been a judge the last...

Fun with Light Bulbs

I needed an image of a “great idea”, and decided to use a light bulb. I started looking through Flickr...

Collation Conflicts in a SQL Server Join

I went to run this query recently:
select TOP 10 *
from users a
inner join Banned b
on a.username = b.usernameand...

IT and Innovation

This is a powerful quote:
“This is the digital world IT must keep up with–one where Apple can view a...

Fun with SQLskills

I’m in a fun mood today, so a few silly items for you.
The last few weeks, Paul Randal (blog | @PaulRandal)...

How To Make Your Laptop 100x Faster

Simon Sabin had his own take on increasing laptop speed. He had some good ideas, but he inspired me to...

Checking Permissions

Someone posted this query recently:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b

where permission_name = 'INSERT'
and
b.grantee_principal_id = a.principal_idThat’s a little ugly, so let’s fix...

Colorado SQL Server User Groups – May

I saw a post from Marc Beacom on the presentations this week for various groups. You can get the info...

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...

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...