SQLSaturday #212 - Redmond 2013 5/18/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. #sqlsat212 THE MIXER, 15255 NE 40th Street Redmond WA 98498 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 3366 Dell Platinum http://www.quest.com/ http://i.dell.com/images/global/brand/ui/storm80/logo80.png 60 170 3369 Pure Storage Platinum http://www.purestorage.com http://info.purestorage.com/rs/purestorage/images/purestorage_horiz_stack_rgb-w_170.png 60 170 3122 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 3348 Melissa Data Silver Sponsor http://www.melissadata.com http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif 60 170 3362 Fusion-io Silver Sponsor https://www.fusionio.com http://www.fusionio.com/images/logo.png 60 170 3365 Joes 2 Pros Silver Sponsor http://joes2pros.com/ http://joes2pros.com/www/wordpress/wp-content/uploads/2012/05/logo/j2p-logo.JPG 60 170 3101 Slalom Consulting Silver Sponsor https://www.slalom.com http://www.sqlsaturday.com/files/4e3ad2de-3ce9-4e8d-9924-27122e8ac1a5.jpg 60 170 3155 PASS Headquarters PASS Sponsor http://sqlpass.org http://www.sqlsaturday.com/images/PASS_logo.jpg 60 170 2974 COZYROC Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 3087 mcgraw-hill Raffle Sponsor http://www.mheducation.com/ http://www.sqlsaturday.com/files/75c944da-6a6f-4231-b10c-89ab62516ba0.png 40 100 3090 O'Reilly Media Raffle Sponsor http://oreilly.com/ http://oreilly.com/images/orn_logos/oralogo_bk200.gif 40 100 3410 Red Gate Raffle Sponsor http://redg.at/Y4QYh8 http://www.red-gate.com/assets/images/common/logo.png 40 100 12858 SQLSaturday 212 Capitol Hill Room 2003 We will provide lunch and two separate speakers will be giving presentations. 5/18/2013 12:00:00 PM 5/18/2013 1:30:00 PM 12858 SQLSaturday 212 Montlake Room 2007 We will provide lunch and two separate speakers will be giving presentations. 5/18/2013 12:00:00 PM 5/18/2013 1:30:00 PM 12858 SQLSaturday 212 Pioneer Square Room 2011 We will provide lunch and two separate speakers will be giving presentations. 5/18/2013 12:00:00 PM 5/18/2013 1:30:00 PM 12858 SQLSaturday 212 Queen Anne Room 2015 We will provide lunch and two separate speakers will be giving presentations. 5/18/2013 12:00:00 PM 5/18/2013 1:30:00 PM 12859 SQLSaturday 212 Queen Anne Room 2015 5/18/2013 7:30:00 AM 5/18/2013 8:30:00 AM 12859 SQLSaturday 212 Pioneer Square Room 2011 5/18/2013 7:30:00 AM 5/18/2013 8:30:00 AM 12859 SQLSaturday 212 Montlake Room 2007 5/18/2013 7:30:00 AM 5/18/2013 8:30:00 AM 12859 SQLSaturday 212 Capitol Hill Room 2003 5/18/2013 7:30:00 AM 5/18/2013 8:30:00 AM 12860 SQLSaturday 212 Capitol Hill Room 2003 Prize Give away 5/18/2013 5:15:00 PM 5/18/2013 5:30:00 PM 12860 SQLSaturday 212 Montlake Room 2007 Prize Give away 5/18/2013 5:15:00 PM 5/18/2013 5:30:00 PM 12860 SQLSaturday 212 Pioneer Square Room 2011 Prize Give away 5/18/2013 5:15:00 PM 5/18/2013 5:30:00 PM 12860 SQLSaturday 212 Queen Anne Room 2015 Prize Give away 5/18/2013 5:15:00 PM 5/18/2013 5:30:00 PM 12878 Rick Morelan Montlake Room 2007 Gone are all the spaghetti errors of past versions of SQL. For example did you know that BEGIN TRAN…COMMIT TRAN is not enough to make everything work together? People are often shocked when they see the demo in this talk where the first statement fails and all others statements still commit. This can still happen to you in SQL 2012 if you are not aware of the options. In fact did you know that when SQL encounters an error of Severity 11 (or higher), there a 4 different ways it can react? Learn how to predict the Error Action and control it. This is possible with or without structured error handling. See both ways to control the outcome to the way you want it. 5/18/2013 9:30:00 AM 5/18/2013 10:30:00 AM 12919 Dipti Sangani Pioneer Square Room 2011 Got a bee in your bonnet about simplifying access to Hadoop data? Want to cross-pollinate your existing SQL skills into the world of Big Data? Join this session to see how to become the Queen Bee of your Hadoop world with Hive and gain Business Intelligence insights with HiveQL filters and joins of HDFS datasets. We’ll navigate through the honeycomb to see how HiveQL generates MapReduce code and outputs files to answer your questions about your Big Data. After this session, you'll be able to democratize access to Big Data using familiar tools such as Excel and a SQL-like language without having to write MapReduce jobs. You'll also understand Hive basics, uses, strengths, and limitations and be able to determine if/when to use Hive. 5/18/2013 1:30:00 PM 5/18/2013 2:30:00 PM 13017 Nicholas Cain Queen Anne Room 2015 You're a DBA or SQL Developer and you are looking for a new gig. You've trawled the job sites, found a position I am hiring for, and decided that it is the job for you. You spruce up your resume and send it in, hoping for the best. In this session I will go over some critical mistakes that will prevent you from getting a job, such as: - Why your resume is an instant turn-off - That thing you said on the phone screen that was flat out wrong - Why the in-person interviewer took an immediate dislike to you 5/18/2013 4:00:00 PM 5/18/2013 5:00:00 PM 13119 Scott Klein Pioneer Square Room 2011 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 the database formally known as 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. 5/18/2013 2:45:00 PM 5/18/2013 3:45:00 PM 13122 David Eichner Capitol Hill Room 2003 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! 5/18/2013 10:45:00 AM 5/18/2013 11:45:00 AM 13126 Jim Murphy Pioneer Square Room 2011 In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works. 5/18/2013 9:30:00 AM 5/18/2013 10:30:00 AM 13132 Rob Garrison Queen Anne Room 2015 Understanding how CDC works sets you up to make an informed decision about whether to use it or one of the alternatives. If you choose to use it, this will also help you understand how to work with it. From this session, you will learn about the basics of CDC, how Microsoft implemented it, and the performance implications for a transactional workload. 5/18/2013 9:30:00 AM 5/18/2013 10:30:00 AM 13305 Argenis Fernandez Pioneer Square Room 2011 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. 5/18/2013 10:45:00 AM 5/18/2013 11:45:00 AM 13314 Joseph Vertido Pioneer Square Room 2011 Learn about Microsoft’s Data Quality Services (DQS), what it is and how it works. You will discover how DQS sets itself apart from conventional data cleansing routines and go through examples on how to begin your own Data Quality Project. What really makes DQS unique and powerful is its ability to access shared knowledge, so we will show you how to access and use this shared knowledge to your benefit. 5/18/2013 4:00:00 PM 5/18/2013 5:00:00 PM 13323 Dev Nambi Montlake Room 2007 Machine learning is the science of building predictive models from available data, in order to predict the behavior of new data. It is the practice of getting computers to act without being explicitly programmed. ML is widely used in web search (Google, Bing), recommendation engines (Netflix and Amazon), computational vision (self-driving cars), and natural language processing (Google Translate, auto-grading essays). This will be a gentle introduction into the world of machine learning. We will cover common techniques such as clustering, supervised vs unsupervised learning, and learning at scale. Finally, we'll explore some examples of machine learning in the real world. 5/18/2013 1:30:00 PM 5/18/2013 2:30:00 PM 13418 Ron Talmage Montlake Room 2007 This talk presents a number of table partitioning scenarios, showing issues and stratgies for solutions. We'll cover topics such as partition naming conventions, disk storage, filegroup management, and techniques for expanding partition ranges. 5/18/2013 2:45:00 PM 5/18/2013 3:45:00 PM 13926 Randy Knight Montlake Room 2007 If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why 'SQL that works' is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that 'worked great in dev' but caused major issues when it hit production. 5/18/2013 4:00:00 PM 5/18/2013 5:00:00 PM 13952 Carla Sabotta Capitol Hill Room 2003 This presentation introduces SQL Server Agent job options that are avialable for packages that are deployed to the new SSIS 2012 server. I'll also review known solutions for troubleshooting packages that don't run when called from a job step, and show how to use the Log File Viewer and SSIS Catalog reports to troubleshoot. 5/18/2013 1:30:00 PM 5/18/2013 2:30:00 PM 14126 Brent Greenwood Capitol Hill Room 2003 Business in the front. Party in the Back. The Mullet strikes a nice balance between 'Classy' 'Outlaw'. By applying this model to BI, we'll uncover ways to deliver solutions faster more efficiently through Lean practices. This session is for anyone who needs to satisfy demanding customers that aren't quite sure what they want, but they need it NOW or they'll lose that critical deal the world will end! We'll focus on sequencing deliverables and using PowerPivot prototypes that can be promoted to an AS Tabular model if/when needed. This process aims to minimize rework while striking a balance between delivering value fast with initial 'Cowboy' efforts, and incrementally building a responsible, scalable, maintainable architecture. 5/18/2013 2:45:00 PM 5/18/2013 3:45:00 PM 14127 Brent Greenwood Capitol Hill Room 2003 The most elegant solution in the world is a waste of money effort if your users don't actually use it. Just deploying to Prod isn't enough. And simply asking your users if they like it (of if they'll sign off on UAT) isn't sufficient. Come on! We're data-people! We need proof! Proactively capturing usage information is a great way to measure user adoption prove to your users management that your solution is delivering a return on their investment. Or if things are bad, understand who's using it who's not to help target your marketing training efforts enhancement cycles. This session will focus on how to eat our own dog food measure the performance of our BI solutions. We'll focus on gathering usage stats for solutions across the core MSBI Stack (Relational DB, SSIS, SSRS, SSAS). We'll use out-of-the-box log data, server-side traces DMVs to capture these data points. Then we'll look at ways to present this data back to stakeholders in scorecard format. 5/18/2013 4:00:00 PM 5/18/2013 5:00:00 PM 14289 Steve Stedman Montlake Room 2007 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. 5/18/2013 10:45:00 AM 5/18/2013 11:45:00 AM 14329 Pat Sinthusan Queen Anne Room 2015 Microsoft SQL Server has become one of the most commonly virtualized applications. In fact, a 2012 VMware customer survey found that 52% of all SQL Server instances were virtualized, up from only 43% in 2010. Since there are multiple types of storage and various protocols that storage can be presented to the guest virtual machine, it is important that DBA’s understand where the database and log files should reside for the best possible performance and ease of management. In this session you will learn the benefits of a properly configured data management architecture for virtualized SQL Server environments which will provide easier failover, hardware abstraction and simpler capacity planning. We will also demonstrate multiple ways to configure SQL Server storage in a virtual environment as well as best practices, caveats, and performance tips. 5/18/2013 1:30:00 PM 5/18/2013 2:30:00 PM 14785 Greg Larsen Capitol Hill Room 2003 This session will be exploring the SSIS Data Profiling task to quickly analyze your data. I will be reviewing the different profiles available, and explaining the limitations of the Data Profiling task. I will be showing you how to use the different profiles to help you identify candidate keys, null value counts by column, dependencies between columns, length distribution, data format, etc. I will be performing a number of Data Profiling task demos that demonstrate how to use and configure the different profiles. Knowing how to use Data Profiling and interpreting the output helps you quickly determine how best to migrate newly received data into your environment. I will also be showing you how to use the Data Profiling task output to control your SSIS data flow. Additionally I will also be showing you how you can store profiling output in SQL Server, so you can produce trend reports based on profile output information. 5/18/2013 9:30:00 AM 5/18/2013 10:30:00 AM 14992 Buck Woody Capitol Hill Room 2003 Special talk by Buck Woody. 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 14992 Buck Woody Montlake Room 2007 Special talk by Buck Woody. 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 14992 Buck Woody Queen Anne Room 2015 Special talk by Buck Woody. 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 14992 Buck Woody Pioneer Square Room 2011 Special talk by Buck Woody. 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 15303 Chuck Suter Queen Anne Room 2015 Fusion-io is the market leader in the enterprise flash memory industry that pioneered the use of PCIe NAND flash for database storage. SQL Server has been the #1 most common use case by Fusion-io customers who've wanted to reduce I/O latency in and out of their databases. This presentation will cover how Fusion-io can help solve SQL Server performance problems with both local PCIe storage solutions, and shared storage appliances leveraging hybrid PCIe and SATA disk technologies. 5/18/2013 2:45:00 PM 5/18/2013 3:45:00 PM 15357 Dandy Weyn Queen Anne Room 2015 In this session we will drill down into capabilities and investments in SQL Server and Windows Azure SQL Database that you’ll have to know of to be the “DBA of the future”.Learn about how to manage databases in a cloud and on-premise environment using Windows Azure SQL Database and Windows Azure VMs.Learn about administration, optimization, management, security, data movement, high availability and disaster recovery scenarios.And don’t be scared about your future, the future is bright! 5/18/2013 10:45:00 AM 5/18/2013 11:45:00 AM 15359 Robert Collura Queen Anne Room 2015 Latency is the life-blood of any database application. When transactions slow it is often the direct result of traditional spinning disk and its ability to keep up with today's demanding databases. Moving to an all-flash architecture for your database will provide immediate performance benefits while also adding a whole host of operational benefits. During this session you will learn how using an all-flash array can accelerate transaction logs, reduce indexes, and simplify data layouts. We will explain how using our 512-byte technology makes all block alignment issues disappear without all the planning and frequent tuning. The discussion also will include conversations about virtualizing SQL without fear, reducing the size of the data with no performance penalty, and real world examples of customers consolidating and reducing SQL licensing costs. Finally, we will review our unique offering, current flash challenges and how we are addressing the high-performance marketplace. 5/18/2013 12:15:00 PM 5/18/2013 12:45:00 PM 15359 Robert Collura Pioneer Square Room 2011 Latency is the life-blood of any database application. When transactions slow it is often the direct result of traditional spinning disk and its ability to keep up with today's demanding databases. Moving to an all-flash architecture for your database will provide immediate performance benefits while also adding a whole host of operational benefits. During this session you will learn how using an all-flash array can accelerate transaction logs, reduce indexes, and simplify data layouts. We will explain how using our 512-byte technology makes all block alignment issues disappear without all the planning and frequent tuning. The discussion also will include conversations about virtualizing SQL without fear, reducing the size of the data with no performance penalty, and real world examples of customers consolidating and reducing SQL licensing costs. Finally, we will review our unique offering, current flash challenges and how we are addressing the high-performance marketplace. 5/18/2013 12:15:00 PM 5/18/2013 12:45:00 PM 15359 Robert Collura Montlake Room 2007 Latency is the life-blood of any database application. When transactions slow it is often the direct result of traditional spinning disk and its ability to keep up with today's demanding databases. Moving to an all-flash architecture for your database will provide immediate performance benefits while also adding a whole host of operational benefits. During this session you will learn how using an all-flash array can accelerate transaction logs, reduce indexes, and simplify data layouts. We will explain how using our 512-byte technology makes all block alignment issues disappear without all the planning and frequent tuning. The discussion also will include conversations about virtualizing SQL without fear, reducing the size of the data with no performance penalty, and real world examples of customers consolidating and reducing SQL licensing costs. Finally, we will review our unique offering, current flash challenges and how we are addressing the high-performance marketplace. 5/18/2013 12:15:00 PM 5/18/2013 12:45:00 PM 15359 Robert Collura Capitol Hill Room 2003 Latency is the life-blood of any database application. When transactions slow it is often the direct result of traditional spinning disk and its ability to keep up with today's demanding databases. Moving to an all-flash architecture for your database will provide immediate performance benefits while also adding a whole host of operational benefits. During this session you will learn how using an all-flash array can accelerate transaction logs, reduce indexes, and simplify data layouts. We will explain how using our 512-byte technology makes all block alignment issues disappear without all the planning and frequent tuning. The discussion also will include conversations about virtualizing SQL without fear, reducing the size of the data with no performance penalty, and real world examples of customers consolidating and reducing SQL licensing costs. Finally, we will review our unique offering, current flash challenges and how we are addressing the high-performance marketplace. 5/18/2013 12:15:00 PM 5/18/2013 12:45:00 PM 15360 David Swanson Capitol Hill Room 2003 Lunch Session #2 5/18/2013 12:40:00 PM 5/18/2013 1:00:00 PM 15360 David Swanson Montlake Room 2007 Lunch Session #2 5/18/2013 12:40:00 PM 5/18/2013 1:00:00 PM 15360 David Swanson Pioneer Square Room 2011 Lunch Session #2 5/18/2013 12:40:00 PM 5/18/2013 1:00:00 PM 15360 David Swanson Queen Anne Room 2015 Lunch Session #2 5/18/2013 12:40:00 PM 5/18/2013 1:00:00 PM