SQLSaturday #169 - Denver 2012 9/22/2012 12:00:00 AM (GMT-07:00) Mountain Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat169 10150 E. Belleview Avenue Englewood CO 80111 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 2424 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2678 Quanta Intelligence Marquee Sponsor http://www.quantaintelligence.com http://www.quantaintelligence.com/image/quanta_logo_large.jpg 40 100 2717 Datavail Marquee Sponsor http://www.datavail.com http://denver.sqlpass.org/Portals/41/Sponsors/DataVailLOGO.jpg 40 100 2399 DawaBI Silver Sponsor http://www.DawaBI.com http://www.dawabi.com/Data/Sites/1/logos/DawaBI_Logo_DawaBI_W_Tag_1.jpg 60 170 2473 Pragmatic Works Silver Sponsor http://pragmaticworks.com/ http://pragmaticworks.com/images/logo/PragmaticWorksLogo.jpg 60 170 2532 Red Gate Software Silver Sponsor http://www.red-gate.com http://www.red-gate.com/assets/images/common/logo.png 60 170 2602 Fusion-io Silver Sponsor https://www.fusionio.com http://www.fusionio.com/images/logo.png 60 170 2613 Quest Software Silver Sponsor http://www.quest.com/ http://www.quest.com/images/common/quest_logo.gif 60 170 2680 Xtivia Silver Sponsor http://www.Xtivia.com http://www.xtivia.com/images/XtiviaLogo-170x60.jpg 60 170 2434 CozyRoc Bronze Sponsor http://www.cozyroc.com http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 2693 Qortex Bronze Sponsor http://www.qortex.com https://si0.twimg.com/profile_images/2453160943/jaawtzf6r5mjizzfirrz.png 60 170 2513 SQL Cruise Personal/Community Contributor http://www.sqlcruise.com http://sqlcruise.com/wp-content/uploads/2012/07/square_logo.png 40 100 2460 SAPIEN Technologies, Inc. SWAG Sponsor http://www.SAPIEN.com http://www.sapien.com/assets/img/SAPIEN%C2%AE%20BUTTON%20LOGO_Horizontal.jpg 40 100 2581 Wrox Press SWAG Sponsor http://www.wrox.com/go/ugmember http://newsletter.wrox.com/images/usergroups/New_WROX_Logo_color.gif 40 100 2646 McGraw Hill SWAG Sponsor http://www.mhprofessional.com/promo/index.php?promocode=SQLPROMO http://denver.sqlpass.org/Portals/41/Sponsors/hdr_home_logo.gif 40 100 2686 Pluralsight SWAG Sponsor http://www.pluralsight.com http://s.pluralsight.com/mn/img/logo/pluralsight-fullcolor-175x39-v1.png 40 100 10408 SQL Saturday Keynote/Lunch/Closing Mt. Elbert/Gym Lunch 9/22/2012 12:15:00 PM 9/22/2012 1:15:00 PM 10409 Mike Davis SQL Server 2012 Roundup Crestone Needle/C206 The newest version of SQL Server is out and packed with new features. Come see all of the newest features and best practices in SSIS 2012. Learn about the new SSIS parameters, environments, deployment, and the new tasks. Understand the new project deployment mode and how to execute SSIS 2012 packages with T-SQL. 9/22/2012 8:45:00 AM 9/22/2012 9:45:00 AM 10413 Mike Davis Business Intelligence Pikes Peak/C209 PowerPivot is a powerful new tool able to slice and dice data in memory very fast. But how do you acheive complex situations like, parent child hierarchies, Many to Many, and using inactive Relationships. Come see these complex DAX functions and leave with some great DAX knowledge. 9/22/2012 10:00:00 AM 9/22/2012 11:00:00 AM 10423 Jason Kassay DB Developer/DBA Maroon Bells/High School Most people in the database world have heard of the term, 'The Accidental DBA', those programmers who out of nowhere get thrown into working with databases. Well what about the other side of the coin? What about those DB Developers and DBA's who have to write code? 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. 9/22/2012 11:15:00 AM 9/22/2012 12:15:00 PM 10426 Kevin Cox Big Data/Cloud Mt. Wilson/C201 See the architecture of the largest Azure projects in the world. Find out why most use a combination of SQL Azure and NoSQL. 9/22/2012 2:30:00 PM 9/22/2012 3:30:00 PM 10468 Mike Byrd DBA Pyramid Peak/Middle School There are many white papers and articles about table partitioning, but when it comes down to implementing partitioning there is little 'real world' documentation. This presentation will cover definitions (so you will know what I am talking about), tips on what tables to partition and how to pick a partition key, and finally a real world example with scripts on implementation and ongoing maintenance of the partitioned tables. 9/22/2012 10:00:00 AM 9/22/2012 11:00:00 AM 10476 Christopher Shaw DB Developer/DBA Maroon Bells/High School 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. 9/22/2012 10:00:00 AM 9/22/2012 11:00:00 AM 10487 Joe Salvatore Business Intelligence Pikes Peak/C209 This session focuses on many patterns, practices, and general considerations for accessing SQL Server Analysis Services (SSAS) cube data using SQL Server Reporting Services. 9/22/2012 2:30:00 PM 9/22/2012 3:30:00 PM 10631 Tom Norman DBA Pyramid Peak/Middle School Everyday a DBA needs to access our system. They might need to make a change. Can I see what they did, of course. Let's look at DDL tracking, events and service broker to see how we can see security, object and jog changes. What did that DBA really to in our Sql Server? We need a log to show our auditor, let's prove what the DBA did. 9/22/2012 2:30:00 PM 9/22/2012 3:30:00 PM 10647 Michael Fal DB Developer/DBA Maroon Bells/High School Everything that's old is new again, as Windows Server moves back to the terminal interface. With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure. This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it. 9/22/2012 8:45:00 AM 9/22/2012 9:45:00 AM 10658 Chris Schmidt Business Intelligence Pikes Peak/C209 Join us for an in-depth discussion on SSIS Configurations. What are the different types? Can we make it easy to promote our packages from development? The answer is YES, we can! In this session, we'll cover the various configuration methods, configuration tables, and how we can make those same tables dynamic. 9/22/2012 3:45:00 PM 9/22/2012 4:45:00 PM 10692 Raphael Klebanov Business Intelligence Pikes Peak/C209 This session will describe the best practices for designing a data warehouse to get the most out of SQL Server. Raphael has worked in data warehousing for 12 years and will blend experience, with best practices and recommendations from Microsoft's Fast Track program. Each version of SQL Server introduces new features specifically for data warehousing - by applying the correct technique, feature, hint, modelling approach and layout the data warehouse will be faster and more scalable. 9/22/2012 8:45:00 AM 9/22/2012 9:45:00 AM 10700 Michael Fal Professional Development Mt. Princeton/C202 Have you wanted to speak, but weren't sure how or where to start? Maybe you've done some presentations, but still aren't comfortable with building your deck or working in front of an audiance? This session will show you how you how to create great presentations by using many of the same techniques musicians use to create songs and perform on stage. Participants won't need to have any musical training or previous speaking experience to benefit from this session. 9/22/2012 2:30:00 PM 9/22/2012 3:30:00 PM 10784 Steve Jones Professional Development Mt. Princeton/C202 Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more. 9/22/2012 11:15:00 AM 9/22/2012 12:15:00 PM 10786 Steve Jones Big Data/Cloud Mt. Wilson/C201 A look at the Filestream and Filetable features in SQL Server that can allow you to handle unstructured data inside your SQL Server database. 9/22/2012 1:15:00 PM 9/22/2012 2:15:00 PM 10856 John Morehouse DBA Pyramid Peak/Middle School Are you just starting out in the DB world? Are you unsure of things that you should know? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to any of those question, then this is the session for you! John will be talk about things that he's seen in the trenches that every DBA should know and understand. 9/22/2012 1:15:00 PM 9/22/2012 2:15:00 PM 10872 Glenn Berry DBA Pyramid Peak/Middle School If you have ever been responsible for a mission critical database, you have probably been faced with a high stress, emergency situation where a database issue is causing unacceptable application performance, resulting in angry users and hovering managers and executives. If this hasn't happened to you yet, thank your lucky stars, but start getting prepared for your time in the hot seat. This session will show you how to use DMV queries to quickly detect and diagnose the problem, starting at the server and instance level, and then progressing down to the database and object level. Based on the initial assessment of the problem, different types of DMV queries will help you narrow down and identify the problem. 9/22/2012 8:45:00 AM 9/22/2012 9:45:00 AM 10914 Christopher Price SQL Server 2012 Roundup Crestone Needle/C206 We will explore data quality issues that face today’s business and how Data Quality Services 2012 can help IT Pros and Data Stewards meet those challenges. We will start from zero, build a knowledge base, profile data to train our knowledge base and then use that knowledge to highlight both the cleansing and matching capabilities of DQS. This session will also cover the DQS SSIS component that’s available in SQL Server 2012. 9/22/2012 11:15:00 AM 9/22/2012 12:15:00 PM 10961 Jeff Renz Business Intelligence Pikes Peak/C209 Tabular modules allow developers to create models based upon different data sources; create hierarchies, perspectives, partitions and roles similar to traditional OLAP cubes. In this session will highlight the differences between traditional OLAP and tabular models and reasons for selecting one approach over another. I will demonstrate how to create a data model first in power pivot model and then import into an Analysis Services Tabular Project. Working with the imported data I will then create measures, KPIs, perspectives, and implement security. Finally I will deploy the model to an Analysis Server. 9/22/2012 1:15:00 PM 9/22/2012 2:15:00 PM 10970 Gabriel Villa DB Developer/DBA Maroon Bells/High School Develop a Quick and Dirty Web interface to your database: for the DBA and other non-developers. So you want to develop to your database? Do you have your own tools to check performance? Does Chris Shaw's Utility Database sound like a tool you have and want a web interface, but don’t want to write a lot of code? I will demonstrate how a simple ASP.Net MVC site can be developed and deployed against your database. See firsthand how easy we can use Shaw's utility database and access across the web over a mobile device so you may manage performance online whilst zipping your drink of choice. 9/22/2012 3:45:00 PM 9/22/2012 4:45:00 PM 10985 Scott Berkley Big Data/Cloud Mt. Wilson/C201 Increasingly, firms are encountering issues when attempting to turn massive data sets from social media and other textual sources into usable information. Solutions like Hadoop and MapReduce offer the ability to mine and aggregate large amounts of information, but there is quite a difference between these systems and traditional relational databases. This session will provide an overview and demonstration of Microsoft’s Azure cloud offering with Hadoop and will cover the benefits and challenges of implementing a “Big Data” solution 9/22/2012 8:45:00 AM 9/22/2012 9:45:00 AM 10988 Brandon Tucker DB Developer/DBA Maroon Bells/High School Ever gotten stuck with a vendor application? Ever wanted to gleam some information from that database? It's happened to many of us. Whether it be a ticketing or a call system, sometimes you just want to get more information out of it. In this talk, we'll discuss what methods are available to you to try and discover where the data resides and how it flows through the database. 9/22/2012 2:30:00 PM 9/22/2012 3:30:00 PM 10989 Carlos Bossy Big Data/Cloud Mt. Wilson/C201 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. 9/22/2012 10:00:00 AM 9/22/2012 11:00:00 AM 10990 Kellyn Pot'Vin DBA Pyramid Peak/Middle School Well known RDBMS’ have similar physical designs to meet ACID requirements and production standards. As most DBA’s are required to support more than one platform these days, this presentation will introduce the SQL Server DBA to the fundamental concepts of Oracle database administration. The attendee will leave this session with a solid understanding of the similarities and differences in comparison to common Oracle features, design basics and how they correspond to SQL Server architecture. Prerequisites: An open mind to different database platforms and a solid understanding of SQL Server. No exposure to Oracle database administration is required to attend this presentation. 9/22/2012 3:45:00 PM 9/22/2012 4:45:00 PM 10994 Jessica Moss SQL Server 2012 Roundup Crestone Needle/C206 Exploring your data has never been easier with Power View included in SQL Server 2012. Learn how to quickly analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool. This session will not walk through installation of the tool, but will instead describe the different visualizations provided and when you would use each one. 9/22/2012 1:15:00 PM 9/22/2012 2:15:00 PM 10995 Jessica Moss SQL Server 2012 Roundup Crestone Needle/C206 SQL Server 2012 makes great strides in the development, maintainability, and administration features of Integration Services packages. Whether you already have packages from an earlier version or you are starting from scratch, you will learn how to take advantage of these new features. In this session, we will show: an upgrade of Integration Services packages from 2008 R2 to 2012, the modifications needed to run these packages in 2012, and the information produced about package execution. 9/22/2012 3:45:00 PM 9/22/2012 4:45:00 PM 10998 Doug Lane Professional Development Mt. Princeton/C202 Are you the only SQL Server professional at your company? Join Glenn Berry, Mike Fal, Carlos Bossy, and Doug Lane in an interactive discussion about how to deal with the challenges of being the only SQL person on staff. Whether you're one of five employees or five hundred, you'll learn tips and techniques for how to survive and thrive as a solo DBA/developer. Topics will include managing time and expectations amid frequent interruptions, how and when to automate and delegate tasks, maintaining data quality, and getting help when you're stuck. 9/22/2012 1:15:00 PM 9/22/2012 2:15:00 PM 11009 Marc Beacom SQL Server 2012 Roundup Crestone Needle/C206 SQL Server 2012 has many new T-SQL features and enhancements that will simplify your code and life. We’ll roll up our sleeves and dive in head first to take a look at some of the new features. 9/22/2012 2:30:00 PM 9/22/2012 3:30:00 PM 11012 Sean McCown DBA Pyramid Peak/Middle School Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of having your users breathe down your neck for 2hrs because it’s taking too long to restore a DB? Well now you don’t have to worry about that anymore. I’m going to show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. Backups actually have kind of an execution plan that you can access if you know how, and knowing how to get the individual portions of your backup process down will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15yrs to tune my backups and I’ve had great success. 9/22/2012 11:15:00 AM 9/22/2012 12:15:00 PM 11014 Sean Jen McCown Professional Development Mt. Princeton/C202 'Interviews are so easy,' says absolutely nobody. In fact, interviewing for your next DBA or SQL developer job is a very tricky process, with many common pitfalls. In this fun and interactive session, we'll give you all the best advice you've never heard about pre-interview preparation, typical traps, and the new professionalism. You will start to refine the way you present yourself, tailor your answers appropriately, and learn about our revolutionary negotiating tactics. Most importantly, we'll quantify the most difficult aspect of interviews: knowing when to keep silent. 9/22/2012 3:45:00 PM 9/22/2012 4:45:00 PM 11025 Jennifer McCown DB Developer/DBA Maroon Bells/High School You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool. This session is chock full of code examples, including before-and-after demos and how-tos. 9/22/2012 1:15:00 PM 9/22/2012 2:15:00 PM 11026 Jennifer McCown Professional Development Mt. Princeton/C202 Whether you are searching for a new job or already well established, you need the right tools and strategy to make your career great! Men and women both should come and join the discussion to share their experiences with job hunting, interviewing, professional development, and on-the-job issues. 9/22/2012 10:00:00 AM 9/22/2012 11:00:00 AM 11040 Todd Kleinhans SQL Server 2012 Roundup Crestone Needle/C206 When do you need your data encrypted? After providing a brief history and intro to encryption and cryptography, we will look at several ways to secure your SQL Server 2012 data and systems. We are going to cover: column level encryption, transparent data encryption (TDE), discuss third party tools, and enterprise key management (EKM) using hardware security modules (HSM)s. We will also cover certain gotchas and pitfalls to avoid. 9/22/2012 10:00:00 AM 9/22/2012 11:00:00 AM 11133 Jason Horner Business Intelligence Pikes Peak/C209 This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries. 9/22/2012 11:15:00 AM 9/22/2012 12:15:00 PM 11219 SQL Saturday Keynote/Lunch/Closing Mt. Elbert/Gym Closing remarks and give-aways! 9/22/2012 5:00:00 PM 9/22/2012 5:30:00 PM 11220 SQL Saturday Keynote/Lunch/Closing Mt. Elbert/Gym Opening Keynote 9/22/2012 8:00:00 AM 9/22/2012 8:30:00 AM 11221 SQL Saturday Keynote/Lunch/Closing Mt. Elbert/Gym Registration 9/22/2012 7:00:00 AM 9/22/2012 8:00:00 AM 11417 Big Data/Cloud Panel Big Data/Cloud Mt. Wilson/C201 Panel discussion on Big Data/Cloud projects. 9/22/2012 3:45:00 PM 9/22/2012 4:45:00 PM 11611 Carlos Bossy Big Data/Cloud Mt. Wilson/C201 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. 9/22/2012 11:15:00 AM 9/22/2012 12:15:00 PM