SQL Rally May 11-13 – Expand your BI Skills

SQL Rally is coming soon and I’m really excited to say that I have the honor of speaking there! For those of you who haven’t heard, SQL Rally is a new conference in Orlando, FL intended to complement the PASS Summit held every fall. There are a lot of good reasons to attend SQL Rally, and it’s a great alternative if you haven’t been able to make it to the Summit because of cost, distance, or scheduling conflicts.

The agenda is packed with top speakers and sessions.  Wednesday May 11th has full day optional pre-conference seminars covering 4 different areas, including a BI workshop, Query performance tuning, Database development, and Professional development.  The following two days, May 12-13, have 24 one-hour technical training sessions each day divided into 4 tracks.  I’m going to be presenting The Data Mining Lifecycle to show you how to get started with the data mining tools provided in Analysis Services so you can include data mining in the applications you develop.

The 4 tracks at SQL Rally allow you to get a lot of information in all areas of SQL Server, whether it be database administration, development, or BI.  In my experience I’ve found that spanning multiple tracks is often the best way to get more out of a conference like this.  Since I typically work and speak in the BI space, I have some suggestions to make if you want to develop or expand your BI skills and career by attending some sessions not in the BI track.  Of course, you won’t go wrong with any of the BI sessions, but becoming a top BI developer requires more than what we normally identify as BI skills.

For example:  You’ve been doing a lot of report development with Reporting Services but haven’t delved into other areas of BI.  Catch as many BI track sessions as you can, but get to some of these sessions too:

–  ETL Head-to-Head:T-SQL vs. SSIS by Tim Mitchell

Knowing when to use T-SQL vs. SSIS is key to developing solid ETL.

Writing Faster Queries by Tim Chapman

Fast response to queries and timely data transformation through speedy SQL is always important in BI.

Big and Tall: When to Partition by Kendra Little

Partitioning is a very important skill to have when developing a data warehouse, a data mart, or any dimensional model.

SQL Tricks by A.P. Ward Pond and T-SQL Code Sins: The Worst Things We Do to Code, and Why by Jennifer McCown

Strong T-SQL skills are underrated for BI.

Helping Your Data Warehouse Succeed: 10 Mistakes to Avoid in Data Integration by Rafael Salas

The most difficult part of a Data warehouse project is ETL, so you can never have enough information in this area.

Creating a Metadata Mart with SSIS – Data Governance, Data Profiling & Code Generation by Ira Warren

Metadata lays the groundwork for a solid ETL system and Ira seems to have a great solution.

And of course you have to go to my session The Data Mining Lifecycle by Carlos Bossy

This session is a great way to find out about the potential of analytics and predictive modeling in SQL Server.


By the way, you can still register for SQL Rally at a discount if you do it by April 30 so don’t wait.  I hope to see you there and say hello to you!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: