SQLSaturday #120 - Orange County 2012 3/24/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. #sqlsat120 Goldenwest College 15744 Goldenwest St. Huntington Beach CA 92647 1751 Red Gate Gold Sponsor http://www.red-gate.com http://www.red-gate.com/assets/images/common/logo.png 60 170 1901 Idera Gold Sponsor http://www.idera.com http://www.idera.com/images/Logo-Idera.png 60 170 1948 Microsoft Gold Sponsor http://www.microsoft.com http://www.sqlsaturday.com/files/d4c80e75-5362-4be4-bfc6-d6100ad38454.jpg 60 170 1954 WhereScape USA Limited Gold Sponsor http://www.wherescape.com http://www.sqlsaturday.com/files/69a47543-eb40-4f8e-9c17-c30cf750e253.gif 60 170 2010 Golden West College Facilities Sponsor http://www.goldenwestcollege.edu/ http://www.sqlsaturday.com/files/7e48a597-32a7-4fa9-900e-8ca868c81741.png 60 170 2061 Fusion-io Silver Sponsor https://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 1719 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 1734 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 1755 StrateSQL Blog Sponsor http://www.jasonstrate.com http://www.jasonstrate.com/images/StrateSQLBanner.jpg 40 100 1836 MarkTab Consulting Blog Sponsor http://www.marktab.net http://www.marktab.net/images/MarkTabNet_100x40.gif 40 100 1855 SQLvariant Blog Sponsor http://sqlvariant.com/wordpress http://sqlvariant.com/BlogSupport/Images/SQLvariant_Logo.png 40 100 7773 Aaron Nelson Aaron Nelson is a Senior SQL Server Architect with over 10 years of experience in SQL Server. Aaron holds certifications for MCITP: Business Intelligence Developer, Database Administrator, Database Developer; as well as MCTS: Windows Server Virtualization, Configuration (meaning Hyper-V). @http://twitter.com/sqlvariant http://www.linkedin.com/in/sqlvariant http://sqlvariant.com/wordpress/ https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/sqlvariant 48 48 8241 Andrew Karcher Andrew Karcher @akarcher http://www.linkedin.com/in/andrewkarcher http://www.andrewkarcher.com https://api.twitter.com/1/users/profile_image?screen_name=@akarcher 48 48 7987 Audrey Hammonds Audrey Hammonds is a database developer at ista North America in Alpharetta, GA, and a SQL Server MVP. She blogs at datachix.com with Julie Smith. She loves pretty databases, cool T-SQL, and interesting problems. She's been doing this data thing for about 15 years, and is still amazed that data can be so entertaining. You can probably find her at Taco Mac, Starbucks, or on Twitter as @DataAudrey. If she's not there, she's likely at home with her family, reading geeky Fantasy or Science Fiction. @DataAudrey http://www.linkedin.com/in/audreyhammonds http://datachix.com https://api.twitter.com/1/users/profile_image?screen_name=@DataAudrey 48 48 7688 Ben Aminnia Ben Aminnia is a database architect / .NET developer / consultant at Pointer Corporation www.pointercorp.com with over 20 years of experience in developing database systems and managing a team of SQL Server developers and DBAs. He's also the president of Los Angeles SQL Server Professionals Group www.sql.la and the architect of Virtual Information Portal (VIP) System www.vipletters.com. http://www.linkedin.com http://www.pointercorp.com 48 48 6553 Benjamin Muller Ben Muller (MBA MCITP:BI) is an experienced and popular speaker on Data Warehouse, Business Intelligence, and Collaboration topics, including speaking at dozens of SQLSaturday, Oregon BI Community (orbic.org), SharePoint user group, and regional events. When not promoting DW/BI topics, Ben has the pleasure of leading a great group of expert Data Warehouse and Business Intelligence professionals serving clients throughout the Pacific Northwest. @BenjaminNevarez http://www.linkedin.com/in/benmuller http://benjmuller.wordpress.com https://api.twitter.com/1/users/profile_image?screen_name=@BenjaminNevarez 48 48 6665 Brent Greenwood Brent Greenwood is a Senior Business Intelligence Engineer at Bridgepoint Education and a Business Intelligence Instructor at UCSD-extension. He has over 11 years of experience in data analysis, data warehousing and business intelligence delivering solutions in the Investment Management, Brokerage, Insurance Services, Healthcare and Higher Education verticals. He is an MCITP in SQLServer2008 BI and Database Dev, as well as a TDWI Certified BI Professional in Data Analysis Design. http://www.linkedin.com/in/brentgreenwood http://brentgreenwood.blogspot.com https://api.twitter.com/1/users/profile_image?screen_name= 48 48 7989 Carlos Bossy Carlos Bossy (MCTS, MCP SQL Server 2008 BI, CBIP) is a Consultant with 25 years experience in software and database development. As the Principal of his company Carlos focuses on developing Business Intelligence solutions including modeling data warehouses, predictive analytics, integration and reporting. He has worked with SQL Server for 12 years and is very enthusiastic about its powerful features. Carlos has developed warehouses and BI solutions for a variety of industries and state agencies. @carlosbossy http://www.linkedin.com/in/carlosbossy http://www.carlosbossy.com https://api.twitter.com/1/users/profile_image?screen_name=@carlosbossy 48 48 7606 Chris Dickey Chris Dickey is an independent consultant specializing in SQL Server performance. He has over 21 years of experience working with SQL Server. He also has a 30 year background in software development including: T-SQL, SQL CLR, XML, C, C++, C#, .NET, Win32 API, ASP, ASP.NET and ASP.NET MVC 3, jQuery. Chris Dickey is a graduate of the University of California San Diego. http://www.linkedin.com/pub/chris-dickey/14/106/424 http://www.FastSqlServer.com 48 48 6747 Clint Kunz Clint Kunz is a Data Platform Technology Specialist working for Microsoft Corporation in Southern California. He has been working with SQL Server and in the Business Intelligence and Data Warehousing field for over 11 years. Clint focuses on helping customers adopt and deploy Microsoft tools to solve their analysis, reporting, and information management challenges. @cgkunz http://www.linkedin.com/in/clintkunz https://api.twitter.com/1/users/profile_image?screen_name=@cgkunz 48 48 8642 Denise McInerney Denise McInerney began her career as a SQL Server DBA in 1998. Denise's focus is design and performance tuning OLTP databases that support web-based applications. She is currently employed as a Staff DBA at Intuit in Mountain View, CA. Denise serves as a Director on the PASS Board of Directors. An active PASS volunteer since 2003, Denise founded the group's Women in Technology chapter. @denisemc06 https://api.twitter.com/1/users/profile_image?screen_name=@denisemc06 48 48 6555 Denny Cherry Denny Cherry has over a decade of experience managing SQL Server and is currently the Manager of Information Systems at Phreesia. Denny holds several Microsoft Certifications including the MCM as well as being a Microsoft MVP and an MCM. @mrdenny http://www.linkedin.com/in/mrdenny http://www.mrdenny.com https://api.twitter.com/1/users/profile_image?screen_name=@mrdenny 48 48 6786 Diana Dee Diana is a Microsoft Certified Trainer who has taught Microsoft courses to IT professionals and college students since 1996. Diana has been a course developer throughout her computer teaching career. She has revised and developed database design, administration, and querying courses for an on-line University and for a major training company. She presented 'How Indexes Optimize Query Performance' at SQL Saturday #44, and 'Relational Database Design Basics' at SQL Saturday #73. @SQLDee https://api.twitter.com/1/users/profile_image?screen_name=@SQLDee 48 48 7341 Douglas Barrett Douglas Barrett is a Senior Solution Architect with WhereScape. Douglas has worked as a consultant specializing in Data Warehousing and BI on SQL Server since 2000, working for Microsoft and now WhereScape. Over this time Douglas has used iterative project approaches to successfully deliver projects for a large number of clients including Retail Banks, Airlines, Insurance companies, Retailers, Health providers and Manufacturers. @dougy_jb http://www.linkedin.com/profile/view?id=13639001 https://api.twitter.com/1/users/profile_image?screen_name=@dougy_jb 48 48 7461 Eddie Wuerch Eddie Wuerch is a DBA, developer, and trainer specializing in SQL Server for over ten of the twenty years he has spent in IT. Eddie is currently the tech lead of the DBA team at ExactTarget, a leading SaaS ESP located in Indianapolis. Eddie and his team design and manage the many multi-terabyte 24x7 SQL Server database clusters that form the foundation of the ExactTarget application. He holds MCITP certifications in SQL Server 2005 and 2008 development and administration, and is an MCT. @eddiew http://www.linkedin.com/in/eddiewuerch https://api.twitter.com/1/users/profile_image?screen_name=@eddiew 48 48 6851 Grant Fritchey @gfritchey http://www.linkedin.com/in/scarydba https://api.twitter.com/1/users/profile_image?screen_name=@gfritchey 48 48 7372 Harry Chandra Harry Chandra is a SQL Server Database Administrator for a software company in Portland, Oregon with a Bachelor of Arts Degree in Information System from Portland State University. He's been working with various releases of SQL Server for over 4 years. His main focus is in Administration and High Availability for SQL Server, although he has always strived to expand his knowledge into other area of SQL Server. He is a member of the Portland SQL Server User Group and SQL Pass member. @SQLDude503 http://www.linkedin.com/pub/harry-chandra/38/219/324 http://blogs.h2dclan.com https://api.twitter.com/1/users/profile_image?screen_name=@SQLDude503 48 48 6552 Ike Ellis With over 17 years of experience in databases and a current Microsoft MVP, Ike Ellis is recognized as one of the best and brightest independent SQL Server experts. Ike is an exceptional community leader who shares his extensive technical expertise with prominent businesses, learners, and user groups. He provides indispensable feedback to Microsoft as a member of SAGO (Microsoft's group of SQL Azure Experts). Ike has been Microsoft certified since the beginning, currently holding an MCDBA, MCSE, @ellisteam1 http://www.linkedin.com/in/ikeellis http://www.ellisteam.net https://api.twitter.com/1/users/profile_image?screen_name=@ellisteam1 48 48 6685 Janis Griffin Janis Griffin has over 20 years of DBA experience including design, development and implementation of many critical database applications. Prior to Confio, Janis held DBA positions in the Telecom Industry (15 yrs), working with both real-time network routing databases and OLTP business to business applications. Janis was Principal Architect and Sr. Manager, mentoring other DBAs on best practices in database performance tuning. @DoBoutAnything http://www.linkedin.com/pub/janis-griffin/0/914/aba https://api.twitter.com/1/users/profile_image?screen_name=@DoBoutAnything 48 48 7555 Jeremiah Peschka Jeremiah sees the magic in technology. He knows how to do things now, and he also knows how to think about possibilities. Jeremiah likes to imagine new kinds of indexes, new kinds of teams, new kinds of applications — this means when you need to reinvent something, or get unblocked, you should talk to Jeremiah. @peschkaj http://linkedin.com/in/jeremiahpeschka http://brentozar.com https://api.twitter.com/1/users/profile_image?screen_name=@peschkaj 48 48 7535 Kendra Little Kendra Little is all about data, communication, and creativity. Kendra is a founder at Brent Ozar PLF, LLC, where she specializes in high availability and performance tuning. She is a Microsoft Certified Master in SQL Server-- the highest technical SQL Server Certification available. Those cartoons in her blog posts and slide decks? She draws 'em all. @Kendra_Little http://www.linkedin.com/in/kendralittle http://brentozar.com https://api.twitter.com/1/users/profile_image?screen_name=@Kendra_Little 48 48 6743 Lynn Langit Lynn is a a former Microsoft evangelist who has been working with relational data for over 10 years. She's published three books on SQL Server BI and is now writing and teaching on data solutions (both relational and non-relational) for DevelopMentor. Lynn is helping customers to understand the impact of two major new trends - cloud and noSQL on the world of data solutions. She is also the co-founder of the non-profit 'Teaching Kids Programming.' @lynnlangit http://www.LynnLangit.com https://api.twitter.com/1/users/profile_image?screen_name=@lynnlangit 48 48 6763 Michael Steineke Michael Steineke is the Vice President of Information Technology for Edgenet – Big Hammer. He has been working with NLBS and Windows Clustering on Windows NT 4 Server through 2008R2, creating clusters with IIS, File System, SQL, ISA, and Hyper-V, including geographically dispersed clusters. Michael has designed and implemented multiple systems for scalability, high availability and disaster recovery. @cfrandall http://www.linkedin.com/in/brentozar https://api.twitter.com/1/users/profile_image?screen_name=@cfrandall 48 48 6695 Mitchell Bottel Mitchell Bottel is a senior database administrator and owner of Innovative IT Consulting. He has 11 years of IT experience, focusing on SQL Server for the last seven years with an emphasis on database administration and high availability solutions. He has authored blog posts on the SQLServerPerformance website and written White Papers on using Dynamic Management Views. @SacSQLDude http://www.iitconsulting.com https://api.twitter.com/1/users/profile_image?screen_name=@SacSQLDude 48 48 8652 Nitin Salgar Nitin C Salgar has over 7 years of DBA experience including planning,design, development and implementation of line of business database applications. Nitin has worked primarily as a consultant holding positions primarily in the Benefit Management, Transportation and Government. He has worked on OLTP and OLAP applications housed on Premise (Co-Lo / Datacenter) as well as Cloud. He also possesses several Microsoft certifications on 2008, gearing toward 2012 @nitinsalgar http://www.linkedin.com/in/salgarnc https://api.twitter.com/1/users/profile_image?screen_name=@nitinsalgar 48 48 7655 Phil Helmer Phil Helmer has been working with relational databases for the last 10 years, the last half of that with SQL Server. He is particularly involved with database design/development as well as modifying databases to scale. He is currently a Database Engineer in San Diego for the cloud storage firm Nirvanix, Inc. Phil also has a degree in Management Information Systems from the University of New Orleans. @philhelmer http://www.linkedin.com/in/phelmer http://www.philhelmer.com https://api.twitter.com/1/users/profile_image?screen_name=@philhelmer 48 48 6819 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 https://api.twitter.com/1/users/profile_image?screen_name=@randy_knight 48 48 7692 Rick Morelan Rick is the author of the “SQL Joes 2 Pros” book series. Rick has worked for Microsoft since the late 90s and has attained over 30 Microsoft certifications in applications, networking, databases and .NET development, including MCDBA, MCTS, MCITP, MCAD, MOE, MCSE and MCSE+I. He has also provided training for NW University, Volt Technical Education, Bellevue College, and Microsoft. @Joes2Pros http://Joes2Pros.com https://api.twitter.com/1/users/profile_image?screen_name=@Joes2Pros 48 48 7046 Warren Sifre Warren Sifre has over 15 years of experience in the IT community and has worked in a variety of industries deploying many different products, most of which consisted of using MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. He has joined PTI to ensure his continued mastery in the different disciplines of MS SQL maintains upward momentum. @WAS_SQL http://www.linkedin.com/pub/warren-sifre/2b/88b/289 http://www.pti.net https://api.twitter.com/1/users/profile_image?screen_name=@WAS_SQL 48 48 6552 6552 Ike Ellis Track 6 Tech 117 SQL Azure Federations is an amazing way to scale-out relational database applications. You will learn about new T-SQL keywords and why SQL Azure is uniquely suited to solve the relational scale-out problem. Come discover how you can use SQL Azure Federations to handle scale problems of any size! 3/24/2012 1:30:00 PM 3/24/2012 2:30:00 PM 6553 6553 Benjamin Muller Track 3 Tech 100 Tired of supposedly data-driven discussions that quickly devolve into anarchy, finger pointing, and second guessing? This session will show you how to use new and improved SQL Server 2012 BI capabilities, including PowerPivot v2 and Power View to clear the FUD and get your meetings back on track. We will discuss principals for creating effective, business-oriented BISM models, and visualization techniques that emphasize clarity and usability. 3/24/2012 2:45:00 PM 3/24/2012 3:45:00 PM 6554 6554 Benjamin Muller Track 4 Tech 101 In this session Benjamin Muller, Practice Manager, Business Intelligence at CSG Pro will discuss Microsoft's upcoming Business Intelligence tool, Power View. Packaged with the SQL Server 2012 release, Power View lets users of all skill levels quickly create dynamic and compelling reports and analyses which can be instantly published to SharePoint. Ben will review the features and functionality of Power View, and talk through some common Power View scenarios. 3/24/2012 8:30:00 AM 3/24/2012 9:30:00 AM 6555 6555 Denny Cherry Track 1 Rustler Hangout In this session we will be looking at the SQL Server table partitioning features which were introduced in SQL Server 2008. We will look at how to create partitioned tables and indexes as well as the internals of the table. We will also look at how to move data from one partition to another and from one table to another with minimal to no impact to the users. 3/24/2012 9:45:00 AM 3/24/2012 10:45:00 AM 6557 6557 Denny Cherry Track 1 Rustler Hangout In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2008 databases. We will also be looking into the new indexing features that are available in SQL Server 2008 (and SQL Server 2005) and how you the .NET developer can make the best use of them to get your code running its best. 3/24/2012 11:00:00 AM 3/24/2012 12:00:00 PM 6665 6665 Brent Greenwood Track 3 Tech 100 In this session, we will walk through the fundamentals of dimensional modeling that are at the core of Kimball method data warehousing. We will cover theory and real world applications of the following: - The modeling process - Fact table patterns - Dimension patterns - Conforming structures - Advanced modeling patterns and best practices 3/24/2012 8:30:00 AM 3/24/2012 9:30:00 AM 6685 6685 Janis Griffin Track 2 Math 118 More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment. 3/24/2012 8:30:00 AM 3/24/2012 9:30:00 AM 6687 6687 Janis Griffin Track 8 Tech 214 Management Data Warehouse (MDW) which was introduced in 2008 can provide DBAs with useful performance information about Disk Usage, Server Activity and Query Statistics. This presentation will explore how to set up MDW, look at its underlying schema / statistics and point out some of its shortcomings in comparison with other performance tools. 3/24/2012 11:00:00 AM 3/24/2012 12:00:00 PM 6695 6695 Mitchell Bottel Track 7 Tech 118 In this session, you will learn how to setup and implement Central Management Server (CMS) to run queries against multiple SQL servers in your environment. We will also cover Policy Based Management (PBM) and how to use out of the box best practices and create custom policies to maintain your environment. We will then look at using both CMS and PBM in conjunction with each other to monitor your environment. 3/24/2012 11:00:00 AM 3/24/2012 12:00:00 PM 6696 6696 Mitchell Bottel Track 7 Tech 118 Self-promotion is often times the best promotion you can get. In this session, we will talk about how to promote yourself, your brand and your career. We will discuss Social Medias, communities, volunteering and other ways to get your name out… What are the first steps? Come find out. We will hit some of the basic techniques to the advanced strategies. 3/24/2012 8:30:00 AM 3/24/2012 9:30:00 AM 6743 6743 Lynn Langit Track 1 Rustler Hangout Are you confused (and concerned) by all the talk about noSQL solutions? Are you uncertain as to which solution is right for your situation? (if any). Come to this demo-filled session to understand the noSQL landscape. Includes info about cloud-based BLOB storage from all of the big vendors, i.e. Amazon, Google, Microsoft, Also includes info about Hadoop and other open source databases, such as MongoDB. 3/24/2012 2:45:00 PM 3/24/2012 3:45:00 PM 6747 6747 Clint Kunz Track 3 Tech 100 This session will cover the enhancements in SQL Server 2012's Enterprise Information Management Platform (EIM), That includes SQL Server Integration Services (SSIS), the new Data Quality Services Engine (DQS), and Master Data Services new capabilities (MDS). We'll also touch on the publically available information on Project Barcelona - the new Data Lineage and Impact Analysis services under development as well. 3/24/2012 11:00:00 AM 3/24/2012 12:00:00 PM 6763 6763 Michael Steineke Track 1 Rustler Hangout Overview of new features and enhancements in SQL Server 2012 ‘Denali’ to help support High Availability and Disaster Recovery. Breakdown of AlwaysOn Feature set, and design considerations. What are Availability Groups, and Readable Secondary’s, and how do they work. Multi-Subnet SQL clustering, what no more stretched VLAN? Including demo’s and working systems to review configurations. 3/24/2012 8:30:00 AM 3/24/2012 9:30:00 AM 6786 6786 Diana Dee Track 2 Math 118 Securing SQL Server requires an understanding of how a SQL Server instance and its objects are accessed and how permissions for access are granted or not allowed. This presentation will cover the entire spectrum from service accounts, logins, and users, to granular permissions and encryption. You should acquire enough understanding to be able to apply the 'principle of least privilege' in your own SQL Server environment. Content: • Service accounts • Logins and Users • Permissions • Encryption • Some new security features of SQL 2012 3/24/2012 1:30:00 PM 3/24/2012 2:30:00 PM 6819 6819 Randy Knight Track 3 Tech 100 The XML Functionality embedded into SQL Server 2005 and 2008 is one of its most powerful yet least understood features. This seems to be primarily because DBA's shy away from it and developers prefer to work with XML in their code. In this session we will explore the XML features of SQL Server and how we can bridge these two worlds. Topics covered will include retrieving relational data as XML, storing XML in the database using the XML Datatype, XML indexes, and the XQuery functions included in SQL Server. We will also look at using XML as stored procedure parameters as a way to pass large amounts of complex data between client and server. 3/24/2012 4:00:00 PM 3/24/2012 5:00:00 PM 6820 6820 Randy Knight Track 5 Tech 116 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. 3/24/2012 8:30:00 AM 3/24/2012 9:30:00 AM 6851 6851 Grant Fritchey Track 6 Tech 117 SQL Server backups can be burdensome to set up and maintain. All sorts of different problems can occur. This session targets the most common problems encountered while working with SQL Server backup and shows you how to identify these issues in your environment. In fact, I’ll walk you through how to prevent these common issues from ever cropping up within your systems in the first place. Be prepared for information you can take back to the office and put to work right away making your system backups more reliable. With backups running correctly all the time, you’ll be protecting your systems better, and feeling a lot less stress when it times to perform an emergency restore. 3/24/2012 4:00:00 PM 3/24/2012 5:00:00 PM 6852 6852 Grant Fritchey Track 6 Tech 117 While most T-SQL developers focus on writing quality T-SQL code and efficient queries, what they often forget is how it should best be deployed. This includes deployment of new applications, as well as upgrades and bug fixes. In this session, you will learn many best practices involving the principles of continuous integration, such as maintaining a code repository, automating builds, self-testing, auditing, automated deployment, and much more. This session is designed for both DBA administrators and developers who want to optimize their T-SQL deployment process. 3/24/2012 2:45:00 PM 3/24/2012 3:45:00 PM 7046 7046 Warren Sifre Track 4 Tech 101 Imagine an environment where moving a database from a SQL Instance to another is as simple as just restoring the database. (Yes, no other steps!) SQL Server 2012 RC0 now supports Partial Contained databases. We will cover the different levels of containment, configuring SQL Server to support it, and much more (i.e. Demos). 3/24/2012 2:45:00 PM 3/24/2012 3:45:00 PM 7047 7047 Warren Sifre Track 6 Tech 117 What are FileTables? How do they work? What are their limitations? These questions and more will be answered in this demo filled presentation. We will walkthrough the configuration and implementation of this feature. We will show you some use cases on how this fucntionality can help you manage your data in whatever forms it exists. 3/24/2012 8:30:00 AM 3/24/2012 9:30:00 AM 7341 7341 Douglas Barrett Track 3 Tech 100 This session will describe the best practises for designing a data warehouse to get the most out of SQL Server. Doug has worked in data warehousing for 12 years and will blend experience, with best practises 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. 3/24/2012 9:45:00 AM 3/24/2012 10:45:00 AM 7344 7344 Benjamin Nevarez Track 2 Math 118 The SQL Server Query Optimizer is a cost-based optimizer: it analyzes a number of candidate execution plans for a given query, estimates the cost of each of these plans, and selects the plan with the lowest cost. In this session I will go into the internals of the Query Optimizer and will show you the steps that it performs in the background covering everything from the time a query is submitted to SQL Server until an execution plan is generated. Why query optimization is an inherently complex problem and why challenges in some of its most fundamental areas are still being addressed today will be covered as well. 3/24/2012 2:45:00 PM 3/24/2012 3:45:00 PM 7345 7345 Benjamin Nevarez Track 2 Math 118 Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics. 3/24/2012 4:00:00 PM 3/24/2012 5:00:00 PM 7346 7346 Benjamin Nevarez Track 1 Rustler Hangout This session, updated for SQL Server 2012, will show you how a better understanding of how the Query Optimizer works can help you to improve the performance of your queries. I will show you the top 10 Query Optimizer topics that can give you the most benefit by focusing both on concepts and practical solutions. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach. 3/24/2012 1:30:00 PM 3/24/2012 2:30:00 PM 7372 7372 Harry Chandra Track 8 Tech 214 In this introductory session, we will go through an overview of SQL Server Mirroring and Log Shipping. What are the parts and modes of database mirroring. You will also be introduce to log shipping and how it works. We will have a demo part of the session where we will go through every step of how to set up mirroring and log shipping. By the end of this session, you should have a general understanding and ability to deploy database mirroring and log shipping to meet your High Availability and Disaster Recovery requirement. 3/24/2012 2:45:00 PM 3/24/2012 3:45:00 PM 7461 7461 Eddie Wuerch Track 5 Tech 116 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. 3/24/2012 2:45:00 PM 3/24/2012 3:45:00 PM 7462 7462 Eddie Wuerch Track 5 Tech 116 Have you ever thought about speaking at a user group or SQL Saturday, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and build a killer abstract for it, * Design and build the presentation, and * Prepare and deliver your first session 3/24/2012 4:00:00 PM 3/24/2012 5:00:00 PM 7463 7463 Eddie Wuerch Track 5 Tech 116 Latching is a necessary function of the database engine. Although latching is a topic is normally presented only in expert-level sessions, a good grasp of the problems excessive latching exposes is important even for novice tuners. This session focuses on the PAGELATCH_* and PAGEIOLATCH_* wait types, explaining what is happening, why it is happening, and how to use the exposed information to tune queries and solve performance problems. If you've seen these wait types in Activity Monitor and wonder what they meant, then this session is for you! 3/24/2012 9:45:00 AM 3/24/2012 10:45:00 AM 7535 7535 Kendra Little Track 2 Math 118 When your SQL Server is critically injured, you need a first responder kit to help you diagnose the problem and apply emergency aid. In this session, Kendra Little introduces you to queries, built-in tools, and processes for triaging an emergency. If you have one year's experience with database administration, this session will set you up to triage like a pro. 3/24/2012 11:00:00 AM 3/24/2012 12:00:00 PM 7555 7555 Jeremiah Peschka Track 2 Math 118 Computers are governed by the rules of physics: electrons, drive heads, and disk platters can only move so fast. Understanding how these rules operate and interact leads to insights into application performance. Understanding why something might perform a certain way makes it much easier to understand the tradeoffs of a specific design. Database systems are built according to those rules: memory is faster than disk which is faster than the network. Database schemas and queries are built within the rules of database systems. You will hit the limitations of these rules. If you know what the rules are and why they are in place, you'll know when it's time to break them... and how to succeed. 3/24/2012 9:45:00 AM 3/24/2012 10:45:00 AM 7558 7558 Jeremiah Peschka Track 5 Tech 116 Refactoring SQL is not like refactoring application code. This talk will demonstrate proven SQL refactoring techniques that will help you identify where performance gains can be made, apply quick fixes, improve readability, and help you quickly locate places to make sweeping performance improvements. Jeremiah Peschka has years of hands on experience tuning SQL applications for performance, throughput, and concurrency. 3/24/2012 1:30:00 PM 3/24/2012 2:30:00 PM 7606 7606 Chris Dickey Track 7 Tech 118 I will demonstrate practical examples of how to use Extended Events to figure out details of what SQL Server is doing when problems are occuring. You can dig deep into the internals of SQL Server with Extended Events since they track operations at a very low level. Extended Events were first introduced in SQL Server 2008 but have not been used that much because of the learning curve. SQL Server 2012 has promoted Extended Events to a much more important level. The feature is now ready to replace Profiler as the primary tool to gather real time details of query execution. The majority of my presentation will be demoing real world problem solving. 3/24/2012 1:30:00 PM 3/24/2012 2:30:00 PM 7655 7655 Phil Helmer Track 7 Tech 118 There are some classic database programming tasks that rely on answering the question 'What did I just change?' Prior to SQL Server 2005, we had to use functions like SCOPE_IDENTITY() and some extra tricks for handling multiple rows. Some people even had to resort to triggers. Yikes!! This session focuses on the practical use cases for the T-SQL OUTPUT clause. More importantly, you will find out how you can ditch the tricks of the past for a simpler solution that will help keep you sane. 3/24/2012 4:00:00 PM 3/24/2012 5:00:00 PM 7688 7688 Ben Aminnia Track 8 Tech 214 SQL Server 2012 promises to be another milestone in improved performance, security, self-service BI, and migration to the cloud. Among the enhancements in SQL Server 2012 are 14 new functions in T-SQL as well as SQL Server Data Tools (SSDT) and the new talk of the town: 'AlwaysOn!' Additional topics within the presentation will cover different viewpoints of DBAs, Developers, and IT Managers, both before and after the decision to upgrade to SQL Server 2012 and required planning steps. 3/24/2012 8:30:00 AM 3/24/2012 9:30:00 AM 7692 7692 Rick Morelan Track 4 Tech 101 Forget Profiler for a second, I have seen one poorly placed index bring an enterprise database to its knees. We will cover the basic tips of performance which always work and the ones which always fail. What can you do – and what should you do –when it comes to the most common types of indexes so you always make the right move. We will use lessons from SQL Architecture Joes 2 Pros Vol3. 3/24/2012 1:30:00 PM 3/24/2012 2:30:00 PM 7693 7693 Rick Morelan Track 6 Tech 117 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 or control it. This is possible with or without structured error handling. See both ways to control the outcome. This is a very common workplace faux pas and a Microsoft Certification topic for Dev and Admins. We will use lessons from SQL Programming Joes 2 Pros Vol4. 3/24/2012 9:45:00 AM 3/24/2012 10:45:00 AM 7773 7773 Aaron Nelson Track 7 Tech 118 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. 3/24/2012 9:45:00 AM 3/24/2012 10:45:00 AM 7871 7871 Clint Kunz Track 4 Tech 101 Power View is the new ad-hoc data visualization tool coming in SQL Server 2012. Power View runs on a Business Intelligence Semantic Model created in either PowerPivot for Excel, or in Visual Studio 2010 for publishing to SQL Server Analysis Services. In this session we will go through the complete process for creating several (BISM) models from scratch, and working up in complexity using the Data Analysis Expresssion Language (DAX) to provide a functional and usable experience for your end-users that will use Power View. 3/24/2012 9:45:00 AM 3/24/2012 10:45:00 AM 7987 7987 Audrey Hammonds Track 7 Tech 118 Time-travel stories all have one common plot element - some action done in the past has big impact on the future. Sometimes you get lucky… Hoverboards! Sometimes, not so much... Morlocks! The same holds true in your database. Design decisions have a huge impact on how you’re going to get data into and out of your database. This session illustrates the performance impact of common database design issues and proposes design alternatives that will help your database avoid an H.G. Wellsian future. 3/24/2012 2:45:00 PM 3/24/2012 3:45:00 PM 7988 7988 Audrey Hammonds Track 1 Rustler Hangout There has been a lot of fanfare for some of the new features of SQL Server 2012. (AlwaysOn and T-SQL Windowing, I’m looking at you.) But there are a few other shiny little gems hidden between the replicas and frame clauses. The good folks at Microsoft have given T-SQL a few new features and functions, and it’s time to dig in and take a look at what presents they’ve brought us. T-SQL enhancements for 2012, including Result Sets, paging support, metadata discovery, new scalar functions, and the THROW clause for error handling are demonstrated in this session. Shiny! 3/24/2012 4:00:00 PM 3/24/2012 5:00:00 PM 7989 7989 Carlos Bossy Track 3 Tech 100 This session will present a Database and ETL Architecture that allows you to smoothly move data from your application databases across the enterprise in real-time to your data warehouse. Carlos Bossy will show you how to use SQL Server features such as Replication, Change Data Capture, SSIS and other techniques to extract, transform and load data fast and dependably and view a real demonstration of the system in action. Finally, Carlos will show how to use Reporting Services to present data with a minimum amount of latency. 3/24/2012 1:30:00 PM 3/24/2012 2:30:00 PM 7991 7991 Benjamin Nevarez Track 5 Tech 116 Columnstore indexes are one of the most exciting new features available in the next release of SQL Server 2012. Combined with new query processing algorithms, columnstore indexes are designed to improve the performance of data warehouses queries by several orders of magnitude providing more business value by allowing users to interactively explore the data. This session explains how columnstore indexes improve the performance of data warehouse queries—focusing on the query processing and optimization aspect of the technology—and identifies limitations of the current product release. 3/24/2012 11:00:00 AM 3/24/2012 12:00:00 PM 7992 7992 Carlos Bossy Track 4 Tech 101 The new Tabular Model in SQL Server 2012 is being touted as a powerful analytic engine that is faster and easier to implement than traditional cubes using Analysis Service. In this session Carlos Bossy will demonstrate how to develop analytic models using your existing data sources and will discuss best practices for preparing data so that it can be effectively used as a Tabular database. In addition to creating the model, Carlos will show you how to quickly add measures, hierarchies, and calculated columns to provide a rich user experience. 3/24/2012 11:00:00 AM 3/24/2012 12:00:00 PM 8016 8016 Ben Aminnia Track 6 Tech 117 This is my diary of the adventurous road I traveled for exploring the new world of SQL Azure. It spans a time period of about 18 months, with a mix of failures, success stories, and lessons learned. 3/24/2012 11:00:00 AM 3/24/2012 12:00:00 PM 8241 8241 Andrew Karcher General Session Registration Area Opening Remarks to kick off the day 3/24/2012 8:00:00 AM 3/24/2012 8:15:00 AM 8242 8242 Andrew Karcher General Session Registration Area End of Day Raffle 3/24/2012 5:00:00 PM 3/24/2012 5:30:00 PM 8642 8642 Denise McInerney Track 1 Rustler Hangout There are a variety of issues that affect women working in tech today, both as individuals and as a group. What concerns you as a WIT or someone who supports WIT? Bring your questions and ideas to a WIT un-panel. 3/24/2012 12:30:00 PM 3/24/2012 1:15:00 PM 8643 8643 Grant Fritchey Track 3 Tech 100 Gathering Knowledge for Performance: In this session, you’ll gain invaluable tips to enhance your SQL Server performance. Learn how to gather knowledge to identify database health issues, and avoid the same errors from slowing you down in the future. Come along to this session and you’ll have the chance to win a free license for SQL Monitor. 3/24/2012 12:30:00 PM 3/24/2012 1:15:00 PM 8650 8650 Douglas Barrett Track 4 Tech 101 This session will demonstrate how to build, iterate, document and deploy a data warehouse very quickly without compromising quality using WhereScape RED. WhereScape RED is a data warehouse development environment that automates many time consuming steps, generating tables, processing code, indexes, workflow and documentation as a single process. The resulting development speed and the ability to make changes extremely efficiently makes it the ideal tool for agile projects. 3/24/2012 12:30:00 PM 3/24/2012 1:15:00 PM 8651 8651 Warren Sifre Track 4 Tech 101 We are always being told 9’s, 9’s and more 9’s, but when implementation time comes to take action, technology / budget limitations get in the way, especially in the High Availability and Disaster Recovery (HA/DR) technology space. Clustering and Mirroring are great and meet many of our needs, but there are some things we have wished for, such as a mirror database that is usable. AlwaysOn solves this limitation by merging both Mirroring and Multi-Node Multi-Subnet Clustering (True Geo-Clustering Support!!!). AlwaysOn also allows the replica database to be used in a Read-Only capacity, so we can use it for reporting purposes. (Imagine that!) Join us in providing a warm welcome to this new functionality with extensive demos. 3/24/2012 4:00:00 PM 3/24/2012 5:00:00 PM 8652 8652 Nitin Salgar Track 8 Tech 214 This session is to discuss the data synchronization strategies. We'll go over setting up a Data Sync service between On Premise and Clound,cloud to cloud and other topologies offered. Will discuss one time data transfer options such as dacpac, Migration wizard and bcp 3/24/2012 1:30:00 PM 3/24/2012 2:30:00 PM