Join me for Lunch - SQL Lunch #33 (Indicators, Sparklines and Databars)

Read more

I have presented you with a couple of easy puzzles in the last few posts.  So, let's step it up a little with one that is a little more challenging.  I have to be honest, this puzzle was sent to me by one of my co-workers at Pragmatic Works.  Here… Read more

Puzzle #6 should not have presented too much of a challenge, it's intentions were to introduction you to the ORDER function that is available in MDX.  Ok, so this is what I started with:

This is a very simple statement that satisfies most of the puzzle requirements.  The only one… Read more

As we continue with the puzzles, I will continue to introduce new MDX functions.  In this puzzle the requirements are as follows:

Columns:  Reseller Sales Amount

Rows:  Product Subcategories

Filters:  None

Hints:  This puzzle is too easy for a hint. ;)

Ahhhh, but there is one… Read more

After spending a week in Tampa, FL at a client site I've had some time to unwind and reflect back on SQL Saturday #28.  I have received some really positive feedback from all individuals involved.  While I can't say that every aspect of the event was excellent, I can say… Read more

So, I was recently asked if you could display a vertical bar on a line graph to denote the last day of the month.  Initially, I had no clue how to solve this problem.  I talked to a couple of people and searched the web, but came up empty.  I… Read more

Again I want to apologize for the slow posting of the solution to this puzzle, but I have been hard at work on SQL Saturday #28.  Fortunately, I carved out some time to write it up.  The solution to this puzzle could have been accomplished a couple of ways.… Read more

In this three part series SQL Server MVP Andy Leonard will discuss SSIS Design Patterns.

Speaker: Andy Leonard

Add To Outlook: Add To Calendar

Meeting URL:  https://www.livemeeting.com/cc/usergroups/join?id=J8NSMR&role=attend

Date and Time: 8/9/2010 11:30:00 AM CST

Topic: #28-SSIS Design Patterns 1a: Introduction to SSIS Design Patterns
This is part one of… Read more

We are just about a week away from probably the biggest FREE training event to ever take place in Baton Rouge, LA.  Heck this is probably the biggest FREE technology event in Louisiana.  I really don't know.  Nevertheless, since it is almost here I wanted to encourage any one that… Read more

Do you have a challenging SQL Server or .Net issue that is causing you to have sleepless nights? Well, we have convinced 12 of our speakers (Experts) to allocate an additional hour of their day strictly for answering questions. These are some of the top SQL Server and .NET guys… Read more

Writing YTD totals and Running totals using T-SQL can take a little effort.  However, with MDX it's not too difficult.  In this puzzle I will write an MDX statement that produces a monthly YTD or Running total.  Here are the requirements:

Columns:  Monthly Running Total (Calculation), Internet Sales Amount Read more