T-SQL Tuesday #22 – Data Presentation

Data Presentation is not just about the look of a report.  Data Presentation involves performance, accuracy, display and the business requirements.  By giving proper attention to each of these facets, the Data presented will be both remarkable and acceptable to the end-user.

TSQL Tuesday 21 – FAIL FAIL FAIL

It is TSQL Tuesda… err Wedn… err Tuesday for August 2011.  This month the party is a day later and bringing us oodles of failure. Adam Machanic is hosting this month.  He thought it would […]

T-SQL Tuesday #19 – Disasters & Recovery

There are three types of disasters that are seldom expected. Read about the fun of dealing with these different types of disasters.

T-SQL Tuesday #18 – CTEs

To CTE or not to CTE, that is the Question So my post really has nothing to do with the title.  This is not a post to help you determine whether a CTE is appropriate […]

T-SQL Tuesday #17 – APPLY Knowledge

We have another opportunity to write as a part of TSQL Tuesday today.  This month Matt Velic (Blog | Twitter).  Matt has proposed a challenge that was derived from a comment on twitter.  The challenge […]

T-SQL Tuesday #016: Aggregates and Statistics

For my data analysis and trending, I wanted to find a simple distribution across quartiles.

T-SQL Tuesday #15 DBA Automaton

Often, we hear about DBA’s automating everything under the sun.  Why?  It simplifies the job and creates time to work on other projects.

TSQL Tuesday 14: Committed

For this TSQL Tuesday post, I will just add a short list of my professional goals for this next year.  Otherwise, this post would be mostly about my non-professional goals.

T-SQL Tuesday #13 – Business Requirements

I think a common area that is easily overlooked when it comes to requirements and interpretation of requirements is report creation.  A common problem is that there are no defined or written requirements for the creation of a report.

T-SQL Tuesday #012 – Skills

November is upon us and in some areas this also means that the leaves have changed color.  With the change in leaves we also have a change in TSQL Ones…err Tuesday this month.  The change […]