SQLSaturday #131 - Phoenix 2012 4/28/2012 12:00:00 AM (GMT-07:00) Arizona SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat131 Chandler-Gilbert Community College Pecos Campus 2626 E Pecos Road Chandler AZ 85225 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 1884 Microsoft Gold Sponsor http://www.microsoft.com/sqlserver/en/us/default.aspx http://www.sqlsaturday.com/files/be551f5e-38e9-43b9-9b9b-f58fcd31522b.jpg 60 170 1888 Idera Gold Sponsor http://www.idera.com http://www.idera.com/images/Logo-Idera.png 60 170 2009 Neudesic Gold Sponsor http://www.neudesic.com/ http://www.sqlsaturday.com/files/d07d6dfe-c1b8-4be8-9615-ada0c3428110.jpg 60 170 2172 Statera Gold Sponsor http://www.statera.com http://www.sqlsaturday.com/files/e7d0bf2e-10f1-4a04-aba4-63b23846017a.jpg 60 170 2193 Quest Software Gold Sponsor http://www.quest.com http://www.quest.com/images/common/quest_logo.gif 60 170 2204 Business and Decision Gold Sponsor http://www.businessdecision.us http://businessdecisionmsft.com/wp-content/uploads/2011/03/BDLogo.png 60 170 2236 Red Gate Software Gold Sponsor http://www.red-gate.com/ http://www.sqlsaturday.com/files/086a76b8-df89-429b-9ba6-d632fbd485b7.jpg 60 170 1871 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2165 Fusion-io Silver Sponsor https://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 2174 GoDaddy.com Silver Sponsor http://www.godaddy.com/default.aspx http://www.sqlsaturday.com/files/cd417076-3b09-477c-99ee-7d9592e4ae6a.jpg 60 170 1986 CozyRoc Bronze Sponsor http://www.cozyroc.com http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 2102 Interface Technical Training Bronze Sponsor http://www.interfacett.com http://www.interfacetechimmersion.com/images/INT-Logo.jpg 60 170 1839 MarkTab Consulting Blog Sponsor http://www.marktab.net http://www.marktab.net/images/MarkTabNet_100x40.gif 40 100 2022 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 2208 Bill Pearson (Island Technologies Inc.) Blog Sponsor http://digital-duke.com/ http://digital-duke.com/wp-content/Digital-Duke.comWhiteBak.jpg 40 100 2237 Morgan Kaufman Publisher Sponsors http://mkp.com/ http://www.sqlsaturday.com/files/b27dbdbf-6242-41e2-af4a-8ffaaa520f5c.jpg 40 100 7565 SQL Saturday 131 App Dev IRN 128 4/28/2012 9:30:00 AM 4/28/2012 9:45:00 AM 7565 SQL Saturday 131 App Dev IRN 128 4/28/2012 10:45:00 AM 4/28/2012 11:00:00 AM 7565 SQL Saturday 131 App Dev IRN 128 4/28/2012 2:30:00 PM 4/28/2012 2:45:00 PM 7565 SQL Saturday 131 App Dev IRN 128 4/28/2012 3:45:00 PM 4/28/2012 4:00:00 PM 7565 SQL Saturday 131 App Dev / DBA IRN 129 4/28/2012 9:30:00 AM 4/28/2012 9:45:00 AM 7565 SQL Saturday 131 App Dev / DBA IRN 129 4/28/2012 10:45:00 AM 4/28/2012 11:00:00 AM 7565 SQL Saturday 131 App Dev / DBA IRN 129 4/28/2012 2:30:00 PM 4/28/2012 2:45:00 PM 7565 SQL Saturday 131 App Dev / DBA IRN 129 4/28/2012 3:45:00 PM 4/28/2012 4:00:00 PM 7565 SQL Saturday 131 DBA IRN 126 4/28/2012 9:30:00 AM 4/28/2012 9:45:00 AM 7565 SQL Saturday 131 DBA IRN 126 4/28/2012 10:45:00 AM 4/28/2012 11:00:00 AM 7565 SQL Saturday 131 DBA IRN 126 4/28/2012 2:30:00 PM 4/28/2012 2:45:00 PM 7565 SQL Saturday 131 DBA IRN 126 4/28/2012 3:45:00 PM 4/28/2012 4:00:00 PM 7565 SQL Saturday 131 BI Architecture IRN 120 4/28/2012 9:30:00 AM 4/28/2012 9:45:00 AM 7565 SQL Saturday 131 BI Architecture IRN 120 4/28/2012 10:45:00 AM 4/28/2012 11:00:00 AM 7565 SQL Saturday 131 BI Architecture IRN 120 4/28/2012 2:30:00 PM 4/28/2012 2:45:00 PM 7565 SQL Saturday 131 BI Architecture IRN 120 4/28/2012 3:45:00 PM 4/28/2012 4:00:00 PM 7565 SQL Saturday 131 BI Architecture IRN 106 4/28/2012 9:30:00 AM 4/28/2012 9:45:00 AM 7565 SQL Saturday 131 BI Architecture IRN 106 4/28/2012 10:45:00 AM 4/28/2012 11:00:00 AM 7565 SQL Saturday 131 BI Architecture IRN 106 4/28/2012 2:30:00 PM 4/28/2012 2:45:00 PM 7565 SQL Saturday 131 BI Architecture IRN 106 4/28/2012 3:45:00 PM 4/28/2012 4:00:00 PM 7565 SQL Saturday 131 BI Delivery IRN 131 4/28/2012 9:30:00 AM 4/28/2012 9:45:00 AM 7565 SQL Saturday 131 BI Delivery IRN 131 4/28/2012 10:45:00 AM 4/28/2012 11:00:00 AM 7565 SQL Saturday 131 BI Delivery IRN 131 4/28/2012 2:30:00 PM 4/28/2012 2:45:00 PM 7565 SQL Saturday 131 BI Delivery IRN 131 4/28/2012 3:45:00 PM 4/28/2012 4:00:00 PM 7565 SQL Saturday 131 BI Delivery IRN 219 4/28/2012 9:30:00 AM 4/28/2012 9:45:00 AM 7565 SQL Saturday 131 BI Delivery IRN 219 4/28/2012 10:45:00 AM 4/28/2012 11:00:00 AM 7565 SQL Saturday 131 BI Delivery IRN 219 4/28/2012 2:30:00 PM 4/28/2012 2:45:00 PM 7565 SQL Saturday 131 BI Delivery IRN 219 4/28/2012 3:45:00 PM 4/28/2012 4:00:00 PM 7565 SQL Saturday 131 Professional Development / Azure IRN 125 4/28/2012 9:30:00 AM 4/28/2012 9:45:00 AM 7565 SQL Saturday 131 Professional Development / Azure IRN 125 4/28/2012 10:45:00 AM 4/28/2012 11:00:00 AM 7565 SQL Saturday 131 Professional Development / Azure IRN 125 4/28/2012 2:30:00 PM 4/28/2012 2:45:00 PM 7565 SQL Saturday 131 Professional Development / Azure IRN 125 4/28/2012 3:45:00 PM 4/28/2012 4:00:00 PM 7565 SQL Saturday 131 SSIS IRN 123 4/28/2012 9:30:00 AM 4/28/2012 9:45:00 AM 7565 SQL Saturday 131 SSIS IRN 123 4/28/2012 10:45:00 AM 4/28/2012 11:00:00 AM 7565 SQL Saturday 131 SSIS IRN 123 4/28/2012 2:30:00 PM 4/28/2012 2:45:00 PM 7565 SQL Saturday 131 SSIS IRN 123 4/28/2012 3:45:00 PM 4/28/2012 4:00:00 PM 7565 SQL Saturday 131 Microsoft SC 140-144 4/28/2012 9:30:00 AM 4/28/2012 9:45:00 AM 7565 SQL Saturday 131 Microsoft SC 140-144 4/28/2012 10:45:00 AM 4/28/2012 11:00:00 AM 7565 SQL Saturday 131 Microsoft SC 140-144 4/28/2012 2:30:00 PM 4/28/2012 2:45:00 PM 7565 SQL Saturday 131 Microsoft SC 140-144 4/28/2012 3:45:00 PM 4/28/2012 4:00:00 PM 7566 SQLSaturday 131 Microsoft SC 140-144 4/28/2012 12:00:00 PM 4/28/2012 1:30:00 PM 7566 SQLSaturday 131 SSIS IRN 123 4/28/2012 12:00:00 PM 4/28/2012 1:30:00 PM 7566 SQLSaturday 131 Professional Development / Azure IRN 125 4/28/2012 12:00:00 PM 4/28/2012 1:30:00 PM 7566 SQLSaturday 131 BI Delivery IRN 219 4/28/2012 12:00:00 PM 4/28/2012 1:30:00 PM 7566 SQLSaturday 131 BI Delivery IRN 131 4/28/2012 12:00:00 PM 4/28/2012 1:30:00 PM 7566 SQLSaturday 131 BI Architecture IRN 106 4/28/2012 12:00:00 PM 4/28/2012 1:30:00 PM 7566 SQLSaturday 131 BI Architecture IRN 120 4/28/2012 12:00:00 PM 4/28/2012 1:30:00 PM 7566 SQLSaturday 131 DBA IRN 126 4/28/2012 12:00:00 PM 4/28/2012 1:30:00 PM 7566 SQLSaturday 131 App Dev / DBA IRN 129 4/28/2012 12:00:00 PM 4/28/2012 1:30:00 PM 7566 SQLSaturday 131 App Dev IRN 128 4/28/2012 12:00:00 PM 4/28/2012 1:30:00 PM 7571 Wil Sisney SSIS IRN 123 You know how to create a connection manager, and you can extract data to a flat file. So how do you get past basic package creation? This presentation will cover 5 high-level techniques you can use to become the 'go-to' person for SSIS in your organization. This session will be packed with demos of packages you can use to achieve SSIS Awesomeness! 4/28/2012 11:00:00 AM 4/28/2012 12:00:00 PM 7574 William E. Pearson III BI Architecture IRN 120 Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations. 4/28/2012 9:45:00 AM 4/28/2012 10:45:00 AM 7579 William E. Pearson III Professional Development / Azure IRN 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.” 4/28/2012 4:00:00 PM 4/28/2012 5:00:00 PM 7582 William E. Pearson III BI Architecture IRN 106 Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to many organizations, including financial services firms and the like. After all, having customer calendars in their cubes' date dimension means sales and marketing managers can analyze - and report upon - data according to the fiscal calendar of the customer, as well as within the context of their own. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson leads an examination into a way we can accomplish this by implementing a SQL Server Analysis Services 'many-to-many' dimension scenario. 4/28/2012 1:30:00 PM 4/28/2012 2:30:00 PM 7609 Kathy Gibbs DBA IRN 126 SQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data. 4/28/2012 1:30:00 PM 4/28/2012 2:30:00 PM 7618 Colin Smith DBA IRN 126 This will be a 100 level class that discusses the basics of powershell, how to set it up, how to use it, and how it will help the DBA be more productive. This will also include examples for SQL Server 2012. 4/28/2012 4:00:00 PM 4/28/2012 5:00:00 PM 7645 Stacia Misner BI Delivery IRN 131 Head starting to explode from all the technical information you’re absorbing? Come spend a session with us while we play games with Reporting Services…literally! Come watch and cheer as SQL Server MVP Stacia Misner is challenged by her progeny and protégé Erika Bakse to an hour of word play, all wrapped up in SQL Server Reporting Services. They’ll push the limits with what can be built in SSRS and have a stupid amount of fun while doing it. Swag, trash talk, board games and SQL…who could ask for more? 4/28/2012 8:30:00 AM 4/28/2012 9:30:00 AM 7646 Stacia Misner BI Delivery IRN 219 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. 4/28/2012 11:00:00 AM 4/28/2012 12:00:00 PM 7647 Stacia Misner BI Delivery IRN 219 Power View is the new data visualization and self-service BI tool that will debut in SQL Server 2012. To successfully roll-out this technology to your user community, you need to understand its architecture and data dependencies. Come to this session to get past the razzle dazzle that most Power View sessions offer, and peek behind the curtain to learn how to properly configure your environment to support Power View and how to prepare data for user consumption within Power View . 4/28/2012 2:45:00 PM 4/28/2012 3:45:00 PM 7672 Samuel greene DBA IRN 126 Are you finding your mornings filled with busy work? Trying to manage a large and growing number of SQL servers and feeling a bit overwhelmed? We'll take a look at tools that can help such as the SQL Server Tacklebox and a monitoring tool with a funny name - Zabbix. http://data.samgreene.com for more info. 4/28/2012 8:30:00 AM 4/28/2012 9:30:00 AM 7684 Jason Volpe BI Architecture IRN 106 This session will demonstrate how a BI semantic model is created, how it's used once it's created, and how to maintain it once it's deployed. The BI semantic model is a critical component in the new SQL 2012 BI capabilities. 4/28/2012 8:30:00 AM 4/28/2012 9:30:00 AM 7685 Jason Volpe Microsoft SC 140-144 In this session, we'll demonstrate how to build reports in the new SQL Server 2012 PowerView reporting toolset. In addition, we'll tackle some of the more complex features so you, too, can build beautiful looking reports. 4/28/2012 11:00:00 AM 4/28/2012 12:00:00 PM 7686 Jason Volpe Microsoft SC 140-144 With over 500 new features coming in SQL Server 2012, it's important to clearly illustrate how those new features impact SharePoint and what you need to be aware of. SharePoint is the cornerstone for collaboration in the Microsoft Business Intelligence Platform so make sure you know what to look out for as well as what you can take advantage of in the new SQL Server 2012 Platform. 4/28/2012 4:00:00 PM 4/28/2012 5:00:00 PM 7739 Tom Kallal App Dev / DBA IRN 129 Don’t miss this useful six pack of production-quality, system-level stored procedures. Source code is fully documented, and contains many valuable tips for querying SQL Server system views. The author will demonstrate each utility, and offer suggestions for extending it. 4/28/2012 1:30:00 PM 4/28/2012 2:30:00 PM 8162 Steve Jones Professional Development / Azure IRN 125 Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more. 4/28/2012 2:45:00 PM 4/28/2012 3:45:00 PM 8163 Steve Jones App Dev IRN 128 There are a number of encryption options in SQL Server and this session will talk about many of them, looking briefly at TDE, hashing, encryption keys, and SSL encrpytion. 4/28/2012 11:00:00 AM 4/28/2012 12:00:00 PM 8201 Andrew Thornton-Smith BI Delivery IRN 219 SharePoint is to be hosted on your SQL farm... Now what? In this session, we will cover the basic need to know for SQL administrators who are now responsible for SharePoint's DBs. In our journey, topics we will cover will be, Farm sizing's architecture to considerations for Enterprise Search and considerations for crawling the dreaded G:\, H:\ Z:\ drives, To the myriad of SharePoint Databases and which to watch out for. And finally what tasks in SharePoint are the heavy weights in terms of IOPS, CPU RAM. 4/28/2012 8:30:00 AM 4/28/2012 9:30:00 AM 8204 Erika Bakse BI Delivery IRN 131 Dynamic MDX can be a great way to reuse, reduce, and recycle .rdls and simplify report maintenance. Have a lot of reports that are practically the same, minus a few pesky exceptions? Dynamic MDX could be the answer! In this session we’ll walk through how to create a basic .rdl that can support a variety of MDX queries that will be generated dynamically. We will also discuss the pros and cons of this approach so that you can make an informed decision of when and if Dynamic MDX is the solution for you. 4/28/2012 9:45:00 AM 4/28/2012 10:45:00 AM 8205 Erika Bakse BI Delivery IRN 131 Reporting Services is a powerful tool that can make designing reports a snap...most of the time. But every once in a while you have to format a report very specifically, and that starts with your data query. In this session, we'll think outside the group! Learn about how to use named sets, dummy members, and other MDX tricks to craft your queries in a way that allows you to conquer the trickiest report layouts. 4/28/2012 1:30:00 PM 4/28/2012 2:30:00 PM 8252 Randy Knight App Dev / DBA IRN 129 The XML Functionality embedded into SQL Server 2005 and 2008 is one of its most powerful yet least understood features. This seems to be primarily because DBA's shy away from it and developers prefer to work with XML in their code. In this session we will explore the XML features of SQL Server and how we can bridge these two worlds. Topics covered will include retrieving relational data as XML, storing XML in the database using the XML Datatype, XML indexes, and the XQuery functions included in SQL Server. We will also look at using XML as stored procedure parameters as a way to pass large amounts of complex data between client and server. 4/28/2012 8:30:00 AM 4/28/2012 9:30:00 AM 8253 Randy Knight App Dev IRN 128 If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why 'SQL that works' is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that 'worked great in dev' but caused major issues when it hit production. 4/28/2012 2:45:00 PM 4/28/2012 3:45:00 PM 8254 Randy Knight App Dev / DBA IRN 129 In today's enterprise environments, it is becoming increasingly necessary to integrate data from a variety of sources. As SQL Server continues its march into the enterprise, the days of focusing 100% on one platform are over. At a bare minimum, we need to be able to communicate with DBA's for other platforms. Terminology as simple as Instance and Database mean very different things in Oracle than they do in SQL Server. In this session, we will compare and contrast the two platforms in terms of features and terminology. We will also discuss some of the best practices and pitfalls when integrating the two. 4/28/2012 11:00:00 AM 4/28/2012 12:00:00 PM 8315 Douglas Brendle DBA IRN 126 Ever wonder what's in your SQL Plan cache? Wonder why or how the plan cache got so big? This session will cover what the cache is, how it is used, and how poor application and query design can make it worse. Rather than put participants to sleep with dozens of slides we will get down and dirty with lots of demos including .Net code and some cool DMVs to guide the way. 4/28/2012 9:45:00 AM 4/28/2012 10:45:00 AM 8333 Denise McInerney App Dev / DBA IRN 129 Understanding Transactions Transactions are essential to maintaining data integrity. Getting transactions right means understanding both how they work and the business rules that govern your data. This session will explain the fundamentals of transactions and how they behave in SQL Server. It will delve into ACID properties, isolation levels and nested transactions. The session will also review how to structure transactions to satisfy business rules and ensure efficient performance. 4/28/2012 9:45:00 AM 4/28/2012 10:45:00 AM 8358 Amy Lewis SSIS IRN 123 Got data that is a mess that you have been asked to clean up before loading into your data warehouse? Come learn from this demo packed session the various components and techniques in SSIS for cleaning messy data including removing duplicates, removing unwanted characters and words. Become less 'fuzzy' about the cleansing powers of fuzzy grouping and fuzzy lookups. 4/28/2012 2:45:00 PM 4/28/2012 3:45:00 PM 8362 Tom Marek BI Delivery IRN 219 In a customer service based business world the newest feature being offered to clients in many industries is access to their data for ad hoc analytics. Agile players in many industries are stealing away market share because of this additional feature they can offer and in turn is forcing big players in every industry to just keep up to hold their ground. SQL Server 2012 will be in the middle of this battle and will give us the ability to deliver this feature without building the entire system from scratch. This feature is brought to us by using the new Power View and Business Intelligence Semantic Model all surfaced using SharePoint 2010. *** This session will be co-presented by Jacob Wilson who is a SharePoint MCM *** 4/28/2012 9:45:00 AM 4/28/2012 10:45:00 AM 8365 Tom Marek BI Architecture IRN 106 PowerPivot took end users a long way towards creating some amazing self-service data models that we are starting to find are very valuable to the business. Now how do we take these models to the next level and truly allow enterprise access to something that may have just lived in a team site previously? This is where the new features of Business Intelligence Semantic Models (BISM) come into play. We will take a BISM model from its baseline roots of a PowerPivot and drive it to the enterprise level showcasing partitioning, security, and hierarchies while explaining how these will come into play in a real world business scenario. 4/28/2012 2:45:00 PM 4/28/2012 3:45:00 PM 8366 Meredith Ryan DBA IRN 126 Creating backups is one of the fundamental skills every DBA should know, but there are a plethora of choices when it comes to how you will back up your databases. Learn the options with SQL server, what each choice will do for you and when to use each one. 4/28/2012 11:00:00 AM 4/28/2012 12:00:00 PM 8367 Meredith Ryan App Dev / DBA IRN 129 Let's cover the basics of setting up and monitoring SQL server Replication. I will focus on configuring transactional replication including options for the distributor, and where to run your log reader agents - but rest assured we will touch on merge and snapshot replication as well. 4/28/2012 2:45:00 PM 4/28/2012 3:45:00 PM 8392 Wil Sisney Professional Development / Azure IRN 125 Being a database professional can be a thankless job. No one thinks about the database when it works well. So how do you get the proper recognition when performance review time rolls around? How do you distinguish yourselves among your peers? This session will cover 6 things you can focus on to ace your next performance review! 4/28/2012 8:30:00 AM 4/28/2012 9:30:00 AM 8394 Matt Smith BI Architecture IRN 106 Let's take a look at this new feature of SQL 2012 and see if we truly can get PowerPivot Performance in a database. After that we will cover potential use cases and identify where it can be used in your org. 4/28/2012 11:00:00 AM 4/28/2012 12:00:00 PM 8397 Martin Schoombee BI Architecture IRN 106 Snapshot fact tables are a common approach when a point-in-time reference is required. In some cases though, even snapshots are not an option due to the amount of data it will generate. In this session we will walk through a practical example of when and how to implement temporal fact tables, and how these can be a viable alternative to snapshots in certain situations. 4/28/2012 4:00:00 PM 4/28/2012 5:00:00 PM 8437 Robert Miller App Dev IRN 128 SQL Server introduced the ability to define TVPs (aka, User-Defined Table Types) as a Read-Only parameter-type in stored procedures. As usual, the .Net out-of-the-box experience is not the most performant. To truly realize the full performance benefit with passing data from a .Net application via a TVP requires additional development. 4/28/2012 4:00:00 PM 4/28/2012 5:00:00 PM 8438 Robert Miller App Dev IRN 128 Review and compare Change-Tracking and Change Data Capture functionality. 4/28/2012 8:30:00 AM 4/28/2012 9:30:00 AM 8504 Carlos Bossy BI Architecture IRN 120 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. Carlos Bossy will show you how to use SQL Server features such as Replication, Change Data Capture, SSIS and other techniques to extract, transform and load data fast and dependably and view a real demonstration of the system in action. Finally, Carlos will show how to use Reporting Services to present data with a minimum amount of latency. 4/28/2012 2:45:00 PM 4/28/2012 3:45:00 PM 8566 Jacob Wilson BI Delivery IRN 219 No more SSRS report database??? Learn about the new SSRS architecture in SQL 2012 for SharePoint 2010 integration and how the architecture has been pushed away from SQL into SharePoint. 4/28/2012 1:30:00 PM 4/28/2012 2:30:00 PM 8570 Martin Schoombee BI Architecture IRN 120 Facts and Dimensions are the essence of any Data Warehouse, but there are many other components required to make the environment scalable, flexible and fully automated. There are lots of decisions to be made: Should you have a separate database for staging or not? How do you fully automate the ETL sub-system and parameterize it? In this session we will discuss a practical approach to designing the Data Warehouse back-end, based on personal experience. 4/28/2012 1:30:00 PM 4/28/2012 2:30:00 PM 8572 Josh Sivey BI Architecture IRN 106 Join me in learning how to design aggregations for your SSAS cubes using Usage Based Optimization. We'll learn about capturing usage patterns in the SSAS query log and then using that log information to help the Agregation Design Wizard design aggregations to improve the overall performance of a partition. 4/28/2012 9:45:00 AM 4/28/2012 10:45:00 AM 8573 Josh Sivey BI Architecture IRN 120 In this talk, we discuss how to use the LastNonEmpty AggregateFunction available in SSAS Enterprise Edition to enable 'point in time' reporting and analysis. We'll also discuss point in time reporting strategies if you don't have SSAS Enterprise Edition. 4/28/2012 4:00:00 PM 4/28/2012 5:00:00 PM 8576 Jeff Renz SSIS IRN 123 This is a demo intensive deep dive showing a variety of SSIS methods that you can use to load unstructured text files, gigabyte size files, images, XML, Excel, email, and binary files. I will share techniques that allow files to be loaded in real time with a queue system to load small files separate from large files, file merging for fast loading, and parallel file loading using master/child packages and custom SSIS objects. Finally, I will share useful C# code for parsing complex strings, data manipulation and file archival. 4/28/2012 9:45:00 AM 4/28/2012 10:45:00 AM 8577 Jeff Renz BI Architecture IRN 120 Data vault is a compelling new architecture for an enterprise data warehouse. Star schema data warehouses are the most well-known design pattern in the industry. Are hub, link and satellite tables your cup of tea or are you more of a fact and dimension type of person? Come with an open mind to our session and cast your vote for the architecture that you prefer. No matter which way you vote, you will come away with a deeper understanding of the data vault and star schema architectures, the pros and cons of both, and new implementation techniques to leverage new features of SQL Server 2012. 4/28/2012 11:00:00 AM 4/28/2012 12:00:00 PM 8578 Jeff Renz BI Delivery IRN 131 Many BI developers are familiar with generating dashboards using Performance Point or other drag and drop non-coding solutions. However, it’s time to take it up a notch. Come to my session and learn how to develop amazing interactive Silverlight dashboard applications that impress your users but doesn’t cost your company an arm and a leg. After attending my session you will learn the basics about Silverlight, WCF, and very simple to implement 3rd party controls which take your dashboard from basic to amazing. Rest assured you don’t have to be an expert in web development to be successful in creating a dashboard in Silverlight that simply rocks. 4/28/2012 2:45:00 PM 4/28/2012 3:45:00 PM 8591 Brad Baker SSIS IRN 123 Since its initial release in Microsoft SQL Server 2005, Integration Services has been incrementally improved in each subsequent version. However, those changes were minor in comparison to the major enhancements, performance improvements, and new features introduced in SQL Server 2012 Integration Services. These changes can be organized into the categories of development, deployment and administration. This presentation will be focused on what's new in SQL Server 2012 SSIS development. 4/28/2012 8:30:00 AM 4/28/2012 9:30:00 AM 8593 Mark Bosley App Dev IRN 128 You work with smart people, but there you are in a code review of a co-worker's SQL ready to be rushed into production and it is so elaborately stupid that you don't know where to start. How did we get here? Why is the level of SQL literacy so low? There are two goals in the session. First, we will look at lot's of stupid SQL. Second, we will talk about how to encourage co-workers to write better SQL. Looking at stupid SQL can help even experienced programmers as we examine why something is wrong. Along the way, we note where SQL Server itself is stupid (e.g. the IsNumeric function) We will also look at some places where some subtleties of SQL can trip even an experienced Pro. 4/28/2012 1:30:00 PM 4/28/2012 2:30:00 PM 8594 Carlos Bossy BI Architecture IRN 120 SQL Server 2012 has made it easier to make the move to Business Intelligence and in this session Carlos Bossy will present three new features you can (and should) implement immediately. The new Analytics functions in T-SQL, Columnstore indexes, and the Tabular model are powerful features that will give your users the ability to analyze data in a faster, more effective manner. Each of these features was targeted at casual or beginning BI developers and DBAs who more familiar with traditional relational database models. You will leave this session with a good understanding of the next steps to take to get on the fast-track to BI. 4/28/2012 8:30:00 AM 4/28/2012 9:30:00 AM 8621 Angel Abundez BI Delivery IRN 131 Today's executives and information workers want to use mobile devices to get at their business information, make critical decisions, and thrive. Let's help them get there with SQL Server Reporting Services and SharePoint. Tablets are common place now, and smart phones have been in place for years, but have we devoted enough attention to make effective use of the new form factors? Let's discuss how our design approach changes when we want to launch mission-critical dashboards and reports on smaller screen sizes using touch-screen technology. We'll look at iPad and other mobile devices, SSRS and SharePoint, BI Developer and Business User, with emphasis on data visualization best practices. 4/28/2012 11:00:00 AM 4/28/2012 12:00:00 PM 8644 Gus Apostol Microsoft SC 140-144 The SQLOS component is an internal user mode OS enrichment layer for SQL Server that delivers necessary system level services such as co-operative user mode scheduling, memory management, deadlock detection and exception handling to SQL Server components. One of the investments we made for SQL Server 2012 is to refactor the Memory Manager subcomponent in SQLOS to allow users to predictably size the SQL Server memory consumption in addition to performance scalability improvements. Come learn about what this change means for sizing memory for workloads in SQL Server 2012. You will also hear about related DMV and performance counter changes for this improvement. 4/28/2012 9:45:00 AM 4/28/2012 10:45:00 AM 8647 Gus Apostol Microsoft SC 140-144 SQL Server database administrators need to proactively prevent or minimize performance problems when they occur, and diagnose the cause to take the appropriate corrective action. The reasons for performance problems can range from a poorly designed database to a system that is improperly configured for the workload. This talk will focus on understanding common performance problems, diagnosing and troubleshooting using publicly available tools, and provide a general methodology for diagnosing and troubleshooting SQL Server performance problems using common customer scenarios. 4/28/2012 2:45:00 PM 4/28/2012 3:45:00 PM 8717 Rushabh Metha SSIS IRN 123 SSIS 2012 Management Considerations and Best PracticesSQL Server 2012 introduces a number of exciting new features that will change the way we design, deploy and manage SSIS packages. We will explore the new features, understand how to take advantage of them and formulate some best practices for efficient management of these packages. 4/28/2012 1:30:00 PM 4/28/2012 2:30:00 PM 8718 Jeff Jones App Dev IRN 128 According to Itzik Ben-Gan: “Windowing functions are the best thing to happen since sliced bread”. In SQL Server 2005, Microsoft introduced SQL Windowing into Transact-SQL with new ranking functions and existing aggregate functions. This gave the Transact-SQL developer the ability to easily generate row numbers and compute sums, averages, etc. while returning detailed data rows. But the ANSI/ISO SQL standard had defined additional windowing functionality and SQL Server 2012 now supports more of it. This includes the ability to frame the scope of the window and new functions like LAG, LEAD, FIRST_VALUE and LAST_VALUE. These enhancements extend the set-based functionality of Transact-SQL. 4/28/2012 9:45:00 AM 4/28/2012 10:45:00 AM 8723 Amy Lewis Microsoft SC 140-144 Join us during lunch with a panel of Women In Technology. 4/28/2012 12:30:00 PM 4/28/2012 1:30:00 PM 8724 Ryan McCauley DBA IRN 126 Automating SQL Server source control - Ryan McCauley This session will look at a quick and easy process that takes regular snapshots of object definitions in the database and stores any changes. Representing SQL Server data spaces visually - Ryan McCauley This session will take a quick look at a Codeplex project that does this, SQL Space Mapper, and how it accomplishes it by leveraging a library from Microsoft Research SSRSaaS? Maybe not, but you might be surprised. Matt Smith GUARANTEED - GUARANTEED - In 15 minutes you will know how to write a web service end point using SSRS. If I don't do it in 15 minutes, you'll get your money back!!! - 4/28/2012 2:45:00 PM 4/28/2012 3:45:00 PM 8735 David Ikeda Microsoft SC 140-144 In this session, you’ll learn how to configure and implement SQL Server AlwaysOn Availability groups. We’ll explore the architecture, concepts, and steps for configuring High Availability in SQL Server 2012 4/28/2012 1:30:00 PM 4/28/2012 2:30:00 PM 8736 David Ikeda Professional Development / Azure IRN 125 Are you interested in becoming certified in SQL Server? Do you already hold a SQL certification and wonder about getting certified in the new program? In this session, David ikeda will provide an overview of the certifications and training offered by Microsoft for SQL Server 2012. We’ll discuss the value of being certified, and then discuss the different certifications, upgrade paths and the related training options offered by Microsoft Learning. 4/28/2012 11:00:00 AM 4/28/2012 12:00:00 PM 8982 Kathrine Lord Professional Development / Azure IRN 125 In this session you will learn how to integrate Azure Marketplace data and other Odata feeds into your Semantic Model to provide rich and robust modeling and reporting without the need to create complex workflows or copy and paste formulas every time you manually integrate external data. You will also learn how to publish your data to the marketplace and the roadmap for Microsoft’s private data hubs – bringing the power of the Azure Marketplace to your datacenter. 4/28/2012 9:45:00 AM 4/28/2012 10:45:00 AM 9027 Lou Carbone Microsoft SC 140-144 Session will cover overall method to migrate from an Oracle database to a SQL Server database. Will address architecture. Key components: Methodology, Demonstration of SSMA (Reports, potentially data migration itself, time permitting) (Using Oracle 11i database(data warehouse structure) to SQL Server 2012.) 4/28/2012 8:30:00 AM 4/28/2012 9:30:00 AM