SQLSaturday #153 - Salt Lake City 2012 10/20/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. #sqlsat153 10701 South River Front Parkway e.g. street address here if entered venue name above South Jordan UT 84095-3524 2342 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2587 SQL Solutions Group Gold Sponsor http://www.sqlsolutionsgroup.com http://www.sqlsolutionsgroup.com/images/ssg_sqlsat.jpg 60 170 2775 Utah Geek Events Gold Sponsor http://www.utahgeekevents.com http://asylumphotography.smugmug.com/Other/UgeLogo/i-FknSpqC/0/M/UGE-logo-color-blackBG-M.jpg 60 170 2706 Quest Software Silver Sponsor http://www.quest.com/ http://www.quest.com/images/common/quest_logo.gif 60 170 2278 CozyRoc Bronze Sponsor http://www.cozyroc.com http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 2303 Steve Stedman Personal Sponsor http://SteveStedman.com http://stevestedman.com/wp-content/uploads/SteveStedman.png 40 100 11208 Aaron Cutshall Aaron Cutshall has over 26 years of experience in programming, databases, system design and data architecture in various industries. He has been in the Healthcare Informatics fields for the past 6 years working on large databases involving millions of patient records and is prominent in the field of healthcare quality measurements. @ancutshall http://www.linkedin.com/in/aaroncutshall https://api.twitter.com/1/users/profile_image?screen_name=@ancutshall 48 48 11279 Ben Miller Ben has been a member of the SQL Server Community for over 14 years now. He is currently a Sr. DBA for HealthEquity, an HSA Provider in Draper Utah. He is a SQL Server MVP and has spent time in the field using SQL Server since 1997. He has worked at various companies throughout the US as well as at Microsoft for 7 years. He is passionate about SQL Server and automation and integration. @dbaduck http://www.linkedin.com/in/dbaduck https://api.twitter.com/1/users/profile_image?screen_name=@dbaduck 48 48 11311 Chad Crawford Chad has been working with database engines for 14 years, the last 12 focused specifically on SQL Server. He has filled a variety of roles spanning architecture, development and administration. Chad is currently the Database Architect at Henry Schein Practice Solutions in American Fork. When he isn’t optimizing a query, you will find him running, dreaming about airplanes, or looking for a new strategy board game. @sp_services http://www.linkedin.com/pub/chad-crawford/6/a04/8b6 https://api.twitter.com/1/users/profile_image?screen_name=@sp_services 48 48 11555 Cindy Gross Cindy Gross is a member of SQLCAT where she works with BI, Hadoop, and Hive to make data more accessible to decision makers and generate more business value. She has extensive data platform experience, with roles that span engineering and direct customer engagement, and was honored to earn the title of SQL Server 2008 Microsoft Certified Master. As an active member of the technical community, she regularly speaks at local and national events and contributes to whitepapers, blogs, and books. @SQLCindy http://www.linkedin.com/in/cindygross http://blogs.msdn.com/cindygross/ https://api.twitter.com/1/users/profile_image?screen_name=@SQLCindy 48 48 9391 Jason Brimhall Jason Brimhall has 10+ yrs experience and has worked with SQL Server from 6.5 through SQL 2008 R2. He has experience in performance tuning, high transaction environments, as well as large environments. He is currently a DB Architect and an MCDBA. He is he VP of the Las Vegas User Group (SSSOLV). @jasonkassay http://www.linkedin.com/in/dbajbrimhall https://api.twitter.com/1/users/profile_image?screen_name=@jasonkassay 48 48 11526 Kelly Martinez Kelly Martinez, a Programmer/Analyst with the City of Greeley, Colorado has over 15 years of I.T. experience. His primary focus is on the Microsoft stack but has also has worked on various open source platforms specializing in web and database development. When not thinking about databases and code he enjoys spending time with his family, traveling, camping, and reading. @greeleygeek http://zero1design.com https://api.twitter.com/1/users/profile_image?screen_name=@greeleygeek 48 48 9061 Martin Miller Martin Miller is an Enterprise Data Warehouse Architect at Intermountain Healthcare and has been a database professional for over 10 years working with several different platforms including Oracle and SQL Server. Throughout his career he has worked in several different roles including Database Administrator, Datanase Analyst and Database Developer. When not working on databases he enjoys the outdoors and spending time with his wife and three children. http://www.linkedin.com/in/mmiller73 https://api.twitter.com/1/users/profile_image?screen_name= 48 48 11816 Pat Wright Ben is a former Microsftie, now an MVP and has recently passed his MCM knowledge exam, Jason Brimhall is a SQL Server consultant and has also recently passed his MCM knowledge exam. Randy Knight is owner of www.sqlsolutionsgroup.com a consulting firm for SQL server, and has also recently passed his MCM knowledge exam. It is a great bunch of presenters to get knowledge from! @SqlAsylum http://www.linkedin.com/in/patwright https://api.twitter.com/1/users/profile_image?screen_name=@SqlAsylum 48 48 10738 Paul Turley Paul is a Mentor for SolidQ a Microsoft Most Valuable Professional (MVP) for SQL Server and BI. He teaches, develops training courseware, speaks at industry conferences and has authored and co-authored several technical books on SQL Server, Reporting Services and BI. He speaks at Microsoft TechEd and has presented at the Professional Association for SQL Server (PASS) global summit since 2004. @paul_turley http://www.linkedin.com/pub/paul-turley/2/2b6/930 http://SqlServerBiBlog.com https://api.twitter.com/1/users/profile_image?screen_name=@paul_turley 48 48 11251 Randy Knight Randy Knight (MCITP) has been working with Microsoft technology for over 20 years, focusing on SQL Server for the last 14. He is currently the owner and Principal Consultant for SQL Solutions Group, a Utah-based SQL Server consultancy. He is a nationally known speaker and trainer, having presented at SQL Saturday, Code Camp, User Groups and the inaugural PASS SQLRally. @randy_knight http://www.linkedin.com/in/randyknight http://www.sqlsolutionsgroup.com/blog https://api.twitter.com/1/users/profile_image?screen_name=@randy_knight 48 48 9046 Scott Heffron Scott Heffron is a ETL engineer located in the Salt Lake City area. He has been involved in client/server, GIS, Web, and Mobile projects for the past 25 years. He is currently on ETL projects in SQL Server and Oracle. @SQLScott http://www.linkedin.com/in/ScottPHeffron https://api.twitter.com/1/users/profile_image?screen_name=@SQLScott 48 48 9486 Steven Wake Steve Wake is a BI Consultant at Pragmatic Works with more than 15 years of experience in various IT organizations. Steve started his IT career as a COBOL programmer. In 2002 he decided to become an SSRS and C# developer. After learning as much as possible about SSRS he has learned SSIS and SSAS to increase his toolset. Steve is also very involved in the community, speaking and being elected President of the Denver SQL Server User Group in 2011. He blogs at wakebi.com @stevewake on Twitter. @stevewake http://www.linkedin.com/in/b5lurker http://wakebi.com https://api.twitter.com/1/users/profile_image?screen_name=@stevewake 48 48 11326 Tjay Belt TJay Belt is an outdoorsman who enjoys riding dirtbikes, waterskiing/boating, playing racquetball and spending time with his family. When he can't be out playing, TJay loves to tinker with databases. TJay has been an IT professional for over a decade. Currently serving as a Database Admin with Imagine Learning. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst. @tjaybelt http://www.linkedin.com/in/tjaybelt http://sqlsolutionsgroup.com/team.aspx https://api.twitter.com/1/users/profile_image?screen_name=@tjaybelt 48 48 11273 Tobe Pittman Have worked as a database architech for the last 6 years. Have worked with both SQL Server (since 6.5) and several versions of Oracle. 48 48 9045 9045 SQLSaturday 153 Track 1 Room 200 10/20/2012 12:30:00 PM 10/20/2012 1:30:00 PM 9045 9045 SQLSaturday 153 Track 2 Room 206 10/20/2012 12:30:00 PM 10/20/2012 1:30:00 PM 9045 9045 SQLSaturday 153 Track 3 Room 201 10/20/2012 12:30:00 PM 10/20/2012 1:30:00 PM 9045 9045 SQLSaturday 153 Track 4 Lab 10/20/2012 12:30:00 PM 10/20/2012 1:30:00 PM 9046 9046 Scott Klein Track 4 Lab 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. 10/20/2012 9:00:00 AM 10/20/2012 10:00:00 AM 9047 9047 Scott Klein Track 2 Room 206 With more and more companies moving to a cloud solution, the necessity to easily and efficiently scale their database solution is critical. This session will discuss how to scale SQL Azure using SQL Azure Federations, a recent addition to SQL Azure that provides the ability to build scalable, elastic, and multi-tenant solutions in SQL Azure. SQL Azzure Federations bring the sharding pattern into SQL Azure as a first class citizen as a way to achieve greater scalability and performance from the database tier of your application through horizontal partitioning at the database level. This session will look at Federations from a real-world point of view, by applying Federations to a real-life database. We will also look at performance benefits. 10/20/2012 11:30:00 AM 10/20/2012 12:30:00 PM 9061 9061 Martin Miller Track 3 Room 201 Data modeling is all about representing the real world in the database, and for 30 years the ER Model has been the preferred method for designing databases where the goal is to 'get the data in' by capturing business transactions. But the ER Model is not the most efficient model where the goal is to 'get the data back out'. The Dimensional Model allows us to take a very different look at all that data and restructure it in a way that is optimized for aggregation and summarizing so that we can unlock its information potential and build effective 'Business Intelligence' systems. This presentation takes you 'through the looking glass' to introduce you to a world of 'fact tables', 'dimensions', 'star schemas' and more. 10/20/2012 1:30:00 PM 10/20/2012 2:30:00 PM 9391 9391 Jason Kassay Track 3 Room 201 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. 10/20/2012 10:15:00 AM 10/20/2012 11:15:00 AM 9486 9486 Steven Wake Track 2 Room 206 SSIS 2012 added rounded corners and Undo/Redo to the designer, but what else was added to make this worth the upgrade? In this session there will be as many demos of the new features as can be fit into the time provided. Along with the rounded corners, you will also see the changes to deployment, SSIS catalog database, metadata/XML updates, Parameters, logging updates, Data Taps, ODBC support, script debugging, PowerShell interface and as many others as we can get through. If you haven't seen what has been updated in SSIS 2012, this will be the session to cover the most! 10/20/2012 2:45:00 PM 10/20/2012 3:45:00 PM 10412 10412 Jason Brimhall Track 1 Room 200 SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine. 10/20/2012 1:30:00 PM 10/20/2012 2:30:00 PM 10738 10738 Paul Turley Track 2 Room 206 Relational, multidimensional, now Tabular... how many ways can you bend your data (and your brain)? It took some work to get our heads around cubes, MDX OLAP concepts; and now the next generation of analytical data technology from Microsoft is not so radical. Learn how to enable deep analytics BI in your environment without popping brain cells learning yet another foriegn technology. The magic of VertiPaq: PowerPivot on the desktop BISM Tabular models leverage modern computing power in a new way. Gain insight about how to choose among all these options and build compelling dashboards reports with SharePoint, Reporting Services Power View. 10/20/2012 9:00:00 AM 10/20/2012 10:00:00 AM 10741 10741 Paul Turley Track 3 Room 201 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! 10/20/2012 11:30:00 AM 10/20/2012 12:30:00 PM 11208 11208 Aaron Cutshall Track 4 Lab Do you ever wonder how you can make T-SQL do what you really want? Do you want to know how to make it jump through loops, perform amazing twists and turns, and execute other wondrous performances? In this session you'll learn about various features such as CTE, ROW_NUMBER, and other great features that will enable you to make your T-SQL queries and stored procedures more efficient and give you the results you really want. 10/20/2012 10:15:00 AM 10/20/2012 11:15:00 AM 11251 11251 Randy Knight Track 3 Room 201 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. 10/20/2012 4:00:00 PM 10/20/2012 5:00:00 PM 11252 11252 Randy Knight Track 1 Room 200 SQL Server offers several isolation levels beyond the default 'READ COMMITTED'. But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each. 10/20/2012 11:30:00 AM 10/20/2012 12:30:00 PM 11273 11273 Tobe Pittman Track 4 Lab Making life a little easier by creating an airtight deployment process. Will address methods of scripting, versioning, creating bootstrap and test data, security, rolling back, etc. By reducing human interaction (and thus error) and increasing the ability to reproduce development, QA and production conditions, deployment night will be much less stressful and much shorter. 10/20/2012 2:45:00 PM 10/20/2012 3:45:00 PM 11279 11279 Ben Miller Track 2 Room 206 Ever wanted to know what happens in SQL Server when you use PowerShell and SMO to manage a SQL Server? How fast can your automation really go? I will take you through the most common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come peek behing the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO. You'll be glad you did. 10/20/2012 10:15:00 AM 10/20/2012 11:15:00 AM 11280 11280 Ben Miller Track 1 Room 200 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. 10/20/2012 4:00:00 PM 10/20/2012 5:00:00 PM 11311 11311 Chad Crawford Track 1 Room 200 SQL Server Service Broker is a messaging framework built into the SQL Server engine. It enables SQL Server to handle messaging between servers and applications with light setup and overhead. The flexibility of the framework enables Service Broker to queue event notifications, task execution requests or other messages while leveraging the strength of SQL Server transaction management, reliability and recoverability. In this session we will see how to set up Service Broker, discuss case studies where it has been implemented in industry, and step through a practical example implementing an audit log. 10/20/2012 9:00:00 AM 10/20/2012 10:00:00 AM 11326 11326 Tjay Belt Track 1 Room 200 The very nature of a database system is to be dynamic; rarely static. The applications that use databases tend to change, requiring changes to occur within our databases. The totality of pieces and parts that comprise this ‘change’ will be combined into a ‘Release’ that will be applied to your systems. Controlling this change is not rocket science, but it is not without its complexities. We will discuss various terms, processes, ideas, and suggest tools to assist you in performing this necessary function, while minimizing risk, and impacting your systems in a graceful fashion. 10/20/2012 2:45:00 PM 10/20/2012 3:45:00 PM 11502 11502 Scott Heffron Track 2 Room 206 This talk will show the steps needed to process an XML file for an order entry system. We will go through the lifecycle of the XML file and how the data is processed so that it is usable for entry in an order entry system. We will show the different pieces of the XML process and files and how they work together. We will also show how to dynamically change information as the need arises. 10/20/2012 1:30:00 PM 10/20/2012 2:30:00 PM 11526 11526 Kelly Martinez Track 4 Lab NoSQL is one of the hot 'new' things in the developer world. As DBAs inevitably someone will come to us for help or advice on (or possibly choosing) a NoSQL solution. This session aims to give you a basic understanding in order to best answer those questions for your organization. In this presentation I will cover: What exactly NoSQL is (and is not), ACID compliance of some popular NoSQL solutions, main differences between traditional RDBMS and NoSQL, why NoSQL popular with developers, and when you might (or might not) want to leverage it for a solution. 10/20/2012 1:30:00 PM 10/20/2012 2:30:00 PM 11545 11545 Jason Brimhall Track 3 Room 201 Extended Events were introduced in SQL Server 2008. With SQL 2012, we have seen a significant upgrade to this feature. Join me for a little adventure into what extended events are. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. 10/20/2012 9:00:00 AM 10/20/2012 10:00:00 AM 11555 11555 Cindy Gross Track 2 Room 206 What is this Big Data thing and why should you care? Learn about Microsoft's Hadoop connectors, the Hive add-in for Excel, what Pig and Hive are, and more. Big Data is an exciting foray into the world of data previously too big to load and query in an affordable manner. With the new Big Data tools you can expand your BI reach and be the hero who helps your company make better business decisions. Session takeaways: • Understand what Big Data, Hadoop, Hive, and Pig are at a high level and how to use Hadoop, Hive and Pig as part of an integrated enterprise strategy for analyzing Big Data. • Learn why Big Data is so important in the business intelligence arena. • Kickstart your Big Data learning and know where to go to learn more. 10/20/2012 4:00:00 PM 10/20/2012 5:00:00 PM 11691 11691 Cindy Gross Track 1 Room 200 Everyone is buzzing about Hive and trumpeting the virtues of Hadoop. But what does it mean? Why does it matter to a SQL Server and/or BI professional? Come get a taste of the Hive honey and see why this new technology is worth buzzing about! 10/20/2012 10:15:00 AM 10/20/2012 11:15:00 AM 11815 11815 Scott Heffron Track 4 Lab SSIS event handlers are the simplest means of turning an SSIS script into a reliable system that is auditable, reacts appropriately to error conditions, reports progress and allows instrumentation and monitoring your SSIS packages. They are easy to implement, and provide a great deal of flexibility. Rob Sheldon once again provides the easy, clear introduction 10/20/2012 11:30:00 AM 10/20/2012 12:30:00 PM 11816 11816 Pat Wright Track 3 Room 201 We have 3 excellent DBA's/Designers/Architects from here in the Valley that will be available to answer questions about your system. If you have specific design questions or what's the best way to do X this is the session to attend! Ben Miller, Jason Brimhall and Randy Knight will be on the panel and Pat Wright will be moderating. 10/20/2012 2:45:00 PM 10/20/2012 3:45:00 PM 11817 11817 Pat Wright Track 1 Room 200 Join us for wrap up of the day's events and giveaways. 10/20/2012 5:00:00 PM 10/20/2012 5:15:00 PM 11817 11817 Pat Wright Track 2 Room 206 Join us for wrap up of the day's events and giveaways. 10/20/2012 5:00:00 PM 10/20/2012 5:15:00 PM 11817 11817 Pat Wright Track 3 Room 201 Join us for wrap up of the day's events and giveaways. 10/20/2012 5:00:00 PM 10/20/2012 5:15:00 PM 11817 11817 Pat Wright Track 4 Lab Join us for wrap up of the day's events and giveaways. 10/20/2012 5:00:00 PM 10/20/2012 5:15:00 PM