SQLSaturday #217 - Columbus 2013 6/8/2013 12:00:00 AM (GMT-06:00) Central Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat217 Ohio Dominican University 1216 Sunbury Rd Columbus OH 43219 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 3234 Nimble Storage Gold Sponsor http://www.nimblestorage.com http://www.nimblestorage.com/images/logo.png 60 170 3259 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 3311 Robert Half Technology Silver Sponsor http://www.roberthalftechnology.com http://www.roberthalftechnology.com/External_Sites/content/RHT-NA3/Shared/Images/logos/rht_logo.gif 60 170 3398 Dell Inc. Silver Sponsor https://www.quest.com http://i.imgur.com/BAdC3.png 60 170 3180 Red Gate Software Bronze Sponsor http://www.red-gate.com/ http://www.red-gate.com/assets/images/common/logo.png 60 170 3220 COZYROC Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 3279 IDera Bronze Sponsor http://www.idera.com http://www.idera.com/images/idera-logo-tag_webHP.png 60 170 3241 SAPIEN Technologies, Inc. Blog Sponsor http://www.SAPIEN.com http://www.sapien.com/assets/img/SAPIEN_h_logo.jpg 40 100 13280 SQLSatruday 217 Database Administration Room 1 6/8/2013 10:15:00 AM 6/8/2013 10:45:00 AM 13280 SQLSatruday 217 Database Administration Room 1 6/8/2013 2:15:00 PM 6/8/2013 2:30:00 PM 13280 SQLSatruday 217 Database Administration Room 1 6/8/2013 3:45:00 PM 6/8/2013 4:00:00 PM 13280 SQLSatruday 217 SQL Development Room 2 6/8/2013 10:15:00 AM 6/8/2013 10:45:00 AM 13280 SQLSatruday 217 SQL Development Room 2 6/8/2013 2:15:00 PM 6/8/2013 2:30:00 PM 13280 SQLSatruday 217 SQL Development Room 2 6/8/2013 3:45:00 PM 6/8/2013 4:00:00 PM 13280 SQLSatruday 217 Business Intelligence Room 3 6/8/2013 10:15:00 AM 6/8/2013 10:45:00 AM 13280 SQLSatruday 217 Business Intelligence Room 3 6/8/2013 3:45:00 PM 6/8/2013 4:00:00 PM 13280 SQLSatruday 217 Database Performance Room 4 6/8/2013 3:45:00 PM 6/8/2013 4:00:00 PM 13281 SQLSaturday 217 SQL Development Room 2 6/8/2013 12:00:00 PM 6/8/2013 1:00:00 PM 13281 SQLSaturday 217 Database Administration Room 1 6/8/2013 12:00:00 PM 6/8/2013 1:00:00 PM 13282 SQLSaturday 217 Database Administration Room 1 6/8/2013 8:30:00 AM 6/8/2013 9:00:00 AM 13282 SQLSaturday 217 SQL Development Room 2 6/8/2013 8:30:00 AM 6/8/2013 9:00:00 AM 13283 SQLSaturday 217 SQL Development Room 2 6/8/2013 5:15:00 PM 6/8/2013 5:45:00 PM 13283 SQLSaturday 217 Database Administration Room 1 6/8/2013 5:15:00 PM 6/8/2013 5:45:00 PM 13484 Kevin Feasel Database Administration Room 1 When you have one SQL Server instance to maintain, you can give that instance plenty of TLC. When you have a hundred instances, many things which worked before simply will not scale, potentially leaving your databases in peril. The next step (after justifiable panic) is to give yourself a force multiplier to help you keep your sanity on the job--specifically, an administrative database. This session will give you an idea of what kinds of tools should go into an administrative database, as well as how to use this to collect important metrics for reporting and auditing. Audience participation from more advanced database administrators is encouraged: we want to find out what's in YOUR DB wallet. 6/8/2013 9:00:00 AM 6/8/2013 10:15:00 AM 13640 Janis Griffin Database Performance Room 4 SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server. Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies. 6/8/2013 1:00:00 PM 6/8/2013 2:15:00 PM 13642 Janis Griffin Database Performance Room 4 SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query. 6/8/2013 9:00:00 AM 6/8/2013 10:15:00 AM 13782 Jeremiah Peschka Business Intelligence Room 3 You've upgraded to better hardware, tuned your queries, and busy seasons is still six months away; you should be resting easy. But reports are running too long, SQL Server is under a heavy load, and you're not sure how you'll keep up with the demands of customers, much less the rest of the business. I've been there before. By moving functionality into Hadoop, I've been able to scale the database bigger and faster than previously possible; small incremental improvements became massive linear improvements and I delivered functionality that was previously thought to be impractical. In this session, I'll cover patterns, strategies, and use cases to increase reporting and analytics performance using Hadoop. 6/8/2013 4:00:00 PM 6/8/2013 5:15:00 PM 13783 Jeremiah Peschka Business Intelligence Room 3 By now you've probably heard the words 'Big Data' and 'Hadoop', but you're not sure what they mean, much less how to get started. Maybe you're struggling with storing a lot of data, rapidly processing a huge volume of data, or maybe you're just curious. There are a bewildering array of options and use cases within the Hadoop ecosystem. Every day I help customers understand their data problems, understand where Hadoop fits into their environment, and determine how they can use Hadoop to solve their problem. This session provides an introduction to what Hadoop is, when it's appropriate to use Hadoop, and guidance on how to get started. 6/8/2013 9:00:00 AM 6/8/2013 10:15:00 AM 14082 Sam Nasr SQL Development Room 2 The 2012 release of SQL Server introduces 14 new functions for developers. This list includes functions for conversion, date/time calculation, enhanced logic, and string manipulation. In this session we’ll cover the ins and outs of these new functions, making you a better T-SQL developer. 6/8/2013 2:30:00 PM 6/8/2013 3:45:00 PM 14084 Sam Nasr SQL Development Room 2 Custom proximity search is a new feature introduced in SQL Server 2012 Full-Text Search. It's facilitated using the NEAR operator, allowing it to be used in the CONTAINS predicate or CONTAINSTABLE function. The NEAR operator allows for searching words near each other. It also allows the user to specify the maximum number of non-search terms separating the first and last search terms in a match. In addition, an optional parameter can be used to specify an exact order match. 6/8/2013 10:45:00 AM 6/8/2013 12:00:00 PM 14690 Brian Davis SQL Development Room 2 How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again. 6/8/2013 1:00:00 PM 6/8/2013 2:15:00 PM 14714 Russ Loski Business Intelligence Room 3 When creating an SSIS package, it is best practice to follow some kind of template. The package configuration needs to be set up. Logging needs to be set up. The work that you do to set up this template is tedious at best. In this session we will develop a template SSIS package using BIML. BIML is an XML markup language designed for representing the structure of an SSIS package. BIML Script takes that structure and generates an SSIS package. We will create a package that has some specific connection strings. We will tie those connection strings to configuration settings. Then we will add custom logging. We will then build individual SSIS packages to copy a list of tables to their destination. 6/8/2013 2:30:00 PM 6/8/2013 3:45:00 PM 14792 Allen White Database Administration Room 1 The more you have to manage, the more likely you'll want to automate your processes. PowerShell is the scripting language that will make you truly effective at managing lots of servers. This session will introduce you to PowerShell and show you how to use it to manage SQL Server across many instances. 6/8/2013 2:30:00 PM 6/8/2013 3:45:00 PM 14793 Allen White Database Performance Room 4 We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly. 6/8/2013 4:00:00 PM 6/8/2013 5:15:00 PM 14799 Erin Stellato Database Performance Room 4 If you’re like me, you’ve been using SQL Trace and Profiler since you started using SQL Server. They’re like old friends, tried and true. You know how they work, you know what you can capture, you know how to find the data you need. But now you’ve been told that your good friends have been deprecated in SQL Server 2012, and you need to become best friends with Extended Events. What is THAT all about? It’s ok. Really. In this session we’ll look at Profiler and Extended Events side by side to see how easy it is to transition to Extended Events. We’ll step through real world examples using Extended Events to do what you’re used to doing with Trace, and even more. You can find the time learn Extended Events…today. 6/8/2013 10:45:00 AM 6/8/2013 12:00:00 PM 14800 Erin Stellato Database Administration Room 1 A lot of statistics management happens automatically in SQL Server – think index rebuilds, maintenance plans and the Auto Update Statistics database option. But sometimes that’s not enough. Sometimes a DBA has to step in and manage selected statistics because the default settings and usual jobs just don’t provide enough information for the query optimizer to create a good query plan. In this session we’ll review configurations that often require extra care from you, the DBA. We’ll also dissect the UPDATE STATISTICS statement to see how it really works, and explore options you can implement to ensure that the query optimizer really does have the information it needs to create an optimal plan. If you’re ready to take your statistics knowledge to the next level then this session is for you! 6/8/2013 1:00:00 PM 6/8/2013 2:15:00 PM 14824 Colleen Morrow Database Administration Room 1 Let's face it, auditing isn't fun. But if you're a DBA, you need to know what's going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we'll cover what you can and can't audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale. Auditing doesn't have to be hard. And with the help of a little custom coding, it can even be fun. 6/8/2013 4:00:00 PM 6/8/2013 5:15:00 PM 14825 Colleen Morrow Database Administration Room 1 When and how was this view changed? Where did that index go? Who's accessing my sensitive data? In this demo-heavy session, we'll explore various methods of auditing events in SQL Server, how they work, and the inherent strengths and shortcomings of each in an epic quest to find the perfect SQL Server auditing solution. 6/8/2013 10:45:00 AM 6/8/2013 12:00:00 PM 14829 Kevin Boles Database Performance Room 4 Another in TheSQLGuru's very popular 'Deep Dive' series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice. 6/8/2013 2:30:00 PM 6/8/2013 3:45:00 PM 14831 Kevin Boles SQL Development Room 2 Yeah, it has an arcane syntax - but that is why we have templates and snippets! :-P Merge is a very powerful TSQL construct that can both simplify your code and help with some otherwise difficult maneuvers such as the classic 'Upsert'. 6/8/2013 4:00:00 PM 6/8/2013 5:15:00 PM 14833 Julie Smith SQL Development Room 2 This presentation is for absolute beginners to Integration Services, giving the bare essentials to start working in this environment with confidence. We’ll cover basic architecture, basic development, and basic administration in one hour! List of scary acronyms and terms on the list for “demystification”: SSIS, BIDS, ETL, Configurations, Package Deployment, Package Execution, SQL Server Agent. 6/8/2013 9:00:00 AM 6/8/2013 10:15:00 AM 15263 William Pearson Business Intelligence Room 3 As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence. 6/8/2013 10:45:00 AM 6/8/2013 12:00:00 PM 15264 Bill Pearson Business Intelligence Room 3 The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models, developed by business users, to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with Analysis Services 2012, may find it difficult to choose between the two paths. In this session, BI Architect and MVP Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing real world examples to illustrate approaches for given scenarios. 6/8/2013 1:00:00 PM 6/8/2013 2:15:00 PM