SQLSaturday #23 - Louisville 2009
Event Date: 10/24/2009 00:00:00
Event Location:
- 10200 Linn Station Rd
- Louisville, Kentucky
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: Attunity CDC: Enabling the Real-Time SSIS Story
Abstract: BI Voyage, an Attunity Partner Presents:Change Data Capture for SSISAttunity is the leading provider of change data capture (CDC) products that capture and deliver only the changes made to enterprise data sources, enabling efficient and real-time data integration, and eliminating the need for batch processing windows. With Attunity CDC products for SQL Server Integration Services (SSIS) you can build data integration solutions for real-time data warehousing supporting operational business intelligence requirements, replicate data from one source to another, and synchronize two or more data sources to ensure data consistency.Attunity CDC offering for SSIS includes:Attunity Oracle-CDC for SSISAttunity SSIS CDC Accelerator
Speaker(s):
- Derek Comingore
Track and Room: Track 2 - N/A
Title: Scalable SQL Server Virtualization
Abstract: Learn how Hyper-V can provide on-demand scalability and improved resource utilization specifically for the unique SQL Server workload characteristics. We will discuss how to use Resource Governor to guarantee predictable performance, as well as, how to automate the allocation of resources based on the servers current performance, and how to contain problem processes. Finally, we will discuss how the Data Collector can be used to provide constant information about the health of the cloud to itself and to the DBA. Throughout the session, we will demonstrate how these ideas work together to create a new SQL Server infrastructure that will change as your needs change.
Speaker(s):
- Sarah Barela
Track and Room: Track 1 - N/A
Title: Do It Right: Best Practices for Analysis Services
Abstract: Are you seeking practical, in-depth technical advice for building a BI solution using SSAS? Analysis Services changed tremendously with the advent of SQL Server 2005. It introduced a new way of building dimensions and cubes that required a new way of modeling the solution. This session examines the best practices for properly designing cubes for performance and usability. It discusses some high-level topics but also looks at advanced topics such as alternative approaches to many-to-many dimensions, SCOPE statements, aggregation design, scalability issues, processing techniques, server properties, and more.
Speaker(s):
- Craig Utley
Track and Room: Track 2 - N/A
Title: Why Data Warehousing Projects Fail
Abstract: Is your organization planning to build a data warehouse or BI solution? Data warehousing projects, like many large IT projects, have high failure rates. While the exact rate of failure for data warehousing projects is difficult to pin down, the causes of these failures fall into a small number of categories. It is obviously possible to successfully complete a data warehousing project and deliver value to the business. Craig Utley has seen Microsoft BI solutions in various states of completeness at over 30 companies worldwide and has seen some awesome successes and some spectacular failures. This session addresses the reasons data warehousing projects fail and how you can succeed in overcoming these obstacles.
Speaker(s):
- Craig Utley
Track and Room: Track 2 - N/A
Title: Demystifying Transact-SQL
Abstract: Transact-SQL (T-SQL) is the language of SQL Server, and is literally used for everything from defining database objects to querying data from a database. In this primer, essential T-SQL syntax will be explained to demonstrate how to work with data in progressively complex ways. Also demonstrated will be how to write functions and stored procedures to handle more complex requirements, as well as some of the more powerful features of the T-SQL language itself. Finally, we’ll see examples of how to consume the results of a query from .NET using ADO.NET.
Speaker(s):
- Jason Follas
Track and Room: Track 1 - N/A
Title: Tuna Helper - Proven Process for Tuning SQL
Abstract: Many DBAs and Developers are faced with tuning poorly performing SQL statements. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait time data, indexing strategies, column selectivity and several more that will help the you succeed on future tuning projects.
Speaker(s):
- Dean Richards
Track and Room: Track 1 - N/A
Title: Powershell in SQL Server 2008
Abstract: Powershell is one of the wild fire pieces running through the Microsoft landscape right now. With its semi-integration with SQL Server 2008 it provides a powerful scripting environment for those people whom are looking for a more traditional route of automation other than .NET. Additionally, most administrative functions are merely a repetitive sequence of tasks that you do over and over again. This talk will consist of an introduction to the Powershell environment as seen through the DBAs eyes and demonstrate some scripts that can help you manage your environment.
Speaker(s):
- Arie Jones
Track and Room: Track 1 - N/A
Title: ETL from the Trenches: SSIS in the Real World
Abstract: Sure you’ve read the SSIS books. And sure you’ve seen a lot of SSIS presentations. But how do you put it all together to create a solid ETL framework for loading your data warehouse environment? In this session, we’ll look at the ins and outs of a real-world ETL environment built using SSIS. We’ll discuss the SSIS design patterns used to handle a multi-tiered data warehouse environment with multiple data sources, different loading schedules, and several different data transformation requirements. We’ll also discuss how the development team responsible for the ETL environment at the Department of Veterans Affairs handles package auditing and logging, team development, package testing, and automated deployments.
Speaker(s):
- Dave Fackler
Track and Room: Track 2 - N/A
Title: Comparing Clustering Methods
Abstract: Clustering is very important technology for High Availability and it is important for DBA to understand benefits and pitfalls. With very few available techniques and a lot of gray areas right decision might help to avoid extra costs. Presentation is unveiling clustering basics, reviews and compares clustering technologies including Microsoft, XCOTO Gridscale, and HP PolyserveMatrix. This presentation can be helpful not only to beginners but to intermediate level DBAs and infrastructure managers.
Speaker(s):
- Alexander Prusakov
Track and Room: Track 1 - N/A
Title: SSIS Power hour
Abstract: SSIS Detailed session
Speaker(s):
- Dave Fackler
Track and Room: Track 2 - N/A
Title: SQL Server 2008: Extended Events
Abstract: SQL Server 2008 provides a plethora of diagnostic tools from which you can wield as a DBA to diagnose problems within your database systems. Extended Events is an extended event handling system that parallels much of the functionality of SQL Trace. The one MAJOR difference is that Extended Events is highly scalable and configurable system that allows the administrator to collect as little or as much data as they wish in order to identify a possible problem. This session will focus on looking at the Extended Events architecture, how it works, how to use it, and some tools that may help you along the way.
Speaker(s):
- Arie Jones
Track and Room: Track 1 - N/A
Title: Analysis Services 2008 End-to-End
Abstract: Are you interested in designing, building, and deploying an Analysis Services database that follows best practices and best delivers value to your organization? This session goes through the process of optimizing cube creation through the proper design of dimensions, measure groups, aggregations, calculations, perspectives, security, and more. The areas of source code control, deployment, promotion from test to production, processing efficiency, and other areas will be discussed. Far from a theoretical discussion, this seminar will present real-world lessons learned about what works in production environments.
Speaker(s):
- Craig Utley
Track and Room: Track 2 - N/A
Title: Project Gemini
Abstract: Introduction to Project Gemini
Speaker(s):
- Derek Comingore
Track and Room: Track 2 - N/A
Title: the XML Capabilities of SQL Server 2008
Abstract: XML-based data is very prevalent in today’s data world to the point that every database developer should know how to work with XML. Middle-tier translation of XML into relational data may be inflexible, and often leads to a loss of fidelity over time. One solution is to move the XML handling into the database itself in order to improve overall integration. SQL Server 2005 provides powerful XML processing features that allow easy access to data stored within XML without sacrificing any of the original fidelity.
Speaker(s):
- Jason Follas
Track and Room: Track 1 - N/A
Title: Cloud Computing
Abstract: MS SQL Server Evangelist talks of advantages of cloud computing.
Speaker(s):
- Brian Prince
Track and Room: Track 1 - 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.
Brian Prince
MS Evangelist Brian Prince talks of advantages of cloud computing.
Craig Utley
Contact: http://www.LearnMicrosoftBI.com
Craig Utley is a SQL Server MVP, Mentor with Solid Quality Mentors and a former Program Manager with the SQL Server Customer Advisory Team (SQLCAT) where he focused on Business Intelligence. Craig has been involved in the Microsoft BI space since the betas of SQL Server 7.0, when he helped write Microsoft’s first data warehousing course. Since then he has consulted at a variety of businesses worldwide on their BI solutions. He is a frequent conference speaker and published author.
Dave Fackler
Twitter: - @sqlbiguru
LinkedIn: Dave Fackler
Contact: http://davefackler.blogspot.com/
Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features using dimensional modeling design principles and best practices. He has also architected and developed several enterprise ETL processes using SSIS and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting solutions using SSAS and SSRS, often coupled with SharePoint and Office components. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year.
Derek Comingore
Contact: http://BIVoyage.com
Derek is the founder and a Principal Architect with BI Voyage, a Microsoft Partner specializing in BI solutions (www.bivoyage.com). As a SQL Server MVP and a certified professional in several Microsoft technologies, including SQL Server BI, he speaks at local and national SQL Server user groups and is a published author on SQL Server topics.
Dave Fackler
Twitter: - @sqlbiguru
LinkedIn: Dave Fackler
Contact: http://davefackler.blogspot.com/
Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features using dimensional modeling design principles and best practices. He has also architected and developed several enterprise ETL processes using SSIS and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting solutions using SSAS and SSRS, often coupled with SharePoint and Office components. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year.
Jason Follas
Contact: http://jasonfollas.com
Jason Follas is a Technical Architect for Perficient, serving clients primarily located in the greater Detroit region (including Toledo, where he lives and serves as the President of the Northwest Ohio .NET User Group). Since 1994, he has developed many interesting solutions on the Microsoft platform, including an Aircraft Weight and Balance system used by an air freight company and blend optimization software. In 2007 and 2008, Microsoft recognized Jason as a Microsoft MVP (SQL Server).
Dean Richards
LinkedIn: Dean Richards
Dean Richards is a Senior DBA for DBMS Insights and has helped hundreds of companies solve database and virtualization performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize and move databases to the cloud.
Craig Utley
Contact: http://www.LearnMicrosoftBI.com
Craig Utley is a SQL Server MVP, Mentor with Solid Quality Mentors and a former Program Manager with the SQL Server Customer Advisory Team (SQLCAT) where he focused on Business Intelligence. Craig has been involved in the Microsoft BI space since the betas of SQL Server 7.0, when he helped write Microsoft’s first data warehousing course. Since then he has consulted at a variety of businesses worldwide on their BI solutions. He is a frequent conference speaker and published author.
Alexander Prusakov
Alexander Prusakov is Sr. SQL Server DBA from Indianapolis, IN. As consultant, he is utilizing his expertise in database design, development, and administration for variety of companies. He provides database administration for enterprise size companies (over 50 servers, over 400 instances, and over 2000 databases) and helps small and medium size companies to re-design and re-develop core databases utilizing MS SQL Server 2005/2008.
Craig Utley
Contact: http://www.LearnMicrosoftBI.com
Craig Utley is a SQL Server MVP, Mentor with Solid Quality Mentors and a former Program Manager with the SQL Server Customer Advisory Team (SQLCAT) where he focused on Business Intelligence. Craig has been involved in the Microsoft BI space since the betas of SQL Server 7.0, when he helped write Microsoft’s first data warehousing course. Since then he has consulted at a variety of businesses worldwide on their BI solutions. He is a frequent conference speaker and published author.
Derek Comingore
Louiville native speaker
Jason Follas
Contact: http://jasonfollas.com
Jason Follas is a Technical Architect for Perficient, serving clients primarily located in the greater Detroit region (including Toledo, where he lives and serves as the President of the Northwest Ohio .NET User Group). Since 1994, he has developed many interesting solutions on the Microsoft platform, including an Aircraft Weight and Balance system used by an air freight company and blend optimization software. In 2007 and 2008, Microsoft recognized Jason as a Microsoft MVP (SQL Server).
Arie Jones
Contact: http://www.programmersedge.com
Arie Jones ‘AJ’ is the Principal Technology Manager for Perpetual Technologies, Inc. in Indianapolis, IN. Arie leads PTI’s team of expert consultants in planning, design, development, deployment, and management of database environments and applications to achieve the best combination of tools and services for each client. Additionally, AJ is a community speaker, has written several books such as “Learn SQL in 24 Hours”, and blogs extensively at http://www.programmersedge.com
Sarah Barela
Twitter: - @sarahspace
Contact: http://www.sqlsarah.net
Sarah Barela is a Senior Manager at CBeyond Cloud Services, formerly MaximumASP. She has a Master’s degree in Information Science from the University of Texas, where she specialized in Database Management Systems. Sarah has spent over 15 years focusing on the administration of enterprise environments with large numbers of SQL Servers. Sarah is currently responsible for a rapidly growing environment with more than 2000 SQL Server instances. Her latest interests are in applying cloud technologies to SQL Server environments. Sarah has been a guest speaker at a number of PASS Chapter meetings, SSWUG Virtual Conferences, SQL Connections, SQLSaturday events, and the 2007, 2009, and 2010 PASS Summits.
Arie Jones
Contact: http://www.programmersedge.com
Arie Jones ‘AJ’ is the Principal Technology Manager for Perpetual Technologies, Inc. in Indianapolis, IN. Arie leads PTI’s team of expert consultants in planning, design, development, deployment, and management of database environments and applications to achieve the best combination of tools and services for each client. Additionally, AJ is a community speaker, has written several books such as “Learn SQL in 24 Hours”, and blogs extensively at http://www.programmersedge.com
Sponsors
The following is a list of sponsors that helped fund the event: