SQLSaturday #198 - Vancouver, BC 2013 2/16/2013 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. #sqlsat198 British Columbia Institute of Technology (BCIT) - Burnaby Campus 3700 Willingdon Avenue - Building SW5 for Registration Burnaby BC, Canada V5G 3H2 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 2904 Microsoft Canada Titanium http://technet.microsoft.com/en-ca http://www.sqlsaturday.com/files/e403d21e-948f-4fa5-accf-5c0dd8a24c5f.png 60 170 2949 Dell Software Group Gold Sponsor http://www.quest.com/ http://i.imgur.com/BAdC3.png 60 170 2903 Melissa Data Silver Sponsor http://www.melissadata.com http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif 60 170 2929 Fusion-io Silver Sponsor https://www.fusionio.com http://www.sqlsaturday.com/files/21bbb190-3e6a-45b1-8938-2ffc1f49caf7.jpg 60 170 2933 Red Gate Software Silver Sponsor http://redg.at/XpmDLL http://www.red-gate.com/assets/images/common/logo.png 60 170 2840 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2858 SQLNotes Silver Sponsor http://www.sqlnotes.info http://www.sqlsaturday.com/files/cdf462de-6e93-4601-9224-e7311dfd8cdc.jpg 60 170 2877 PASS Headquarters Bronze Sponsor http://www.sqlpass.org http://www.sqlsaturday.com/images/PASS_logo.jpg 60 170 2891 DevTeach Bronze Sponsor http://www.SQLTeach.com http://www.sqlsaturday.com/files/a8b38e5c-16fe-4c63-8d70-f1477d8e4e3b.jpg 60 170 2939 Idera Bronze Sponsor http://www.idera.com/ http://www.sqlsaturday.com/files/9d57a90d-a179-4fd6-98c2-63fac4df6ae6.jpg.png 60 170 2855 Robert L Davis Personal Sponsor http://www.sqlsoldier.com http://www.sqlsoldier.com/imgs/SQLSoldierdotcom.jpg 40 100 2836 Steve Stedman Personal Sponsor http://DatabaseHealth.SteveStedman.com http://stevestedman.com/wp-content/uploads/SteveStedman-Database-Health-Reports.png 40 100 3041 SQLvariant Blog Sponsor http://sqlvariant.com http://sqlvariant.com/BlogSupport/Images/SQLvariant_Logo.png 40 100 12192 SQLSaturday 198 Track 1 SW1 - Room 1025 2/16/2013 10:30:00 AM 2/16/2013 10:50:00 AM 12192 SQLSaturday 198 Track 1 SW1 - Room 1025 2/16/2013 4:00:00 PM 2/16/2013 4:20:00 PM 12192 SQLSaturday 198 Track 2 SW1 - Room 1205 2/16/2013 10:30:00 AM 2/16/2013 10:50:00 AM 12192 SQLSaturday 198 Track 2 SW1 - Room 1205 2/16/2013 4:00:00 PM 2/16/2013 4:20:00 PM 12192 SQLSaturday 198 Track 3 SW3 - Room 1710 2/16/2013 10:30:00 AM 2/16/2013 10:50:00 AM 12192 SQLSaturday 198 Track 3 SW3 - Room 1710 2/16/2013 4:00:00 PM 2/16/2013 4:20:00 PM 12192 SQLSaturday 198 Track 4 SW3 - Room 1750 2/16/2013 10:30:00 AM 2/16/2013 10:50:00 AM 12192 SQLSaturday 198 Track 4 SW3 - Room 1750 2/16/2013 4:00:00 PM 2/16/2013 4:20:00 PM 12192 SQLSaturday 198 Track 5 SW5 - Room 1840 2/16/2013 10:30:00 AM 2/16/2013 10:50:00 AM 12192 SQLSaturday 198 Track 5 SW5 - Room 1840 2/16/2013 4:00:00 PM 2/16/2013 4:20:00 PM 12192 SQLSaturday 198 Track 6 SW5 - Room 1850 2/16/2013 10:30:00 AM 2/16/2013 10:50:00 AM 12192 SQLSaturday 198 Track 6 SW5 - Room 1850 2/16/2013 4:00:00 PM 2/16/2013 4:20:00 PM 12192 SQLSaturday 198 Track 7 SW 9 - Room 110 2/16/2013 10:30:00 AM 2/16/2013 10:50:00 AM 12192 SQLSaturday 198 Track 7 SW 9 - Room 110 2/16/2013 4:00:00 PM 2/16/2013 4:20:00 PM 12193 SQLSaturday 198 Track 7 SW 9 - Room 110 2/16/2013 12:05:00 PM 2/16/2013 1:20:00 PM 12193 SQLSaturday 198 Lightning Talks SW 1 - Room 1021 2/16/2013 12:05:00 PM 2/16/2013 1:20:00 PM 12193 SQLSaturday 198 Track 6 SW5 - Room 1850 2/16/2013 12:05:00 PM 2/16/2013 1:20:00 PM 12193 SQLSaturday 198 Track 5 SW5 - Room 1840 2/16/2013 12:05:00 PM 2/16/2013 1:20:00 PM 12193 SQLSaturday 198 Track 4 SW3 - Room 1750 2/16/2013 12:05:00 PM 2/16/2013 1:20:00 PM 12193 SQLSaturday 198 Track 3 SW3 - Room 1710 2/16/2013 12:05:00 PM 2/16/2013 1:20:00 PM 12193 SQLSaturday 198 Track 2 SW1 - Room 1205 2/16/2013 12:05:00 PM 2/16/2013 1:20:00 PM 12193 SQLSaturday 198 Track 1 SW1 - Room 1025 2/16/2013 12:05:00 PM 2/16/2013 1:20:00 PM 12194 SQLSaturday 198 Track 1 SW1 - Room 1025 2/16/2013 7:00:00 AM 2/16/2013 8:00:00 AM 12194 SQLSaturday 198 Track 2 SW1 - Room 1205 2/16/2013 7:00:00 AM 2/16/2013 8:00:00 AM 12194 SQLSaturday 198 Track 3 SW3 - Room 1710 2/16/2013 7:00:00 AM 2/16/2013 8:00:00 AM 12194 SQLSaturday 198 Track 4 SW3 - Room 1750 2/16/2013 7:00:00 AM 2/16/2013 8:00:00 AM 12194 SQLSaturday 198 Track 5 SW5 - Room 1840 2/16/2013 7:00:00 AM 2/16/2013 8:00:00 AM 12194 SQLSaturday 198 Track 6 SW5 - Room 1850 2/16/2013 7:00:00 AM 2/16/2013 8:00:00 AM 12194 SQLSaturday 198 Track 7 SW 9 - Room 110 2/16/2013 7:00:00 AM 2/16/2013 8:00:00 AM 12195 SQLSaturday 198 Track 7 SW 9 - Room 110 2/16/2013 5:30:00 PM 2/16/2013 6:00:00 PM 12195 SQLSaturday 198 Track 6 SW5 - Room 1850 2/16/2013 5:30:00 PM 2/16/2013 6:00:00 PM 12195 SQLSaturday 198 Track 5 SW5 - Room 1840 2/16/2013 5:30:00 PM 2/16/2013 6:00:00 PM 12195 SQLSaturday 198 Track 4 SW3 - Room 1750 2/16/2013 5:30:00 PM 2/16/2013 6:00:00 PM 12195 SQLSaturday 198 Track 3 SW3 - Room 1710 2/16/2013 5:30:00 PM 2/16/2013 6:00:00 PM 12195 SQLSaturday 198 Track 2 SW1 - Room 1205 2/16/2013 5:30:00 PM 2/16/2013 6:00:00 PM 12195 SQLSaturday 198 Track 1 SW1 - Room 1025 2/16/2013 5:30:00 PM 2/16/2013 6:00:00 PM 12196 David Eichner Track 6 SW5 - Room 1850 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 makes creating executive dashboards easy! 2/16/2013 8:00:00 AM 2/16/2013 9:05:00 AM 12197 Aaron Nelson Track 4 SW3 - Room 1750 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/16/2013 8:00:00 AM 2/16/2013 9:05:00 AM 12199 Rohan Joackhim Track 3 SW3 - Room 1710 During query optimization, SQL Server is looking for queries or index operations that might benefit from parallel execution. This session will start with the basics of parallelism in SQL Server. Then lead you to understand what is under the hood of parallel query execution. How you can avoid or benefit from parallelism in OLTP or OLAP environment. 2/16/2013 4:20:00 PM 2/16/2013 5:25:00 PM 12202 Steve Stedman Track 3 SW3 - Room 1710 SQL Server 2012 adds many new enhancements to TSQL. Learn how to use the windowing functionality of the OVER clause to create sliding aggregation. Find out about the new SEQUENCE object and when you should or should not use it to replace an IDENTITY. Learn the IIF function and CHOOSE function to replace a common simple CASE functions. OFFSET / FETCH will be covered to show you how to eliminate cursors or CTEs for data paging. With CONCAT you have an easier time building strings in your TSQL statements independent of the data type, and without concern over nulls. With these and other new TSQL enhancements you will be able to take full advantage of the power of TSQL in SQL Server 2012. 2/16/2013 8:00:00 AM 2/16/2013 9:05:00 AM 12205 Greg Larsen Track 6 SW5 - Room 1850 Profiling data allows you to understand various aspects of new you receive. By profiling data you can make sure it meets your data quality standards. During this session we will be exploring the SSIS Data Profiling task to quickly analyze your data. Each of the eight different profiles available will be reviewed. A number of demos will be shown so you understand how to use and configure the different profiles. You will learn how to use the Data Profiling task output to control your SSIS data flow. Additionally you will be shown how to store the profiling output in SQL Server, so you can produce trend reports based on past profiling output information. 2/16/2013 1:30:00 PM 2/16/2013 2:35:00 PM 12214 Michael DeFehr Track 4 SW3 - Room 1750 Data access can be easy to set up in your applications with wizards and ORMs, but sometimes your queries are just not as fast as you think they should be – especially on those tables that are getting bigger and bigger. In this session, we will take a peek under the hood and see how SQL server answers the questions you ask of it. This is an introductory session, but it will be jam-packed with demos and useful tips that you will be able to use to make your applications more responsive. 2/16/2013 10:50:00 AM 2/16/2013 11:55:00 AM 12222 Scott Klein Track 1 SW1 - Room 1025 As cloud computing becomes more popular and cloud-based solutions the norm rather than the fringe, the need to efficiently migrate your database is crucial. This demo-filled session will discuss the tips and tricks, methods and strategies for migrating your on-premises SQL Server databases to Windows Azure SQL Database, AKA SQL Azure. Focusing primarily on SQL Server Data Tools and the DAC Framework, this session will focus on how these tools can make you a kung-fu migration master. 2/16/2013 4:20:00 PM 2/16/2013 5:25:00 PM 12225 Pat Sinthusan Track 1 SW1 - Room 1025 Microsoft SQL Server is one of the most commonly virtualized application. In order for SQL Server to run well in a virtual environment, the virtualized host must be properly configured and managed. We will discuss some of the benefits of virtualization that particularly apply to virtualized SQL Server environments which include: easier failover, hardware abstraction and simpler capacity planning. This session will demonstrate how to setup SQL Server storage in a virtual environment as well as best practices, caveats, and performance of SQL Server database. 2/16/2013 1:30:00 PM 2/16/2013 2:35:00 PM 12237 Ben Miller Track 4 SW3 - Room 1750 Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? This session will go over all the steps and caveats that go with this technology. This is a topic that is an Enterprise Feature, but allows you to have your database encrypted on disk. We will discuss the Encryption Hierarchy as well as how it relates to SQL Server TDE. 2/16/2013 9:15:00 AM 2/16/2013 10:20:00 AM 12252 Aaron Bertrand Track 3 SW3 - Room 1710 The session will cover a collection of minor bad habits that can occasionally lead to major problems. 2/16/2013 9:15:00 AM 2/16/2013 10:20:00 AM 12255 Julie Koesmarno Track 5 SW5 - Room 1840 Geographical Analysis is now made easy with Power View and Excel 2013. Simple yet powerful data exploration and segmentation analysis on geography can be performed, without the need of expensive hardware or software. In this session, you’ll learn how to create visually appealing and meaningful maps using Power View. 2/16/2013 2:45:00 PM 2/16/2013 3:50:00 PM 12257 Mladen Prajdic Track 4 SW3 - Room 1750 Yes, you read the title right. No, it's not about the usual 'one table per partition' and 'restore full backup then copy the data over' methods. No, there are no 3rd party tools involved. Just you and your SQL Server. Yes, it's crazy. No, it's not for production purposes. And yes, that's why it's so much fun. Prepare to dive into the world of data pages, log records, deletes, truncates and backups and how it all works together to get your table back from the endless void. Want to know more? Come and see! 2/16/2013 4:20:00 PM 2/16/2013 5:25:00 PM 12266 Stacia Misner Track 2 SW1 - Room 1205 Self-service BI is usually an independent activity. But when individuals discover interesting information that they want to share, they need a centralized location to do that. When people work together, new insights are possible, and that’s what collaboration is all about. As more people see the benefits of the solution, they become more likely to use it. As individual products, SQL Server 2008 R2, SharePoint 2010, and Excel 2010 expand your options for enabling BI in your organization, but collectively they create a solid platform for collaborative BI. Knowing which tool to use for which job can be tricky. Come to this session to learn how to use these tools to foster collaboration. 2/16/2013 9:15:00 AM 2/16/2013 10:20:00 AM 12267 Stacia Misner Track 7 SW 9 - Room 110 Power View is the new data visualization and self-service BI tool that debuted in SQL Server 2012 and is now available as part of Excel 2013. 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 . 2/16/2013 1:30:00 PM 2/16/2013 2:35:00 PM 12274 Thomas LaRock Track 3 SW3 - Room 1710 Karen and Tom debate about options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys *NULL vs NOT NULL * Agile Database Design * Database Refactoring * How much does Size Matter? * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions. 2/16/2013 10:50:00 AM 2/16/2013 11:55:00 AM 12275 Thomas LaRock Track 3 SW3 - Room 1710 Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency. 2/16/2013 2:45:00 PM 2/16/2013 3:50:00 PM 12381 Hugo Kornelis Track 3 SW3 - Room 1710 User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly avoided by all T-SQL gurus? The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance. However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of SQL Server and still get good performance. 2/16/2013 1:30:00 PM 2/16/2013 2:35:00 PM 12405 Robert Davis Track 2 SW1 - Room 1205 Contained Databases is a new feature introduced in SQL Server 2012. We will take a look at the security implications of contained databases and why it considered only “partially” contained. This technical dive into the feature will demonstrate how to implement contained databases, how to migrate a contained database, and what “gotchas” to be aware of. 2/16/2013 8:00:00 AM 2/16/2013 9:05:00 AM 12432 Cathy Dumas Track 5 SW5 - Room 1840 Excel 2013 was silently packed with a slew of new BI features, including native integration of the PowerPivot and Power View add-ins. Come see some demos of how these new features work. Although you will see some pretty visualizations, there's more to Excel 2013 than dancing bubbles. There are some serious implications to taking advantage of these new technologies. Learn some of the trade-offs involved in taking advantage of these new features, especially when working with multiple data sources. 2/16/2013 1:30:00 PM 2/16/2013 2:35:00 PM 12444 Colin Stasiuk Track 4 SW3 - Room 1750 Do more with less… sound familiar? In this demo rich introduction to Policy Based Management presentation we will be going over what Policy Based Management is and how you can use Policy Based Management and a Central Management Server to evaluate your daily, weekly, and monthly checklists against your entire SQL Server environment. We will be reviewing some of the “out of the box” policies as well as creating some custom policies that you might be interested in evaluating against all of your SQL Server instances. 2/16/2013 1:30:00 PM 2/16/2013 2:35:00 PM 12448 Guy Bowerman Track 4 SW3 - Room 1750 Cumulative update 2 introduces new features to SQL Server backup and Sysprep which enable important hybrid scenarios. In this session you’ll learn how to use and troubleshoot the new features. 2/16/2013 2:45:00 PM 2/16/2013 3:50:00 PM 12450 John Huang Track 1 SW1 - Room 1025 DBCC WritePage is an undocumented command that allows users to modify physical pages directly. It can only be useful for database repairing when there are extreme situations where nothing can help you recover your data. It makes troubles in most of the time. But it's a good tool for learning other stuff. More importantly, you need to know this when others have already known. In this 500 level session, We will explore some internals, use this command or other ways to break the database integrity, and use this tool to recover it. I will also demonstrate you how to keep yourself safe from using this command. 2/16/2013 8:00:00 AM 2/16/2013 9:05:00 AM 12480 Oliver Engels Track 6 SW5 - Room 1850 With the new Data Quality Services (DQS) Microsoft has an offering for Data Quality Management. This session gives you insights how to use DQS efficiently. In demos you will understand best practises in setting up a knowledge base, correct matching rules and how to integrate DQS to your processes as DQS is never an island solution. DQS performance aspects and how to report your quality improvements will round up the session. The session assumes that you have already tested DQS and want to get further with this toolset. 2/16/2013 2:45:00 PM 2/16/2013 3:50:00 PM 12487 Niko Neugebauer Track 7 SW 9 - Room 110 There are very few applications which are being developed from zero, the most are apps are simply inherited from previous development teams. This session serves to show some easy implementable practices to follow after inheriting a database. Those practices allow to check some if the database design was done in regards to the actual data, or if while implementing some of the constraints and checks some tables were left behind. :) The practices shown in this session will allow to check the database design and identify some of the possible performance degradations. 2/16/2013 2:45:00 PM 2/16/2013 3:50:00 PM 12512 Donabel Santos Track 5 SW5 - Room 1840 Jumpstart your way with SQL Server 2012 Reporting Services! This session will cover the basics – and some intermediate topics – on designing reports with SSRS 2012. We will start with basic reports, and build our way to adding parameters, interactive components, charts and subreports. This session will be jampacked with demos. 2/16/2013 8:00:00 AM 2/16/2013 9:05:00 AM 12520 Mark Tabladillo Track 6 SW5 - Room 1850 Text mining is projected to dominate data mining, and the reasons are evident: we have more text available than numeric data. Microsoft introduced a new technology to SQL Server 2012 called Semantic Search. This session's detailed description and demos give you important information for the enterprise implementation of Tag Index and Document Similarity Index. The demos include a web-based Silverlight application, and content documents from Wikipedia. We'll also look at strategy tips for how to best leverage the new semantic technology with existing Microsoft data mining. 2/16/2013 9:15:00 AM 2/16/2013 10:20:00 AM 12525 Allan Hirt Track 1 SW1 - Room 1025 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/16/2013 10:50:00 AM 2/16/2013 11:55:00 AM 12578 Edwin Sarmiento Track 2 SW1 - Room 1205 The health and performance of your SharePoint farms are directly related to how your SQL Server databases perform. If the SQL Server databases are not performing well, that will translate to poor SharePoint performance.Check out this session to learn how to properly configure a SQL Server instance for maximum SharePoint performance. We will look at understanding the underlying storage, proper database files placement, tuning the tempdb database database and other configuration settings that will help your SharePoint databases achieve optimum performance. 2/16/2013 10:50:00 AM 2/16/2013 11:55:00 AM 12634 Jean-Rene Roy Track 6 SW5 - Room 1850 Before SQL Server 2012, SSIS configuration was a Rocket science. Since then Microsoft has been working nonstop to get this aspect of SSIS more simple. A large amount of enhances in SQL Server 2012 have been done to SSIS and if you know how difficult it was to configure SSIS packages in SQL Server 2008, you need to see this session. If you are new to SSIS you also need to see all enhances to SSIS and see how simple it is to use it. 2/16/2013 4:20:00 PM 2/16/2013 5:25:00 PM 12653 Josh Fennessy Track 5 SW5 - Room 1840 With the release of SQL 2012, Analysis Services (SSAS) has seen some major changes. An entire new method of modelling analytic data has emerged and it's called Tabular Mode Analysis Services. In addition to that, a new semantic layer has been added to the tool, the Business Intelligence Semantic Model (BISM), which will help to bring the two modes -- Multidimensional and Tabular -- into one level playing arena. In this session, attendees will gain understanding of what Multidimensional and Tabular modelling IS, as well as how the BISM layer helps to translate user requests to ensure no confusion is made. Attendees will also learn how to BUILD a Tabular model, and will help design a solution live during the presentation. 2/16/2013 10:50:00 AM 2/16/2013 11:55:00 AM 12824 Joseph Vertido Track 6 SW5 - Room 1850 Learn about Microsoft’s Data Quality Services (DQS), what it is and how it works. We'll show you how DQS sets itself apart from conventional data cleansing routines that we’re used and go through examples on how to begin your own Data Quality Project. But what really makes DQS unique and powerful is its ability to access shared knowledge. In this presentation, we will also go through how to access and use that shared knowledge. 2/16/2013 10:50:00 AM 2/16/2013 11:55:00 AM 12891 Constantin Klein Track 7 SW 9 - Room 110 The number of sensors is growing and growing and brings us closer to the 'Internet of things'. Applications, that have to process a big amount of data from event streams are a logical consequence. Some developers might have heard from Reactive Extensions (Rx) already, but Microsoft offers with StreamInsight (SI) another comprehensive platform for these scenarios. In this session you will learn what a great addition for your toolbox StreamInsight is, if you have to develop applications, that have to handle complex events (CEP- Complex Event Processing). See how you can start with this technologie and how easy it is to jump in for .NET developers. 2/16/2013 10:50:00 AM 2/16/2013 11:55:00 AM 12902 Rick Morelan Track 7 SW 9 - Room 110 Using a Function is quick and easy if you know they are there. Functions always do or return something useful. When you send data into a function, it does its work and then sends you back some information. Each version of SQL server adds new functionality and 2012 continues that tradition. Many things you may not even have to build since more system supplied functions now ship with SQL Server 2012. This session will focus on the new string, time and logical functions added to SQL Server 2012. 2/16/2013 4:20:00 PM 2/16/2013 5:25:00 PM 12958 Richard Baumet Track 1 SW1 - Room 1025 Go through the artichecture for setting up AlwaysOn talking about the differnt technogies involved and how you can leverage them to divide up workloads among different replicas. You'll quickly know why this HADR solution is one of SQL Server 2012's biggest feature 2/16/2013 2:45:00 PM 2/16/2013 3:50:00 PM 13024 Josh Fennessy Track 5 SW5 - Room 1840 Providing boring static reports is no longer acceptable in today's business culture.  Analytics are expected to be highly visual, interactive, and should tell a meaningful story.  The latest version of Microsoft Excel is designed to perform those duties and more. Narrative reporting goes far beyond the tabular format and eliminates the need for comments. Learn how to craft narrative style reporting in this unique session.  Join Josh Fennessy and Julie Koesmarno as they guide you through several design scenarios that are often asked of a business analyst.  You'll learn Excel reporting techniques that will enable you to build highly visual and interactive reports without the need for heavy infrastructure requirements. 2/16/2013 4:20:00 PM 2/16/2013 5:25:00 PM 13025 Yaroslav Pentsarskyy Track 2 SW1 - Room 1205 New marketplace is a great opportunity for developers to get rapid exposure on a growing platform. SharePoint 2013 introduces a new app model that brings the best of web development to SharePoint. This session will use a series of demos to walk through the developer getting started experience for apps for SharePoint and will highlight development tools such as Napa and Visual Studio. Whether you're a .NET developer or a SharePoint developer come learn how to build apps for SharePoint and submit them to Office marketplace. 2/16/2013 4:20:00 PM 2/16/2013 5:25:00 PM 13026 John White Track 2 SW1 - Room 1205 This session is will help the SQL DBA or the SharePoint farm administrator understand what is required from the 'other side' to get BI features up and running in SharePoint. We will outline the SharePoint farm and services architectures, and then walk through configuration scenarios that will get BI assets such as Reporting Services in SharePoint mode, PowerPivot for SharePoint, Power View, and PerformancePoint up and running. 2/16/2013 1:30:00 PM 2/16/2013 2:35:00 PM 13033 Medhat Elmasry Track 2 SW1 - Room 1205 Never tried Entity Framework before? Or long term Entity Framework developer? Come learn how Entity Framework 5 makes it very simple to keep both your code and database in sync as you make changes using Code First and Migrations. Plus learn about many other enhancements including Designer improvements and support for new Enums and Spatial types. 2/16/2013 2:45:00 PM 2/16/2013 3:50:00 PM 13035 Damir Bersinic Track 7 SW 9 - Room 110 In this session you will learn about the capabilities in Windows Server 2012 Hyper-V that allow you to take large-scale SQL Server workloads and migrate them to Microsoft’s Private Cloud. You will find out how to configure the key resources – memory, CPU, network, and disk – to help enable the largest SQL Server implementations to perform well. You will see how System Center 2012 SP1 helps you deal with performance and other issues allowing you to respond more quickly to elements that may impact the applications your users depend on. Finally, we will demonstrate how implementing SQL Server on a Private Cloud helps to more easily deal with routine maintenance of both SQL Server and the infrastructure supporting it. 2/16/2013 9:15:00 AM 2/16/2013 10:20:00 AM 13049 Karen Lopez Track 5 SW5 - Room 1840 Model-Driven Database Development: Myths, Magic and Methods. In this presentation, Karen discusses data model-driven database development from the point of view of the Data Architect, the DBA, and the Developer. She will cover topics such as 'Who does what?', 'Why are we doing this?', 'Do I have to Use a GUI?' and 'Just who do you think you are?'. Demos, too. Finally, 10 tips for making model-driven database development successful in your organization's culture and environment. 2/16/2013 9:15:00 AM 2/16/2013 10:20:00 AM 13410 Paul Turley Track 1 SW1 - Room 1025 When do you use a sparkline, column, or line chart? How do you create a business scorecard – and with what tool? Using Excel, Power View, and Report Builder, this session will guide you through the choices and help you apply the right visual to your business data. Come see what well-known industry experts have to say about the correct use of visualization choices and techniques, colors, backgrounds, borders, and 3-D effects. Then see demonstrations of how to create those rich visuals in the different reporting tools, used with PowerPivot and tabular semantic models. 2/16/2013 9:15:00 AM 2/16/2013 10:20:00 AM 13646 Rick Morelan Track 7 SW 9 - Room 110 Data Dude gone wild!!! Your final scripts deployed to the live database a few months ago and almost everything went perfectly. Since then you have heard there were few index patches needed maybe even a new column in one or the tables. The live database has drifted just a little from your deployed SQL scripts. How would you like to update your next baseline code to already resemble the current state of the production database? This is just one of the incredible features you can do with SSDT. Take the statefull nature of your database to create and test your code automatically and declaratively. Database developers can use the SQL Server Object Explorer in VS to easily. See how the new scripting and automation tools are used in SQL 2012. 2/16/2013 8:00:00 AM 2/16/2013 9:05:00 AM 13697 SQLSaturday 198 Lightning Talks SW 1 - Room 1021 2/16/2013 7:00:00 AM 2/16/2013 8:00:00 AM 13697 SQLSaturday 198 Lightning Talks SW 1 - Room 1021 2/16/2013 8:00:00 AM 2/16/2013 9:05:00 AM 13697 SQLSaturday 198 Lightning Talks SW 1 - Room 1021 2/16/2013 9:15:00 AM 2/16/2013 10:20:00 AM 13697 SQLSaturday 198 Lightning Talks SW 1 - Room 1021 2/16/2013 10:30:00 AM 2/16/2013 10:50:00 AM 13697 SQLSaturday 198 Lightning Talks SW 1 - Room 1021 2/16/2013 10:50:00 AM 2/16/2013 11:55:00 AM 13713 Lightning Talks Lightning Talks SW 1 - Room 1021 LT: Sometimes life is like that - Melody Zacharias; LT: System Tweaks for a DBA by Dr Seuss - Richard Baumet; LT: Rock Your World With GeoFlow - Julie Koesmarno; LT: Cant Touch This! - Niko Neugebauer; LT: But I Want BI NOWWWW - Paul Turley 2/16/2013 1:30:00 PM 2/16/2013 2:35:00 PM