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

Hints Are Not Always Better

This week Steve Jones reminds us that improving performance in T-SQL is not always obvious. Those little nuggets of knowledge can be very handy, which is why you should be regularly looking to acquire more of them.

Which Bugs Do You Find?

This Friday Steve Jones wonders what types of bugs you find in software. Are there more prevalent because of design or coding?

Filestream

IT and Innovation

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

Plans

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

Stalking the Bad Guys

What do yo do if you find malicious code in your system? Delete it? Steve Jones suggests that a honeypot might be a better idea.

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