Next Meeting: Thu, Feb 21 2013
Feb 2013 NTSSUG Meeting
6:00 - 6:20 - Welcome, Announcements & Food
6:20 - 7:20 - BI Information in SQL Server by Russ Loski
7:30 - 8:30 - Data Warehouse Series - Basics and Beyond - David Stein
8:30 - 8:45 - Raffle and closing.
Event Time : Thu, Feb 21 2013 18:00 - 21:00 (GMT-06:00) Central Time (US & Canada)
Your Local Time: Fri, Feb 22 2013 00:00 - 03:00
Microsoft Building LC-1
7000 North Highway 161
Direction: Microsoft is between Highway 114 and MacArthur Boulevard in Irving (Las Colinas), on Highway 161. The easiest way to get to there is to take the outer access road for Highway 161 North and exit into the Microsoft parking lot. It is the first building you will see once you exit. We'll be in the first building, LC-1.
Please park in the front of the building that faces Highway 161. Enter the front of the building and sign-in at the front desk.
BI Information in SQL Server
Russ Loski, SQL Server Developer Independent
Much of what you need to know about BI is stored in SQL Server and is available using some conventional and some less conventional SQL Server tools. We will be looking at how to gather information about your Reporting Service. Which reports were run, how many times? We will look at the parameters that were selected when running those reports. Then we will dig into the reports themselves. What queries are used in the reports? To what server are the reports connecting? We will use regular transact SQL as well as XQuery to dig out these gems.
Russ Loski is a Dallas area SQL server developer. He began work with SQL Server 6.5 in the late nineties as an Access developer and now focusses on developing ETL solutions with SSIS. He currently works as an independent trainer but has worked as contract SQL developer for companies in various industries: from the Dallas Cowboys to Bank of America. From Verizon to T-Mobile.
Data Warehouse Series - Basics and Beyond
David Stein, Data Warehouse Architect RealPage Inc.
In a series of 1 hour sessions, I'll cover both the basics and gotchas of Data Warehouse Development using the SQL Server 2012 toolset. Some of the things we'll cover are:
• Basic methodology for evaluating business requirements/needs, obtaining user cooperation, and identifying source data quality issues.
• Data Warehouse basic concepts including Facts, Dimensions, Star and Snowflake Schemas.
• Deep dive into slowly changing Dimension types and how to handle them using T-SQL and SSIS.
• T-SQL Merge Fundamentals and how it can be used to load Dimension and Fact Tables. Yes, I swear the Merge Generation Code will be ready for the presentation. :)
• Understanding the three basic Fact Table types, how they are used, and loaded with SSIS.
• Date Dimension creation and configuration.
• Taking advantage of SSIS 2012 functionality improvements including Environments, Project Parameters etc.
• Strategies for SSIS and database optimization, insuring data integrity, etc.
• And much, much more.
Each session will progressively build upon the previous sessions and session material will be posted on my blog.
David Stein is a Data Warehouse Architect with RealPage Inc. in Carrollton, TX. He’s worked in SQL Server Business Intelligence for almost a decade in many roles as both a consultant as well as a corporate employee. He’s designed Data Warehouses from scratch as well as saved projects in serious jeopardy. He is also very active in the community, having spoken at PASS events at all levels, including the PASS Summit, SQL Rally, and at numerous SQL Saturday events and user groups. You can learn more about Data Warehousing, Business Intelligence, and other technical topics on his blog at Made2Mentor.com or follow him on Twitter @Made2Mentor.
NTSSUG 20130221 Russel Loski SSRS.zipDW Basics and Beyond Part 2.pdf