Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: August 2010

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

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

#33-SSRS 2008 R2 - Indicators, Sparklines and Databars

Speaker: Patrick LeBlanc

Add To Outlook: Add To Calendar

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

Date and Time: 9/1/2010 11:30:00 AM CST
BIO: Patrick LeBlanc, SQL Server MVP, is currently a Business…

Read more

0 comments, 566 reads

Posted in SQLDownSouth on 30 August 2010

MDX Puzzle #7

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

0 comments, 138 reads

Posted in SQLDownSouth on 29 August 2010

MDX Puzzle #6 - Solution

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

0 comments, 144 reads

Posted in SQLDownSouth on 27 August 2010

MDX Puzzle #6

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

0 comments, 223 reads

Posted in SQLDownSouth on 25 August 2010

SQL Saturday #28 - Lessons Learned

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

3 comments, 353 reads

Posted in SQLDownSouth on 23 August 2010

SQL Reporting Services - Line Graph with a Vertical Bar

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

0 comments, 1,357 reads

Posted in SQLDownSouth on 11 August 2010

MDX Puzzle #5 - Solution

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

0 comments, 231 reads

Posted in SQLDownSouth on 10 August 2010

SQL lunch #28-SSIS Design Patterns 1a: Introduction to SSIS Design Patterns

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

0 comments, 296 reads

Posted in SQLDownSouth on 8 August 2010

SQL Saturday #28 Update

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

0 comments, 145 reads

Posted in SQLDownSouth on 6 August 2010

SQL Saturday #28 Announces: Asks The Experts

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

1 comments, 169 reads

Posted in SQLDownSouth on 3 August 2010

MDX Puzzle #5

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

0 comments, 163 reads

Posted in SQLDownSouth on 1 August 2010