SQLSaturday #149 - Minnesota 2012 9/29/2012 12:00:00 AM (GMT-06:00) Central Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat149 University of Minnesota - Keller Hall 200 Union Street SE Minneapolis MN 55455 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 2617 Quest Software You Rock! Sponsor (Limit 1) http://www.quest.com/ http://www.quest.com/images/common/quest_logo.gif 60 170 2711 Blackdog Innovative Solutions, Inc. Breakfast Sponsor (Limit 1) http://www.blackdogis.com http://www.blackdogis.com/Portals/0/BlackdogISLogo.png 60 170 2526 U of MN - Software Engineering Center Venue Sponsor http://www.umsec.umn.edu http://www.sqlsaturday.com/files/2b15ee4b-f733-4880-a039-d36d5da6450c.jpg 60 170 2202 Emergent Networks Gold Sponsor http://www.emergentnetworks.com/ http://www.emergentnetworks.com/images/sqlsaturday/EN_logo_small.jpg 60 170 2221 Virteva Gold Sponsor http://www.virteva.com http://www.virteva.com/images/virteva170x60.jpg 60 170 2414 Magenic Gold Sponsor http://magenic.com http://magenic.com/Portals/0/Images/magenic-logo.png 60 170 2427 Idera Gold Sponsor http://www.idera.com http://www.idera.com/campaign_images/logo_Idera_tag_170x60.png 60 170 2503 Benchmark Learning Gold Sponsor http://www.benchmarklearning.com/default.aspx http://www.benchmarklearning.com/images/logo.gif 60 170 2552 GNet Group Gold Sponsor http://www.gnetgroup.com http://www.gnetgroup.com/gfx/header/top_logo1.png 60 170 2555 RBA Gold Sponsor http://www.rbaconsulting.com http://www.rbaconsulting.com/Content/Media/bcc16bc58c114676a1050c9c6500eb70/RBA-170x60.png 60 170 2620 Superior Consulting Services Gold Sponsor http://www.teamscs.com/ http://www.teamscs.com/images/TeamSCS_logo.png 60 170 2341 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2554 Intertech Silver Sponsor http://www.intertech.com http://www.sqlsaturday.com/files/9ce39472-3949-4378-8e51-0fc0da5e5c4f.jpg 60 170 2596 Robert Half Technology Silver Sponsor http://www.rht.com http://www.roberthalftechnology.com/External_Sites/content/RHT-2009/Shared/Images/rht_logo.gif 60 170 2671 Melissa Data Silver Sponsor http://www.melissadata.com http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif 60 170 2203 SQLskills.com Bronze Sponsor http://www.sqlskills.com/ http://www.SQLskills.com/SQLskillsLogo.jpg 60 170 2276 CozyRoc Bronze Sponsor http://www.cozyroc.com http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 2419 Sapien Technologies Inc. SWAG http://www.sapien.com/software/primalscript http://www.sapien.com/assets/img/logo3.png 40 100 2737 PluralSight SWAG http://Pluralsight.com http://s.pluralsight.com/mn/img/logo/pluralsight-fullcolor-175x39-v1.png 40 100 2241 Digineer, Inc. Friends of SQL Saturday http://www.digineer.com http://minnesota.sqlpass.org/Portals/70/digineer_Logo.jpg 40 100 2378 SQLSoldier Friends of SQL Saturday http://www.sqlsoldier.com http://www.sqlsoldier.com/imgs/SQLSoldierdotcom.jpg 40 100 2404 Red Gate Software Friends of SQL Saturday http://www.red-gate.com/ http://www.red-gate.com/assets/images/common/logo.png 40 100 2556 Stratezon, Inc Friends of SQL Saturday http://www.stratezon.com http://www.stratezon.com/images/stratezon-logo.jpg 40 100 2201 Jason Strate Blog Sponsor http://www.jasonstrate.com http://www.jasonstrate.com/images/StrateSQLBanner.jpg 40 100 2211 SQLFriends Blog Sponsor http://sqlfriends.org http://sqlfriends.org/wp-content/uploads/2012/04/SQLFriends.png 40 100 2212 Bill Pearson (Island Technologies Inc.) Blog Sponsor http://digital-duke.com http://digital-duke.com/wp-content/Digital-Duke.comWhiteBak.jpg 40 100 2223 Steve Hughes - Data on Wheels Blog Sponsor http://www.dataonwheels.com http://dataonwheels.files.wordpress.com/2011/12/dataonwheelslogolglines.png 40 100 2249 Lohn Solutions Blog Sponsor http://www.sqlfeatherandquill.com/ http://www.sqlfeatherandquill.com/wp-content/themes/atahualpa/images/SQLFAQ.jpg 40 100 2580 EPMAdmin.com Blog Sponsor http://www.epmadmin.com/ http://www.faisalmasood.com/images/logo.gif 40 100 2593 Aaron King Blog Sponsor http://www.aaronstanleyking.com http://4.bp.blogspot.com/-93_zp7_4Cd0/TdJ1A5UaQWI/AAAAAAAAAGY/YewNZMA39-U/s1600/AaronStanleyKingBanner60.png 40 100 2604 IngeniousSQL Blog Sponsor http://www.ingenioussql.com/ http://www.ingenioussql.com/wp-content/uploads/2012/08/ingenioussql-e1345087010429.jpg 40 100 2615 Premier Applications, Inc Blog Sponsor http://www.premierapps.com http://www.premierapps.com/DataOgre.jpg 40 100 8894 Jason Strate Rapson 45 Rapson 45 There's a lot that goes on under the covers of SQL Server with your indexes. But it's not as secretive as you might think. Most of this information is made available to you through DMVs. While this information is useful - you need a clear understanding of what is in the DMVs in order to understand what is going on. In this session we'll take a dive into sys.dm_index_operational_stats to find out what it does and what you can do with this information. 9/29/2012 10:00:00 AM 9/29/2012 11:15:00 AM 8898 Jason Strate Rapson 54 Rapson 54 Do you know when your users are using the production login accounts from their workstations? Are you aware of changes being made to the development servers that may impact future deployments? Has the new Junior DBA start giving out access like candy? As DBAs, we are responsible for knowing and acting on all of this and much more. Fortunately, SQL Server provides a number of features that you can use to monitor and track user activity. In this session, we’ll look at these features and demonstrate how you can use them to the extent that your users find you creepy! 9/29/2012 3:45:00 PM 9/29/2012 5:00:00 PM 8919 William E Pearson III Keller 3-125 Keller 3-125 Having implemented BI solutions for years, I have found documentation to be a task too often resisted until late in the project, when it is hastily and incompletely prepared in remaining hours. Because the integrated Microsoft BI solution comprises multiple application layers, it is challenging to generate documentation about the whole solution in a single, unified document. In this presentation I will share approaches I’ve come to use in assembling documentation that “covers all the bases.” 9/29/2012 12:45:00 PM 9/29/2012 2:00:00 PM 8933 William E Pearson III Keller 3-210: MVP-MCM Keller 3-210 As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence. 9/29/2012 10:00:00 AM 9/29/2012 11:15:00 AM 8944 Jason Thomas Rapson 56 Rapson 56 SSRS 2008 R2 has opened a new realm of reporting possibilities by including the spatial data support. By the end of this session, you should be familiar with the basic spatial concepts, creating map reports in SSRS from different sources, drilling down on map reports, aggregating custom data in the maps and some interesting tips and tricks revolving around them. 9/29/2012 2:15:00 PM 9/29/2012 3:30:00 PM 8973 Lara Rubbelke Keller 3-180 Keller 3-180 Drill into Microsoft's Big Data solution and learn how to derive the most value from all your data, including previously untapped unstructured data. Microsoft’s Big Data solution offers breakthrough insights by enabling customers to combine the richness of relational data from databases with unstructured data from Hadoop. 9/29/2012 10:00:00 AM 9/29/2012 11:15:00 AM 8989 Ross McNeely Keller 2-260 Keller 2-260 In this session explore the use of the SQL Server spatial data types. We will see an example of the geography spatial data type used to represent data in a round-earth coordinate system. Then the geometry spatial data type which represents data in a flat coordinate system will be demonstrated. Both spatial types are CLR data types and provide a powerful way for businesses; such as; retailers to identify where their shoppers are concentrated, or for call centers to visualize the effect of top performers on others. 9/29/2012 2:15:00 PM 9/29/2012 3:30:00 PM 8999 Mike Donnelly Rapson 54 Rapson 54 There are some great new tasks in SSIS 2012 to take advantage of (CDC) Change Data Capture. I'll walk you through adding CDC to your database and tables and then updating incremental changes using the New CDC Control Task, CDC Source and CDC Splitter. 9/29/2012 2:15:00 PM 9/29/2012 3:30:00 PM 9002 Kirby Richter Rapson 56 Rapson 56 Tables getting big? Not allowed to delete the data? Consider table partitioning a great way to help manage large tables. It is also useful for implementing a data retention and archiving strategy. 9/29/2012 8:30:00 AM 9/29/2012 9:45:00 AM 9006 Joseph Sack Keller 3-210: MVP-MCM Keller 3-210 When the query optimizer inaccurately predicts the number of rows for query execution plan iterators, performance can suffer due the generation and use of a suboptimal plan. Fixing cardinality estimate issues will help the query optimizer generate a higher quality plan. This session will teach you how to identify cardinality estimate issues in your query execution plan and also cover various ways in which cardinality estimate issues can be addressed. 9/29/2012 2:15:00 PM 9/29/2012 3:30:00 PM 9007 Mark Vaillancourt Keller 3-115 Keller 3-115 Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment. 9/29/2012 12:45:00 PM 9/29/2012 2:00:00 PM 9008 Merrill Aldrich Keller 3-115 Keller 3-115 If you haven't dug in to PowerShell at this point, you're missing out on some amazing, powerful, practical stuff that could save you time every day. PowerShell does have a learning curve at the outset, especially for those not already familiar with OO concepts or programming in a language like C#, so this introductory session will go through the very basics of PowerShell syntax. If that collection of pipes and hyphens and curly braces seems to be written in some incomprehensible foreign language, this session is for you. At the end of the session you should have a grasp of how and why a PowerShell script does what it does, and the confidence to dig in deeper and begin using POSH scripts in your own work. 9/29/2012 10:00:00 AM 9/29/2012 11:15:00 AM 9008 Merrill Aldrich Rapson 45 Rapson 45 If you haven't dug in to PowerShell at this point, you're missing out on some amazing, powerful, practical stuff that could save you time every day. PowerShell does have a learning curve at the outset, especially for those not already familiar with OO concepts or programming in a language like C#, so this introductory session will go through the very basics of PowerShell syntax. If that collection of pipes and hyphens and curly braces seems to be written in some incomprehensible foreign language, this session is for you. At the end of the session you should have a grasp of how and why a PowerShell script does what it does, and the confidence to dig in deeper and begin using POSH scripts in your own work. 9/29/2012 2:15:00 PM 9/29/2012 3:30:00 PM 9039 Ted Krueger Keller 3-210: MVP-MCM Keller 3-210 How many times have you been sitting in a meeting and you hear, “We want all our users to have access to the data, 24/7. That includes when they are offline and on a client location”. At this point you may start letting out a large sigh because you are thinking, “How could the user get to the data if there is no connection?” This isn’t as hard as you may think and this session will show how to use SQL Servers Merge Replication in order to accomplish the task. Merge replication offers a scalable option for data mobility. This session will go over how Merge Replication can be used to replicate data to users that spend many hours offline. 9/29/2012 12:45:00 PM 9/29/2012 2:00:00 PM 9040 Aaron Lowe Keller 3-180 Keller 3-180 As protectors of arguably, the most important asset companies’ have we are tasked with ensuring quality, security and performance. However the ways in which we utilize and obtain those assets are often not formalized and therefore suffer from degraded quality. Let's discuss some strategies that can be implemented to not only raise the bar of quality, but also make you sleep easier at night. 9/29/2012 2:15:00 PM 9/29/2012 3:30:00 PM 9050 Dan English Keller 3-180 Keller 3-180 The world of self-service BI just keeps getting better. From self-service analysis with PowerPivot to self-service reporting with Microsoft Power View. This session will discuss the new BI Semantic Model concept, show you how to build models with PowerPivot and Analysis Services, and then go over using the new browser based reporting tool Power View to provide highly interactive reporting solutions. There is fun to be had by all and who knew that analyzing data could be so fun, come and find out more and see how it all works and what to expect with the upcoming release of SQL Server. 9/29/2012 8:30:00 AM 9/29/2012 9:45:00 AM 9067 Jeff Krebsbach Keller 2-260 Keller 2-260 Are you trying to make sense of large amounts of data rapidly flowing past your doorstep? Using Microsoft StreamInsight I will show how we can consume and process information in real time so your business can react to information more rapidly with Complex Event Processing (CEP) applications. Whether you are trying to monitor the stock market for exciting opportunities, keep an eye on the conditions of your warehouse floor, or attempting to trend patterns on social media, StreamInsight gives you a handle on enormous amounts of rapidly changing data.We will start with an overview of Services Oriented Architecture (SOA) and how tools like Microsoft BizTalk and Microsoft StreamInsight can help you intelligently architect your busines 9/29/2012 8:30:00 AM 9/29/2012 9:45:00 AM 9351 Ira Whiteside Rapson 56 Rapson 56 This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We  will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation. 9/29/2012 3:45:00 PM 9/29/2012 5:00:00 PM 9370 Eric Zierdt Rapson 43 Rapson 43 This session will explore SQL Server Execution Plans. Learn how the server is processing a query, see potential pain points, how to know if an index is needed. This session is designed for intro level DBA's, designers, programmers or anyone who hasn't used Execution plans before 9/29/2012 3:45:00 PM 9/29/2012 5:00:00 PM 9403 Paul Doyle Keller 3-125 Keller 3-125 In this session we will explore how SQL Server Analysis Services Tabular running in DirectQuery mode can be used to power real-time analytics. In DirectQuery mode the data is guaranteed to be up-to-date, no refreshing or processing is necessary, because DirectQuery mode queries data that is stored in a SQL Server database. We will provide concepts and step-by-step examples of setting up a BI Semantic Model, including security, best practices for getting the most out of Power View and the differences between DirectQuery and the In-Memory VertiPaq cache, so you are equipped to start building real-time analytics solutions with SSAS and Power View. 9/29/2012 3:45:00 PM 9/29/2012 5:00:00 PM 9655 Robert Davis Keller 3-180 Keller 3-180 Corruption cannot always be avoided. You can take steps to ensure early detection, and you can prepare for the eventuality of it occurring, but it's not possible to completely prevent it. Early detection is your best protection against data lost due to corruption. In this session, we will discuss the protections within SQL Server to help identify corruption and to help recover from it. We will look at the different types of corruption that could hit your database and the best way to deal with each type. Includes live demos recovering from different types of corrupt databases. 9/29/2012 3:45:00 PM 9/29/2012 5:00:00 PM 9786 Ben Thul Rapson 56 Rapson 56 In order to keep your database schema healthy, you need to trim unused tables from time to time. In this session, we'll cover how to use the procedure cache and SQL audit to show you where to start pruning! 9/29/2012 10:00:00 AM 9/29/2012 11:15:00 AM 9881 Jeff Prom Keller 2-260 Keller 2-260 Does your company have similar data in multiple locations? Not really sure which set of data is accurate? Want to give subject matter experts the ability to maintain their own data? In this session we will cover SQL Server's solution to Master Data Management. We will talk about MDS from start to finish including installation, creating models/entities, working with data, using the new Excel add-in, security, hierarchies, views, versions, and business rules. 9/29/2012 3:45:00 PM 9/29/2012 5:00:00 PM 9973 Sarita Garg Rapson 54 Rapson 54 One of the new exciting features of SQL server 2012 is called Contained Database. We will explore what is contained database, what is partially contained database, what are its components, benefits of using it, some of the limitations, contained database authentication and security best practices, and how to migrate a partially contained database. 9/29/2012 12:45:00 PM 9/29/2012 2:00:00 PM 10123 Eric Ness Keller 3-115 Keller 3-115 Data modeling is often an abstract exercise involving a lot of talk and diagrams, but little hands-on experimentation. This may still be viable in the world of transactional systems where a lack of source data prevents the modeler from quickly creating a prototype system, however in the world of dimensional modeling where source data is abundant there’s no longer a reason to treat data modeling as an academic exercise. This session will cover how to use PowerPivot for Excel to quickly create prototypes of different dimensional models to try out and discard as necessary. The features of PowerPivot which allow quick import of data from a variety of data sources will also be demonstrated. 9/29/2012 3:45:00 PM 9/29/2012 5:00:00 PM 10163 Bill Preachuk Rapson 45 Rapson 45 How does Apache Hadoop fit into our neat tidy database world? In this technical session we'll examine Big Data through the lense of an SQL DBA/DW guy who became a Cloudera Certified Hadoop Developer. Find out in detail what HDFS and Map/Reduce actually are. Learn what Hadoop really means to the SQL Server Professional. See demos of real-world data tasks that Hadoop can accomplish. 9/29/2012 12:45:00 PM 9/29/2012 2:00:00 PM 10287 Luke Jian Rapson 43 Rapson 43 A lot of database professionals today do not have a Computer-Science Degree so they never attended a “Introduction to Databases” course. In this session we are trying to fix at least one thing and we’ll look in depth at the three types of join operations, visualize how their algorithms work in order to understand how query plans are computed, explain why these join operations have very different performance characteristics and why the optimizer chooses a specific join operator to use in a query plan. Will demonstrate that empirical cost calculations are similar to what Query Optimizer actually outputs. Good understanding of join algorithms is vital in order to diagnose and remedy issues related to bad query plans. 9/29/2012 12:45:00 PM 9/29/2012 2:00:00 PM 10357 Ed Leighton-Dick Keller 2-260 Keller 2-260 Normalizing a database - splitting apart tables into simpler, more focused tables - can yield concrete benefits, including manageability, scalability, and space savings. The concept is a central tenet of a relational database system such as SQL Server, yet far too many database professionals are unfamiliar with it. This session will present a practical primer on normalization: what it is, why it's beneficial, how to do it, and when not to do it. 9/29/2012 10:00:00 AM 9/29/2012 11:15:00 AM 10430 Robert Davis Keller 3-210: MVP-MCM Keller 3-210 This isn't the same old AlwaysOn demo that everyone else is doing. This is the stuff that almost nobody is talking about, but they are very important features that will save you time, frustration, and even money. These are the top features of SQL Server 2012 that you may not even be aware of. Come learn about these really cool features and see them in action. 9/29/2012 8:30:00 AM 9/29/2012 9:45:00 AM 10471 Jes Borland Keller 3-210: MVP-MCM Keller 3-210 Having multiple database files and filegroups is one of many strategies to improve performance and make administration easier. What are filegroups, and how do you use them? In this session, I'll show you how to create filegroups, create objects in them or move objects to them, and discuss how they can help performance. I'll also cover Enterprise-level features like piecemeal restores. 9/29/2012 3:45:00 PM 9/29/2012 5:00:00 PM 10472 Jes Borland Keller 2-260 Keller 2-260 SQL Server professionals like to talk - a lot. We blog, we tweet, we answer forum questions, and more to help others. Add your voice! Learn about the different ways you can share your experience and knowledge. Once you start teaching others, you'll realize how much knowledge you have! 9/29/2012 12:45:00 PM 9/29/2012 2:00:00 PM 10623 Zach Mattson Rapson 56 Rapson 56 Why am I here? This is a question you might ask yourself each day at work. Perhaps its mundane tasks, reactive troubleshooting, or just filling out TPS reports on a Friday afternoon. This session is going to attack the mundane and show you some of the things Powershell can bring to the table for working with SQL Server. From performance monitoring to writing tests, it promises to be entirely scripts and demos compiled from real work on a large OLTP SQL environment . The theoretical will be ignored as well as any common decency towards mass produced beer. No SSIS or Powerpoint will be harmed during this presentation. 9/29/2012 12:45:00 PM 9/29/2012 2:00:00 PM 10661 Andy Lohn Rapson 43 Rapson 43 This session will demonstrate tips and tricks that will help you complete tasks fast and efficient using TSQL. This session is targeted at TSQL beginners to SQL Server experts looking to add to their TSQL bag of tricks. The focus of this session will be on leveraging builtin functions, scripts to create scripts, troubleshooting procedures and other uses. 9/29/2012 10:00:00 AM 9/29/2012 11:15:00 AM 10707 David Eichner Keller 3-125 Keller 3-125 Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder allows creation of executive dashboards that display cash on hand, payables, receivables, sales, and purchase order commitments with drill-downs! 9/29/2012 10:00:00 AM 9/29/2012 11:15:00 AM 10863 Rick Krueger Rapson 43 Rapson 43 Business Intelligence gets a lot of press these days, but do you often wonder to yourself as you are writing a report, ‘Who is going to use this’? Learn about the rich information that SSRS is already capturing for you about your reports: who is running them and how often, how long do they take to execute, how much time is spent in data retrieval vs rendering, which parameters were passed in, and more… Co-Presenter: Dave Valentine (@IngeniousSQL) 9/29/2012 2:15:00 PM 9/29/2012 3:30:00 PM 10864 David Valentine Rapson 45 Rapson 45 Join Rick and Dave on this most excellent adventure as they teach you how to get more work done in less time. Leave your checkbook at home, because this is all about maximum productivity with minimum budget. Leave with Visual Studio and SQL Server Management Studio shortcut keys, extensions, and add-ins. We guarantee you will see something you haven’t seen before, or your money back. Co-Presenter: Rick Krueger (@DataOgre) 9/29/2012 8:30:00 AM 9/29/2012 9:45:00 AM 10974 Hope Foley Rapson 43 Rapson 43 Ted Krueger will join Hope in presenting this session. Consulting is a mystical career path that is often questioned: should I do it, can I do it and why should I do it? Come join us on a discussion of the pros and cons to consulting with an emphasis on SQL Server and Microsoft Technologies. We'll field questions with real world experiences. Once you leave this open floor session, you'll be able to make better choices in your own professional development and how consulting may or may not effect it. 9/29/2012 8:30:00 AM 9/29/2012 9:45:00 AM 10980 Kyle Neier Rapson 54 Rapson 54 We've all heard these words - but what do they all mean? No - this isn't about getting boats up a hill, small building bricks, or an uncommon hairstyle. In this session we'll identify the most common locks and discuss how to leverage and avoid their use. We'll discuss how these locks can turn into blocks and discuss several techniques that can be employed to insure increase data availability and improve performance. Wrapping up the trio, we'll discuss what deadlocks are and what they are not as we discuss strategies for both detection and remediation of this often misunderstood concept. 9/29/2012 10:00:00 AM 9/29/2012 11:15:00 AM 10981 Aaron King Keller 3-115 Keller 3-115 In this presentation Aaron will cover how to collect data from multiple SQL Servers using SQL Server 2008 Integration Services (SSIS). Then he will use SQL Server Reporting Services (SSRS) to report detail on that data. After that he will use SQL Server Analysis Services (SSAS) to create a KPI. Finally he’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided. 9/29/2012 2:15:00 PM 9/29/2012 3:30:00 PM 10997 Greg Beaumont Keller 3-115 Keller 3-115 Based upon experience with implementing healthcare BI solutions for clients with hospital visit data, this presentation will discuss common healthcare BI challenges and review solutions for those challenges using Microsoft tools. A demonstration of how Microsoft BI tools can be used to provide valuable reporting insights will be accompanied by a discussion about architectural challenges with healthcare data. How can there be a unified data warehouse when various departments have different requirements? How can Microsoft BI tools such as SSAS, SSRS, PerformancePoint, Excel, and PowerPivot provide immediate reporting value? Can Performance Measures be built into a BI solution? These questions and more will be reviewed and discussed. 9/29/2012 8:30:00 AM 9/29/2012 9:45:00 AM 11000 Derek Dai Rapson 54 Rapson 54 This session will introduce the new xVelocity Memory-Optimized Columnstore Index feature of SQL 2012. This presentation will describe what a column store index is, how this feature is used to store data by columns instead of by rows and compare the advantages and disadvantages between the two storage methods. Live demos will explore how to create columnstore indexes, when to create them, best practices for using them and typical data warehouse scenarios that can leverage the columnstore index to drastically speed up data warehouse queries, in many cases by a factor of 10 to 100, so you are equipped to start implementing this feature into your database environment. 9/29/2012 8:30:00 AM 9/29/2012 9:45:00 AM 11015 Fazel Haris Keller 3-125 Keller 3-125 Practical, real world implementation of advanced dimensional design concepts using SQL Server Analysis Services 2012. Topics, examples and demos will include the appropriate use of Reference Dimensions, Fact Dimensions,and Many-To-Many Dimensions, to effectively architect and implement SSAS solutions that meet complex business requirements. 9/29/2012 2:15:00 PM 9/29/2012 3:30:00 PM 11122 Jason Horner Keller 3-125 Keller 3-125 In this session we will explore the many ways that PowerShell can help with all aspects of the software development process. Including Development, Deployment, and Administration. Specific products in the stack covered will be SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS). We will spend time going over some basic project structure and configuration management best practices as well. Some previous minor exposure to PowerShell or .Net programming is assumed. 9/29/2012 8:30:00 AM 9/29/2012 9:45:00 AM 11203 Steve Hughes Rapson 45 Rapson 45 Window functions are an underused feature in T-SQL. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions. 9/29/2012 3:45:00 PM 9/29/2012 5:00:00 PM 11224 SQL Saturday Welcome Rapson 45 Rapson 45 Welcome 9/29/2012 8:15:00 AM 9/29/2012 8:30:00 AM 11224 SQL Saturday Welcome Rapson 54 Rapson 54 Welcome 9/29/2012 8:15:00 AM 9/29/2012 8:30:00 AM 11224 SQL Saturday Welcome Rapson 43 Rapson 43 Welcome 9/29/2012 8:15:00 AM 9/29/2012 8:30:00 AM 11224 SQL Saturday Welcome Keller 2-260 Keller 2-260 Welcome 9/29/2012 8:15:00 AM 9/29/2012 8:30:00 AM 11224 SQL Saturday Welcome Keller 3-125 Keller 3-125 Welcome 9/29/2012 8:15:00 AM 9/29/2012 8:30:00 AM 11224 SQL Saturday Welcome Keller 3-115 Keller 3-115 Welcome 9/29/2012 8:15:00 AM 9/29/2012 8:30:00 AM 11224 SQL Saturday Welcome Keller 3-210: MVP-MCM Keller 3-210 Welcome 9/29/2012 8:15:00 AM 9/29/2012 8:30:00 AM 11224 SQL Saturday Welcome Keller 3-180 Keller 3-180 Welcome 9/29/2012 8:15:00 AM 9/29/2012 8:30:00 AM 11224 SQL Saturday Welcome Rapson 56 Rapson 56 Welcome 9/29/2012 8:15:00 AM 9/29/2012 8:30:00 AM 11225 SQL Saturday Registration/Breakfast Rapson 56 Rapson 56 Registration/Breakfast 9/29/2012 7:15:00 AM 9/29/2012 8:15:00 AM 11225 SQL Saturday Registration/Breakfast Keller 3-180 Keller 3-180 Registration/Breakfast 9/29/2012 7:15:00 AM 9/29/2012 8:15:00 AM 11225 SQL Saturday Registration/Breakfast Keller 3-210: MVP-MCM Keller 3-210 Registration/Breakfast 9/29/2012 7:15:00 AM 9/29/2012 8:15:00 AM 11225 SQL Saturday Registration/Breakfast Keller 3-115 Keller 3-115 Registration/Breakfast 9/29/2012 7:15:00 AM 9/29/2012 8:15:00 AM 11225 SQL Saturday Registration/Breakfast Keller 3-125 Keller 3-125 Registration/Breakfast 9/29/2012 7:15:00 AM 9/29/2012 8:15:00 AM 11225 SQL Saturday Registration/Breakfast Keller 2-260 Keller 2-260 Registration/Breakfast 9/29/2012 7:15:00 AM 9/29/2012 8:15:00 AM 11225 SQL Saturday Registration/Breakfast Rapson 43 Rapson 43 Registration/Breakfast 9/29/2012 7:15:00 AM 9/29/2012 8:15:00 AM 11225 SQL Saturday Registration/Breakfast Rapson 54 Rapson 54 Registration/Breakfast 9/29/2012 7:15:00 AM 9/29/2012 8:15:00 AM 11225 SQL Saturday Registration/Breakfast Rapson 45 Rapson 45 Registration/Breakfast 9/29/2012 7:15:00 AM 9/29/2012 8:15:00 AM 11226 SQL Saturday Team Keller 3-210: MVP-MCM Keller 3-210 Closing Ceremonies and Raffle 9/29/2012 5:15:00 PM 9/29/2012 6:15:00 PM 11595 Lunch Break Keller 3-125 Keller 3-125 Grab your lunch and join a group of SQL Saturday #149 attendees for an informal discussion about SQL Server Analysis Service. 9/29/2012 11:15:00 AM 9/29/2012 12:45:00 PM 11597 Lunch Break Keller 3-180 Keller 3-180 Grab your lunch and join a group of SQL Saturday #149 attendees for an informal discussion about Disaster Recovery.. 9/29/2012 11:15:00 AM 9/29/2012 12:45:00 PM 11598 Lunch Break Keller 3-210: MVP-MCM Keller 3-210 Grab your lunch and join a group of SQL Saturday #149 attendees for an informal discussion about networking (people, not computers) as well as an opportunity to hone your interviewing skills with some mock interviews.. 9/29/2012 11:15:00 AM 9/29/2012 12:45:00 PM 11599 Lunch Break Keller 2-260 Keller 2-260 Grab your lunch and join a group of SQL Saturday #149 attendees for an informal discussion about Powershell. 9/29/2012 11:15:00 AM 9/29/2012 12:45:00 PM 11600 Lunch Break Rapson 43 Rapson 43 Grab your lunch and join a group of SQL Saturday #149 attendees for an informal discussion about indexing and query tuning. 9/29/2012 11:15:00 AM 9/29/2012 12:45:00 PM 11601 Lunch Break Rapson 45 Rapson 45 Grab your lunch and join a group of SQL Saturday #149 attendees for an informal panel discussion about Women In Technology (WIT). 9/29/2012 11:15:00 AM 9/29/2012 12:45:00 PM 11602 Lunch Break Rapson 54 Rapson 54 Grab your lunch and join a group of SQL Saturday #149 attendees for an informal discussion about SSRS and SSIS. 9/29/2012 11:15:00 AM 9/29/2012 12:45:00 PM 11603 Lunch Break Rapson 56 Rapson 56 Grab your lunch and join a group of SQL Saturday #149 attendees for an informal discussion about Big Data. 9/29/2012 11:15:00 AM 9/29/2012 12:45:00 PM 11604 Lunch Break Keller 3-115 Keller 3-115 Grab your lunch and join a group of SQL Saturday #149 attendees for an informal discussion about SQL In the Cloud and Backup Restore.. 9/29/2012 11:15:00 AM 9/29/2012 12:45:00 PM 11668 Kevin Selinger Keller 3-180 Keller 3-180 Quest Software Session - TBD 9/29/2012 12:45:00 PM 9/29/2012 2:00:00 PM