SQLSaturday #187 - Richmond 2013 3/9/2013 12:00:00 AM (GMT-05:00) Eastern Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat187 28 Westhampton Way Richmond VA 23173 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 2799 University of Richmond Venue Sponsor http://spcs.richmond.edu/ http://sqldatapartners.files.wordpress.com/2012/10/uofrcontinuingstudies.jpg 40 100 2937 B2B Solutions Gold Sponsor http://www.b2bsol.com http://sqldatapartners.files.wordpress.com/2013/01/b2b_rgb-copy-with-more-space-170-x-60-pixels.jpg 60 170 3038 CapTech Gold Sponsor http://www.captechconsulting.com/ http://upload.wikimedia.org/wikipedia/commons/2/2a/CTV_logo_2012_jpg.jpg 60 170 3048 Nimble Storage Gold Sponsor https://www.nimblestorage.com http://www.nimblestorage.com/images/logo.png 60 170 3057 Red Gate Software Silver Sponsor http://redg.at/VIt4x0 http://www.red-gate.com/assets/images/common/logo.png 60 170 3017 COZYROC Silver Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 3022 Dell Software Group Silver Sponsor http://www.quest.com/ http://i.imgur.com/BAdC3.png 60 170 2844 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2861 PASS Headquarters Silver Sponsor https://www.sqlpass.org http://www.sqlsaturday.com/images/PASS_logo.jpg 60 170 2926 SLAIT Consulting Silver Sponsor http://www.slaitconsulting.com/ http://img33.imageshack.us/img33/4460/slaitconsultinglogo.jpg 60 170 3080 Embarcadero Silver Sponsor http://www.embarcadero.com/products/db-powerstudio http://sqldatapartners.files.wordpress.com/2013/02/embarcadero.jpg 60 170 2984 Ntirety, Inc Bronze Sponsor http://www.ntirety.com http://www.ntirety.com/packages/theme_businesstheme/themes/businesstheme/images/NT-Logo2.png 60 170 2989 Idera Bronze Sponsor http://www.idera.com http://www.idera.com/images/Logo-Idera.png 60 170 2783 SQL Data Partners LLC Community Contributor http://www.sqldatapartners.com http://i1.wp.com/sqldatapartners.files.wordpress.com/2012/08/logosmallmodified.jpg 40 100 2892 Wayne Sheffield Individual http://blog.waynesheffield.com/wayne http://www.gravatar.com/avatar/a7a0ce0513a3a79e6bfe3bbe0bcf5852.png 40 100 3061 xSQL Software In Kind http://www.xsql.com http://www.xsql.com/images/xSQLSoftware.png 40 100 3006 Padgett Business Services In Kind http://www.smallbizaccountingrichmondva.com http://data.gointranet.com/unitloc/sbp/images/PadgettLogo.gif 40 100 2880 Pluralsight In Kind http://Pluralsight.com http://s.pluralsight.com/mn/img/logo/pluralsight-fullcolor-175x39-v1.png 40 100 11819 SQLSaturday 187 BI C112 3/9/2013 8:30:00 AM 3/9/2013 8:45:00 AM 11819 SQLSaturday 187 BI2 C114 3/9/2013 8:30:00 AM 3/9/2013 8:45:00 AM 11819 SQLSaturday 187 Dev A201 3/9/2013 8:30:00 AM 3/9/2013 8:45:00 AM 11819 SQLSaturday 187 DBA E303 3/9/2013 8:30:00 AM 3/9/2013 8:45:00 AM 11819 SQLSaturday 187 Professional Development / Misc C200 3/9/2013 8:30:00 AM 3/9/2013 8:45:00 AM 11819 SQLSaturday 187 Mixed Auditorium (1st Floor) 3/9/2013 8:30:00 AM 3/9/2013 8:45:00 AM 11820 SQLSaturday 187 DBA E303 3/9/2013 12:30:00 PM 3/9/2013 1:30:00 PM 11820 SQLSaturday 187 BI2 C114 3/9/2013 12:30:00 PM 3/9/2013 1:30:00 PM 11820 SQLSaturday 187 BI C112 3/9/2013 12:30:00 PM 3/9/2013 1:30:00 PM 11821 SQLSaturday 187 BI C112 3/9/2013 7:45:00 AM 3/9/2013 8:30:00 AM 11821 SQLSaturday 187 BI2 C114 3/9/2013 7:45:00 AM 3/9/2013 8:30:00 AM 11821 SQLSaturday 187 DBA E303 3/9/2013 7:45:00 AM 3/9/2013 8:30:00 AM 11821 SQLSaturday 187 Dev A201 3/9/2013 7:45:00 AM 3/9/2013 8:30:00 AM 11821 SQLSaturday 187 Mixed Auditorium (1st Floor) 3/9/2013 7:45:00 AM 3/9/2013 8:30:00 AM 11821 SQLSaturday 187 Professional Development / Misc C200 3/9/2013 7:45:00 AM 3/9/2013 8:30:00 AM 11822 SQLSaturday 187 Professional Development / Misc C200 3/9/2013 5:15:00 PM 3/9/2013 5:45:00 PM 11822 SQLSaturday 187 Mixed Auditorium (1st Floor) 3/9/2013 5:15:00 PM 3/9/2013 5:45:00 PM 11822 SQLSaturday 187 Dev A201 3/9/2013 5:15:00 PM 3/9/2013 5:45:00 PM 11822 SQLSaturday 187 DBA E303 3/9/2013 5:15:00 PM 3/9/2013 5:45:00 PM 11822 SQLSaturday 187 BI2 C114 3/9/2013 5:15:00 PM 3/9/2013 5:45:00 PM 11822 SQLSaturday 187 BI C112 3/9/2013 5:15:00 PM 3/9/2013 5:45:00 PM 11824 Michael Corey Professional Development / Misc C200 A database is a very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA how to virtualize a business critical application like SQL server 2012. It will be based upon experience learned using VMWare as the virtualization platform. But many of the lessons taught will carry over to any virtualized platform. 3/9/2013 3:00:00 PM 3/9/2013 4:00:00 PM 11905 A.J. Mee BI2 C114 Much like other recent installments of SQL Server, SQL 2012 provides a wealth of new capabilities in the arena of Business Intelligence. Come join A.J. Mee, a veteran Microsoft BI specialist, to review the key advances that SQL Server 2012 brings to enterprise BI scenarios, including: · Power View · BI Semantic Model (BISM) · Data Quality Services · Master Data Management · Columnstore Index 3/9/2013 1:45:00 PM 3/9/2013 2:30:00 PM 11929 Paul Rizza BI C112 As the newest version of SQL Server, 2012 is introducing many new BI features. This session will look at what has changed in SSIS 2012 and how to best leverage these new features to get the most for your ETL effort! 3/9/2013 11:15:00 AM 3/9/2013 12:15:00 PM 11937 Paul Oster Dev A201 The discussion will cover beginner and intermediate SQL Server based XML for data export. The discussion will start by covering basic XML generation via SQL Server and XML schema validation, moving on to intermediate XML export. It will then go into a more advanced topic of utilizing XSLT to create robust data import scripts via xlst and xquery/xpath. 3/9/2013 1:45:00 PM 3/9/2013 2:30:00 PM 11958 Melissa Coates BI C112 Compare and contrast how each Microsoft BI tool satisfies requirements for visualization, interactivity, data sources, formatting, printing, and exporting. We'll explore the strengths and limitations of each tool for creating dashboards scorecards with PerformancePoint, Reporting Services, Excel, and Power View. This session will help you with things to consider when selecting one tool in the Microsoft BI stack versus another. 3/9/2013 10:00:00 AM 3/9/2013 11:00:00 AM 12131 Kevin Kline Mixed Auditorium (1st Floor) Considering a promotion into management? This session will teach you the fundamental skills needed to effectively lead an IT team. Topics include motivational skills, communication skills and project/job tracking skills. Attendees will learn: 1. What are the fundamental ways that a new leader can build credibility and trust with their team? 2. What are the unique ways in which IT people are motivated? 3. How can a leader effectively communicate with their IT team using a variety of communication channels? 4. How steps can a leader take to ensure that their IT team is achieving optimum effectiveness? 3/9/2013 1:45:00 PM 3/9/2013 2:30:00 PM 12132 Kevin Kline Mixed Auditorium (1st Floor) SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy, nor does it mean is problem free. After all, many apps are growing from small, home-grown applications every year, with green IT professionals encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. There is a short list of mistakes that, if you know of them in advance, will make your life much easier. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before. 3/9/2013 8:45:00 AM 3/9/2013 9:45:00 AM 12145 Jason Hall Dev A201 I spend a large portion of each day looking through performance reports and dashboards from various organizations around the world. I've identified some very common performance problems and/or misunderstandings that tend to have easy, though not always obvious, solutions. I intend to share the whys and hows of these issues with anyone who would like to attend during a SQL Saturday session. 3/9/2013 8:45:00 AM 3/9/2013 9:45:00 AM 12146 Jason Hall Professional Development / Misc C200 In a world where separation of responsibilities becomes more and more important, the borders between DBAs and developers have grown wider than ever. For the developer seeking to employ the services of SQL Server, Interaction with one or more DBAs at certain stages of the development life cycle is nearly a given. This session discusses tips and techniques to follow that can ensure these interactions are civil, and maybe even pleasant. This topic includes tips on TSQL scripting, deployment techniques, bad habits to avoid and beginning execution plan analysis. 3/9/2013 4:15:00 PM 3/9/2013 5:15:00 PM 12187 Rob Volk Professional Development / Misc C200 In a world...where DBAs are blamed, mistreated, and overworked...one man...WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, cursors and missing WHERE clauses, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys! 3/9/2013 10:00:00 AM 3/9/2013 11:00:00 AM 12241 Jessica Moss BI C112 Too often reports sent on a daily basis end up in a mail filter. Only a small percentage of the reports are actually necessary for someone to take action. How happy would your users be if you could only provide the report when they actually needed to look at it? You can, by using subscriptions and alerts in Reporting Services 2012. This session will provide a comparison of regular subscriptions, data-driven subscriptions, and data-driven alerts in Reporting Services 2012 in SharePoint Integrated mode. Attend this session to learn how to provide reports that will be read rather than filtered. 3/9/2013 8:45:00 AM 3/9/2013 9:45:00 AM 12261 Joseph D'Antoni DBA E303 Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start. In this presentation you'll learn all about the new DR features in SQL Server 2012 and see them in practice. 3/9/2013 10:00:00 AM 3/9/2013 11:00:00 AM 12270 Stacia Misner BI C112 Head starting to explode from all the technical information you’re absorbing? Come spend a session with us while we play games with Reporting Services…literally! Come watch as Stacia Misner and a special guest introduce you to some word play, all wrapped up in SQL Server Reporting Services. She'll push the limits with what can be built in SSRS and show you how to have fun while doing it. Board games and SQL…who could ask for more? 3/9/2013 3:00:00 PM 3/9/2013 4:00:00 PM 12439 Andy Leonard BI2 C114 This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up. 3/9/2013 10:00:00 AM 3/9/2013 11:00:00 AM 12440 Andy Leonard Mixed Auditorium (1st Floor) Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session. 3/9/2013 4:15:00 PM 3/9/2013 5:15:00 PM 12472 Mike Hillwig DBA E303 Mike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky. 3/9/2013 3:00:00 PM 3/9/2013 4:00:00 PM 12488 Panel Discussion Mixed Auditorium (1st Floor) Join us for this Women in Technology (WIT) panel to discuss career tips, promotion opportunities, and moving your profession forward. Each member will share their background and then will answer questions in an interactive QA session. Both men and women are welcome to attend this informative event! 3/9/2013 12:30:00 PM 3/9/2013 1:30:00 PM 12532 SHANNON LOWDER Professional Development / Misc C200 During this talk I'll walk you through the process actually used to migrate a client's systems from hosted in a company closet to multiple Microsoft Azure data centers. Along the way we'll discuss the planning that went into the migration, the testing we went through, the pain points we hit, all the way to up and running in the cloud. This session covers the roadmap, we won't go through the actual migration itself...that took almost a year to complete. 3/9/2013 11:15:00 AM 3/9/2013 12:15:00 PM 12609 Kevin Boles Dev A201 We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over FORTY times now and it is always very highly rated! 3/9/2013 4:15:00 PM 3/9/2013 5:15:00 PM 12610 Kevin Boles Dev A201 For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure! 3/9/2013 10:00:00 AM 3/9/2013 11:00:00 AM 12630 Brandon Leach DBA E303 In this hour long session We'll delve into the Health Insurance Portability and Accountability Act (HIPAA) and what implications it has for us as data professionals. We'll discuss SQL Server best practices that can help protect ourselves, our company, and the people whom we serve. We'll also dive into several features in SQL Server that can help in this endeavor. 3/9/2013 1:45:00 PM 3/9/2013 2:30:00 PM 12659 Kevin Hazzard BI2 C114 Data Quality (DQ) tools are typically expensive and difficult to integrate into your ETL and governance plans but it doesn't have to be that way. During this fun, highly-interactive session, Kevin Hazzard (Microsoft Windows Azure MVP and author of the book Metaprogramming in .NET), will show you how to implement a modular, highly resilient DQ foundation from the tools you already own, no matter which version of SQL Server you're using today. At the end of this discussion, Kevin will give you a copy of his schema and his standard DQ function library that you can use in your own databases. 3/9/2013 8:45:00 AM 3/9/2013 9:45:00 AM 12662 Matt Velic Professional Development / Misc C200 If you don't have the chance to work on different kinds of projects, it can be tough to grow all the necessary skills to further your career. Take control of the situation by building a virtual lab at home. We'll begin the session by talking about why you might want to build a lab, and what you'll need to complete the task - nothing more than your home computer and free software. We'll review the basics of virtualization as it relates to VirtualBox. Finally, we'll dive into an example of building a Windows Server 2012 cluster, and talk about how you can use these networking and server skills to advance your SQL Server education. 3/9/2013 8:45:00 AM 3/9/2013 9:45:00 AM 12708 Tim Chapman Dev A201 Poor database performance is Achilles' heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this session we'll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible. 3/9/2013 11:15:00 AM 3/9/2013 12:15:00 PM 12709 Tim Chapman DBA E303 Have you ever wondered what an index actually looks like and performs under the covers? In this talk I'll discuss Index Internals, and how SQL Server creates, maintains, and uses indexes internally for normal operations. I’ll be discussing topics such as index data structures, query optimization (briefly) and maintaining indexes and statistics. 3/9/2013 8:45:00 AM 3/9/2013 9:45:00 AM 12768 Thomas LaRock Mixed Auditorium (1st Floor) Life is all about choices, and when it comes to SQL Server it is no different. If you don't have a methodology for researching questions and resolving issues then you need to get one, and soon. Join SQL Server MCM and MVP Thomas LaRock from Confio Software as he helps guide you while YOU make the choices in this interactive performance tuning adventure. 3/9/2013 3:00:00 PM 3/9/2013 4:00:00 PM 12777 Steve Jones Mixed Auditorium (1st Floor) 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. 3/9/2013 11:15:00 AM 3/9/2013 12:15:00 PM 12779 Steve Jones Dev A201 Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications. 3/9/2013 3:00:00 PM 3/9/2013 4:00:00 PM 12822 Karen Lopez Mixed Auditorium (1st Floor) A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions. 3/9/2013 10:00:00 AM 3/9/2013 11:00:00 AM 13031 Philip Noakes BI C112 Once you’ve loaded your data into a star schema and built an Analysis Services 2008 R2 cube around it, you are ready to harness the power of multi-dimensional analysis. Then, what are your next steps? You need to decide how to create and display reports. Should you go with Reporting Services, PowerView or another reporting tool? This session will explore and demonstrate the different reporting options for deriving business intelligence. (Co-presented with Jessica Moss) 3/9/2013 1:45:00 PM 3/9/2013 2:30:00 PM 13105 John Welch BI2 C114 Wondering how all that big data is going to be moved around? Or how you are going to move any of it into your SQL Server environment? Come to this session, and learn about some of the familiar and not so similar tools you can use for moving big data. We’ll compare the options, discuss how they can work with your existing Microsoft technologies, and provide some guidance on when to use each of the tools. 3/9/2013 4:15:00 PM 3/9/2013 5:15:00 PM 13106 John Welch BI2 C114 Unit testing is a widely accepted best practice, yet it is difficult to do well with SSIS packages. This session will focus on both the practice of test driven development as it applies to SSIS, and the tools for actually implementing it. It will cover in depth how to set up your development environment to support test driven development and what techniques can be used to make this practical for SSIS. You will also see how to automate the testing of SSIS packages, using the open source ssisUnit framework. The session will cover several of the common questions about automated unit testing, including how to handle test data , how to set up the environment for multiple developers, and how to make tests flexible. 3/9/2013 11:15:00 AM 3/9/2013 12:15:00 PM 13112 Grant Fritchey Professional Development / Misc C200 Just because you're using an Azure SQL database does not mean you can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using up lots of resources. This session will introduce you to the tools you have available to identify poor performing queries, such as dynamic management objects and others. You'll learn how to understand why a query is running slow using the Azure Portal execution plans. This understanding will enable you to fix your poorly performing queries. All in the cloud. 3/9/2013 1:45:00 PM 3/9/2013 2:30:00 PM 13113 Grant Fritchey DBA E303 You've fallen into a job that requires you to manage a SQL Server Database Management System. Now you have to keep these databases on their feet. You've heard of this concept called a backup, and it sounds great, but you sure don't know what it is. This session is for you. We're going to go over backups, right from the beginning, so that when you come out of this session you can go back to your systems and set up backups, log backups, differentials, and anything else you might need. Further, you'll know how to recover your database in the event of an actual failure. The fundamentals you need to get a good backup in place and then be able to restore it will be covered in this session. 3/9/2013 4:15:00 PM 3/9/2013 5:15:00 PM 13218 Melissa Coates BI2 C114 You don't want to settle for being an average Report Developer, right? In this highly interactive session we'll discuss various development, standardization, deployment, and documentation practices that will make your SSRS development life easier, your output of higher quality, increase maintainability, and ultimately save you time. Audience participation and sharing of experiences is encouraged as we cover choices you have for datasets, sorting, grouping, filtering, calculations, parameters, deployment, and delivery. This session focuses primarily on SQL Server Reporting Services 2012, although some concepts may apply to other BI tools as well.  Join us for this this session and take your reporting skills to the next level! 3/9/2013 3:00:00 PM 3/9/2013 4:00:00 PM 13278 Geoff Johnson DBA E303 Common Table Expressions (CTEs) serve two main functions: first they remove the clutter of subqueries out of the FROM clause while simultaneously making them easy to reference multiple times by alias if need be, and second they make it possible to do recursive queries. Learn the basics of using CTEs to streamline T-SQL code and to query self-referential tables. 3/9/2013 11:15:00 AM 3/9/2013 12:15:00 PM 13386 Rafael Salas BI C112 Dealing with bad data is a painful and expensive experience.  In this session we will jump into SQL Server 2012 for a hands-on demonstration of cleansing and correcting data with  SQL Server Data Quality Services (DQS) and Integrations Services (SSIS). We will dive into DQS knowledge-driven approach, reusability, cleansing and matching, and explore the collaboration opportunities between data stewards and IT professionals.  You will demonstrate how to create a knowledge base, define domains and rules to clean data, enrich data by using third-party data providers, and use the new SSIS DQS cleansing component. 3/9/2013 4:15:00 PM 3/9/2013 5:15:00 PM 14095 CapTech Consulting Dev A201 It can quickly become overwhelming to track all of your SQL Server Integration Services (SSIS) packages for loading data. Trying to figure out ‘what ran when’ and ‘who did what’ are tasks we've all had to face. CapTech Consulting has successfully solved these common data management problems by implementing a data management framework for multiple organizations. Come to this lunchtime session to learn how to implement your own SSIS framework and to never worry about your SSIS packages again! 3/9/2013 12:30:00 PM 3/9/2013 1:30:00 PM 14160 Nimble Storage Professional Development / Misc C200 This presentation will explore the evolution of storage architectures, reviewing the technology inflection points and core business drivers that have propelled the transitions from direct attached to monolithic to modular storage solutions. We are at the beginning of the next major technology inflection driving enterprise storage. Solid state drives (SSDs) promise to solve the performance challenges inherent in spinning disks, rendering traditional storage architectures obsolete. But SSDs by themselves are not the solution. The next decade will be dominated by storage architectures designed from the ground up to leverage the best characteristics of flash and disk. Will these new solutions be able to simultaneously deliver high performance and high capacity primary storage? And can they improve data protection, improving recovery point and recovery time objectives with far less cost and complexity? Learn the answer and examine real-world case studies in this informative session. 3/9/2013 12:30:00 PM 3/9/2013 1:30:00 PM