SQLSaturday #9 - Greenville 2008
Event Date: 10/11/2008 00:00:00
Event Location:
- ECPI Greenville Campus
- 1001 Keys Drive
- Greenville, South Carolina
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Performance Point 2007 Server Data Integration
Abstract: Performance Point 2007 Server is a powerful tool that allows the Business Analyst to define and create the relational and analysis data structures, forms, reports and dashboards with simple wizard driven tools. The Information Technology folks still need to integrate these solutions into existing databases. Based on real world experience building large enterprise Performance Point Planning and Monitoring solutions, this guides through the pitfalls and key issues involved with integrating Performance Point 2007 Server into your current Data Warehouse environment. Key topics include The Business Model, Data Staging, Data Loading, Data Validation, PPS Command Line (PPSCMD), and Key Tips and Tricks for tying these all together using SQL Serv
Speaker(s):
- Rob Schoenborn
Track and Room: Business Intelligence - N/A
Title: Resource Governor in SQL Server 2008
Abstract: One of the new features in SQL Server 2008 is the resource governor. With increasingly consolidated SQL Server environments, and particularly with applications with complex performance requirements, this new feature will provide more fine grained control over how your solutions work. During this session we will review the functionality included in this feature, identify scenarios where it can be used, and show how to implement it.
Speaker(s):
- David Darden
Track and Room: SQL DBA - N/A
Title: Implementing Smart Reports with MS BI Platform
Abstract: Intent of this session is to demostrate use of smart reports to present datamining results. Reports can be used to analyze historical patterns, review trends and present predictions.These reports use analysis services, CLR stored procedure and reporting services. [Note: Concept of this article comes from the book, Applied Microsoft Analysis Services, by Teo Lachev]
Speaker(s):
- Tejas Patel
Track and Room: Business Intelligence - N/A
Title: Getting Started with SQL Express
Abstract: New to SQL? Check out Microsoft’s free versions of SQL Server Express. We will discuss the differences between 2005 and 2005 SQL Express versions and walk through the installation process. We’ll also learn some basic SQL commands and how you can use SQL Express at home and in your next web project.
Speaker(s):
- Jason Burton
Track and Room: SQL Development - N/A
Title: Dynamic Management Views Will Save Your Life
Abstract: Do you ever wish you could get an X-Ray view of your sluggish SQL Server? Take the guesswork out of troubleshooting database issues by utilizing the data collected in Dynamic Management Views. In this session, Whitney Weaver will show you the tools implemented in SQL Server 2005 that give you extraordinary view into the health and well being of your database instance. Code samples will be presented around query performance, I/O utilization, index usage, and more.
Speaker(s):
- Whitney Weaver
Track and Room: SQL DBA - N/A
Title: Scaling SQL Server for Large Datamarts
Abstract: One of the roles of Business Intelligence for Retailers is to determine buying patterns based on customer demographics. This type of analysis though can quickly create very large cubes above 600 Gigabytes and often between 1 to 4 Terabytes. Based on real world experience with two major retailers, this talk will discuss key design tips and best practices for building these large cubes so the data can be accessed in a timely manner. Key topics covered include vertical and horizontal partitioning, necessary key parameters, and custom aggregations.
Speaker(s):
- Rob Schoenborn
Track and Room: SQL DBA - N/A
Title: Using Data Profiling to Improve ETL
Abstract: Data quality is one of the most challenging aspects of constructing a reliable data warehouse / business intelligence solution. SQL Server Integration Services 2008 introduces the Data Profiling Task, which can be used to help improve the data quality in the ETL process itself. This session will cover the use of the Data Profiling Task to gather initial quality metrics from both source systems and the warehouse. It will also cover how to incorporate data profiling into the ongoing ETL process to continue gathering quality metrics on new data, and to build dynamic data quality rules that adjust themselves based on the current quality measures.
Speaker(s):
- John Welch
Track and Room: Business Intelligence - N/A
Title: Patterns for SSIS Configurations
Abstract: One of the common issues encountered with SSIS is deploying configurations for multiple environments. During this session, 3 patterns for handling configurations in SSIS will be covered. from a simple pattern that handles most cases, to a very flexible pattern that covers most complex scenarios. Learning and using these patterns will allow SSIS developers to more easily deploy packages between environments, and leverage a single point of configuration in each environment.
Speaker(s):
- John Welch
Track and Room: Business Intelligence - N/A
Title: SQL Server 2005 Auditing Using the CLR
Abstract: Database auditing is something everyone would like their databases to do, but implementing it without slowing data access down can be difficult. In this session I will show you how to use the CLR to create triggers that do not have a big performance hit and do not have to be rewritten if the tables change.
Speaker(s):
- Lee Johnson
Track and Room: SQL Development - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Rob Schoenborn
Contact: http://www.magenic.com
Rob’s experience in designing and implementing databases in various technical and business environments has enabled him to become a subject matter expert in database administration and development, especially working with technologies such as Microsoft SQL Server, Analysis Server, Reporting and Notification Services, ASP.NET, Web Services, and XML. With over 18 Years of industry experience, Rob brings outstanding skills in conceptual database modeling, scaling, clustering, replication, network
John Welch
Contact: http://www.agilebi.com
John Welch is Chief Architect with Mariner, a consulting firm specializing in enterprise reporting analytics, data warehousing and performance management solutions. John has been working with business intelligence and data warehousing technologies for 7 years, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), an award given due to his commitment to sharing his knowledge with the IT community. John is an experienced speaker, hav
Jason Burton
Jason is currently a Business Intelligence Architect at Ameco, a subsidiary of Fluor. He has been working in IT for over 12 years developing internal and external web, e-commerce, and data warehouse applications. He has been hacking out sql since Oracle 7.3 and SQL Server 6.5 and has given presentations at the SC Code Camp and the SQL Server Innovators Guild.
Whitney Weaver
Contact: http://whitneyweaver.com
Whitney Weaver is a Principal Consultant with Magenic Technologies. He focuses on data technologies within the Microsoft product line. Over the past 10 years he has implemented SQL Server solutions for a number of industries including Energy Management, Financial Services, Health Insurance, Manufacturing, and State Government. Whitney regularly speaks at user groups and other developer events.
Lee Johnson
I have been a professional programmer since 1995. I have worked in such fields as point of sale, internet communications, gage management, warehouse inventory, and accounting. Early in my career I was specialized in communications, anything from RS232 to Winsock to low level protocols. The past few years I have been with CSI and specialized in data conversion and database development. I have tutored all the programming and database classes at Greenville Tech for 4 years.
David Darden
David Darden is a Senior Consultant at Mariner, a consulting firm specializing in enterprise reporting analytics, data warehousing and performance management solutions. David has 10 years experience in software development including design, architecture, development, quality assurance, and project management. David has been working with SQL Server since version 7.0, with a focus on business intelligence and data warehousing since 2003, and has delivered solutions using a across a variety of in
Tejas Patel
Tejas Patel works as a Senior BI Consultant with Magenic Technologies. He has worked various retail and manufacturing industries and have built enterprise level BI solutions for them.
Rob Schoenborn
Contact: http://www.magenic.com
Rob’s experience in designing and implementing databases in various technical and business environments has enabled him to become a subject matter expert in database administration and development, especially working with technologies such as Microsoft SQL Server, Analysis Server, Reporting and Notification Services, ASP.NET, Web Services, and XML. With over 18 Years of industry experience, Rob brings outstanding skills in conceptual database modeling, scaling, clustering, replication, network
John Welch
Contact: http://www.agilebi.com
John Welch is Chief Architect with Mariner, a consulting firm specializing in enterprise reporting analytics, data warehousing and performance management solutions. John has been working with business intelligence and data warehousing technologies for 7 years, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), an award given due to his commitment to sharing his knowledge with the IT community. John is an experienced speaker, hav
Sponsors
The following is a list of sponsors that helped fund the event: