SQLRALLY.com PASS SQLRally 2011 www.sqlpass.org Twitter Facebook LinkedIn

To vote on which BI Platform Architecture, Development & Administration sessions you would like to see presented at PASS SQLRally 2011, please click here

The following abstracts have been submitted for the BI Platform Architecture, Development & Administration category for PASS SQLRally 2011. Voting for these sessions will take place Jan 31-Feb 6, 2011.

Category Quick Links

Administration
Advanced SSIS
Analytics
Data Warehousing
Mining
New Technology
SSAS/MDX
SSIS
SSRS
Sharepoint/PowerPivot
Summit Spotlight


Administration

Title: Revolutionizing Database Performance Through Accelerated Disk IO
Speaker: David Gitner
Category: Administration
Level: 100
Abstract: Speaker: Eyal Markovich, Principal Consultant. Over the past several decades, data storage has evolved to today’s highly distributed storage systems, capable of storing petabytes of data and servicing hundreds of users and applications. Yet the technology to deliver the data efficiently has lagged far behind other technologies. With today’s SSD technology the capability now exists to significantly increase data throughput by reducing or eliminating IO wait times; resulting in the highest levels of application performance. Eyal Markovich of Kaminario will discuss the latest storage technology leveraging DRAM SSD and HDD components to greatly improve your database performance and data availability.
Session Goals
  • Highest levels of data throughput and IOPS (IOs per second)
  • High data availability and reliability with no single point of failure
  • No changes to applications or infrastructure is required
Speaker Bio:  



Title: Building SQL 2008 BI to Manage Enterprise Multi-Platform Server Capacities
Speaker: Joshua Jin
Category: Administration
Level: 200
Abstract: At Intel IT, one of our challenges is to manage and report virtual servers' performance and capacities by application and organizations. We will explain how we overcome this challenge by utilizing SQL Server 2008 BI capabilities. In this case study session, we will share how to make ETL system scalable, and how we deployed a 3-Terabyte data warehouse on a VM. This session will cover how we use BI performance data to report overall and detailed capacities in our virtualization environment as well as how we use BI data to manage Virtual Machines to achieve optimal production performance.
Session Goals
  • To share our story, best practices, SQL Server 2008 BI features, and our lessons learned with SQL PASS communities.
Speaker Bio: Joshua Jin is a frequent speaker at the SQL PASS local chapter in Portland, Oregon. He holds MCITP Business Intelligence Developer, Database Administrator, and Database Developer certifications for SQL Server 2005. Joshua is a contributing author of “Professional SQL Server 2005 Performance Tuning” by Wiley/Wrox. In his role at Intel IT, he is currently the development lead of a large SQL BI project for a private Cloud.



Title: The BI DBA
Speaker: Randy Dyess
Category: Administration
Level: 200
Abstract: In this session, you will learn the differences between administering a data warehouse database, or a reporting database, versus a database meant for OLTP operations. This session will cover the basic administration tasks and how they can be different for DBAs working with data warehouse/reporting databases.
Session Goals
  • Understand the needs of OLAP databases
  • Understand tasks needed for successful OLAP database administration
  • Understand how OLAP databases are different than OLTP databases
Speaker Bio: Bio Randy is mentor with Solid Quality Mentors and has a large variety of experiences dealing with SQL Server over the past 18 years. He has worked in environments with Terabytes of data and environments that had over a 1000 databases with only a few megabytes of data in each database. Currently Randy specializes in training and mentoring with a focus on topics pertaining to performance tuning, SQL Server hardware infrastructure design and configuration, and SQL Server capacity planning. Randy is the author of TransactSQL Language Reference Guide, coauthor of MCTS Self-Paced Training Kit: Microsoft SQL Server 2005 Implementation and Maintenance (Exam 70-431) and numerous magazine and newsletter articles pertaining to SQL Server and has spoken at various international and national conferences. Randy blogs and maintains a website at www.SQLServerManagement.com.



Title: Agile BI with Microsoft Technologies
Speaker: Daniel Evans
Category: Administration
Level: 300
Abstract: Learn how to deliver BI solutions using Microsoft technologies in an agile development approach
Session Goals
  • Learn core concepts of agile development with BI
  • Utilize Microsoft tools (VS and SQL) to perform agile BI development
Speaker Bio:  



Title: Optimizing a Business Intelligence Solution
Speaker: Jen Underwood
Category: Administration
Level: 300
Abstract: This presentation covers optimizing a Microsoft business intelligence solution and the end-to-end components: SQL Server data warehouse, SSIS (Integration Services), SSRS (Reporting Services) and SSAS (Analysis Services). We will begin with running and discussing Best Practices Analyzer results. Then we will review some practical approaches for prioritizing performance issues followed by demonstrations of tuning tools for the database, ETL packages, reports and OLAP cubes. This presentation will be supplemented with downloadable scripts and resources for further review.
Session Goals
  • Introduce Best Practices Analyzer, BIDS Helper, MDX Studio and other business intelligence performance tuning scripts and tools.
  • Demonstrate tuning various components of a business intelligence solution.
  • Share some practical approaches to identifying and prioritizing performance issues to address.
Speaker Bio: Jen Underwood has over 15 years of database and reporting solution experience specializing in the Microsoft platform. Career highlights include global military, retail, financial, healthcare and supply chain industry projects for well-known clients including the Department of Defense, Bloomberg, Walmart and Teradata. She participated in Microsoft TAP programs for Microsoft SQL Server 2008 R2, PowerPivot and SharePoint 2010. She is actively involved in local SQL Server user groups and has presented at multiple, regional SQLPASS events in Georgia, Florida and California. She has a Bachelors degree in Business Administration and post-graduate certification in data mining.

Advanced SSIS

Title: Achieving Real-time BI in a Heterogeneous Environment Using CDC Technology & Microsoft SSIS
Speaker: Doug Wheaton
Category: Advanced SSIS
Level: 200
Abstract: This session will focus on the various options for using Change Data Capture (CDC) and Microsoft SSIS to achieve real-time business intelligence efficiently and cost-effectively. Participants will learn how to enable high performance, efficient and real-time data integration using SQL Server Integration Services (SSIS), when working with heterogeneous source data from Oracle, DB2 and others. Additionally, this session will cover considerations for leveraging CDC technologies integrated with the Microsoft BI platform to enable data replication. Use cases highlighting real-time data warehousing and successful BI, MDM, and operational reporting initiatives will also be outlined. Doug Wheaton is a CDC expert and has over 20 years of experience in the content, workflow management and data integration space. He has written numerous related articles and has presented at many Microsoft conferences, SQL Saturdays and user groups throughout the US on the topics of BI and data integration using Microsoft SSIS.
Session Goals
  • To address the implementation and use of the technologies that enable self-service BI.
  • Teach the benefits of implementing a CDC solution tightly integrated with Microsoft SSIS
  • Share implementations of organizations that have successfully implemented said solutions.
Speaker Bio: Doug Wheaton is a CDC expert and has over 20 years of experience in the content, workflow management and data integration space. He has written numerous related articles and has presented at many Microsoft conferences, SQL Saturdays and user groups throughout the US on the topics of BI and data integration using Microsoft SSIS.



Title: ETL Head-to-Head: T-SQL vs. SSIS
Speaker: Tim Mitchell
Category: Advanced SSIS
Level: 300
Abstract: In this session, we'll compare ETL strategies between SQL Server Integration Services and plain old T-SQL. Is one better than the other? Should I just use SSIS and skip T-SQL altogether, or vice versa? We'll address these questions and more, and will take a look at some practical examples and a few head-to-head comparisons using both tools.
Session Goals
  • Attendees will gain an understanding of the role of Transact-SQL as part of an ETL strategy.
  • Attendees will gain an understanding of the logistical differences between using SSIS and Transact-SQL for ETL processing.
  • Attendees will learn, through practical demonstration, some situations that may be better served by Transact-SQL rather than SSIS (and the reverse).
Speaker Bio: Tim Mitchell is a business intelligence consultant, database developer, speaker, and trainer. He has been working with SQL Server for over 7 years, working primarily in business intelligence, ETL/SSIS, database development, and reporting. He has earned a number of industry certifications and holds a Bachelor's Degree in Computer Science from Texas A&M at Commerce, and is a Microsoft SQL Server MVP. Tim is a business intelligence consultant for Artis Consulting in the Dallas, Texas area. As an active member of the community, Tim has spoken at venues including numerous SQL Saturday events, Houston Tech Fest, and various user groups and PASS virtual chapters. He is a board member and speaker at the North Texas SQL Server User Group in Dallas, is co-chair of the PASS BI Virtual Chapter, and is an active volunteer for PASS. Tim is an author and forum contributor on SQLServerCentral.com and has published dozens of SQL Server training videos on SQLShare.com. You can read his blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.



Title: Integrating Change Data Capture with SSIS
Speaker: Chris Skorlinski
Category: Advanced SSIS
Level: 300
Abstract: Working together, Change Data Capture (CDC) and SSIS can identify changed data and move changes to your Data Warehouse. This session will focus on using SSIS package to pull daily, hourly, or near real-time Type I and Type II dimension changes from SQL Server running CDC.
Session Goals
  • Understanding of how SSIS package can be used to automate the extraction of SQL change data.
  • Walkthrough of how a simple SSIS package can be created to perform a complex task.
  • Provide familiarity to Change Data Capture technology.
Speaker Bio: Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/.  



Title: Real-time Data Integration
Speaker: Carlos Bossy
Category: Advanced SSIS
Level: 300
Abstract: This session will present a Database and ETL Architecture that allows you to smoothly move data from your application databases across the enterprise in real-time to your data warehouse. Use SQL Server features such as Replication, Change Data Capture, and SSIS to extract, transform and load data fast and dependably and view a real demonstration of the system in action.
Session Goals
  • Show live demo of real-time ETL.
  • Demonstrate how to setup Transactional Replication and CDC for use in a real-time environment.
  • Present techniques for using SSIS so that it can deliver data in real-time.
Speaker Bio: Carlos Bossy is a MCTS SQL Server 2008 Business Intelligence Developer with 25 years of experience in software and database development. Carlos is a consultant for his own company and focuses on developing Business Intelligence solutions including data warehouses, predictive analytics, data integration and reporting. He has been working with SQL Server for 10 years and is very enthusiastic about its powerful features, and enjoys speaking at events such as SQL Saturday conferences, local users groups and for IASA. He has developed data warehouses and business intelligence solutions for several industries and state agencies, including solar energy, manufacturing, education and social services.



Title: SSIS Data Flow Buffer Breakdown
Speaker: Eric Wisdahl
Category: Advanced SSIS
Level: 300
Abstract: This session will examine the different types of data flow components, execution trees, data buffers, performance metrics and logging mechanisms. In determining how the buffers are built and used, the developer will begin to understand if, how and why package performance will be impacted when new transformations or columns are added. The developer will further learn how to capture performance metrics to identifiably track these impacts. Finally, the session will take a look at the controls and effects of parallel package and parallel task execution.
Session Goals
  • Understanding of how the data flow data buffers are built and optimized.
  • Understanding of logging events useful for data flow buffer management.
  • Understanding of some of the controls and impacts for parallel execution.
Speaker Bio: Eric Wisdahl is a computer engineer working in the database field. He has held multiple positions in the insurance industry with a focus on Business Intelligence. Currently, he is working as a database administrator in a development role for an e-commerce company. Eric is a moderator on the MSDN SQL Forums, a volunteer for the PASS organization and a frequent speaker at SQL Saturday Conferences. Eric Wisdahl does not like writing about himself in the third person. It is kind of creepy.



Title: Using Script Task and Components in SQL Server Integration Services (SSIS)
Speaker: Michael Davis
Category: Advanced SSIS
Level: 300
Abstract: Mike will show you how to build script tasks in the control flow and Script components in the data flow of an SSIS package. If there is not a task in the toolbox that can do what you need, then a script task or component is used to complete these steps. Learn when to use them and when not to use them.
Session Goals
  • Learn how to build script tasks in the control flow of an SSIS package.
  • Learn how to build Script components in the data flow of an SSIS package.
  • Learn when to use Scripts and when to avoid them.
Speaker Bio: Mike Davis, MCTS, MCITP, is a Senior BI consultant at Pragmatic Works. He is an author of two Business intelligence books. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.



Title: Generating SSIS Packages
Speaker: André Kamman
Category: Advanced SSIS
Level: 400
Abstract: I had to import and process 100+ files for my latest project and wondered if there was a way to generate SSIS packages based on a repository table containing the rules. As it turns out, this can be done but the programming model is a bit awkward. The samples that you can find online are not always functional and debugging is difficult. I did get it to work though and will show you how I did it and what problems I ran into. After this session you will know how to generate packages that contain sources, destinations, cached lookups, derived columns, conditional splits, sorts, union all, etc. This session is not about the script component inside SSIS but about generating SSIS packages and programmatically reading and changing properties of existing packages. This session should also be useful if you're not a full blown developer but more of a DBA type. I'm a DBA and I got through this :-)
Session Goals
  • You will learn how to generate packages from scratch
  • You will learn how to batch change packages.
  • You will learn how the programming model works, so you have a starting point in case you want to build something that was not covered in my session already.
Speaker Bio: I'm a contractor based in the Netherlands. Working with SQL Server since version 6.5 I sometimes think that I have memorized Books Online by now and can do my work on autopilot. But usually even before my first cup of coffee something strange happens and I find myself searching for clues on Google. Besides being a co-founder and currently chairman of the Dutch PASS chapter, I'm also a SQL Server MVP

Analytics

Title: Building a Visual Vocabulary
Speaker: Tim Costello
Category: Analytics
Level: 100
Abstract: Data visualization is a hot topic. In this session we will cover two of the most common data visualization patterns: time series and Part to Whole analysis. We will discuss how to identify them, common problems, best practices and what visualizations work best for each.
Session Goals
  • At the end of this session the attendee will feel comfortable identifying these common data patterns and understand which data visualizations most effectively tell the story of the data in each scenario.
Speaker Bio: Tim is a business intelligence developer with InterWorks inc. in Dallas, Texas. Tim is passionate about data visualization and helping people realize new insights from their data through data visualization.



Title: Performance Management Scorecards - Building a process to achieve top performance
Speaker: Scott Schledwitz
Category: Analytics
Level: 100
Abstract: Performance Management relies on optimal performance from the repository. Understanding the requirements of the business user and applying it to the process and architecture guarantees a successful deployment. We will step through the delivery of a Performance Management/Balanced Scorecard solution beginning with the business requirements and applying it to our data model as well as the business intelligence tool used to create the front end.
Session Goals
  • Understand the difference between business intelligence and performance management.
  • Understand the requirements for a performance management/balanced scorecard solution from a business perspective.
  • Applying the requirements to the data model and scorecard front end.
Speaker Bio:  



Title: Bridging Predictive Analytics and Performance Management
Speaker: Eugene Asahara
Category: Analytics
Level: 200
Abstract:

Performance Management (PM) can take a quantum step forward in terms of value to an enterprise by applying a heavy dose of Predictive Analytics (PA) to the seemingly secondary PM object known as the Strategy Map. After a few years of PerformancePoint Server 2007 (PPS 2007), most information workers are now well familiar with PM concepts such as KPIs, Scorecards and Dashboards. The object of primary focus in PPS 2007 was the Scorecard which points out what needs attention. This is of great value since recognizing that there is a problem is half the battle. However, it doesn’t do much in assisting with a diagnosis or a treatment, which is the other half of the battle. Further development of the Strategy Map can be instrumental in advancing the capabilities of PM in assisting in the diagnosis and treatment for business problems. It is currently usually implemented as an alternate view of a scorecard, displaying the KPIs in a high-level cause and effect web of relationships. But if we expand upon the Strategy Map and drill deeper into how changes in one KPI affects other KPIs, the compelling world of assisting in diagnosis and treatment is opened. The problem we then run into is that mapping cause and effect to significant depths is a daunting task to say the least. However, Predictive Analytics can play a crucial role in easing the task by assisting with the discovery of cause and effect, validation of long-held assumptions, the automatic adjustment of the weights of the "rules", and provide a good guess of a cause’s effect in lieu of more precise information.

The real-life complexities of an enterprise mean that nothing is certain, rendering Strategy Maps alone appearing to be rather naive and at times almost worthless. The probabilistic "best guesses" provided by PA smoothes out the brittleness of the theories espoused by the Strategy Map. The bridging of PM and PA will result in a magnitude of increased value for PM and an explosion of the number of "species" of data mining models for PA. Further discussion of these notions can be found in my blog titled, Bridging Predictive Analytics and Performance Management.

Session Goals
  • How bridging the two data-driven technologies of Performance Management and Predictive Analytics yield a sum greater than its parts.
  • An overview of Predictive Analytics methodology, including “data prep”, which much like ETL for Data Warehouses, is where the majority of the effort lies.
  • An overview of tools to implement the concept of implementing an “advanced strategy map”.
Speaker Bio: Eugene Asahara specializes in high-end Analysis Services implementation and performance tuning, predictive analytics, and overall BI architecture. He has thirteen years of experience on the Microsoft BI stack; including one year on the SSAS product team and seven years as a Lead DB/BI Architect at Microsoft Consulting Services. He has trained hundreds of BI consultants at the 300+ level on deep aspects of SSAS and MDX and has been a speaker at numerous technical events such as TechReady. Aside from consulting on BI engagements by day Eugene develops bleeding-edge BI software by night. Many of his thoughts around BI and that bleeding-edge space can be found at www.softcodedlogic.com.



Title: Delivering BI to the Masses at Microsoft Using CBI: Top 10 challenges
Speaker: Sanjay Soni
Category: Analytics
Level: 200
Abstract: See a live demo of how Microsoft IT is delivering BI to the masses (30,000+ active users globally) at Microsoft using SharePoint 2010 and 2007, using Excel, PerformancePoint, SQL Server Reporting Services 2008 R2 and other Microsoft BI products. We will showcase and share technical details and best practices on how Microsoft IT has created a solution (as part of EDW strategy) to consolidate 100+ applications from 50+ business organizations in a single enterprise report catalog and a BI portal. We will also demonstrate how participants can build a solution like Microsoft CBI using a solution offering / SharePoint accelerator for external customers to create enterprise BI catalog where companies can deliver BI to the masses at their own enterprises.
Session Goals
  • How Microsoft IT, delivering BI to 30,000+ users, is using 100% Microsoft Business Intelligence products/solution.
  • Top 10 challenges and technical lessons learned while hosting BI as a service from IT for business and enabling self-service BI
  • Live demo of how BI solution can be utilized by external customers using various Microsoft BI products and solution.
Speaker Bio: Sanjay Soni is a BI Platforms Evangelist in the Microsoft IT BI Engineering.  He is an MCDBA, MCTS and specializes in Business Intelligence using MS technologies including Microsoft SQL Server Analysis Services, SharePoint BI, Reporting Services, PerformancePoint etc. Sanjay has authored and presented a variety of papers and sessions in last 12+ years at various BI conferences including TDWI, BI Conference, PASS, SQL Connections, SharePoint Conference and Tech-Ed with many of these papers published in SQL Server magazine as well as on various web sites including Microsoft.com, Technet etc.



Title: Predixion PMML Connexion™
Speaker: Eugene Asahara
Category: Analytics
Level: 300
Abstract: Although the OLAP side of Analysis Services is #1, the Data Mining side is not. There are many entrenched players particularly in the predictive analytics realm, SAS and IBM (with Cognos and SPSS) being the best examples. "R" may be dominant in a few years as it has captured the minds of today's academics. Predictive Analytics practitioners on the Microsoft BI Stack will very likely need to work with existing systems built on those platforms as well as analysts preferring those platforms. The problem is that these platforms require extensive training. That is, compared to Predixion Software’s predictive analytics offerings which include products for modeling, deploying, and querying. However, because developing a predictive analytics system can still be an intense endeavor even with tools that are easier to use, the ability to integrate existing models in a system based on the Microsoft BI Stack is crucial. Predictive Analytics consultants can take advantage of Predixion Software’s offerings and include existing models built on other platforms within the Microsoft BI stack using Predixion PMML Connexion™, Predixion PMML integration layer. PMML (Predictive Model Markup Language) is the XML markup language used as the standard for sharing data mining and predictive analytics models between various platforms and visualization tools.
Session Goals
  • Communicate the landscape of what to expect when engaging in a situation with existing data mining models that are not built using SSAS or Predixion Insight.
  • Introduce the syntax, usage, and value of PMML.
  • Demonstrate how to use Predixion PMML Connexion.
Speaker Bio: Eugene Asahara specializes in high-end Analysis Services implementation and performance tuning, predictive analytics, and overall BI architecture. He has thirteen years of experience on the Microsoft BI stack; including one year on the SSAS product team and seven years as a Lead DB/BI Architect at Microsoft Consulting Services. He has trained hundreds of BI consultants at the 300+ level on deep aspects of SSAS and MDX and has been a speaker at numerous technical events such as TechReady. Aside from consulting on BI engagements by day Eugene develops bleeding-edge BI software by night. Many of his thoughts around BI and that bleeding-edge space can be found at www.softcodedlogic.com.

Data Warehousing

Title: Business Intelligence: Decaffeinated Please!
Speaker: Jose Chinchilla
Category: Data Warehousing
Level: 100
Abstract: For many Database Administrators, Data Analysts and other IT and Business Professionals, Business Intelligence (BI) and Data Warehousing (DW) may be a new and uncharted territory with no clear path towards the destination. Others, who have already jumped head-on into the Business Intelligence journey, may be facing challenges that can potentially put their efforts at risk of failure. In this session attendees will learn some of the basic concepts that are key in understanding BI and DW. I will go over the need for Business Intelligence and Data Warehousing, its maturity stages, the Microsoft toolset for BI/DW and my 10 rules of wisdom for a successful BI solution intended as a roadmap to get you started in the right direction. I will also go over some of the common challenges, pitfalls and roadblocks and how to avoid them.
Session Goals
  • Understand how to implement a successful Business Intelligence and Data Warehousing solution by following a practical roadmap, methodology and my own 10 rules of wisdom for BI success.
  • Understand the roadblocks and pitfalls commonly encountered during the process of implementing a Business Intelligence solution, how to avoid them and get pass through them.
  • Identify the available Microsoft toolset at each of the three basic layers of a Business Intelligence solution.
Speaker Bio: Jose Chinchilla is a Microsoft Certified Database Administrator and Business Intelligence Developer working as a Business Intelligence consultant for Convergence Consulting Group. He has more than 12 years of experience in the Information Technology field and has held several positions including: Network Administrator, Database Administrator, and IT Manager. His latest career focus has been in the area of Business Intelligence, OLTP and OLAP database design and development. Jose specializes in building ETL/ELT frameworks, OLAP cubes, Data Warehouses and Multidimensional Analysis and Decision Support Systems using the Microsoft SQL Server 2005/2008 toolset. Jose has been involved in several Data Warehousing and Business Intelligence projects for small to medium sized organizations in local government, social services, educational services, retail and manufacturing. He is the current President of the Tampa Bay Business Intelligence User Group and Official PASS Chapter and is a regular speaker at SQL Server and Business Intelligence events such as SQL Saturday around the country. Jose blogs at www.sqljoe.com and is an avid twitterer under the alias of SQLJoe. Jose enjoys spending time with his wife and two girls at home in Tampa, FL.



Title: Near Real-Time Data Warehouse
Speaker: Patrick LeBlanc
Category: Data Warehousing
Level: 100
Abstract: Traditionally data warehouses are built, monthly, weekly, and sometimes daily. In today’s ever evolving and fast pace business environment the use of month old or even day old data is becoming less valuable. Company executives are looking for more up to date data to make faster and better business decisions. In this session Patrick LeBlanc and a co-host will explain how to build a complete Near Real-Time Data Warehouse solution using SSIS, SSAS, and SSRS. This is an interactive and demo-centric session so bring your laptop.
Session Goals
  • Explain Near realtime data warehouse needs
  • Develop SSIS package to Incrementally load data warehouse
  • Develop Incrementally loading SSAS cube
Speaker Bio: Patrick LeBlanc, SQL Server MVP and author, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes working in the Educational, Advertising, Mortgage, Medical and Financial Industries. He is also the founder of TSQLScripts.com, SQLLunch.com and the President of the Baton Rouge Area SQL Server User Group. Patrick is a regular speaker at various SQL Server community events, including SQL Saturday’s, User Groups and the SQL Lunch.



Title: Developing Date and Role-Playing Dimensions
Speaker: Sandra Mueller
Category: Data Warehousing
Level: 200
Abstract: Let's go from Cradle to Grave with the one dimension in 99.99999% of cubes, the dreaded Date dimension. Without this dimension users wouldn't know if it is worth staying open on a holiday or which day of the week the most fresh produce ships or even what their bonus will be. What should be included in the dimension? Should you use the wizard to generate? In this session, we will explore a generic date dimension load script and then configure SSAS to use the table as the time dimension. We will explore performance considerations of attribute hierarchies compared with usability benefits of user hierarchies. Finally, we will address the advantages of role-playing dimensions to make Order Date, Ship Date and Received Date dimensions.
Session Goals
  • Determine fields required for a custom time dimension and performance considerations for using a physical table in the data source over an auto generated resource.
  • Importing date dimension, configuring dimension type, attribute hierarchies (performance impact), and user hierarchies.
  • Understand the benefits and costs of role-playing dimensions and how to create one within cube (and when they will let you down).
Speaker Bio: Sandra A. Mueller started with Administration (via a programming job) in 1997 and moved into Database Design and performance optimization. She has always had a passion for sharing knowledge and trying to help others avoid the hard lessons she learnt. To this end she has been an MCT for 16 years, writing course ware, providing training and follow-on project consultation. In 2004 after an activation with the military her focus turned to SQL Server 2005 and its Business Intelligence (BI) capabilities. She is currently working as a BI Architect with SQL Server 2008R2 OLAP solutions. Sandra blogs on http://www.SandraAMueller.com. She recently started the Raleigh NC SQL Server BI User Group (http://www.tripassBI.org). She consistency speaks at SQL Saturday events and supports her local community by speaking, volunteering and attending regional chapters.



Title: Helping Your Data Warehouse Succeed: 10 Mistakes to Avoid in Data Integration
Speaker: Rafael Salas
Category: Data Warehousing
Level: 200
Abstract: You may have heard this: Data integration is the most difficult part of a data warehouse project. But, do you know why? Or better yet, do you know what could increase your chances of success? With data being the focal point of a data warehouse, its data integration component becomes a critical point of failure of the whole system, and to make matters worse, we, as developers, face increasingly complex scenarios and requirements such as larger number of systems and volumes of data, data quality problems and complex business logic. In this session Rafael will share a compilation of pitfalls and mistakes he has seen –and made!– across many implementations, and offers recommendations to avoid them. We will look at problems related to metadata, data quality, monitoring, system reliability and some SSIS specific issues among other common problems. And while this session won’t get you the magic formula for ETL perfection, it will get you one step closer in the right direction.
Session Goals
  • Identify common ETL and data integration pitfalls
  • Offer solutions and recommendations to avoid them.
  • Learn about good and no-so good practices around SSIS
Speaker Bio: Rafael is an accomplished professional with more than 12 years of experience helping Fortune 500 companies and public agencies to improve decision-making, financial management and customer engagement processes by harnessing the power of their data using Business Intelligence and data warehousing technologies. As Manager of Professional Services Consulting at Quaero, a CSG Solution, he provides technical leadership in BI and data warehousing architecture, data integration, OLAP, and Dimensional Modeling. Rafael is a Microsoft SQL Server MVP since 2007 and an active member of the SQL Server community. He speaks frequently at events such as SQL Saturdays, Code Camps and local users groups meetings, and is also an article author and blogger. www.rafael-salas.com



Title: The Fast Track Data Warehouse
Speaker: Randy Dyess
Category: Data Warehousing
Level: 300
Abstract: In this session you will learn about the Microsoft Fast Track solution and what it may mean to you. Attendees will gain a better understanding of what a Fast Track solution offers and how to begin their own Fast Track installation and avoid some of the misunderstandings when it comes to Fast Track installations.
Session Goals
  • Understand what a Fast Track solution is and how it may benefit you.
  • Understand tasks needed for successful Fast Track solution.
  • Understand how Fast Track databases are different than regular databases.
Speaker Bio: Bio Randy is mentor with Solid Quality Mentors and has a large variety of experiences dealing with SQL Server over the past 18 years and has worked with environments with Terabytes of data and environments that had over a 1000 databases with only a few megabytes of data in each database. Currently Randy specializes in training and mentoring with a focus on topics pertaining to performance tuning, SQL Server hardware infrastructure design and configuration, and SQL Server capacity planning. Randy is the author of TransactSQL Language Reference Guide, coauthor of MCTS Self-Paced Training Kit: Microsoft SQL Server 2005 Implementation and Maintenance (Exam 70-431) and numerous magazine and newsletter articles pertaining to SQL Server and has spoken at various international and national conferences. Randy blogs and maintains a website at www.SQLServerManagement.com.

Mining

Title: The Data Mining Lifecycle
Speaker: Carlos Bossy
Category: Mining
Level: 200
Abstract: Modern day computing power and SQL Server makes it possible to add sophisticated data mining models to our applications that forecast and predict, perform anomaly detection, and classify data. This presentation will demonstrate how to use Analysis Services by going through a live demo of the data mining lifecycle and to incorporate these complex algorithms seamlessly into your databases. Attendees will be shown how to create, train, test and deploy a data mining model using SSAS, how to use SSIS to query and load mining forecasts, and a sample web application that seamlessly uses a mining model. Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications...and learn how to win your fantasy football league and beat the stock market too!
Session Goals
  • Create a data mining model by going through the data collection, training, testing, and deployment processes.
  • How to incorporate a data mining model seamlessly within a web application that makes real-time predictions.
  • Use SSIS to load data while querying a data mining model to forecast the value of missing data.
Speaker Bio: Carlos Bossy is a MCTS SQL Server 2008 Business Intelligence Developer with 25 years of experience in software and database development. Carlos is a consultant for his own company and focuses on developing Business Intelligence solutions including data warehouses, predictive analytics, data integration and reporting. He has been working with SQL Server for 10 years and is very enthusiastic about its powerful features, and enjoys speaking at events such as SQL Saturday conferences, local users groups and for IASA. He has developed data warehouses and business intelligence solutions for several industries and state agencies, including solar energy, manufacturing, education and social services.



Title: Enterprise Data Mining for SQL Server Professionals
Speaker: Mark Tabladillo
Category: Mining
Level: 300
Abstract: This presentation presents SQL Server Data Mining (SSDM) for SQL Server Professionals based on the speaker's past presentations for SQL Saturday. Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business Intelligence Development Studio (BIDS), highlighting Integration Services, and PowerShell.  The interactive demos are based on Microsoft's Contoso Retail sample data. Finally we will evaluate where Microsoft data mining can help you in a practical business environment, which may include Oracle and SAS.
Session Goals
  • Analysis Services provides enterprise-level data mining support.
  • Enterprise Integration Services supports data mining queries.
  • People can implement data mining solutions without taking formal statistics or machine learning classes.
Speaker Bio: Mark Tabladillo provides consulting and training for data mining with Solid Quality Mentors. He has taught statistics at Georgia Tech and for the graduate business school of the University of Phoenix. In addition to his Microsoft certifications (MCT, MCITP, MCAD .NET), Mark has presented at many local, regional, and national technical conferences. Mark produces a data mining resource and blog at http://www.marktab.net



Title: Enterprise Text Mining with Analysis Services
Speaker: Mark Tabladillo
Category: Mining
Level: 300
Abstract: In this session we will look at text mining tools for document classification with Integration Services and DMX (Data Mining Extensions). Based on the speaker’s experience with several enterprise text mining projects, we will walk through a demo of Integration Services and Analysis Services aiding in document classification. Finally we will evaluate where Microsoft text mining can help you in a practical business environment, which may include Oracle and SAS.
Session Goals
  • Analysis Services provides enterprise-level text mining support.
  • Enterprise Integration Services supports text mining tools.
  • People can implement text mining solutions without taking formal statistics or machine learning classes.
Speaker Bio: Mark Tabladillo provides consulting and training for data mining with Solid Quality Mentors. He has taught statistics at Georgia Tech and for the graduate business school of the University of Phoenix. In addition to his Microsoft certifications (MCT, MCITP, MCAD .NET), Mark has presented at many local, regional, and national technical conferences. Mark produces a data mining resource and blog at http://www.marktab.net



Title: SQL Server Data Mining: Making $mart financial decision$ in weak financial markets
Speaker: Steve Simon
Category: Mining
Level: 300
Abstract: Over the past few months many financial houses have been severely ‘hit’ by the current slump in the subprime mortgage market. This has led to severe losses and considerable client liability. Many firms are now starting to take a serious look at the potential utilization of data mining techniques as part of their ongoing efforts to control their risk exposure. This beginner to intermediate level hands-on presentation is aimed at showing the attendee some of the ‘data mining’ prototypes solutions that we are currently developing with SQL Server 2005 / 2008, as a part of our ongoing efforts to manage our risk.
Session Goals
  • The attendee will be guided through the high level principles of data mining with an emphasis on financial solutions.
  • The attendee will see how certain types of data such as ‘gain/loss’ data have proved most useful when it comes to financial data mining solutions.
  • The attendee will see that these solutions and techniques CAN be ported and adapted to other business areas with a minimal amount of effort and time.
Speaker Bio:  

New Technology

Title: BI in the Cloud
Speaker: Tom Marek
Category: New Technology
Level: 200
Abstract: One of the next jumps to cloud computing will be Business Intelligence (BI). During this presentation we will showcase how Microsoft's Windows Azure platform can advance your organization's BI strategy to help you make full use of the on-premises data and analytical tools you rely on today to make critical business decisions, rapidly and accurately. We will also highlight some of the main features that combine your on-premises BI with the cloud during the demonstrations. The first round of adopters of BI in the cloud will have two major focus areas, the first being the usage of cloud services to create BI for a current cloud based application and the latter being an extension of on-premise data from either transactional or dimensional data. The two areas will be covered extensively to highlight ways this can be done and also show you the many ways to do each highlighting which path best suites your organization’s needs.
Session Goals
  • Showcase different ways an organization are able to use various Microsoft cloud based services to either have an entirely cloud based BI architecture or extend their current BI that is on-premise to the cloud.
  • Demonstrate the use of the full Azure toolset that can be used to create BI in the cloud, including SQL Azure, SQL Azure Data Sync, SQL Azure Reporting, Silverlight dashboards, and Office 365 Beta dashboards and KPIs.
  • Show ways to leverage the Windows Azure and Office 365 tools to extend your on-premise BI. This will include pulling data from OLAP cubes and demonstrating ways to use the power of your SSAS engine to provide data to a new visualization layers.
Speaker Bio: Tom Marek has over a decade of experience leading teams working on various database systems and web developments ranging from small, simple databases to extremely large systems based on heavy data analysis. The future is all about Business Intelligence and every company now has a number of databases and they would like better reports built  in order to analyze that data. Business Intelligence is the means to the result they are looking for and the technology is affordable to all in this day and age. Currently, Tom leads the BI/SQL team for Neudesic by helping manage thought leadership and development of intellectual property for use with clients and training of consultants. The position is focused on growing the entire practice across the nation, through partnerships and technical sales of our services. It also requires acting as a liaison between technical developers and CxO level clients to gather information on their business and help find ways to analyze it to make them more profitable and/or efficient.



Title: Developing an Information Governance Program using Master Data Services
Speaker: Patrick Gallucci
Category: New Technology
Level: 200
Abstract: In this session we will focus on developing an Information Governance Program and how this can be delivered with Microsoft Master Data Services. Listed below are some of the key factors to a successful Information Governance Program. This session will focus on how to deliver these concepts utilizing Microsoft Master Data Services and the Microsoft Office 2010 tools. • Accountability. Because of the ways in which information is captured--and how it flows across the enterprise, everyone has a role to play in how it is governed. Many of the most important roles are played by individuals fairly junior in the organization. They typically play a key role data capture stage and often cause--or see-errors on a first-hand basis. Certain individuals need to be dedicated to Governance. These roles are filled by senior executives such as the CIO, Information Architects, and Data and Content Stewards. • Efficient Operating Models. The Governance approach should define an organizational structure that most effectively handles the complexities of both integration and IM across the whole of the organization. Of course, there will typically be some degree of centralization as information flows across the business. However, this organizational model need not be a single, hierarchical team. The common standards, methods, architecture, and collaborative techniques so central to Governance allow this model to be implemented in a wide variety of models: physically central, virtual, or offshore.. • A Common Methodology. A Governance program should include a common set of activities, tasks, and deliverables. Doing so builds specific information management-based competencies. This enables greater reuse of artifacts and resources, not to mention increased productivity out of individuals. It also manifests the commonalities of different IM initiatives across the organization. • Standard Models. A common definition of terms, domain values, and their relationships is one of the fundamental building blocks of Governance. This should go beyond a traditional data dictionary. It should include a lexicon of unstructured content. Defining common messaging interfaces allows for easy inclusion of “data in motion.” Business and technical definitions should be represented and, just as important, the lineage between them easy to navigate . • Architecture. An IM architecture should be defined for the current-state, transition points, and target vision. The inherit complexity of this initiative will require the representation of this architecture through multiple views. Use of archite
Session Goals
  • Provide an understanding of Information Governance issues today.
  • Provide a Service Delivery Methodology using Master Data Services to address the Information Governance Issues of today.
  • Look at how to extend Master Data Services with Microsoft Office 2010 to empower your organization on the path to an Information Governance Program.
Speaker Bio: Patrick Gallucci is a Data Warehouse/Business Intelligence Architect, Consultant and Trainer with 18 years’ experience working with relational databases including Microsoft SQL Server, Oracle, DB2, Sybase and MySQL. Before leaving Microsoft in February of 2009, Patrick’s role as BI Associate Architect saw him working on multi-terabyte DW\BI Solutions with PepsiCo, Conoco-Phillips, Cisco, MTV, Showtime, ABC\Disney, CBS, Kohl’s, Aetna, Chase, Citibank, WAMU, Kaplan University and Qwest. He is also a Microsoft Certified Architect, DBA, Engineer and Trainer. Currently Patrick is the BI\SQL Regional Practice Director for Neudesic and is based out of their Dallas Office.



Title: New Reporting Features of SQL Server 2011
Speaker: Michael Davis
Category: New Technology
Level: 200
Abstract: Learn the new features of Reporting Services planned for SQL Server 2011 Denali
Session Goals
  • Learn how to use the new Features of SSRS 2011.
Speaker Bio: Mike Davis, MCTS, MCITP, is a Senior BI consultant at Pragmatic Works. He is an author of two Business intelligence books. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.



Title: SQL Server Code-Named “Denali”: Exploring the Enterprise Data Integration & Management (EDIM) Promise
Speaker: Rafael Salas
Category: New Technology
Level: 200
Abstract: ETL, Data Quality and Master Data Management address issues related to data acquisition, standardization and improvement. In SQL Server Code-Named “Denali” with the introduction of Data Quality Services and the concept of Enterprise Data Integration & Management (EDIM) these 3 areas seems to come together; just like bread, peanut butter and jelly. But are the new tools ready for prime time? Do they overlap with existing tools? Do they integrate seamlessly? In this session, we will explore the concepts under EDIM cover, look at the capabilities of the new Data Quality Services (DQS), and review the most significant improvements in SQL Server Integration Services (SSIS) and Master Data Services (MDS) available in the latest Community Technology Preview (CTP).
Session Goals
  • Introduce attendee to EDIM concepts
  • Explore and demo SSIS, DQS and MDM new capabilities in SQL Server code-named "Denali"
Speaker Bio: Rafael is an accomplished professional with more than 12 years of experience helping Fortune 500 companies and public agencies to improve decision-making, financial management and customer engagement processes by harnessing the power of their data using Business Intelligence and data warehousing technologies. As Manager of Professional Services Consulting at Quaero, a CSG Solution, he provides technical leadership in BI and data warehousing architecture, data integration, OLAP, and Dimensional Modeling. Rafael is a Microsoft SQL Server MVP since 2007 and an active member of the SQL Server community. He speaks frequently at events such as SQL Saturdays, Code Camps and local users groups meetings, and is also an article author and blogger. www.rafael-salas.com



Title: SQL Server Parallel Data Warehouse - Under the Hood
Speaker: Brian Mitchell
Category: New Technology
Level: 300
Abstract: Parallel Data Warehouse is a complex product that is often misunderstood. This session will go deeper into PDW architecture than in previous sessions. Primarily through the use of demos the attendees will be exposed to the PDW service and how it interacts with multiple compute nodes to provide superior performance. The session's reliance on demos will allow the attendees to understand PDW in concrete terms what is usually described in abstract terms. We will spend a good deal of our time examining the tools in PDW available to the DBA to manage this complex appliance.
Session Goals
  • The attendees will get a firm understanding of how PDW is architected from the ground up using technologies familiar to them.
  • The attendees will be exposed to the additional DMV's added to PDW to
  • The attendees will understand how to use the administrators console to quickly understand complex parallel query plans.
Speaker Bio: Brian Mitchell is a MCM - SQL 2008, with a MBA from the University of Florida. In his current position at Microsoft, he is a Senior Premier Field Engineer dedicated to the support of SQL Server Parallel Data Warehouse. Brian has extensive experience creating and delivering advanced training for the full range of the Microsoft BI stack. Specifically, he has great passion for Analysis Services and Reporting Services. Additionally, Brian has spent countless hours onsite at customers delivering proactive and reactive support on the whole range of SQL Server products. Brian previously contributed at SQLSaturday, SQL Server User Groups, and Code Camps.

Sharepoint/PowerPivot

Title: A Year of Living Dangerously, PowerPivot Lessons from the Field
Speaker: Barry Ralston
Category: Sharepoint/PowerPivot
Level: 100
Abstract: Someone once said "Good judgement comes from experience and experience comes from bad judgement". Attend this session to hear some of the lessons learned after a year of using PowerPivot (for Excel and SharePoint) in the field, with customers and live-fire data. We will discuss maxing out a multi-million dollar Teradata installation, nuances (dare I say features) within the user experience and other bits of knowledge gathered over the past year as we look forward to the next release.
Session Goals
  • Understand limitations on the initial release of PowerPivot for Excel and PowerPivot for SharePoint. Especially as this relates to data volumes and user experience. Define the limitations of user interface design with PowerPivot for Excel.
  • Share the best practices for creating a development environment for PowerPivot for SharePoint solutions. Advantages, disadvantages of virtualization, bootable VHD, Hyper-V, etc.
  • Understanding the data modeling challenges with the initial release of PowerPivot. Including many-many relationships, multi-column keys and other work-arounds.
Speaker Bio: Barry Ralston is Chief Architect for Business Intelligence with Birmingham-based ComFrame Software. Barry is also Microsoft’s Virtual Technical Specialist (VTS) for Business Intelligence, responsible for assisting in Alabama, Mississippi and Northwest Florida sales efforts including customer meetings, software demonstrations and Proof of Concept efforts. Barry’s client successes include: ACIPCO, Georgia Tech Research Institute, Bank of Hawaii, Honda Manufacturing of Alabama and Aflac.



Title: Business Intelligence dashboards with MS Excel, Excel OLAP formulas, and Share Point
Speaker: Phillip E Rosen
Category: Sharepoint/PowerPivot
Level: 200
Abstract: I will demonstrate how to develop MS Excel BI Dashboards in the following ways:
1. Workbook style with Office data connections stored on local PC or networked document drive
2. excel services style using Reports Library SP 2007 for storage of the Office data connections & workbook that excel services will render
3. Convert excel pivot table into excel OLAP formulas
4. Discuss SP 2010 BI Center
5. Discuss references to cap off session.
Session Goals
  • Attendees will understand and be able to create BI dashboard workbooks with excel 2007 which are connected to SSAS data cubes via ODC and store the ODC on local PC/data connections folder. They will also be able to develop excel services dashboards.
  • Convert excel pivot table into excel OLAP formulas for use in BI dashboard grids and charts
  • Compare and contrast SP 2007 Reports Library and SP 2010 BI Center then discuss references to cap off session.
Speaker Bio: Phillip E. Rosen is a Business Intelligence (BI) Developer who lives in the Miami, Florida area where he retired from the United States Marine Corps after 20 years of arduous service around the globe, combat tours in Operation Desert Storm 1991, Operation Iraqi Freedom 2004. He is a service disabled veteran who is employed as a virtual civil servant with the Department of Veteran’s Health Administration (VHA) based in Reno, Nevada. Phil conducts local and virtual training events/sessions for VHA BI developers & employees about SQL Server 2008R2 Reporting Services, T-SQL queries, performance tuning and dashboards that are connected to analysis services data cubes. He has 3 years of experience developing BI dashboards using MS Excel which are rendered in Share Point Excel Services and as Excel workbooks for executive leadership to make efficient & timely decision about finical, personnel staffing, and budgeting. Phillip has a wide range of BI experience with SQL Server as an accidental database administrator/developer of an instance of Microsoft SQL Server 2008 managing, maintaining, and updating it. His daily duties/responsibilities require the use of SQL Server 2008R2 client tools; Visual Studio 2008 Business Intelligence Development Studio (BIDS) and SQL Server Management Studio writing Transact-SQL (T-SQL) queries to develop ad hoc and custom reports. Phil enjoys discussing and learning about MS BI, applications & tools.



Title: Business Intelligence Solutions with PowerPivot for Excel and SharePoint
Speaker: Barry Ralston
Category: Sharepoint/PowerPivot
Level: 200
Abstract: PowerPivot represents a disruptive shift in capabilities for delivering self-service Business Intelligence solutions. Combining advances in SQL Server Analysis Services with a true enterprise monitoring and upgrade path, PowerPivot presents a unique prototype to deployment route. The objective of this session is to share with attendees a sample of the broad range of features that comprise PowerPivot for Excel and PowerPivot for SharePoint and how they can be applied to create self-service Business Intelligence solutions. Using both lecture and software demonstration, this session will prepare attendees to use PowerPivot for Excel immediately.
Session Goals
  • The primary user story for a PowerPivot for Excel solution. Combining large, disparate yet related sets of data using SSAS in-memory runtime, on a typical desktop computer.
  • How to get PowerPivot for Excel. A tour of the routine functions to get, related and report data.
  • How PowerPivot for SharePoint, through both the PowerPivot Gallery and the PowerPivot Management Dashboard, creates a path to enterprise migration of these solutions.
Speaker Bio: Barry Ralston is Chief Architect for Business Intelligence with Birmingham-based ComFrame Software. Barry is also Microsoft’s Virtual Technical Specialist (VTS) for Business Intelligence, responsible for assisting in Alabama, Mississippi and Northwest Florida sales efforts including customer meetings, software demonstrations and Proof of Concept efforts. Barry’s client successes include: ACIPCO, Georgia Tech Research Institute, Bank of Hawaii, Honda Manufacturing of Alabama and Aflac.



Title: Business Intelligence with SharePoint 2010 and PowerPivot
Speaker: Jen Underwood
Category: Sharepoint/PowerPivot
Level: 200
Abstract: This presentation covers SharePoint 2010 Business Intelligence technologies and new features including: - New Chart Web Part - Business Intelligence Center and PerformancePoint Dashboards - Simple KPIs and Status Lists - Visio Services Visualizations - Reporting Services and Report Builder - PowerPivot and the Management Dashboard - Business Connectivity Services (former BDC) A wide variety of live demonstrations on where to configure the features in SharePoint and how to use them will be shown. In addition, lessons learned and installation tips will also be shared.
Session Goals
  • Introduce Business Intelligence features in SharePoint 2010
  • Demonstrate usage of the new features
  • Share installation and configuration tips from field implementations
Speaker Bio: Jen Underwood has over 15 years of database and reporting solution experience specializing in the Microsoft platform. Career highlights include global military, retail, financial, healthcare and supply chain industry projects for well-known clients including the Department of Defense, Bloomberg, Walmart and Teradata. She participated in Microsoft TAP programs for Microsoft SQL Server 2008 R2, PowerPivot and SharePoint 2010. She is actively involved in local SQL Server user groups and has presented at multiple, regional SQLPASS events in Georgia, Florida and California. She has a Bachelors degree in Business Administration and post-graduate certification in data mining.



Title: Creating and Using Pivot Tables/Cubes Using 3 Microsoft Tools
Speaker: Michael Antonovich
Category: Sharepoint/PowerPivot
Level: 200
Abstract: This session begins with a simple SQL database consisting of several related tables. It begins with a simple example of using the TSQL PIVOT command using both a static and a dynamic example. It then uses the same tables with Excel together with PowerPivot to create a Pivot Table and Pivot Chart. Finally, as a third method to create Pivot Tables that users can manipulate to see different slices of data, I will demonstrate how easily you can work with those same tables to create a simple cube in Analysis Services. Finally, if time permits, you will see how easy it is to publish those Excel Pivot Tables and Pivot Charts into SharePoint using Excel Services to protect the calculation methods while allowing anyone with a browser to view and use the pivot table.
Session Goals
  • To show you can use multiple Microsoft products to create pivot tables and charts in both Excel with PowerPivot and SQL Server Analysis Services.
  • Provide an introduction to PowerPivot with Excel
  • Provide an introduction to creating cubes with SQL Server Analysis Services.
Speaker Bio: Mike Antonovich is the Assistant Director of Web Applications for Orange County Public Schools in Orlando, FL where he manages the SharePoint portal team implementing the Internet, intranet, collaboration, project, team, and school sites. They are also responsible for multiple .NET custom applications used around the district. In June of 2010, he published his 7th book: Office and SharePoint 2010 User's Guide. Mike first got involved with database development during dBase II but soon gravitated to FoxBase and subsequently FoxPro.  In 1998, Mike switched to SQL Server and has worked with all of the versions from SQL Server 6.5 to Denali.  Since 2007 he has moved into SharePoint and most recently has developed a strong interest in BI and the many ways that Microsoft is supporting BI in all of its tools..



Title: Dashing Dashboarding
Speaker: Sandeep Khandelwal
Category: Sharepoint/PowerPivot
Level: 200
Abstract: SQL Server 2008 data warehousing tools are great. Complement your data warehouse by giving it a perfect partner, a presentation layer that will be loved and adopted by people at all levels. In this session you will learn on how to create interactive and live dashboards using Scorecards, Charts, KPIs, Reports and other BI tools available in SharePoint 2010. The session is geared towards Developers and Architects looking to leverage Performance Point (remember ProClarity), Reporting Services, Excel Services and Visio to provide rich interactive charts and build that platform which adds value to your data warehouse.
Session Goals
  • Highlight the importance of SharePoint 2010 and its effectiveness in delivering rich data.
  • Understand what Excel Services and Performance Point can do for your data warehouse.
  • Basic understanding of overall collaboration tools in SharePoint.
Speaker Bio: Sandeep has been working with SharePoint since early days of STS (SharePoint Technology Services). He specializes in implementing medium to large scale SharePoint farm, creating custom solutions using InfoPath form & Workflow, building BI dashboards using PerformancePoint, Excel Services and Reporting Services, integrating LOB applications with SharePoint and migrating Lotus Notes databases to SharePoint. Also, whenever time permits, Sandeep presents at SharePoint conferences and local SharePoint users group.



Title: EPM using SQL Server and SharePoint
Speaker: Daniel Evans
Category: Sharepoint/PowerPivot
Level: 200
Abstract: Learn how to develop an Enterprise Performance Management solution using SharePoint 2010 and SQL Server 2008 R2. Utilize the most recent offerings from Microsoft including PowerPivot and Reporting Services to give an integrated, scalable BI platform for those interested in deploying Microsoft solutions.
Session Goals
  • Learn what Enterprise Performance management is an why it is important for a BI solution
  • See what Microsoft components support an overall Enterprise Performance Management solution
  • See how the complete Microsoft BI stack can be leveraged to provide an EPM solution
Speaker Bio:  

SSAS/MDX

Title: Performance Tuning Analysis Services
Speaker: Devin Knight
Category: SSAS/MDX
Level: 200
Abstract: In this session, you will learn how to split your measure group data in to more manageable pieces using partitions. Then designing aggregations on your partitions will be discussed including how to create aggregations using Usage Based Optimization (UBO) to speed up query time. Lastly, Devin will walk you through other alternatives for Performance Tuning like Cache Warming and better cube design.
Session Goals
  • Understand use for Partitions and Aggregations
  • Understand how to better design a cube and dimensions for performance
  • Understand how to design a Cache Warming SSIS package cache MDX queries
Speaker Bio: Devin is a Senior BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the books Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services, Knight's Microsoft Business Intelligence 24-Hour Trainer and a soon to be released SharePoint BI book. Devin has spoken at past conferences like PASS, SQL Saturdays and Code Camps. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is the Vice President of the local users’ group (JSSUG).



Title: Unlocking the Mystery of MDX
Speaker: Bryan Smith
Category: SSAS/MDX
Level: 200
Abstract: Despite widespread adoption of Analysis Services, the MDX query language remains a bit of an enigma. It’s not until a very simple but seldom explored concept is understood that the power and elegance of the language is revealed. Join Bryan Smith, co-author of Microsoft SQL Server 2008 MDX Step by Step, in exploring this central concept, providing a foundation for your success with the MDX language.
Session Goals
  • Learn the fundamental concepts behind MDX
Speaker Bio: Bryan is a Database Technology Specialist with Microsoft in Dallas, TX. Prior to his current role, Bryan served as a consultant and trainer with Hitachi Consulting, assisting a variety of customers in designing, implementing, and supporting Business Intelligence solutions. He is co-author of several books on Microsoft technologies including Microsoft SQL Server 2008 Analysis Services Step by Step, Microsoft SQL Server 2008 MDX Step by Step, and Professional SQL Server 2008 Reporting Services.



Title: Currency Conversion (and More) in Analysis Services
Speaker: Christian Wade
Category: SSAS/MDX
Level: 300
Abstract: Want to learn more about Analysis Services and MDX? This session covers numerous features in Analysis Services (2005 to 2008 R2) including dimension/cube design, measure expressions, MDX scripting and the Business Intelligence Wizard. It is all tied together to discuss and apply the options available for currency conversion. Leave the session understanding some of the nuances of Analysis Services to get the most out of your OLAP implementation.
Session Goals
  • Gain understanding of: Types of Currency Conversion, Many-to-many dimensions, Time dimensions, Semi-additive measures, Measure expressions, MDX query authoring and optimization, MDX scripting, The Business Intelligence Wizard
Speaker Bio: Christian Wade is a senior consultant specializing in Microsoft BI solutions. He is from the UK and has been working in an oil field in the Californian desert for over 4 years. He spoke for the San Francisco SQL User Group in 2009, the PASS 2005 Community Summit in Dallas and the 2005 European PASS Conference in Munich, Germany.



Title: Enterprise Class Analysis Services Development
Speaker: David Darden
Category: SSAS/MDX
Level: 300
Abstract: SSAS is one of the most popular tools for OLAP, but many organizations experience challenges when attempting to use their standard development best practices with the tool. This session will cover many topics around enterprise development practices for SSAS, including how to effectively use source control with multiple developers, enable robust automated build/deployment strategies, implement usage monitoring and tracking solutions, and support unit testing for SSAS solutions.
Session Goals
  • Demonstrate how to use source control with multiple developers.
  • Show techniques to automate builds and enable robust deployment strategies.
  • Review strategies for robust monitoring of multiple SSAS deployments for development, administrative, and business purposes.
Speaker Bio: David Darden is a software engineer specializing in enterprise reporting & analytics, data warehousing and performance management solutions. David has over 10 years' experience in software development including design, architecture, development, quality assurance, and project management using a variety of technologies. 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 industries. David has spoken at PASS several years, as well as presenting at a number of regional events. David has worked as a consultant at various Fortune 50 and Fortune 100 companies and has been a developer at Microsoft. David is currently the senior BI engineer at Big Fish Games, the #1 leader in casual online gaming.



Title: The Dirty Dozen: 12 ways to write poorly performing MDX queries
Speaker: Steve Simon
Category: SSAS/MDX
Level: 300
Abstract: OLAP cubes have become an important means of delivering valuable information from complex data within the Corporate Data Warehouse. Adequate information helps the corporate decision makers take the necessary steps to ensure that the enterprise is heading in the correct direction, especially in the tough and turbulent economic times. This is certainly true within the realm of the financial and portfolio management world, which has been under the microscope for the past 18 months. This beginner’s to intermediate level hands-on presentation is aimed at showing the attendee some of the pitfalls of poorly designed and poorly performing MDX queries and how many of the queries may be optimized to ensure that they are both efficient and effective. Through a series of Befores and Afters, the attendee will see how we have managed to improve the performance our queries and learn of some of the "Gotchas" that we encountered along the way. Optimally efficient and effective MDX queries help our end users obtain the information necessary for corporate decision making. This in turn helps them ‘work smartly’ and helps the enterprise achieve its corporate goals and mission statement.
Session Goals
  • The attendee will be shown several pitfalls that one can encounter with poorly designed and poorly performing MDX queries.
  • The attendee will be shown how many of the queries may be optimized with simple design changes and a bit of thought.
  • The attendee will be shown the methodology that we have instituted to ensure that we get things right, the first time around.
Speaker Bio:  

SSIS

Title: (SSIS, TSQL and MDS) - Record Linkage(Fuzzy Matching) Advanced Implementations
Speaker: Ira Warren
Category: SSIS
Level: 100
Abstract:

We will implement several code samples based on a series of articles and posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSIS and MDS). There are many facets to review. I would like to start by drawing concepts from several articles from experienced practitioners, either from academia or the commercial market. They will be footnoted at the end of the session. Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms. For this post, we will focus on the pragmatic steps required to accomplish identifying the relationships between records, and address how these steps fit into an overall data governance and data quality of MDM architecture. We will review real world implementations of several hundred million records. The steps required are shown here in a basic diagram: The steps are as follows:
1. Cleansing and standardization
2. Group records
3. Split records
4. Compare records and determine scores
5. Split into separate match categories
6. Analyze results of matches
7. Evaluate using match tools to determine if best algorithms have been combined.
We will then implement this approach in TSQL and SSIS as well as explore the use of Fuzzy Matching in MDS.

Session Goals
  • Teach Best Practices for Record Linkage and Fuzzy Matching Referecnce to leading Academics William Winkler Chief Researcher US Census
  • Teach Advanced SSIS, VB, MDS and TSQL Code samples for Fuzzy Matching
  • TSQL Functions , SSIS Script Components, SSIS Fuzzy Transforms
Speaker Bio:  Over 35 years experiences in Software Development, IT Management and BI Architecture.



Title: SSIS Configurations, Expressions and Constraints
Speaker: Eric Wisdahl
Category: SSIS
Level: 100
Abstract: This session will look in depth at some of the more powerful aspects of Integrations Services: Expressions, Package Configurations, and Precedence Constraints. With a greater knowledge of these skills the developer will be in a better position to ensure that packages can be promoted across environments without modification, to use the control flow engine to conditionally execute tasks and to dynamically set object properties.
Session Goals
  • The developer will be able create more flexible packages which can leverage the SSIS control flow engine through precedence constraints.
  • The developer will have learned the types of package configurations and how these configurations can be used to promote packages across environments without modification.
  • The developer will have learned what SSIS Expressions are and where it is that these expressions can be used to enable dynamic values for package properties.
Speaker Bio: Eric Wisdahl is a computer engineer working in the database field. He has held multiple positions in the insurance industry with a focus on Business Intelligence. Currently, he is working as a database administrator in a development role for an e-commerce company. Eric is a moderator on the MSDN SQL Forums, a volunteer for the PASS organization and a frequent speaker at SQL Saturday Conferences. Eric Wisdahl does not like writing about himself in the third person. It is kind of creepy.



Title: Cool Tricks to Pull from your SSIS Hat
Speaker: Julie Smith
Category: SSIS
Level: 200
Abstract: SQL Server Integration Services--Variables, For Each Loops, and the SSIS Expression Language. This presentation is geared toward the developer who is relatively new to SSIS, has mastered the basics of the dataflow, and is now looking for elegant ways to automate his/her solutions. It introduces essential components to sophisticated ETL design. The presentation demonstrates several uses of variables, types of variables (including the SSIS workhorse ado.net object), and various ways to populate them. The session will also cover the basics of the SSIS Expression language. This session is demo intensive, using three case studies of real business problems.
Session Goals
  • Attendee should know by the end of the session how to: 1. Create a variable. 2. Understand and use the variables window. 3. Understand variable scope.
  • Understand various ways to dynamically populate a variable. 1. Through an Execute SQL Task 2. Through an SSIS Expression 3.Through the properties of a For Each Loop Task
  • Learn two ways to manage your control flow. 1.Through precedence constraints and 2.Through the "Disable property" of a task.
Speaker Bio: Julie Smith works as a Business Intelligence consultant for Key2 Consulting, LLC in Atlanta, GA. She has implemented increasingly complex ETL solutions for over a decade at various financial institutions and call centers. In addition to Business Intelligence Solutions she has worn many other Database “hats” in her career: Production DBA, Database Development, and Data Modeling, but ETLs are her true passion. She is an MCP in SQL Server 2000 and holds a Bachelor of Arts Degree from the University of South Carolina. She and Audrey Hammonds co-created The Datachix Blog located at http://datachix.com



Title: Dirty Data? Clean It Up!
Speaker: Tim Mitchell
Category: SSIS
Level: 200
Abstract: Dirty data is everywhere, and it's headed for a database near you. Extraction, transformation, and loading (ETL) can be difficult, but often the most challenging component of that process is the validation and clean up of data. Information must be cleansed in such a way that it retains its original message and business value, while conforming to the expectations of the destination system(s). In this session, we will discuss some of the high-level challenges of dealing with dirty data, along with some infrastructure-agnostic recommended practices for doing so. Further, we will dig in and get our fingernails dirty (pun intended) on some specific ways that SQL Server and SSIS can be used to cleanse incoming data.
Session Goals
  • Attendees with gain an understanding of what is classified as "dirty data", and why all data should be considered dirty until proven otherwise.
  • Attendees will learn about some of the challenges present in working with dirty data, along with high-level strategies for cleansing suspect data for production use.
  • Attendees will learn practical ways to integrate and cleanse dirty data using SQL Server and SSIS.
Speaker Bio: Tim Mitchell is a business intelligence consultant, database developer, speaker, and trainer. He has been working with SQL Server for over 7 years, working primarily in business intelligence, ETL/SSIS, database development, and reporting. He has earned a number of industry certifications and holds a Bachelor's Degree in Computer Science from Texas A&M at Commerce, and is a Microsoft SQL Server MVP. Tim is a business intelligence consultant for Artis Consulting in the Dallas, Texas area. As an active member of the community, Tim has spoken at venues including numerous SQL Saturday events, Houston Tech Fest, and various user groups and PASS virtual chapters. He is a board member and speaker at the North Texas SQL Server User Group in Dallas, is co-chair of the PASS BI Virtual Chapter, and is an active volunteer for PASS. Tim is an author and forum contributor on SQLServerCentral.com and has published dozens of SQL Server training videos on SQLShare.com. You can read his blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.



Title: Handling XML Datasource Problems with the XML Task
Speaker: Russel Loski
Category: SSIS
Level: 200
Abstract: SQL Server Integration Services provides an XML Datasource to extract data from XML documents. This datasource works well for simple XML files, but has problems with some common XML structures. For example, the XML Datasource has problems with multiple XML namespaces. Also, the XML Datasource is clumsy working with deep XML hierarchies. This session will explore how to use the XML Task to handle issues like these XML problems. At the end of the session the attendees will be able to import these more complex XML document after applying simple XSLT (XML Style sheet) transformations to their XML documents. They will be able to extract information from the root node of their documents. This session will review briefly how to use the XML Datasource. We will extract data from an XML document that is a list of one element. Next we will look at how to extract data from a hierarchically structured document. This involves using the Merge Join transformation to merge the different outputs that SSIS produces. After this introduction, we will look at a couple problem cases. We will introduce a second XML namespace to the document. The XML Datasource will not be able to process that file. To extract the document, we will preprocess the document using the XML Task using a simple XSLT stylesheet to remove the namespace prefix from all of the node names. Then we will import the data using this revised XML form. Then we will try importing a complex, multilayered XML document. To do this in the Dataflow, it is necessary to merge multiple outputs together. This involves several other steps. To simplify the XML that we need to process, we build an XSLT stylesheet to flatten the data structure. The resulting structure is much easier to process in the Dataflow
Session Goals
  • Introduce the attendees to extracting data from an XML Datasource
  • Provide sample XSLT stylesheet templates that attendees can extend for their own projects
  • Suggest additional uses for the XML Task in an ETL process.
Speaker Bio: Russel came into software development from an unlikely career. He was working as a linguist, constantly creating scripts to move language data from format to format. He realized that he enjoyed the simple programming much more than the discipline of natural language research. He had the opportunity to work on a linguistics research database project where he learned basic SQL as well as basic database design.  That launched his career as a database developer and he began working with different companies to migrate their Access database backends to SQL Server.  This involved learning DTS, including some DTS scripting. In 2003, he moved to contract development and has had the opportunity to work on projects with the Dallas Cowboys and T-Mobile as well as smaller clients such as Rave Motion Pictures. He especially enjoys understanding the data needs of an organization and finding the data that meets those needs.  The topping is figuring out how to actually move that data.



Title: Intermediate SSIS Development
Speaker: Jeremy Walker
Category: SSIS
Level: 200
Abstract: In this presentation, Kyle and Patrick will dig a little deeper into SSIS, and explore some intermediate level developing methods, including package configurations, using the expression language within SSIS, as well as go over the commonly overlooked tool, Checkpoints, that can save the developer from having to do restart a time consuming package from the beginning. For each topic, we’ll begin with how the feature works, and then move into the steps one would take to set up Configurations, Expressions, and Checkpoints in a package. You will also see a demonstration of each feature in action from start to finish.
Session Goals
  • Understand the purpose of configurations and the different ways to implement them.
  • Understand how expressions work and the unique language you need to know to create them within your SSIS package.
  • Understand the purpose of Checkpoints, how they work, how to use the feature, and how beneficial they can be while developing in SSIS.
Speaker Bio: I am a business intelligence consultant working for Pragmatic Works Consulting. I have a primary focus in SSIS and Data Warehouse development. I also have experience with SSRS and Crystal Report with Business Objects.



Title: Loading a Data Warehouse in SSIS
Speaker: Devin Knight
Category: SSIS
Level: 200
Abstract: In this session, you’ll learn how to load a data warehouse using SQL Server Integration Services (SSIS). Devin will first cover the terminology to be expected when creating and loading a data warehouse. Then, you’ll learn the benefits and pitfalls of using the Slowly Changing Dimension transform (SCD Wizard) in SSIS and some alternatives to speeding up the load. Lastly, he’ll cover how to load the fact table.
Session Goals
  • Understand key Data Warehouse terminology
  • Understand native SSIS tools used for loading a Data Warehouse
  • Understand alternative ways to load a dimension table to increase performance
Speaker Bio: Devin is a Senior BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the books Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services, Knight's Microsoft Business Intelligence 24-Hour Trainer and a soon to be released SharePoint BI book. Devin has spoken at past conferences like PASS, SQL Saturdays and Code Camps. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is the Vice President of the local users’ group (JSSUG).



Title: Variables, Expressions, and XML Configs, Oh My!
Speaker: Brandie Tarvin
Category: SSIS
Level: 200
Abstract: Using variables, expressions, and XML config files in SSIS shouldn't be a grand Hollywood production. In fact, it's easier than most people realize. The issue comes down to knowing the syntax and understanding how SSIS looks at these elements. Brandie will walk through the use of all three elements, demonstrating how variables can be used to control the direction of your package, how expressions can be used to reconfigure values or file names, and how XML config files can bring these elements together for a no-fuss, no-muss, multi-server environment. Bring your laptop (not required), with the Adventure Works database installed, and follow along with the fun. By the time this sessions is over, you'll be able to use all three elements with confidence, no matter what the situation.
Session Goals
  • Teach the use of SSIS variables
  • Teach the use of SSIS Expressions, both with and without variables
  • Teach the creation of XML config files, how to pick components for it, and how to use it with Variables and Expressions.
Speaker Bio: Database Administrator by day and Author by night Brandie Tarvin sails pirate-populated waters, fights evil robots in disguise and turns kingdoms into chaotic rebellious city-states all while coding ETL processes and protecting real-world data from corruption. If it weren't for her, someone else would have the job and where would be the fun in that? Brandie's first computer experience was with a State-of-the-Art Commodore 64 brought home by her father, who informed her that "computers are NOT toys" and would not let her use it until she learned how to program. In late 2003, she turned her hobbies of programming, MUSHing and assisting friends with generic tech support into a full time career as a database administrator. She's been stuck in the fabulous and bizarre world of professional IT work ever since. Currently, Brandie is a Database Administrator & Developer for Allstate Dealer Services in Jacksonville. She has published several articles on SQLServerCentral.com, trains her co-workers in SQL Server, and has previously presented at several SQL Saturday events and JSSUG meetings. She also writes fiction and freelances for Catalyst Game Labs in her spare time.

SSRS

Title: Choose Your Own (Reporting) Adventure – SSRS Survivor Series
Speaker: David Stein
Category: SSRS
Level: 100
Abstract: Create a story of guided analytics using Reporting Services drill down, drill through, and expressions. Sure, you may be using drill down already, but I’ll show you how to make the most of Reporting Services interactions, and more importantly how to avoid becoming dragon chow at the end.
Session Goals
  • Participants will understand and be able to perform SSRS techniques such as drill down and drill through.
  • Participants will gain insight regarding innovative uses of sub reports, parameters, and expressions
  • Participants will understand how to combine these techniques to create more interactive and effective guided analytic experiences in Reporting Services.
Speaker Bio: David Stein is a SQL Server Business Intelligence DBA specializing in designing, developing, and maintaining Data Warehouses using Microsoft BI Tools.



Title: The Power of Parameters - SSRS Survivor Series
Speaker: David Stein
Category: SSRS
Level: 100
Abstract: Want to know the best techniques to help your user narrow their search in the most efficient ways possible? Come watch me demonstrate which parameter techniques are best for certain situations and field types. Real world problems and applications are stressed, and I’ll demonstrate why some commonly accepted methods simply do not work and should be avoided.
Session Goals
  • Participants will empowered to choose effective SSRS Parameters settings based upon user requirements and data types.
  • Participants will be able to make SSRS parameters optional and utilize them to provide added value with conditional formatting and grouping in their reports.
  • Participants will be aware of parameter pitfalls such as blank and null fields, as well as Cascading Parameter behavior.
Speaker Bio: David Stein is a SQL Server Business Intelligence DBA specializing in designing, developing, and maintaining Data Warehouses using Microsoft BI Tools.



Title: Tips & Tricks for dynamic Reporting Services Reports
Speaker: Pam Shaw
Category: SSRS
Level: 100
Abstract: In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.
Session Goals
  • Demonstrate dynamic formatting and layouts
  • Demonstrate dynamic data sources
  • Explore the value of Templates
Speaker Bio: Pam Shaw has been in IT for almost 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005 and now 2008. Pam is currently an independent contractor specializing BI. Pam is also the Chapter Leader of the Tampa Bay SQL Users Group - a local chapter of PASS and organizer of SQL Saturday Tampa.



Title: What's New In SSRS 2008 (With Added R2 Flair)
Speaker: Brett Tomson
Category: SSRS
Level: 100
Abstract: Charts, sparklines, shared datasets, oh my! Don your hardhat and take a tour through the new and improved Reporting Services as available in SQL Server 2008 and 2008 R2. In this session, we will navigate the bounty of new features in SSRS ranging from new report controls and report parts to the treasures that await us with data visualization through mapping. From Lookup functions to rendering and distribution changes we'll try to cover it all. If time permits, a fine SSRS-based rendition of T-SQL Hangman awaits us. Be warned though, too many incorrect choices will leave our DBA hanging in the wind!
Session Goals
  • Introduce attendees to the multitude of changes made to the Report Designer in SQL Server 2008 and 2008 R2.
  • Leverage new R2 features in SSRS with regards to mapping data and using Lookup functions.
  • Identify changes report rendering and distribution changes that relate to better performance and ease of use.
