SQLSaturday #177 - Silicon Valley 2013 2/23/2013 12:00:00 AM (GMT-08:00) Pacific Time (US and Canada); Tijuana SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat177 Microsoft Technology Center 1065 La Avenida, Building 1 Mountain View CA 94043 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 2819 ScaleArc Platinum Sponsor http://www.scalearc.com http://www.sqlsaturday.com/files/2bc46ff7-8dbd-4278-9a49-cb4c465fc1c8.jpg 60 170 2833 DesignMind Platinum Sponsor http://www.designmind.com http://www.designmind.com/blog/wp-content/uploads/2012/08/DesignMind_San-Francisco_170x60.png 60 170 2898 SIOS Technology Platinum Sponsor http://us.sios.com/company/about-us/ http://www.sqlsaturday.com/files/11157a4c-31e5-45ff-ad05-e71874e1e460.jpg 60 170 2905 FusionIO Platinum Sponsor http://www.fusionio.com http://www.sqlsaturday.com/files/fec73ae7-45dd-43d0-b4ca-e6d4296e76ed.jpg 60 170 2920 Microsoft Platinum Sponsor http://www.microsoft.com http://www.sqlsaturday.com/files/9fe15dbd-f356-41c6-a665-ec17d0de1711.jpg 60 170 2944 EMC Platinum Sponsor https://community.emc.com/community/connect/everything_microsoft http://www.sqlsaturday.com/files/e4d0a2a9-b856-40bb-990c-acaa9d79e440.jpg 60 170 3016 NetApp Platinum Sponsor http://www.netapp.com http://www.sqlsaturday.com/files/e05ac7f8-87aa-4069-8241-8a77897f1935.jpg 60 170 3064 Nimble Storage Platinum Sponsor http://www.nimblestorage.com http://www.sqlsaturday.com/files/714bbe1a-2149-4605-a04b-9be252f658be.jpg 60 170 3032 Dynamics Edge Gold Sponsor http://www.dynamicsedge.com http://www.sqlsaturday.com/files/ba499523-8c7a-474c-8ff2-7563e6b09a50.jpg 60 170 3081 Precise Gold Sponsor http://www.precise.com http://www.sqlsaturday.com/files/a623aed0-9f47-4671-8170-7c005b59b538.jpg 60 170 3084 LearnIT Gold Sponsor http://www.learnit.com http://www.sqlsaturday.com/files/b2a77d15-ccd2-4a12-b582-999732b33713.jpg 60 170 2964 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2951 Melissa Data Gold Sponsor http://www.melissadata.com http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif 60 170 2922 QuickStart Intelligence Gold Sponsor http://www.quickstart.com http://www.sqlsaturday.com/files/5b74a4fe-e613-4269-81a3-ef7daf93f332.jpg 60 170 3040 Astute Networks Speaker Dinner and Silver Sponsor http://www.astutenetworks.com http://www.sqlsaturday.com/files/67599b5a-3b40-4045-8db0-c1252b0adb98.jpg 60 170 3019 Robert Half Technology Silver Sponsor http://www.rhi.com http://www.sqlsaturday.com/files/692100a3-dee4-47b6-a054-244fdc395452.jpg 60 170 3009 Dell Software Group Silver Sponsor http://www.quest.com/ http://i.imgur.com/BAdC3.png 60 170 3028 SQLskills.com Silver Sponsor http://www.sqlskills.com/ http://www.sqlsaturday.com/files/27234383-bad9-4c5a-83a4-650dfa8e9b35.jpg 60 170 2899 Xtivia, Inc Silver Sponsor http://www.xtivia.com/ http://www.xtivia.com/images/XtiviaLogo-170x60.jpg 60 170 2982 Violin Memory Silver Sponsor http://www.violin-memory.com/ http://www.sqlsaturday.com/files/c7cff1d7-3156-4eac-8939-2ba76a756afc.jpg 60 170 2959 Data by Design Silver Sponsor http://www.dataxdesign.com http://www.sqlsaturday.com/files/237d3e74-3734-4954-88cd-784c32d2c0ee.png 60 170 2963 Red Gate Software Silver Sponsor http://redg.at/XGNByD http://www.red-gate.com/assets/images/common/logo.png 60 170 3001 Sql Power Tools, Inc. Bronze Sponsor http://www.sqlpower.com http://www.sqlpower.com/img/spt_logo_sql_saturday.png 60 170 3004 Krasis Consulting, S.L. / B 36869162 Bronze Sponsor http://www.campusmvp.net/ http://www.campusmvp.net/files/communities/170x60_campusMVPnet_white.gif 60 170 3005 SQL Sentry, Inc. Bronze Sponsor http://www.sqlsentry.net http://www.sqlsentry.net/UI/customMenu/headLogo.png 60 170 3020 COZYROC Bronze Sponsor http://www.cozyroc.com/ http://www.sqlsaturday.com/files/b6d6e261-3657-498e-9a76-e44302f7f0e4.jpg 60 170 3065 xsql Software Software Sponsor http://www.xsql.com/ http://www.sqlsaturday.com/files/158344c2-cee9-45d0-b358-971c3e4f23df.jpg 40 100 3072 Sapien Technologies, Inc. Software Sponsor http://www.sapien.com http://www.sqlsaturday.com/files/31e957a2-3b40-4537-97d1-715aca3017c6.jpg 40 100 3099 Morgan Kaufmann Book Sponsor http://www.mkp.com http://www.sqlsaturday.com/files/194f296c-00a9-4952-aa6b-84e8faf59cef.jpg 40 100 3018 McGraw Hill Technical Book Sponsor http://www.mhprofessional.com http://www.sqlsaturday.com/files/76320424-8054-4da9-8a50-bff96ea81901.jpg 40 100 2957 O'Reilly Media, Inc. Book Sponsor http://www.oreilly.com http://www.sqlsaturday.com/files/bfe33dc4-5cf4-4ee3-b5b8-3f9d11266d1e.jpg 40 100 2828 Steve Stedman Blog Sponsor http://DatabaseHealth.SteveStedman.com http://stevestedman.com/wp-content/uploads/SteveStedman-Database-Health-Reports.png 40 100 11445 SQLSaturday 177 Track 1 - Galileo Galileo 2/23/2013 9:45:00 AM 2/23/2013 10:00:00 AM 11445 SQLSaturday 177 Track 1 - Galileo Galileo 2/23/2013 2:30:00 PM 2/23/2013 2:45:00 PM 11445 SQLSaturday 177 Track 2 - Mercury Mercury 2/23/2013 9:45:00 AM 2/23/2013 10:00:00 AM 11445 SQLSaturday 177 Track 2 - Mercury Mercury 2/23/2013 2:30:00 PM 2/23/2013 2:45:00 PM 11445 SQLSaturday 177 Track 3 - Jupiter Jupiter 2/23/2013 9:45:00 AM 2/23/2013 10:00:00 AM 11445 SQLSaturday 177 Track 3 - Jupiter Jupiter 2/23/2013 2:30:00 PM 2/23/2013 2:45:00 PM 11445 SQLSaturday 177 Track 4 - Saturn Saturn 2/23/2013 9:45:00 AM 2/23/2013 10:00:00 AM 11445 SQLSaturday 177 Track 4 - Saturn Saturn 2/23/2013 2:30:00 PM 2/23/2013 2:45:00 PM 11445 SQLSaturday 177 Track 4 - Saturn Saturn 2/23/2013 11:00:00 AM 2/23/2013 11:15:00 AM 11445 SQLSaturday 177 Track 5 - Computer Training Room Nebula 2/23/2013 9:45:00 AM 2/23/2013 10:00:00 AM 11445 SQLSaturday 177 Track 5 - Computer Training Room Nebula 2/23/2013 2:30:00 PM 2/23/2013 2:45:00 PM 11445 SQLSaturday 177 Track 5 - Computer Training Room Nebula 2/23/2013 11:00:00 AM 2/23/2013 11:15:00 AM 11445 SQLSaturday 177 Track 6 - ECR Exec Conf Room 2/23/2013 9:45:00 AM 2/23/2013 10:00:00 AM 11445 SQLSaturday 177 Track 6 - ECR Exec Conf Room 2/23/2013 2:30:00 PM 2/23/2013 2:45:00 PM 11445 SQLSaturday 177 Track 6 - ECR Exec Conf Room 2/23/2013 11:00:00 AM 2/23/2013 11:15:00 AM 11446 SQLSaturday 177 Track 6 - ECR Exec Conf Room 2/23/2013 12:15:00 PM 2/23/2013 12:45:00 PM 11446 SQLSaturday 177 Track 5 - Computer Training Room Nebula 2/23/2013 12:15:00 PM 2/23/2013 12:45:00 PM 11446 SQLSaturday 177 Track 4 - Saturn Saturn 2/23/2013 12:15:00 PM 2/23/2013 12:45:00 PM 11446 SQLSaturday 177 Track 3 - Jupiter Jupiter 2/23/2013 12:15:00 PM 2/23/2013 12:45:00 PM 11446 SQLSaturday 177 Track 2 - Mercury Mercury 2/23/2013 12:15:00 PM 2/23/2013 12:45:00 PM 11446 SQLSaturday 177 Track 1 - Galileo Galileo 2/23/2013 12:15:00 PM 2/23/2013 12:45:00 PM 11447 SQLSaturday 177 Track 1 - Galileo Galileo 2/23/2013 7:30:00 AM 2/23/2013 8:30:00 AM 11447 SQLSaturday 177 Track 2 - Mercury Mercury 2/23/2013 7:30:00 AM 2/23/2013 8:30:00 AM 11447 SQLSaturday 177 Track 3 - Jupiter Jupiter 2/23/2013 7:30:00 AM 2/23/2013 8:30:00 AM 11447 SQLSaturday 177 Track 4 - Saturn Saturn 2/23/2013 7:30:00 AM 2/23/2013 8:30:00 AM 11447 SQLSaturday 177 Track 5 - Computer Training Room Nebula 2/23/2013 7:30:00 AM 2/23/2013 8:30:00 AM 11447 SQLSaturday 177 Track 6 - ECR Exec Conf Room 2/23/2013 7:30:00 AM 2/23/2013 8:30:00 AM 11448 SQLSaturday 177 Track 6 - ECR Exec Conf Room 2/23/2013 5:00:00 PM 2/23/2013 6:00:00 PM 11448 SQLSaturday 177 Track 5 - Computer Training Room Nebula 2/23/2013 5:00:00 PM 2/23/2013 6:00:00 PM 11448 SQLSaturday 177 Track 4 - Saturn Saturn 2/23/2013 5:00:00 PM 2/23/2013 6:00:00 PM 11448 SQLSaturday 177 Track 3 - Jupiter Jupiter 2/23/2013 5:00:00 PM 2/23/2013 6:00:00 PM 11448 SQLSaturday 177 Track 2 - Mercury Mercury 2/23/2013 5:00:00 PM 2/23/2013 6:00:00 PM 11448 SQLSaturday 177 Track 1 - Galileo Galileo 2/23/2013 5:00:00 PM 2/23/2013 6:00:00 PM 11450 Aaron Nelson Track 4 - Saturn Saturn You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool. 2/23/2013 4:00:00 PM 2/23/2013 5:00:00 PM 11474 Wenming Ye Track 1 - Galileo Galileo Web 2.0 companies have been fully taking advantage of Hadoop based open source tools to tackle Big Data needs. Microsoft now offers the best of both worlds with its own Hadoop solution on Windows Azure with full compatibility and additional rich toolsets. This session is a 'getting-started' tutorial on developing Big Data applications on Windows Azure. We cover application scenarios, Hadoop on Azure, tools, and applied data analytics. More importantly, we show you how to put everything together with a couple of sample applications. 2/23/2013 10:00:00 AM 2/23/2013 11:00:00 AM 11486 Scott Klein Track 4 - Saturn Saturn This session will take an exploratory look at Microsoft's cloud-based relational database offering. We'll lift the hood and look at its many benefits and features, and how it easily fills the need for a highly available and scalable database service in the cloud. We'll discuss how SQL Azure helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA's alike can focus on the aspects of their job they really care about. 2/23/2013 11:15:00 AM 2/23/2013 12:15:00 PM 11515 Rob Kerr Track 2 - Mercury Mercury Learn how to combine SQL Server and SharePoint technologies to deliver compelling insights and rich data exploration. This session covers architecture and deployment planning for BI solutions using SQL Server, Analysis Services, PowerPivot, Power View, Excel Services and related technologies. 2/23/2013 10:00:00 AM 2/23/2013 11:00:00 AM 11866 Pat Sinthusan Track 7 - 2036 MTC Room 2036 Microsoft SQL Server is one of the most commonly virtualized applications environments. With the release of SQL Server 2012, Microsoft introduces full support for SMB. Now you can install SQL Server 2012 with both system and user databases on SMB file shares. This allows you to build end-to-end NAS solutions where the data management capabilities of NAS, such as volume auto grow and shrink. This session will demonstrate how to install and run SQL Server over SMB and VMware NFS on NetApp storage as well as best practices, caveats, and performance of SQL Server database over NAS storage. 2/23/2013 11:15:00 AM 2/23/2013 12:15:00 PM 11948 Joseph Sack Track 6 - ECR Exec Conf Room When the query optimizer inaccurately estimates the number of rows for query execution plan iterators, performance can suffer due to 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. 2/23/2013 1:30:00 PM 2/23/2013 2:30:00 PM 11968 Julie Koesmarno Track 2 - Mercury Mercury One of the hottest trends in analytics right now is geospatial reporting. Long gone are the days of viewing region based data in a grid. Now it is possible to provide users with additional insight on the regional performance of business. In this session, Julie will show you three options for creating and delivering these analytics. First SQL Server Reporting Services 2012 will be presented to show how we can create custom shape objects to conform with business defined regions. Secondly, using the power of Excel 2013, Bing Maps and GeoFlow, learn how to build captivating visualizations directly in Excel. Finally, we'll show how easy it is to build interactive maps using Power View. 2/23/2013 11:15:00 AM 2/23/2013 12:15:00 PM 12107 Denise McInerney Track 3 - Jupiter Jupiter Incorrect, inaccurate and misleading data can get into a database in a variety of ways. It causes bugs, impacts customers and hurts business. This session will explain how DBAs and developers can proactively ensure the data coming into a transactional system is clean and correct. The topics covered will include table design, the pitfalls of NULL, “garbage in”, transactions, change management, and coding standards. The presentation will draw on the speaker's years of personal experience managing busy e-commerce databases supporting multi-million dollar businesses. The speaker will use real-life examples and demos to illustrate the many ways that OLTP data quality can be compromised. 2/23/2013 4:00:00 PM 2/23/2013 5:00:00 PM 12129 Kevin Kline Track 1 - Galileo Galileo SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy, nor does it mean is problem free. After all, many apps are growing from small, home-grown applications every year, with green IT professionals encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. There is a short list of mistakes that, if you know of them in advance, will make your life much easier. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before. 2/23/2013 4:00:00 PM 2/23/2013 5:00:00 PM 12133 Joseph Vertido Track 3 - Jupiter Jupiter The spectrum of Contact Data Quality covers numerous interrelated aspects such as parsing, standardization, correction, verification, enrichment and matching. But one crucial concept that is quite commonly overlooked in the field of data quality is the implementation of an intelligent and automatable process for the creation of the “golden record” through the consolidation of data within the matching process; a technique also known as Survivorship. 2/23/2013 11:15:00 AM 2/23/2013 12:15:00 PM 12169 Janis Griffin Track 4 - Saturn Saturn More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment. 2/23/2013 1:30:00 PM 2/23/2013 2:30:00 PM 12232 Randy Knight Track 6 - ECR Exec Conf Room SQL Server offers several isolation levels beyond the default 'READ COMMITTED'. But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each. 2/23/2013 4:00:00 PM 2/23/2013 5:00:00 PM 12265 William Brown Track 2 - Mercury Mercury Details to follow shortly 2/23/2013 4:00:00 PM 2/23/2013 5:00:00 PM 12280 Jason Horner Track 3 - Jupiter Jupiter In this session, we will dive deeper into the art of dimensional modeling. We will identify the different types of fact tables and dimension tables and discuss how and when to use each type. We will also review approaches to creating rich hierarchies that simplify complex reporting. This session will be very interactive--bring your toughest dimensional modeling quandaries! 2/23/2013 1:30:00 PM 2/23/2013 2:30:00 PM 12383 Grant Fritchey Track 4 - Saturn Saturn Just because you're using an Azure SQL database does not mean you can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using up lots of resources. This session will introduce you to the tools you have available to identify poor performing queries, such as dynamic management objects and others. You'll learn how to understand why a query is running slow using the Azure Portal execution plans. This understanding will enable you to fix your poorly performing queries. All in the cloud. 2/23/2013 10:00:00 AM 2/23/2013 11:00:00 AM 12477 Dilip Nayak and Mitchell Bottel Track 5 - Computer Training Room Nebula Once upon a time, there were 2 SQL Solutions named High Availability and Disaster Recovery. They had a love hate relationship and could never find a common ground. That is, until SQL Server 2012 brought them together in a love story built for the ages. When the dust settled, a beautiful new feature was born. It was called AlwaysON and brought with it new technologies like availability groups, read-only mirrors and listeners. It was a perfect blend of both HA and DR all wrapped up in one bundle of joy. SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. Come see and learn some of the new features associated with it, how they work and why this new feature of SQL Server 2012 is so wonderfu 2/23/2013 4:00:00 PM 2/23/2013 5:00:00 PM 12523 Mark Tabladillo Track 3 - Jupiter Jupiter If you have a SQL Server license (Standard or higher) then you already have the ability to start data mining. In this new presentation, you will see how to scale up data mining from the free Excel 2013 add-in to production use. Aimed at beginning to intermediate data miners, this presentation will show how mining models move from development to production. We will use SQL Server 2012 tools including SSMS, SSIS, and SSDT. 2/23/2013 10:00:00 AM 2/23/2013 11:00:00 AM 12527 Allan Hirt Track 5 - Computer Training Room Nebula The word cluster is used a lot in the IT world, especially when it comes to SQL Server. We have clustered instances of SQL Server, availability groups that require Windows failover clustering ... but how does a DBA make sense of it all? Wonder no more! This session will explain all the forms of clustering as they relate to SQL Server (including how Windows fits into the picture) and give you some of the top keys to success whether you are using an older version of Windows and SQL Server, or you're looking to deploy the latest and greatest. 2/23/2013 2:45:00 PM 2/23/2013 3:45:00 PM 12555 Argenis Fernandez Track 4 - Saturn Saturn Do you consider the Windows GUI to be a waste of resources? Starting with SQL Server 2012, you can run on top of Windows Server Core 2008 R2 or 2012. In this session we will discuss installation and management of SQL Server on Windows Server Core, along with lots of tips and tricks. 2/23/2013 2:45:00 PM 2/23/2013 3:45:00 PM 12565 Carlos Bossy Track 1 - Galileo Galileo If you’re like most Database Administrators then you already work with data that is big, so what is this big data thing all about? This session will cover the significance of big data by comparing and contrasting it to the SQL Server relational database environment. It will also demonstrate the value a big data ecosystem can provide to your technology infrastructure organization by using it to complement your existing data architecture, and by having it co-exist in effective ways with your SQL Server databases. Live demonstrations will show how you to get maximum value out of big data with tools such as Sqoop, Hive and Pig so that you can perform bulk data transfers, queries, and ETL using SQL Server and HDFS, the Hadoop file system. 2/23/2013 2:45:00 PM 2/23/2013 3:45:00 PM 12591 Mickey Stuewe Track 7 - 2036 MTC Room 2036 Did you know that the Table, Matrix, and List controls are all based on the highly flexible Tablix Data Region Grid? So really, they are all one control that can be morphed into each other. Learn how to get the most out of the Tablix controls in this demo-heavy session. We'll go through how to best layout data using multiple Tablix controls. We’ll use parameters to change the layout of the data in these controls to minimize the number of reports that need to be maintained. We’ll create a columnar report that grows vertically as well as horizontally, and we’ll find out about other exciting uses of this highly flexible control. 2/23/2013 2:45:00 PM 2/23/2013 3:45:00 PM 12597 Eddie Wuerch Track 6 - ECR Exec Conf Room Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them. 2/23/2013 2:45:00 PM 2/23/2013 3:45:00 PM 12599 Kevin Boles Track 6 - ECR Exec Conf Room For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure! 2/23/2013 11:15:00 AM 2/23/2013 12:15:00 PM 13036 SQLSaturday 177 Track 6 - ECR Exec Conf Room 2/23/2013 6:00:00 PM 2/23/2013 7:30:00 PM 13036 SQLSaturday 177 Track 5 - Computer Training Room Nebula 2/23/2013 6:00:00 PM 2/23/2013 7:30:00 PM 13036 SQLSaturday 177 Track 1 - Galileo Galileo 2/23/2013 6:00:00 PM 2/23/2013 7:30:00 PM 13036 SQLSaturday 177 Track 2 - Mercury Mercury 2/23/2013 6:00:00 PM 2/23/2013 7:30:00 PM 13036 SQLSaturday 177 Track 4 - Saturn Saturn 2/23/2013 6:00:00 PM 2/23/2013 7:30:00 PM 13036 SQLSaturday 177 Track 3 - Jupiter Jupiter 2/23/2013 6:00:00 PM 2/23/2013 7:30:00 PM 13266 Denny Cherry Track 1 - Galileo Galileo In this session we will be looking at the SQL Server table partitioning features which were introduced in SQL Server 2008. We will look at how to create partitioned tables and indexes as well as the internals of the table. We will also look at how to move data from one partition to another and from one table to another with minimal to no impact to the users. Using these techniques we will be able to improve query performance and reduce downtime when loading and pruning data. 2/23/2013 1:30:00 PM 2/23/2013 2:30:00 PM 13267 Mark Gschwind Track 2 - Mercury Mercury A recent survey by Information Week found that data quality is the greatest barrier to BI adoption in enterprises. MDS addresses this challenge with modeling, validation, alerting and security capabilities. In this presentation, you will learn how to use MDS to model your data to ensure correctness, update it with changes from your ERP, and alert users to data conditions that require attention. Next you will learn the capabilities of DQS and see how it addresses data standardization, completeness and uniqueness challenges. You will then see how to use them together to enable Enterprise Information Management. BI professionals will come away with knowledge on how to use tools that address the greatest risk to success for BI projects - d 2/23/2013 1:30:00 PM 2/23/2013 2:30:00 PM 13268 Dan Bulos Track 2 - Mercury Mercury Microsoft has a broad range of tools that can be used to create a BI application: Power View, Reporting Services, and Excel (Pivot Tables Power View) on the presentation side and SQL, Analysis Services (MOLAP Tabular), PowerPivot, and Excel models on the data side. Which ones should you use when? Should an application mix and match or should an application focus on a limited set of tools? While the technologies in each class have similarities (Power View, Reporting Services, and Pivot Tables all have bar charts), they are fundamentally different and should be used in different circumstances. Compare the tools and learn nuances of each of them by seeing them in the context of real world examples. See how choosing different tool str 2/23/2013 2:45:00 PM 2/23/2013 3:45:00 PM 13269 Joy Mundy Track 1 - Galileo Galileo 2/23/2013 11:15:00 AM 2/23/2013 12:15:00 PM 13270 Phil Hummel Track 5 - Computer Training Room Nebula SQL Server, HyperV, Virtual SAN Switches - Virtual Reality! Details coming soon... 2/23/2013 10:00:00 AM 2/23/2013 11:00:00 AM 13271 Ami Levin Track 6 - ECR Exec Conf Room In this session, we revisit some of the fundamental design principals of relational databases—normalization rules, key selection, and the controversies associated with these issues—from a very hands-on, practical perspective. We also consider the benefits and challenges of using different types of keys (natural, surrogates, artificial, others) from multiple aspects, including data consistency, application development, maintenance, portability, and performance. 2/23/2013 10:00:00 AM 2/23/2013 11:00:00 AM 13273 Chris Shaw Track 5 - Computer Training Room Nebula It depends, every situation is different. The question is often asked of DBA's to provide a solution to very open ended requirements. However, the best solution can only be provided if the database professional is getting all the answers. This session is a case study into many of Disaster Recovery options that we as database professionals have. Understand the answers to the important questions that we should be asking to provide the best solution not only for the database but for the business as well. As an attendee you will learn how to change an answer from it depends into a solid solution that can be built upon. We will take examples from experiences and as a group determine what the best solution is. 2/23/2013 1:30:00 PM 2/23/2013 2:30:00 PM 13274 Justin Barney Track 2 - Mercury Mercury For mission-critical applications being supported by MS SQL Server, uptime and performance are everything, especially under heavy workloads. In this session you will learn how ScaleArc delivers SQL Server infrastructure software that is deployed transparently in minutes and enables higher uptime and significantly better performance for existing SQL Server deployments while providing an instant boost to SQL Servers to handle more traffic (i.e., do more with less). ScaleArc will also demonstrate how it’s software provides real-time query analytics to identify problem queries immediately and optimize traffic. Finally, ScaleArc will demonstrate how customers can achieve horizontal scale-out of a SQL Server environment without having to re-code 2/23/2013 12:45:00 PM 2/23/2013 1:15:00 PM 13275 Jamila Gunawardena and Tony Tomarchio Track 3 - Jupiter Jupiter Powered by Fusion-io, Protected by SIOS 2/23/2013 12:45:00 PM 2/23/2013 1:15:00 PM 13276 Denise McInerney Track 1 - Galileo Galileo Women make up only about 25% of the computing workforce. The number of women majoring in Computer Science in the U.S. has declined significantly over the past 25 years. Yet today technology companies can't find enough talented engineers and the demand is only going to increase. Come hear from a people who are actively working to encourage and enable more girls and women to pursue technology careers. Our panel will include Kimberly Bryant, Founder Black Girls CODE, Ayna Agarwal and Ellora Israni, co-founders of She++ at Stanford and more. 2/23/2013 12:45:00 PM 2/23/2013 1:15:00 PM 13277 Mark Ginnebaugh and Ross Mistry Track 1 - Galileo Galileo Greetings from Mark Ginnebaugh and Keynote with Ross Mistry 2/23/2013 8:30:00 AM 2/23/2013 9:45:00 AM 13277 Mark Ginnebaugh and Ross Mistry Track 2 - Mercury Mercury Greetings from Mark Ginnebaugh and Keynote with Ross Mistry 2/23/2013 8:30:00 AM 2/23/2013 9:45:00 AM 13277 Mark Ginnebaugh and Ross Mistry Track 3 - Jupiter Jupiter Greetings from Mark Ginnebaugh and Keynote with Ross Mistry 2/23/2013 8:30:00 AM 2/23/2013 9:45:00 AM 13277 Mark Ginnebaugh and Ross Mistry Track 4 - Saturn Saturn Greetings from Mark Ginnebaugh and Keynote with Ross Mistry 2/23/2013 8:30:00 AM 2/23/2013 9:45:00 AM 13277 Mark Ginnebaugh and Ross Mistry Track 5 - Computer Training Room Nebula Greetings from Mark Ginnebaugh and Keynote with Ross Mistry 2/23/2013 8:30:00 AM 2/23/2013 9:45:00 AM 13277 Mark Ginnebaugh and Ross Mistry Track 6 - ECR Exec Conf Room Greetings from Mark Ginnebaugh and Keynote with Ross Mistry 2/23/2013 8:30:00 AM 2/23/2013 9:45:00 AM 13306 NetApp Presenters Track 4 - Saturn Saturn 2/23/2013 12:45:00 PM 2/23/2013 1:15:00 PM 13756 Nimble Storage Presenters Track 5 - Computer Training Room Nebula Details coming soon! 2/23/2013 12:45:00 PM 2/23/2013 1:15:00 PM 13757 Phil Hummel Track 6 - ECR Exec Conf Room Details coming soon! 2/23/2013 12:45:00 PM 2/23/2013 1:15:00 PM 13776 Thomas Pizzato Track 5 - Computer Training Room Nebula Come learn about the latest features in the just-released PDW 2.0! 2/23/2013 11:15:00 AM 2/23/2013 12:15:00 PM 13777 Lakshmi Randall Track 3 - Jupiter Jupiter Speaker Lakshmi Randall will walk us through analytics on Azure. 2/23/2013 2:45:00 PM 2/23/2013 3:45:00 PM 13785 Nicholas Schoonover Track 7 - 2036 MTC Room 2036 Details Coming Soon 2/23/2013 10:00:00 AM 2/23/2013 11:00:00 AM