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

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

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

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

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

SQL Azure Query Tuning

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

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

SQL Joins and Subqueries

A discussion about SQL joins and subqueries with information about how to format join statements properly.
In any non-trivial task, developers...

Find your Enabled SQL Server Network Protocols Using PowerShell

Another quick check I like to do when in 'discovery mode' on a client system is to see what network...