Speaker Bio: Brett Tomson is an independent consultant specializing in delivering solutions using the Microsoft Business Intelligence stack and related .NET technologies. He is an accomplished architect and developer of large-scale enterprise systems as well as an author and mentor to others. Brett has been using SQL Server actively for the past 12 years and is the Chapter Leader of the Triangle SQL Server User Group (http://www.tripass.org).



Title: A Checklist for Reporting Services Security
Speaker: Stacia Misner
Category: SSRS
Level: 200
Abstract: Safeguarding your report server is just as important as securing the database server itself. In this session, you learn about the threats to your report server whether running in native or SharePoint integrated mode in either an intranet or Extranet environment. To defend against these threats, this session will arm you with a checklist of steps that you can use to lockdown your report server. This session includes a review of best practices and recommendations for general deployment as well as for specific security scenarios and the differences between Reporting Services 2005 and Reporting Services 2008 (and 2008 R2).
Session Goals
  • Articulate the specific threats to a report server
  • Review best practices for securing a report server
  • Provide a checklist of action items to secure a report server
Speaker Bio: Stacia Misner is a MCIT-BI and MCTS-BI with a Bachelors' degree in Social Sciences. She is a consultant, educator, author, mentor, and principal of Data Inspirations. Her career spans more than 25 years with a focus on improving business practices through technology. Since 2000, she has been providing consulting and education services for Microsoft's business intelligence technologies. In addition, she has authored or co-authored several books covering different components of the Microsoft SQL Server database and business intelligence platform. Stacia has presented at the Professional Association for SQL Server (PASS), Microsoft's TechEd, SQL Server Magazine Connections, and various Microsoft events. She currently lives in Las Vegas.     



Title: Create an Interactive Dashboard with SSRS
Speaker: Patrick LeBlanc
Category: SSRS
Level: 200
Abstract: In this session presented by Patrick LeBlanc and Chris Albrektson they will show you how to take your SSRS Dashboard to the next level. They will start off with some of the best design practices when it comes to creating dashboards. Then, we’ll show you some advanced techniques like using actions, data bars, and indicators and lastly show you how to make your Dashboard interactive. By the end of the session everyone will be able to take these newly learned tips with them in how to make your dashboard standout among the rest.
Session Goals
  • Introduce new dashboarding features in SSRS
  • Show how to create dashboard with SSIS
  • Show how to add interactivity to SSRS Dashboard
Speaker Bio: Patrick LeBlanc, SQL Server MVP and author, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes working in the Educational, Advertising, Mortgage, Medical and Financial Industries. He is also the founder of TSQLScripts.com, SQLLunch.com and the President of the Baton Rouge Area SQL Server User Group. Patrick is a regular speaker at various SQL Server community events, including SQL Saturday’s, User Groups and the SQL Lunch.



Title: On Demand Subscriptions: no crystal ball required
Speaker: Pam Shaw
Category: SSRS
Level: 200
Abstract: Do you have the need to email reports from SSRS – but not sure exactly when you want them to be emailed? What’s more, you don’t have an Enterprise license. No worries, we can do that. It just takes a little planning. We will explore subscriptions which are part of the scheduled delivery process defined within Reporting Services including what is required to create subscriptions. We will then explore what options are available and how we can manipulate these for use on demand. We will review some practical applications that On Demand Subscriptions can resolve.
Session Goals
  • Introduce basics of subscriptions
  • Review how these can be manipulated
  • Discuss practical applications od on demand subscriptions
Speaker Bio: Pam Shaw has been in IT for almost 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005 and now 2008. Pam is currently an independent contractor specializing BI. Pam is also the Chapter Leader of the Tampa Bay SQL Users Group - a local chapter of PASS and organizer of SQL Saturday Tampa.



Title: Reporting Services Boot Camp
Speaker: Brian McDonald
Category: SSRS
Level: 200
Abstract: Do you need to report your business data to users across your enterprise? Have you heard of Reporting Services, but are not sure what it has to offer? Do you have reporting services installed in your environment, but are unsure how to make use of it? All of these questions and many more will be answered in this one hour Reporting Services Boot Camp! Jammed with walk-throughs and demonstrations, this dynamite session is a SQL Saturday favorite and should not be missed. SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which provides a robust and centralized reporting platform for organizations. Using a familiar development environment we can create exciting reports that can be delivered in a variety of ways. In this level 200-300 session, I will: • Introduce and Provide an Architectural Overview of Reporting Services 2008R2 • Provide examples loaded with the awesome new features included in SSRS 2008R2 • Demonstrate how easy it is to deliver the full lifecycle of report development • Show how to deliver reports on the web, through applications and exciting other ways
Session Goals
  • Introduce and Provide an Architectural Overview of Reporting Services 2008R2
  • Provide examples loaded with the awesome new features included in SSRS 2008R2
  • #NAME?
Speaker Bio: Brian K. McDonald, MCDBA, MCSD is a Business Intelligence consultant for Pragmatic Works. Brian has experience in Database Administration, SQL Server Reporting Services, SQL Server Integration Services and Analysis Services. He has worked as an Application Developer, Network Administrator and a Database Administrator throughout his 11 years in the IT industry. He even spent a year on a large Help Desk operation a long, long time ago. Brian takes pride in all his projects and diligently works to not only meet expectations, but greatly exceed them. Brian has written articles for industry websites and continually strives to learn more and become a better version of himself. Brian is an active member of the Jacksonville SQL Server User's Group and has presented at User group meetings, Code Camps and various SQL Saturday events across Florida.



Title: SSRS Administration - Enter a BIDS Free Zone
Speaker: Sandra Mueller
Category: SSRS
Level: 200
Abstract: You are about to enter the BIDS Free Zone. Beware! This session is NOT about report design, spatial data, R2 new features or .NET extensions. We will explore what the ReportServer and ReportServerTempDB databases contain. By understanding their purpose we can discuss, for your company, what recovery mode each should be in and select backup strategies. Furthermore, we will talk about two other resources to backup: the ever critical encryption key and XML configuration files. Next, we'll cover the three scalability options: caching, snapshots and scaling out. There are numerous server configurations (memory thresholds, security, timeouts, etc.) that are familiar to administrators just hard to find. Some are so hidden you might not know they exist. Enter the zone and learn the hidden secrets!
Session Goals
  • Cover essential administration concepts for report administration such as backup's of key systems (databases, keys and config files).
  • Discuss scaling features to include in detail caching and snapshots; and in concept web farms. Using perfmon counters to determine if scale out is required.
  • Server configurations including security, memory threshold management, and settings hidden within XML configuration files.
Speaker Bio: Sandra A. Mueller started with Administration (via a programming job) in 1997 and moved into Database Design and performance optimization. She has always had a passion for sharing knowledge and trying to help others avoid the hard lessons she learnt. To this end she has been an MCT for 16 years, writing course ware, providing training and follow-on project consultation. In 2004 after an activation with the military her focus turned to SQL Server 2005 and its Business Intelligence (BI) capabilities. She is currently working as a BI Architect with SQL Server 2008R2 OLAP solutions. Sandra blogs on http://www.SandraAMueller.com. She recently started the Raleigh NC SQL Server BI User Group (http://www.tripassBI.org). She consistency speaks at SQL Saturday events and supports her local community by speaking, volunteering and attending regional chapters.



Title: Troubleshooting SSRS Performance
Speaker: Evan Basalik
Category: SSRS
Level: 200
Abstract: Evan will discuss and demonstrate how to troubleshoot Reporting Services performance issues. This will cover both tools included in the product plus some real-world scenarios he has dealt with in the past.
Session Goals
  • Understand what can impact SSRS performance
  • Understand the tools available for troubleshooting SSRS performance
  • Understand how to use the available tools to solve an SSRS performance issue
Speaker Bio: I spent 10 years doing R&D for a major textile manufacturer. I joined Microsoft 5 years ago and is currently a Support Escalation Engineer on the SQL Server team. I specialize in connectivity, database client code, and Reporting Services. In addition, he has been working on SQL Azure since before it was even called SQL Azure. .

Summit Spotlight

Title: Do You Know the Data Flow?
Speaker: John Welch
Category: Summit Spotlight
Level: 100
Abstract: The Data Flow task is one of the most powerful and most complex tools available in SSIS. Whether you are brand new to SSIS, or you’ve been using it for a while, it’s likely you’ve had some questions about the Data Flow. Why are some components so much slower than others? Why can’t I store a value (like a row count) in one component, and use it in another component later in the Data Flow? And why does it always seem to be the part of my package that fails when I run it against real data? Well, you’re not alone. During this session, we’ll answer these questions (and many others) by learning how the Data Flow operates internally. We’ll cover the Data Flow from the basic (what’s a component?) to the advanced (how can I determine how many threads my Data Flow is using?). After attending this session, you’ll know a lot more about getting the most out of Data Flows in SSIS.
Session Goals
  • Explain the underlying structure of the data flow
  • Explain the different types of components available in the data flow and their impact on the data flow
  • Demonstrate settings of the data flow that can improve or decrease performance
Speaker Bio: John Welch is BI Architect with Varigence. Varigence builds tools and frameworks that enable the creation and management of end-to-end business intelligence solutions with unprecedented ease and speed. John has been working with business intelligence and data warehousing technologies for 9 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, having given presentations at Professional Association for SQL Server (PASS) conferences, the Microsoft Business Intelligence conference, Software Development West (SD West), Software Management Conference (ASM/SM), and others. He has also contributed to three recent books on SQL Server 2008, “Microsoft SQL Server 2008 Management and Administration”, "Smart Business Intelligence Solutions with Microsoft SQL Server 2008", and “SQL Server MVP Deep Dives”. John writes a blog on business intelligence and SSIS topics at http://agilebi.com/jwelch. He is active in open source projects that help ease the development process for Microsoft BI developers, including BIDS Helper (http://bidshelper.codeplex.com), an add-in for Business Intelligence Development Studio that adds commonly needed functionality to the environment. He is also the lead developer on ssisUnit (http://ssisunit.codeplex.com), a unit testing framework for SSIS.



Title: Using Agile Development Techniques with Integration Services
Speaker: John Welch
Category: Summit Spotlight
Level: 100
Abstract: Traditionally, data warehouse development has been done with a waterfall approach, but over the last few years, there has been more and more interest in using agile approaches. This session focuses on the use of agile development practices like test driven development, pair programming, continuous integration, and refactoring in projects using SQL Server Integration Services. The benefits and challenges of applying these techniques will be discussed, along with proven approaches to common challenges. Whether you have used agile approaches in the past, but are struggling to apply it to Integration Services, or you haven’t used agile approaches at all, but want to understand the benefits, you will find valuable information in this session.
Session Goals
  • Understand how common agile practices can be applied to SSIS development
  • Understand the benefits that can be gained by using an agile approach
  • See specific tips and examples for using automated unit testing, continuous integration, and refactoring in an SSIS context
Speaker Bio: John Welch is BI Architect with Varigence. Varigence builds tools and frameworks that enable the creation and management of end-to-end business intelligence solutions with unprecedented ease and speed. John has been working with business intelligence and data warehousing technologies for 9 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, having given presentations at Professional Association for SQL Server (PASS) conferences, the Microsoft Business Intelligence conference, Software Development West (SD West), Software Management Conference (ASM/SM), and others. He has also contributed to three recent books on SQL Server 2008, “Microsoft SQL Server 2008 Management and Administration”, "Smart Business Intelligence Solutions with Microsoft SQL Server 2008", and “SQL Server MVP Deep Dives”. John writes a blog on business intelligence and SSIS topics at http://agilebi.com/jwelch. He is active in open source projects that help ease the development process for Microsoft BI developers, including BIDS Helper (http://bidshelper.codeplex.com), an add-in for Business Intelligence Development Studio that adds commonly needed functionality to the environment. He is also the lead developer on ssisUnit (http://ssisunit.codeplex.com), a unit testing framework for SSIS.



Title: Data Visualizations in SSRS 2008 R2
Speaker: Stacia Misner
Category: Summit Spotlight
Level: 200
Abstract: Reporting Services 2008 R2 includes several new data visualization features - sparklines, data bars, indicators, and maps. In this latest release, you now have a wide range of options for helping viewers to better understand data through visualization. In this session, you learn what's new, how best to use these new features, and how to avoid common design problems by properly applying principles of visual design.
Session Goals
  • Introduce data visualization features in SQL Server 2008 R2
  • Demonstrate how to use these features effectively
  • Explain how visual design principles impact understanding of data
Speaker Bio: Stacia Misner is a MCIT-BI and MCTS-BI with a Bachelors' degree in Social Sciences. She is a consultant, educator, author, mentor, and principal of Data Inspirations. Her career spans more than 25 years with a focus on improving business practices through technology. Since 2000, she has been providing consulting and education services for Microsoft's business intelligence technologies. In addition, she has authored or co-authored several books covering different components of the Microsoft SQL Server database and business intelligence platform. Stacia has presented at the Professional Association for SQL Server (PASS), Microsoft's TechEd, SQL Server Magazine Connections, and various Microsoft events. She currently lives in Las Vegas.     



Title: PowerPivot for Excel and SharePoint 2010
Speaker: Ayad Shammout
Category: Summit Spotlight
Level: 200
Abstract: In this session, I will cover PowerPivot - a data analysis add-in that delivers computational power directly within MS Excel 2010. By combining native Excel 2010 functionality with PowerPivot’s in-memory engine, I will interactively explore and perform calculations on very large data sets. This session gives the user the freedom to learn the many uses of PowerPivot from importing, modeling, analyzing and pivoting millions of records to publishing to SharePoint. I will show how IT staff can track and monitor user generated PowerPivot workbooks in SharePoint and explore PowerPivot Management Dashboard
Session Goals
  • Understand what PowerPivot is.
  • Build a PowerPivot workbook
  • How PowerPivot integrted with SharePoint
Speaker Bio: Ayad Shammout is a Principal Consultant with Advanti Solutions Inc. Shammout has been involved in IT for 20 years as a Developer, System Engineer, System Analyst and Database Consultant. He has a long experience in Microsoft Platforms and products primarily specialized in SQL Server, SharePoint and Windows OS. He is working in OLTP design and development, DBA support, Performance Tuning and Business Intelligence. Ayad has been involved in many SQL Server Enterprise implementations for High-Availability, Disaster Recovery, Infrastructure Design, System Scalability, Security and Compliance. He has extensive experience in SQL Server Integration Service, SQL Server Reporting Service, SQL Server Analysis Service, and PowerPivot for Excel and SharePoint. Shammout was awarded “SQL Server Innovators Award 2006” and presented at different events. He is an MCDBA, MCSE, MCITP and MCTS



Title: Zero To OLAP Cubes in 60 Minutes
Speaker: Adam Jorgensen
Category: Summit Spotlight
Level: 200
Abstract: Overcome the barriers of traditional training and seminars with this Quick Start to building a cube. This all demo session will get you started and answer many questions you have about building cubes the right way, the first time. Let’s dive in together and learn about how SSAS and OLAP can make deliver actionable intelligence to your end users in a fraction of the time and effort of traditional reporting techniques. This all demo session will get you started and answer many questions you have about what SSAS is and what it can do for you.
Session Goals
  • Understand the goals of OLAP in an environment.
  • Hands on understanding and explanations of SQL Server Analysis Services development.
  • Dispel myths and accelerate development in Analysis Services 2008
Speaker Bio:  Adam Jorgensen, MBA, MCITP: BI, MCDBA is the President of Pragmatic Works, a global BI Software and solutions firm based on Jacksonville, FL. and has been delivering innovative SQL Server and Business Intelligence Solutions for over a decade. His passion is finding new and innovative avenues for clients and the community to embrace business intelligence and lower barriers to implementation. Adam’s focus is on mentoring senior management and technical teams as he helps them to realize the value in the data they already own, while accelerating the technology learning curve. He works with customers to quickly understand their business models and identify their needs to deliver value as efficiently as possible. Adam is considered by many as a community pioneer. Adam is an active member of the Gold Coast User Group in South Florida and is a featured author on sites such as SQLServerCentral.com SQLShare.com and is a co-founder of BIDN.com (Business Intelligence Developer Network). He is also the co-host of SQLLunch.com, a weekly live presentation series focusing on combining experienced presenters with those getting into the community to help them gain confidence and provide a quick free learning outlet to a global audience.  Adam is a regular contributor to the SQLPASS Virtual User Groups for Business Intelligence and other organizations. He regularly speaks at industry group events, major conferences, Code Camps, and SQL Saturday events on strategic and technical topics.    



Title: Data Profiling and Cleansing with Integration Services
Speaker: Erik Veerman
Category: Summit Spotlight
Level: 300
Abstract: This session targets the data profiling capabilities of Integration Services as well as performing data cleansing. Most data sources have missing values, typographical errors, duplicated rows, mismatched rows, or just plain bad data… There’s no magic solution, but SSIS will help you understand and clean your data faster and with less stress. Come hear how to best apply the data profiling and cleansing capabilities in SSIS to get a better grip on your bad data.
Session Goals
  • Understand Data Profiling in SSIS
  • Best Practices for SSIS data cleansing
  • Applying SSIS to real world data quality issues
Speaker Bio: Erik Veerman (SQL Server MVP) is the Director of Business Intelligence for Solid Quality Mentors focusing on the SQL Server BI platform. His industry recognition includes Microsoft's Worldwide BI Solution of the Year and SQL Server Magazine's Innovator Cup winner. Erik is the lead author for the BI Training Kits (MS Press 70-445, 70-448) and a co-author of several WROX Integration Services titles. Erik has designed dozens of BI solutions across a broad business spectrum-telecommunications, marketing, retail, commercial real estate, finance, supply chain, and information technology. His experience with high volume multi-terabyte environments has enabled clients to scale their Microsoft-based BI solutions for optimal potential. As an expert in OLAP design, ETL processing, and dimensional modeling, Erik is a presenter, author and instructor. He led the ETL architecture and design for the first production implementation of Integration Services (SSIS) and helped drive the ETL standards and best practices for SSIS on Microsoft's SQL Server reference initiative, Project REAL. As a resident of Atlanta, Erik often speaks at the Atlanta PASS Chapter user group.  Furthermore, he has presented at the PASS summit for the last several years as well as the SQL Connections conference, and is often a speaker for the SQL Server Magazine road-shows and Microsoft launch events.



Title: Delivering Data as a Service from the SQL Azure (Cloud), mobile BI and self service BI at Microsoft
Speaker: Sanjay Soni
Category: Summit Spotlight
Level: 300
Abstract: See a live demo of how Microsoft IT is distributing terabytes of data from the Enterprise Data Warehouse to various business and IT groups at Microsoft using SQL Azure cloud and on premise platform. Learn about Data Services Layer (DSL) which is a distribution platform that provides a single location for Microsoft users to explore, publish & consume data. See how Windows phone is being used to deliver BI (including scorecards) on mobile phones. Top 10 best practices in running and providing Data as a Service and empowering business users to consume data using various MS BI tools will be discussed. See how PowerPivot and other BI tools are enabling self service BI at Microsoft from EDW. Mobile BI is also being used to consume and deliver that data.
Session Goals
  • See how Microsoft IT is distributing data from 4 TB+ Enterprise Data Warehouse to various business and IT groups at Microsoft using SQL Azure cloud platform
  • See how Windows phone can be used to deliver BI (including scorecards) to the masses through mobile phones
  • Top 10 best practices on how can organizations create one destination for data exploration from EDW
Speaker Bio: Sanjay Soni is a BI Platforms Evangelist in the Microsoft IT BI Engineering.  He is an MCDBA, MCTS and specializes in Business Intelligence using MS technologies including Microsoft SQL Server Analysis Services, SharePoint BI, Reporting Services, PerformancePoint etc. Sanjay has authored and presented a variety of papers and sessions in last 12+ years at various BI conferences including TDWI, BI Conference, PASS, SQL Connections, SharePoint Conference and Tech-Ed with many of these papers published in SQL Server magazine as well as on various web sites including Microsoft.com, Technet etc.



Title: ETL from the Trenches: Using SSIS in the Real World
Speaker: Dave Fackler
Category: Summit Spotlight
Level: 300
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 (updated for 2010) session, we'll look at the ins and outs of a real-world ETL environment built using SSIS. We'll discuss the ETL design patterns used to handle a multi-tiered data warehouse environment with multiple data sources, different loading schedules, and 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.
Session Goals
  • Describe several of the challenges related to architecting and building a real-world ETL solution.
  • Demonstrate several key patterns and practices related to using SSIS for a real-world ETL solution.
  • Explain key practices used by a real-world ETL development team to manage the development, test, and deployment cycles of a large SSIS solution.
Speaker Bio: Dave Fackler is a business intelligence architect and founder of Rolling Hills Enterprises, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies (including SQL Server 2005, SQL Server 2008, Microsoft Office 2007, Microsoft Office SharePoint Server 2007, and Microsoft Office PerformancePoint Server 2007). Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features coupled with dimensional modeling design principles and best practices. He has also architected and developed enterprise extraction, transformation, and loading (ETL) processes using SQL Server Integration Services and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting and analysis solutions using SQL Server Analysis Services and Reporting Services components, often coupled with Microsoft Office System components or third-party reporting and analysis tools. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year and has been very involved in delivering SQL Server and BI training and awareness events throughout the world.



Title: Overcoming SSIS Deployment and Configuration Challenges
Speaker: Erik Veerman
Category: Summit Spotlight
Level: 300
Abstract: It is no secret that a main deficiency of SSIS is deployment. Have you wanted to punch a wall before when trying to move a package from one server to another? You’re not alone. This session will be more than just SSIS deployment anger management. We’ll look at how to overcome the deployment challenges by considering configurations, package and connection security, and deployment approaches. And don’t miss the decision workflows that will help you down the right on choosing the right storage and deployment approaches depending on your situation!
Session Goals
  • Understand SSIS configuration
  • Best practices for deployment
  • Anger management
Speaker Bio: Erik Veerman (SQL Server MVP) is the Director of Business Intelligence for Solid Quality Mentors focusing on the SQL Server BI platform. His industry recognition includes Microsoft's Worldwide BI Solution of the Year and SQL Server Magazine's Innovator Cup winner. Erik is the lead author for the BI Training Kits (MS Press 70-445, 70-448) and a co-author of several WROX Integration Services titles. Erik has designed dozens of BI solutions across a broad business spectrum-telecommunications, marketing, retail, commercial real estate, finance, supply chain, and information technology. His experience with high volume multi-terabyte environments has enabled clients to scale their Microsoft-based BI solutions for optimal potential. As an expert in OLAP design, ETL processing, and dimensional modeling, Erik is a presenter, author and instructor. He led the ETL architecture and design for the first production implementation of Integration Services (SSIS) and helped drive the ETL standards and best practices for SSIS on Microsoft's SQL Server reference initiative, Project REAL. As a resident of Atlanta, Erik often speaks at the Atlanta PASS Chapter user group.  Furthermore, he has presented at the PASS summit for the last several years as well as the SQL Connections conference, and is often a speaker for the SQL Server Magazine road-shows and Microsoft launch events.



Title: What Every DBA Should Know About Sharepoint 2010
Speaker: Victor Isakov
Category: Summit Spotlight
Level: 300
Abstract: Sharepoint is becoming more ubiquitous in both the enterprise and SME market as a core business application. With Sharepoint 2010 Microsoft has re-engineered Sharepoint 2010 so as to leverage SQL Server 2008 R2's capabilities. Consequently it is more important than ever for DBAs to be cognisant of Sharepoint's architecture and how to best provision, configure and manage the SQL Server infrastructure for Sharepoint. In this session Victor Isakov (MCT, MCM, MCA) will present the Sharepoint 2010 architecture and considerations that every DBA should know, including capacity planning, performance management, configuration, disaster recovery and high availability.
Session Goals
  • Make SQL Server DBAs more aware of Sharepoint Architecture and allow them to be able to converse with SharePoint IT Pros.
  • Allow DBAs to capacity plan and configure the SharePoint databases correctly so as to maximise performance of the SharePoint environment. Help DBAs decide whether they should take advantage of Remote BLOB Storage (RBS).
  • Help DBAs to correctly plan a correct high-availability and disaster recovery strategy for their SharePoint solution.
Speaker Bio: Victor Isakov (MCT | MCM | MCA) is a Database Architect and Trainer who provides consulting and training services to various organizations in the public, private and NGO sectors globally, and been involved in different capacities at various international events and conferences. Victor has authored a number of books on SQL Server and worked closely with Microsoft to develop the new generation of SQL Server Certification and Microsoft Official Curriculum for both instructor led training (ILT) and e-Learning. In 2010 Victor who worked with Microsoft on the eBackpack solution at the Department Of Education (NSW) to build a Sharepoint 2010 solution that scales to 1.3 million users.



Title: Zero to Analytics - PowerPivot, PerformancePoint and Excel Svcs
Speaker: Adam Jorgensen
Category: Summit Spotlight
Level: 300
Abstract: This all demo session will cover PowerPivot in Excel and SharePoint, PerformancePoint Dashboard development and Excel services. This session will build an analytcs solution covering all major user groups in your organization with PLENTY of audience participation. It's a great session with more than 90% live demo walkthrough content.
Session Goals
  • Learn to develop and deploy PowerPivot reports in Excel 2010 and SharePoint 2010.
  • Learn to develop and deploy PerformancePoint 2010 reports and analysis in SharePoint 2010.
  • Learn to develop and deploy Excel Services 2010 reports and analysis in SharePoint 2010.
Speaker Bio:   Adam Jorgensen, MBA, MCITP: BI, MCDBA is the President of Pragmatic Works, a global BI Software and solutions firm based on Jacksonville, FL. and has been delivering innovative SQL Server and Business Intelligence Solutions for over a decade. His passion is finding new and innovative avenues for clients and the community to embrace business intelligence and lower barriers to implementation. Adam’s focus is on mentoring senior management and technical teams as he helps them to realize the value in the data they already own, while accelerating the technology learning curve. He works with customers to quickly understand their business models and identify their needs to deliver value as efficiently as possible. Adam is considered by many as a community pioneer. Adam is an active member of the Gold Coast User Group in South Florida and is a featured author on sites such as SQLServerCentral.com SQLShare.com and is a co-founder of BIDN.com (Business Intelligence Developer Network). He is also the co-host of SQLLunch.com, a weekly live presentation series focusing on combining experienced presenters with those getting into the community to help them gain confidence and provide a quick free learning outlet to a global audience.  Adam is a regular contributor to the SQLPASS Virtual User Groups for Business Intelligence and other organizations. He regularly speaks at industry group events, major conferences, Code Camps, and SQL Saturday events on strategic and technical topics.    

 

RegisterToAttend Agenda
The Orlando World Center
Resort Marriott
Hashtag:#sqlrally
Connect with us on Twitter
Presenting Sponsor
 
 
Silver Sponsors


 
  
 
 Bronze Sponsors