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

SQL Rally 2011 Recap

As I write this, I’m somewhere in the air over Florida, headed back home to Dallas from participating in the...

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

MCITP 1 Down 3 To Go

Yesterday I posted a quick blurb about my certification plans this year.  Well, ok not full blown plans , but you get the gist.  I announced that I would...

MCITP 1 Down 3 To Go

Yesterday I posted a quick blurb about my certification plans this year.  Well, ok not full blown plans , but you...

Managing Data Change

Often DBAs receive requests to manually manipulate production data. Ideally, all data changes should be performed through the appropriate application...

Busy is as Busy Does

I am, as they say, one busy little bee.
I just got back from SQLRally last week (here are my SQLRally...