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

Community Podcast CALL FOR CONTRIBUTIONS

If you’re already a MidnightDBA Groupie, then you’ve probably already heard about my fabulous inspiration: a new SQL community podcast!  Now...

CTE, Recursion and Math

Earlier this month we had a TSQL Tuesday on the topic of CTEs.  I bailed on my submission because I...

CTE, Recursion and Math

Earlier this month we had a TSQL Tuesday on the topic of CTEs.  I bailed on my submission because I already posted some CTE examples and was bone dry...

Doing Good Isn’t Easy Some Days

A few weeks back I was on a short trip with my family and as some trips go, it had...

Let’s Get Visual – The Art of Report Design

Paul Turley

Mentor, SolidQ
This article is based on my session at TechEd on May 18th, 2011
Report styles vary depending on the...

Pliant Technology, Enterprise Flash Drives For Your SQL Server: Part 1

Pliant Technology, New Kid On The Block
If you have been reading my storage series, and in particular my section on...

Show correct totals when using SSAS role security

When using role security in SSAS, one point of confusion is when a person sees the grand total for a...

SQL Azure Query Tuning

SQL Azure is still SQL Server at the end of the day. This means it is entirely possible to write...

SQL University Troubleshooting Week Syllabus

Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...