SQLSaturday #172 - Oregon 2012 11/3/2012 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. #sqlsat172 6651 SW Capitol Highway Portland OR 97219 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 2639 Confio Software Platinum Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2663 Red Gate Software Platinum Sponsor http://www.red-gate.com http://www.red-gate.com/assets/images/common/logo.png 60 170 2748 Melissa Data Platinum Sponsor http://www.MelissaData.com http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif 60 170 2750 WhereScape USA Limited Platinum Sponsor http://www.wherescape.com http://www.sqlsaturday.com/files/3feab36d-22a5-4511-94e1-afd5d16b7ef7.png 60 170 2784 Xtivia Inc Platinum Sponsor http://www.Xtivia.com http://www.xtivia.com/images/XtiviaLogo-170x60.jpg 60 170 2798 idera Platinum Sponsor http://www.idera.com http://www.sqlsaturday.com/files/fc775fcb-c9e2-47b7-bfad-c6ab21a09e7b.gif 60 170 2708 Quest Software Gold Sponsor http://www.quest.com/ http://www.quest.com/images/common/quest_logo.gif 60 170 2754 Joes 2 Pros Gold Sponsor http://www.joes2pros.com http://www.sqlsaturday.com/files/b2d2aaa6-7832-4272-9bad-34bc07adefdc.PNG 60 170 2630 CozyRoc LLC Silver Sponsor http://www.cozyroc.com http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 2665 SolidQ Silver Sponsor http://www.SolidQ.com http://www.solidq.com/SiteCollectionImages/LogoTagline_300x101_2colors.jpg 60 170 2801 VanderHouwen Associates, Inc. Silver Sponsor http://www.vanderhouwen.com/ http://www.vanderhouwen.com/sites/default/files/logos/vha_logo_SQL2.jpg 60 170 2787 Pluralsight In-Kind Sponsor http://Pluralsight.com http://s.pluralsight.com/mn/img/logo/pluralsight-fullcolor-250x55-v1.png 60 170 2788 Morgan Kaufmann Publishers In-Kind Sponsor http://mkp.com http://mkp.com/wp-content/themes/Reshma_MK/images/mk_logo.jpg 60 170 2789 O'Reilly Media, Inc. In-Kind Sponsor http://oreilly.com/ http://www.sqlsaturday.com/files/37075d77-2455-4303-871a-a570a5b6e0f3.PNG 60 170 10694 SQLSaturday 172 Ballroom 11/3/2012 10:15:00 AM 11/3/2012 10:45:00 AM 10694 SQLSaturday 172 Ballroom 11/3/2012 3:00:00 PM 11/3/2012 3:30:00 PM 10694 SQLSaturday 172 1 -Indexes Conf A 11/3/2012 10:15:00 AM 11/3/2012 10:45:00 AM 10694 SQLSaturday 172 1 -Indexes Conf A 11/3/2012 3:00:00 PM 11/3/2012 3:30:00 PM 10694 SQLSaturday 172 2 -SQL Dev Conf B 11/3/2012 10:15:00 AM 11/3/2012 10:45:00 AM 10694 SQLSaturday 172 2 -SQL Dev Conf B 11/3/2012 3:00:00 PM 11/3/2012 3:30:00 PM 10694 SQLSaturday 172 3 -BI Treats 204 11/3/2012 10:15:00 AM 11/3/2012 10:45:00 AM 10694 SQLSaturday 172 3 -BI Treats 204 11/3/2012 3:00:00 PM 11/3/2012 3:30:00 PM 10694 SQLSaturday 172 5 -On/Off Prem 208 11/3/2012 10:15:00 AM 11/3/2012 10:45:00 AM 10694 SQLSaturday 172 5 -On/Off Prem 208 11/3/2012 3:00:00 PM 11/3/2012 3:30:00 PM 10694 SQLSaturday 172 6 -Performance 211 11/3/2012 10:15:00 AM 11/3/2012 10:45:00 AM 10694 SQLSaturday 172 6 -Performance 211 11/3/2012 3:00:00 PM 11/3/2012 3:30:00 PM 10694 SQLSaturday 172 7 -Getting it Right 212 11/3/2012 10:15:00 AM 11/3/2012 10:45:00 AM 10694 SQLSaturday 172 7 -Getting it Right 212 11/3/2012 3:00:00 PM 11/3/2012 3:30:00 PM 10694 SQLSaturday 172 8 -ETL Analysis 214 11/3/2012 10:15:00 AM 11/3/2012 10:45:00 AM 10694 SQLSaturday 172 8 -ETL Analysis 214 11/3/2012 3:00:00 PM 11/3/2012 3:30:00 PM 10694 SQLSaturday 172 4 -Powershell 206 11/3/2012 10:15:00 AM 11/3/2012 10:45:00 AM 10694 SQLSaturday 172 4 -Powershell 206 11/3/2012 3:00:00 PM 11/3/2012 3:30:00 PM 10695 SQLSaturday 172 4 -Powershell 206 11/3/2012 12:00:00 PM 11/3/2012 12:30:00 PM 10695 SQLSaturday 172 8 -ETL Analysis 214 11/3/2012 12:00:00 PM 11/3/2012 12:30:00 PM 10695 SQLSaturday 172 7 -Getting it Right 212 11/3/2012 12:00:00 PM 11/3/2012 12:30:00 PM 10695 SQLSaturday 172 6 -Performance 211 11/3/2012 12:00:00 PM 11/3/2012 12:30:00 PM 10695 SQLSaturday 172 5 -On/Off Prem 208 11/3/2012 12:00:00 PM 11/3/2012 12:30:00 PM 10695 SQLSaturday 172 3 -BI Treats 204 11/3/2012 12:00:00 PM 11/3/2012 12:30:00 PM 10695 SQLSaturday 172 2 -SQL Dev Conf B 11/3/2012 12:00:00 PM 11/3/2012 12:30:00 PM 10695 SQLSaturday 172 1 -Indexes Conf A 11/3/2012 12:00:00 PM 11/3/2012 12:30:00 PM 10695 SQLSaturday 172 Ballroom 11/3/2012 12:00:00 PM 11/3/2012 12:30:00 PM 10696 Scott Klein 5 -On/Off Prem 208 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. 11/3/2012 1:45:00 PM 11/3/2012 3:00:00 PM 10704 David Eichner 3 -BI Treats 204 Learn how easy it is to utilize the free download from Microsoft that allows users of Excel to extract business intelligence from a variety of data sources. This introductory session will demonstrate the power of PowerPivot in analyzing large sets of data quickly and efficiently. 11/3/2012 9:00:00 AM 11/3/2012 10:15:00 AM 10717 Brent Ozar 5 -On/Off Prem 208 SQL Server speed boils down to how fast we can get data in and out of storage. Sooner or later, we're going to run out of memory to cache. In this session, we take a lesson from Microsoft's blazing-fast Fast Track Reference Architectures, look at why they work so well for the wildest queries, and explain how to build our own SQL Servers for quick queries. Brent Ozar shows you how to test your own servers and compares them to servers he's worked with in the field. 11/3/2012 9:00:00 AM 11/3/2012 10:15:00 AM 10722 Jeremiah Peschka 6 -Performance 211 No matter how much you tune your code, if the database is slow your application will be slow. While there are as many ways to make a database faster as there are databases, there are universal principles to apply that make the performance tuning process easier. Learn how to identify indexes, understand execution plans, and configure storage. The database the most critical piece of any environment; performance problems in the database cascade outward to effect everyone. This talk will cover tried and true techniques to ease the pain of growing a database while improving application performance from the perspective of both a large enterprise and a small business. 11/3/2012 10:45:00 AM 11/3/2012 12:00:00 PM 10724 Bob Pusateri 1 -Indexes Conf A SQL Server's data compression feature can be a great tool for both getting more bang out of your storage dollar and increasing query performance. In this session we'll cover the different types of data compression, the nitty-gritty behind how they work, and how to make sure you're getting the most out of them. 11/3/2012 5:00:00 PM 11/3/2012 6:15:00 PM 10727 Josh Fennessy 8 -ETL Analysis 214 In this session, attendees will be treated to an introduction to tabular mode. Installation, configuraiton, development tips, maintance, and end user reporting options will all be introduced. A description of BISM and what it means for our beloved Multi-Dimension cubes will be discussed. Attendees wanting to know when to use tabular, and when to stick with multi-dimensional will want to attend this introductory session. 11/3/2012 5:00:00 PM 11/3/2012 6:15:00 PM 10729 Michael Swinarski 7 -Getting it Right 212 Everyone would agree that setting up, configuring, and applying best practices to a database server environment, is always easier to do in the early stages of deployment. Yet too often, environments are built, grow, and become business critical, without such efforts completed until performance and stability become a problem. This session will discuss how this keeps occurring, how we can avoid it from continuing, and some basic standards that should be found in almost any environment. 11/3/2012 9:00:00 AM 11/3/2012 10:15:00 AM 10731 Paul Turley 3 -BI Treats 204 The next-generation analytic, self-service reporting tools will knock your socks off! The Power View reporting experience in SQL Server 2012 and SharePoint 2010 takes user reporting to the next level and makes data exploration fun without writing queries and code. Come see the impressive performance capabilities of BI Semantic Tabular models used with high-volume, enterprise data. Two great things that go great together! 11/3/2012 1:45:00 PM 11/3/2012 3:00:00 PM 10797 Robert Davis 6 -Performance 211 Corruption cannot always be avoided. You can take steps to ensure early detection, and you can prepare for the eventuality of it occurring, but it's not possible to completely prevent it. Early detection is your best protection against data lost due to corruption. In this session, we will discuss the protections within SQL Server to help identify corruption and to help recover from it. We will look at the different types of corruption that could hit your database and the best way to deal with each type. Includes live demos recovering from different types of corrupt databases. 11/3/2012 5:00:00 PM 11/3/2012 6:15:00 PM 10820 Rob Garrison 7 -Getting it Right 212 Fixing bad data is a huge problem. How about if you could design your schema so that it checked the data on the way in? The beginner-level techniques here are very important and useful: primary key, alternate key/unique index, foreign key, etc. But what else can you do to lock down the data in your database? You will leave this session with a better understanding of the normal techniques and some new ones that you probably haven't used before. 11/3/2012 10:45:00 AM 11/3/2012 12:00:00 PM 10873 Joe Salvatore 8 -ETL Analysis 214 This session focuses on many patterns, practices, and important considerations for loading data warehouse fact tables using SQL Server Integration Services. 11/3/2012 10:45:00 AM 11/3/2012 12:00:00 PM 11145 Hugo Kornelis 1 -Indexes Conf A We all know indexes can speed up queries. But why? And how? Why is “index on every column” not a good indexing strategy, why is your shiny new index not used, and why can adding indexes even hurt performance? The key to answering this is understanding how SQL Server lays out your data on disk, how this changes when you add an index, and how SQL Server uses these indexes to find the information required for your queries. In this presentation, Hugo explains (with animated visualization) how heaps, clustered indexes, and nonclustered indexes are organized on disk, and used for scans, seeks, and lookups. Armed with this information, you should be able to find just the right set of indexes for your workload. 11/3/2012 10:45:00 AM 11/3/2012 12:00:00 PM 11146 Hugo Kornelis 1 -Indexes Conf A So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you! Hugo will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries. Then, you will see the tools SQL Server itself hands you to help identify just the right subset of indexes. And finally, you will get an stunning demonstration of just how bad you can hurt performance by following all those recommendations and creating too many indexes. 11/3/2012 1:45:00 PM 11/3/2012 3:00:00 PM 11330 Eddie Wuerch 6 -Performance 211 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. 11/3/2012 9:00:00 AM 11/3/2012 10:15:00 AM 11331 Janis Griffin 7 -Getting it Right 212 SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server. Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies. 11/3/2012 5:00:00 PM 11/3/2012 6:15:00 PM 11353 Jason Horner 3 -BI Treats 204 In this session, we will walk through the process of building a spatial data warehouse from the ground up. We will first design a basic spatial data warehouse, then identify and import a spatial data source by using Microsoft SQL Server Integration Services (SSIS), and finally write a spatial query to provide data to SQL Server Reporting Services (SSRS). We will also review basic concepts of working with spatial data in SQL Server. 11/3/2012 3:30:00 PM 11/3/2012 4:45:00 PM 11359 Michael Wells 4 -Powershell 206 As much as you love SQL Server, do you cringe anytime you hear that you’ll need to stand up yet another SQL Server instance? Sure it’s fun, but who has the time? Maybe you’ve thought there must be a better way of doing this? Sure, you have the ability to generate an unattended install file, but what about all the other things that will need to be done? In this talk, we will explore a process that was created to truly automate not just the SQL Server install, but all of the configurations and the deployment of your organizations standard objects, all using a set of PowerShell scripts that you can download and use today. This session will review the process that has saved hundreds of hours for one organization and can do the same for yours. 11/3/2012 3:30:00 PM 11/3/2012 4:45:00 PM 11360 Michael Wells 5 -On/Off Prem 208 Security and Performance are always two of the top issues for SQL Server DBAs. Until recently the cost of the Operating System was something that you had almost no control over, but with SQL Server 2012 (Denali) you now have the option of running on the Core edition of Windows Server. While Core edition has been used primarily for infrastructure servers like Domain Controllers and DNS servers, SQL Server 2012 now brings support for running the database engine on it. This session will talk about when you may want to consider running SQL on Server Core and will guide you through the task of installing and configuring your server when you no longer have most of the Windows configuration tools that you may be used to. 11/3/2012 10:45:00 AM 11/3/2012 12:00:00 PM 11362 Steve Stedman 2 -SQL Dev Conf B Have you ever wanted to create a recursive query, but didn't see how to do it. With the Common Table Expressions class you will learn everything needed to start using CTE's for recursive queries, as temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE's. One of the most overlooked features of SQL Server is the CTE which not only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server. Learn how recursive CTE’s perform better than other methods to create hierarchical results. See how CTE’s compare to SQL Server 2012 offset and fetch paging techniques. 11/3/2012 1:45:00 PM 11/3/2012 3:00:00 PM 11367 Victor Isakov 2 -SQL Dev Conf B Windows Server 2012 is coming! As a DBA, you should understand Microsoft's new operating system and its important set of features that will change the way you deploy SQL Server and design high availability solutions in your environment. In this session, you'll learn about the benefits that Windows Server 2012 brings to SQL Server, see how to install and configure Windows 8 for a SQL Server deployment, and explore new features that will affect your virtualization and high availability architectures. 11/3/2012 5:00:00 PM 11/3/2012 6:15:00 PM 11370 Rick Morelan 2 -SQL Dev Conf B 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 with SSDT. 11/3/2012 9:00:00 AM 11/3/2012 10:15:00 AM 11391 Aaron Nelson 4 -Powershell 206 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. 11/3/2012 9:00:00 AM 11/3/2012 10:15:00 AM 11419 Tim Ford 6 -Performance 211 Walk-up work. New database requests. Users running ad-hoc queries with 18 LEFT OUTER JOINS against heaps.Surprise SQL instances created by vendors without our knowledge crashing around us!It's enough to drive a lesser DBA crazy-insane. That's why it's important to take as many steps as you can to simplify, automate, tweak, and tune the tasks you can manage so you have time to deal with those situations you can't control. In this session Tim will go over many of performance-enhancing methods he's developed over the last dozen years as a DBA for a major healthcare concern and show you how you can give yourself some breathing room to make the difficult seem easy. 11/3/2012 1:45:00 PM 11/3/2012 3:00:00 PM 11424 Peter Myers 3 -BI Treats 204 The self-service BI capabilities in Excel 2013 are growing in leaps and bounds! This presentation describes and demonstrates the PowerPivot and Power View functionality embedded inside the Excel client. Demonstrations will focus on the new features supported by both tools in the Excel 2013 preview. This presentation is relevant to those already experienced with PowerPivot and Power View, as well as those new to each. 11/3/2012 5:00:00 PM 11/3/2012 6:15:00 PM 11425 Peter Myers 8 -ETL Analysis 214 This presentation introduces the upgraded features of SQL Server 2012 Master Data Services (MDS) and the new service, SQL Server 2012 Data Quality Services (DQS). MDS is a solution for master data management. First released in SQL Server 2008 R2, this upgraded version includes many new features and enhancements, including a new web interface developed with Silverlight, an Excel add-in to support simplified model creation and easier data updates and management. DQS is a new knowledge-driven data cleansing solution, and it supports building knowledge bases that provide correction and de-duplication of data. 11/3/2012 3:30:00 PM 11/3/2012 4:45:00 PM 11431 Laerte Junior 4 -Powershell 206 It is normal for us to have to face poorly performing queries or even complete failure in our SQL server environments. This can happen for a variety of reasons including poor Database Designs, hardware failure, improperly-configured systems and OS Updates applied without testing. As Database Administrators, we need to take precaution to minimize the impact of these problems when they occur, and so we need the tools and methodology required to identify and solve issues quickly. In this Session we will use PowerShell to explore some common troubleshooting techniques used in our day-to-day work as s DBA. This will include a variety of such activities including Gathering Performance Counters in several servers at the same time in async mode. 11/3/2012 1:45:00 PM 11/3/2012 3:00:00 PM 11454 Vern Rabe 7 -Getting it Right 212 It's an all too common occurrence to have table columns or variables that have been assigned less than ideal data types. My goals in this presentation are to show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for proper usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of imappropriate data types or improper usage of them. In addition, I will cover serveral data type related functions and point out caveates in their usage. 11/3/2012 1:45:00 PM 11/3/2012 3:00:00 PM 11461 Julie Koesmarno 3 -BI Treats 204 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. 11/3/2012 10:45:00 AM 11/3/2012 12:00:00 PM 11468 Russ Loski 8 -ETL Analysis 214 SQL Server Reporting Services provides a powerful tool to render report based on information in a database table. But in order to use this feature, you are required to purchase an Enterprise license of SQL Server. In this session, we will create an SSIS package that renders reports to the file system based on values stored in the database. 11/3/2012 1:45:00 PM 11/3/2012 3:00:00 PM 11482 Kendra Little 1 -Indexes Conf A Do you have the right indexes in place to make queries run faster without dragging down write performance? In this session we will diagnose and treat the top five index disorders haunting your production databases. If you're a DBA or developer with 1 year of experience writing T-SQL queries, this session will give you the scripts and knowledge to cure your toughest indexing problems. 11/3/2012 3:30:00 PM 11/3/2012 4:45:00 PM 11498 Matt Masson Adam Larson 5 -On/Off Prem 208 Thinking about moving some of your operations to Azure? Have multiple remote sites, and want to use the cloud to centralize and share data between them?? Just like hearing talks about data transfer performance?! Have we got the session for you! We’ll cover some common user scenarios, and describe when and how to use the latest Microsoft data transfer technologies, including SQL Server Integration Services (SSIS), SQL Data Sync (a capability of SQL Database), and more. 11/3/2012 5:00:00 PM 11/3/2012 6:15:00 PM 11539 Carl Rabeler Ballroom You will see why you get NT Anonymous errors and learn to solve them when working with Excel Services, Reporting Services, and PerformancePoint Services when connecting to back end data sources. You will learn how to configure the Secure Store, Kerberos, the EffectiveUserName connection string, embedded credentials, RSD files and BISM files. 11/3/2012 10:45:00 AM 11/3/2012 12:00:00 PM 11567 Ed Snajder 4 -Powershell 206 SQL Server mirrors are a great way to maintain highly available, fast-failover systems that run on independent disk sets. While it is easy enough to work through the GUI or T-SQL to manage your mirrors, if you have a lot of them, the processes can become tedious. Also, there is not a fast easy way to tear down and build up a mirror after something goes wrong. I’ll show how I leveraged some of the SMO mirroring objects, so that I could not only build and tear down database mirrors efficiently, but to also monitor their health. These same objects can be used to build mirror-aware applications, or ones that could automate the provisioning of highly available databases for critical applications. 11/3/2012 10:45:00 AM 11/3/2012 12:00:00 PM 11585 Mark Broadbent 6 -Performance 211 Do you really understand SQL Servers’ Concurrency behaviour? Are you sure that Transactions are an ALL or NOTHING operation? Do you believe Read operations cannot start a Transaction? Do you really know if READ UNCOMMITTED is safe for reporting? Is being Optimistic really better than being Pessimistic? Can SQL Server 2012 be the solution to all our problems or our worst nightmare? I look forward to you joining me in this very revealing and thought provoking session where I will provide answers to all these questions and more and make you wish you had known all of this sooner. 11/3/2012 3:30:00 PM 11/3/2012 4:45:00 PM 11593 Pat Sinthusan 7 -Getting it Right 212 Microsoft SQL Server is one of the most commonly virtualized applications in VMware 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 allow you to build end-to-end NAS solutions where the data management capabilities of NAS, such as volume auto grow and the ability to shrink NAS volumes, can be taken advantage of by the SQL Server. This session will demonstrate how to install and run SQL Server over SMB and VMware NFS storage. Best practices, caveats, and performance of SQL Server database over SMB and NFS will also be discussed. 11/3/2012 3:30:00 PM 11/3/2012 4:45:00 PM 11605 Mark Simms 5 -On/Off Prem 208 The SQLCAT team has successfully architected, designed and built over 50 SQL Server cloud projects. We want to share the learnings on how to design a cloud application to scale to handle large, complex workloads using Windows Azure SQL Database. Building cloud applications are different than building on premise database driven applications. 11/3/2012 3:30:00 PM 11/3/2012 4:45:00 PM 11628 Bill Fellows 2 -SQL Dev Conf B The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences. 11/3/2012 10:45:00 AM 11/3/2012 12:00:00 PM 11660 Tim Mitchell 8 -ETL Analysis 214 (Note: This session will be co-presented by Tim Mitchell and Matt Masson) In this session, we will review the common decision points surrounding incrementally loading data, and will demonstrate some of the methods for incremental processing. Among the topics of discussion: •Deciding whether an incremental load is appropriate •Pick your tool: T-SQL or SSIS? •Methods for de 11/3/2012 9:00:00 AM 11/3/2012 10:15:00 AM 11682 Hossam Alfraih 1 -Indexes Conf A Hossam will be your guided tour to the indexing world! We will visits index types, know where to use them, how they work, interesting facts, and best practices. We will see how to keep our indexes healthy for better performance as well. 11/3/2012 9:00:00 AM 11/3/2012 10:15:00 AM 11685 Jason Kassay 2 -SQL Dev Conf B Most people in the database world have heard of the term, 'The Accidental DBA', those programmers who have to work with databases. How about the other side of the coin? What about DBA's an Dev's who have to write code or have to work closely with programmers? This presentation is a best practices guide for working with SQL Server in a .Net environment. You will learn how to recognize when bad code is written that interacts with the database, how to track it down, and most importantly how to fix it. On top of that you will also receive an introduction to object oriented programming concepts such as data abstraction, encapsulation, tier architecture, and class objects so that you can better communicate with your programmers. 11/3/2012 3:30:00 PM 11/3/2012 4:45:00 PM 11836 SQLSaturday 172 Ballroom Meet for a few minutes, get your bearings, get the last minute schedule changes, and perhaps win a raffle too! 11/3/2012 8:30:00 AM 11/3/2012 9:00:00 AM 11837 Buck Woody Ballroom Oh noes! Everyone tells me to throw away all my servers, and just move everything to the cloud! What will happen to my job? How will my children go to college? Buck Woody, Senior Technical Specialist on Windows Azure will answer these other questions, including: Why do they call something technical a “cloud”, since a cloud is something with undefined borders made of vapor? Isn’t this just the latest hype, a new buzzword that will soon be gone? Is anyone really using it for production? Are there real reasons to do that? If it’s real, how does it affect my job as a technical professional? What do I need to learn, and where can I learn it? This isn’t sales or marketing - a technical discussion on architectures and how they affect what you do. 11/3/2012 12:30:00 PM 11/3/2012 1:30:00 PM 11838 SQLSaturday 172 Ballroom Extend the day, network with others, enjoy snacks and drinks, and maybe even win a Raffle item. 11/3/2012 6:15:00 PM 11/3/2012 7:30:00 PM 11839 SQLSaturday 172 Ballroom What can you learn about SDQL Server in five minutes? Quite a lot actually... Listen as you are regalled with successes, blunders, failures, and most importantly, a little bit of humor. Each Speaker is only limited by what they can communicate in five minutes. 11/3/2012 1:45:00 PM 11/3/2012 3:00:00 PM 11839 SQLSaturday 172 Ballroom What can you learn about SDQL Server in five minutes? Quite a lot actually... Listen as you are regalled with successes, blunders, failures, and most importantly, a little bit of humor. Each Speaker is only limited by what they can communicate in five minutes. 11/3/2012 3:30:00 PM 11/3/2012 4:45:00 PM 11885 Douglas Barrett 2 -SQL Dev Conf B This is introduction to WhereScape RED, an agile development environment – building high quality data warehouses native to SQL 2008, R2, 2012 quickly. No other toolset can beat the productivity which results in a consistent, scalable, supportable and fully documented data warehouse. Better than that though is engagement with business units during development, ensuring that the data warehouse development is correctly prioritized, relevant and up to date. 11/3/2012 12:30:00 PM 11/3/2012 1:30:00 PM