SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: June 2010

MDX Puzzle #2

Now that we have our feet wet, let’s get started with the next puzzle.  In this puzzle we will write a query that returns Percentage Growth Year over Year.  For example, if sales were $258,056 in 2006 and $389,456 in 2007, then the percentage growth would be (2007 sales –… Read more

0 comments, 1,250 reads

Posted in SQLDownSouth on 30 June 2010

SQL Saturday #28 (Baton Rouge) – All about User Groups

This year at SQL Saturday #28 we will be featuring a User Group Booth alongside the Sponsor booths. The User Group booth will provide information about various User Groups that host meetings. If you are attending SQL Saturday and are a part of a group that would like to be… Read more

1 comments, 1,367 reads

Posted in SQLDownSouth on 29 June 2010

MDX Puzzle #1 Solution

OK, are you ready to start the MDX journey.  In MDX Puzzle #1 posting I presented you with the challenge of writing an MDX query based on the requirements that I outlined in that posting.  In this solution and all subsequent solutions I will walk you through the process of… Read more

1 comments, 755 reads

Posted in SQLDownSouth on 28 June 2010

MDX Puzzle #1

MDX Puzzle #1

Recently, I embarked on a mission to become proficient at writing MDX queries.  This is a challenge, as many of you may already know.  MDX, though a query language, is very different from T-SQL as I quickly found out.  Each week I will share with you a…

Read more

0 comments, 595 reads

Posted in SQLDownSouth on 22 June 2010

SQL Saturday #28 (Baton Rouge) Announcements

Register:  Click Here

Submitted Sessions:  Click Here

Twitter:  @SQLSatBR

On August 14, 2010 at Louisiana State University SQL Saturday #28 will be held.  If you have yet to attend a SQL Saturday you should try to make this event.  Now I know what you are thinking, Baton Rouge in… Read more

0 comments, 469 reads

Posted in SQLDownSouth on 22 June 2010

SSRS R2 - Naming Excel Worksheet Tabs

I was recently asked if it was possible to name an excel tab based on a page in a reporting service report.  Honestly, I did not know if it was possible.  My initial response was, I don’t think so.  Not being 100% sure, I started searching the web and I… Read more

2 comments, 2,542 reads

Posted in SQLDownSouth on 21 June 2010

Insert Unknown Row to Dimension Table

When building a warehouse there is a common practice of adding an Unknown row to the Dimension tables.  For me, this is a monotonous task that I hate doing.  I was recently on a project that had a large number of dimensions and I refused to write a T-SQL Statement… Read more

1 comments, 811 reads

Posted in SQLDownSouth on 15 June 2010

Parameterized Report using a Stored Procedure

Download Sample Project:  Parameterized Report

In a recent forum post on BIDN.com a person asked how to filter the result on the report based on a stored procedure parameter.  Since a short blog post without screen shots wouldn’t fully explain how to accomplish this, I decided to write a quick… Read more

0 comments, 2,131 reads

Posted in SQLDownSouth on 13 June 2010

Upcoming SQL Lunch Events

We are scheduling more and more events daily on the SQL Lunch.  Just as a reminder here are a few of the upcoming events that will be broadcasted soon on the SQL Lunch.

SQL Lunch #22

Date and Time: 6/04/2010 11:30 AM CST

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

Presenter:  Thomas LeBlanc Read more

0 comments, 472 reads

Posted in SQLDownSouth on 10 June 2010

SQL Saturday #22 Pensacola Recap

Saturday I drove up to Pensacola for SQL Saturday #22.  Me and several others from Baton Rouge, including my two kids left Baton Rouge around 3AM. 

We arrived at SQLSat22 around 7:30AM.  We registered and had a few donuts.  Then Patrick Jr. (9), Kalyn (5) and myself headed to Steve… Read more

4 comments, 638 reads

Posted in SQLDownSouth on 8 June 2010

Speaking at SQL Saturday #22 - Pensacola, FL

If you are near Pensacola, FL this weekend, I will be speaking at their SQL Saturday on June 5th, 2010.  I will be presenting two sessions, CDC+SSIS = SCD and Introduction to SharePoint 2010 and PowerPivot.  I know Adam Jorgensen is currently set as the speaker.  I will be… Read more

1 comments, 677 reads

Posted in SQLDownSouth on 2 June 2010

Inventory SQL Servers with CLR Function

In an enterprise with several SQL Server instances it is pivotal that you keep track of each instance and its corresponding properties. Properties such as, name, version, service pack level, is it clustered, etc… I have implemented and read about several approaches that will assist in collecting this information. My…

Read more

0 comments, 622 reads

Posted in SQLDownSouth on 2 June 2010

SQL Lunch Call for Speakers – Quarter 3

One of my quarterly goals is to get speakers for the SQL Lunch webcasts.  Q1 and Q2 of 2010 are in the books, so its time to start working on Q3.  To all of you out there who want to share your knowledge with all of us, please send an… Read more

0 comments, 449 reads

Posted in SQLDownSouth on 1 June 2010