Featured Presentation

T-SQL Alphabet Soup

Speaker: Rodney Landrum

Summary: Come see the quick brown fox jump over the lazy dog in creative T-SQL coding ways and possibly learn a few obscure commands you were not familiar with. This session will show 26 unique quries using T-SQL keywords that start with every letter of the alphabet.

About Rodney: Rodney Landrum has been architecting solutions for SQL Server for over 12 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has authored three books on Reporting Services. He is been a regular contributor to SQL Server magazine, sqlservercentral.com and Simple-talk.com. Rodney is also SQL Server MVP.

 

Pre-Meeting Presentation

Zero to Cube: Fast Track to Analysis Services Development

Speaker: Adam Jorgensen (Video replay from 2010 PASS Summit DVDs)

Summary: Have you wanted to start using Analysis Services to deliver self-service BI to your end users? Have you started a cube project but have trouble using additional functionality like Actions, KPI's and others? This session is a great all hands on experience where we build a fully functional cube in one hour with all the bells and whistles. Even experienced SSAS developers will learn from Adam Jorgensen, BI Expert and SQL Server pro for more than 15 years. This session will cover:

  1. Best practices for database design to support good cube functionality
  2. Major components of an Analysis Services project
  3. Best practices for building your first cube
  4. Tips and Tricks for making the process simple and repeatable
  5. How to best handle adding advanced functionality to your cube
  6. Reporting on your cube from multiple sources

 

cage-aids
cage-aids
cage-aids
cage-aids