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

Archives: November 2010

Handling Type II Dimension with the MERGE Statement

Microsoft attempted to make our lives easier with the Slowly Changing Dimension task in SSIS.  However, as we all know the task has some major performance issues.  So they introduced the MERGE statement.  When I initially started using the MERGE statement I considered it as a great solution to handle… Read more

3 comments, 1,913 reads

Posted in SQLDownSouth on 17 November 2010

My SQL PASS Summit Adventures part 1


I started my PASS Summit a little early this year.  I arrived in Seattle on Friday night, November 5th,  around 10:30 PM.  I met Brian Knight and Tim Moolic (Pragmatic Works COO) and we drove about 1.5 hours to Ashford, WA.  We settled in to our cabin on the Creek…

Read more

1 comments, 576 reads

Posted in SQLDownSouth on 16 November 2010

Join the SQL Lunch on Tuesday

What a long week at PASS (stay tuned for more details about my trip).  Now that it's over back to work.  Join me and Cade Roux for a SQL Lunch on Tuesday. 
#41-Get a Lever and Pick Any Turtle: Lifting with Metadata

Speaker: Cade Roux

Add To Outlook: Add To… Read more

1 comments, 656 reads

Posted in SQLDownSouth on 14 November 2010

A Couple of SQL Lunches this Week

I want to apologize for posting this so late, but there is a SQL Lunch today and one tomorrow.  Hope you all can make it.

#37-Zero to Dashboard

Speaker: Adam Jorgensen

Add To Outlook: Add To Calendar

Date and Time: 11/3/2010 11:30:00 AM CST

BIO: Adam Jorgensen , MBA,… Read more

0 comments, 623 reads

Posted in SQLDownSouth on 3 November 2010

Vote for Our SQL Rally PreCon


Vote here:  http://www.zoomerang.com/Survey/WEB22BD59JCQBT

Honestly, I want each of reading my blog to vote for our Pre-con(Full Day Business Intelligence Workshop).  However, as with any voting process you have choices.  Well....in most cases you do.  We often feel or believe that our… Read more

0 comments, 481 reads

Posted in SQLDownSouth on 1 November 2010