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

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

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

Forum Fun: Running Calculation SQL

A discussion about a forum post for handling a running subtraction in a SQL query.
For my first forum fun post,...