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

Archives: July 2010

MDX Puzzle #4 - Solution

This puzzle may not have been much of a challenge, but it introduced two new MDX concepts.  I have to admit, one of my colleagues and I chatted about this puzzle, and I realized that my requirements were a little unrealistic.  As a result, I changed the requirements a little.… Read more

0 comments, 577 reads

Posted in SQLDownSouth on 30 July 2010

2010 3rd Quarter Goals

Now that we are into the third quarter of 2010 I decided to post an update of my 2nd quarter goals and post goals for the 3rd quarter.  If you all have been following my blog or me on twitter (patrickdba) you know that I was selected as a SQL… Read more

0 comments, 309 reads

Posted in SQLDownSouth on 28 July 2010

MDX Puzzle #4

This puzzle is rather simple, but it does introduce a few new things. Using T-SQL you typically filter queries with a WHERE clause.  You can also do the same with MDX, but just like T-SQL there are a few ways to accomplish this.  In this puzzle you will see an… Read more

0 comments, 238 reads

Posted in SQLDownSouth on 28 July 2010

SQL Saturday Wiki

This past weekend I had the opportunity to hangout with some of the brightest upcoming SQL Server Professionals and a couple of old-timers.  We were gathered in Orlando, FL by Andy Warren to work on the SQL Saturday Wiki.  Essentially, the plans were to improve on the information that… Read more

1 comments, 205 reads

Posted in SQLDownSouth on 25 July 2010

SQL Server 2008 R2 for the DBA Recording and PowerPoint

I recently had the opportunity to do two presentation on SQL Server R2 for the DBA.  In the first session there were approximately 150 attendees and at the second there were approximately 400 attendees.  The recording is available here and you can download the slide deck here.  I would… Read more

0 comments, 239 reads

Posted in SQLDownSouth on 23 July 2010

.NET speaker Idol, Guess who won?

Last night (July 21, 2010) I had the honor of being a speaker at the Baton Rouge .Net User Group.  This wasn't their normal meeting.  It was their 3rd Annual Speaker Idol.  The rules are as follows:

1.  There are three judges that get to ask questions and… Read more

3 comments, 425 reads

Posted in SQLDownSouth on 22 July 2010

Free Data Warehouse Training - SQL Lunch #27 Let's Get Dimensional

Join Adam Jorgensen, tomorrow on the SQL Lunch to learn about Dimensional Modeling.  Go to SQL Lunch and add this event to your calendar or use the link in this posting.  To receive notifications about upcoming SQL Lunches please go here.  Every week this month we will be… Read more

0 comments, 340 reads

Posted in SQLDownSouth on 21 July 2010

SQL Server 2008 R2 for the DBA Webcast

Tomorrow at 11:00 AM EST I will be giving a talk on SQL Server 2008 R2 for the DBA.  Here is the description:

Microsoft SQL Server 2008 provides a number of enhancements and new functionality, building on previous versions. Administration, database maintenance, manageability, availability, security, and performance, among others, all… Read more

0 comments, 192 reads

Posted in SQLDownSouth on 21 July 2010

Practice Your PASS Session on the SQL Lunch

We at the SQL Lunch would like to extend an invitation to all of the PASS speakers.  If you are looking for a place to practice your PASS session please email us at webmaster@sqllunch.com.  Don’t worry, you can have up to 90 minutes or you can break your session… Read more

2 comments, 152 reads

Posted in SQLDownSouth on 18 July 2010

MDX Puzzle #3 Solution

Download Script

Sorry that it’s taken me so long to write this post, but I have been a little busy with the SQL Lunch.  I am back now, so let’s solve this puzzle.  This puzzle introduced a new keyword, WITH, that can be used to create a calculated member…

Read more

4 comments, 364 reads

Posted in SQLDownSouth on 15 July 2010

Free T-SQL Training - SQL Lunch #25 (Transact-SQL Development and Deployment)

Join SQL Server MVP, Andy Leonard, tomorrow on the SQL Lunch to learn some snappy tips and tricks on Transact-SQL development and deployment.  Go to SQL Lunch and add this event to your calendar or use the link in this posting.  To receive notifications about upcoming SQL Lunches please… Read more

0 comments, 219 reads

Posted in SQLDownSouth on 13 July 2010

SQL Saturday #28 “Refer a Friend Contest”

With all the MSDN give away contests, I decided to add another.  Here are the official rules for the twitter referral registration contest for SQL Saturday #28 in Baton Rouge, LA on August 14, 2010 on the campus of Louisiana State University.

In case you haven't heard, SQL Saturday Baton… Read more

0 comments, 193 reads

Posted in SQLDownSouth on 12 July 2010

Speaking at Greater New Orleans .Net User Group (GNO.NET)

This week I will speaking at the Greater New Orleans .Net User Group.  My topic is Introduction to the SQL Server Profiler.  If you want to learn some tips and tricks that you can use when trying to identify performance problems with your SQL Server stop by the meeting.  Also,… Read more

1 comments, 206 reads

Posted in SQLDownSouth on 12 July 2010

Free SSRS Training – SQL Lunch #23 (SSRS R2 – Shared Datasets & Report Parts)

Join SQL Server MVP, Patrick LeBlanc, next week on the SQL Lunch to learn about Share Datasets and Report Parts in SSRS R2.  Go to SQL Lunch and add this event to your calendar or use the link in this posting.  To receive notifications about upcoming SQL Lunches please go… Read more

0 comments, 755 reads

Posted in SQLDownSouth on 9 July 2010

Free SSIS Training - SQL Lunch #24 (Looping in SSIS)

Join Brad Schacht this week on the SQL Lunch to learn about Looping in SSIS.  Go to SQL Lunch and add this event to your calendar or use the link in this posting.  To receive notifications about upcoming SQL Lunches please go here.  Every week this month we… Read more

0 comments, 235 reads

Posted in SQLDownSouth on 7 July 2010

MDX Puzzle #3

The next puzzle comes from a BIDN.com forum post.  Here are the requirements:

Columns:  Internet Order Quantity and Percentage Of Total (Calculation)

Rows: Product

Filter:  Return only the TOP 10 Products based on Internet Order Quantity.

Hint:  Use the WITH MEMBER statement to perform the calculation.  In addition, you will… Read more

0 comments, 200 reads

Posted in SQLDownSouth on 6 July 2010

MDX Puzzle #2 Solution

MDX Puzzle #2 Solution

Download Script

This puzzle was a little more challenging than the first, but it was definitely fun and a good learning experience.  It introduced a new method that allows you to create session scoped calculation that can be used in your MDX query.  You can actually… Read more

2 comments, 447 reads

Posted in SQLDownSouth on 6 July 2010

SQL Server MVP - Are you kidding me?

I received an email today stating that I had been selected as a Microsoft SQL Server MVP for 2010.  This is my first MVP award and I am elated to become part of such a distinguished group.  What a great community!!!!

Thanks to all those that nominated me and thanks… Read more

8 comments, 274 reads

Posted in SQLDownSouth on 1 July 2010