SQLSaturday #122 - Louisville 2012 7/21/2012 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. #sqlsat122 University of Louisville School of Business 2301 3rd Street Louisville KY 40202 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 1949 V-Soft Consulting Group, Inc. Gold Sponsor http://www.vsoftconsulting.com http://sharepoint.vsoftconsulting.com/ImagesUpload/VsoftSmall.PNG 60 170 2189 SIS, LLC Gold Sponsor http://www.thinksis.com https://fbcdn-profile-a.akamaihd.net/hprofile-ak-snc4/373728_129080590479523_1326752477_n.jpg 60 170 2348 Quest Software Gold Sponsor http://www.quest.com/ http://www.quest.com/images/common/quest_logo.gif 60 170 2425 Idera Gold Sponsor http://www.idera.com http://www.idera.com/campaign_images/logo_Idera_tag_170x60.png 60 170 1791 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 1883 New Horizons of Louisville Silver Sponsor http://www.nhcomputerlearning.com http://www.nhcomputerlearning.com/Content/Images/NHcmykLogo.gif 60 170 1809 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1752 StrateSQL Blog Sponsor http://www.jasonstrate.com http://www.jasonstrate.com/images/StrateSQLBanner.jpg 40 100 2027 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 2060 Steve Hughes - Data on Wheels Blog Sponsor http://www.dataonwheels.com http://dataonwheels.files.wordpress.com/2011/12/dataonwheelslogolglines.png 40 100 2363 Craig Purnell Blog Sponsor http://www.craigpurnell.com http://www.craigpurnell.com/wp-content/uploads/2012/03/CraigPurnellSQLSatLogo.jpg 40 100 2454 retracement Blog Sponsor http://tenbulls.co.uk http://retracement.files.wordpress.com/2012/07/retracement_sponsor_logo.png 40 100 6913 Rob Volk Design/Architecture Room 7 Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them. (But they deserved it!) Learn how to: create tables with no names; columns with duplicate names; and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you'll ache for the chance! 7/21/2012 12:45:00 PM 7/21/2012 2:00:00 PM 6916 Rob Volk Design/Architecture Room 7 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, hiding and obfuscating data and code, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys! 7/21/2012 2:15:00 PM 7/21/2012 3:30:00 PM 6939 William E. Pearson III BI Room 3 A Dynamic Dialog session: According to research compiled by Gartner from discussions with many BI clients, a substantial disparity exists, in the implementation of BI, between theory (standard approaches, promises, claims and expectations) and practice (shortfalls, compromises and other realities). In this session, Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog within which we will gain an understanding of the general types of discrepancies between the “ideal” approach to BI and the compromised reality that a large number of organizations experience. We’ll then share and class experiences as a group, and discuss ways to avoid these discrepancies in future projects. 7/21/2012 12:45:00 PM 7/21/2012 2:00:00 PM 7353 Louis Davidson Prof. Growth Room 6 The world of a DBA can be daunting for a person, either as a new or old, because not only do they need to keep up with new and emerging technologies, but also with the code and designs of their coworkers. In this highly participation driven session, we will employ a random topic chooser to pick several of these traits for discussion as a group. Possible topics include past blog topics such as Logic, Curiosity, Failure, Humility, Skill and Passion, as well as any other topics that might be added for that day. So come prepared to participate and voice your opinion about what counts for a DBA. 7/21/2012 3:45:00 PM 7/21/2012 5:00:00 PM 7354 Louis Davidson Design/Architecture Room 7 SQL Server 2012 adds a new object to our arsenal called a sequence that can will give us the capability to implement automatically incrementing values. However, it cannot replace a lot of functionality that we have used a numbers table and windowing functions for (though they can be complimentary to one another). In this session I will demonstrate the uses and performance characteristics of sequences, including how they compliment the use of number tables and windowing functions to create surrogate key and sorting values, and more. 7/21/2012 10:30:00 AM 7/21/2012 11:45:00 AM 7451 Mark Rosenberg Developer Room 2 In this talk 4 time MVP Mark Rosenberg will talk about SQL Server stored procedures and techniques you can use to optimize them. He will cover stored procedures from a developer’s point of view including table variables, common table expressions and temporary tables. Which do you use and when do you use it. There will also be a number of quick tips that anyone can use to improve query performance when they walk out of the session 7/21/2012 3:45:00 PM 7/21/2012 5:00:00 PM 7470 Janis Griffin DBA Room 1 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. 7/21/2012 2:15:00 PM 7/21/2012 3:30:00 PM 7710 Dave Fackler BI Room 3 SSIS is a very powerful platform for creating different types of data integration solutions. But unless you've been using SSIS every day, read through countless blogs each week, and attend every available SSIS session at every conference available, you've probably missed out on several SSIS tips and tricks that have surfaced over the years. So come and listen as I describe and demonstrate some of my favorite SSIS tips and tricks! 7/21/2012 2:15:00 PM 7/21/2012 3:30:00 PM 7779 Kevin Kline DBA Room 1 Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like: - What’s different about 32- and 64-bit systems? - What are the various areas of memory inside of SQL Server? - How are queries handled behind the scenes? - What does SQL Server do with procedural code, like functions, procedures, and triggers? - ...and much more. 7/21/2012 10:30:00 AM 7/21/2012 11:45:00 AM 7791 Jack Corbett Developer Room 2 Learn how to use SQL Server Profiler to troubleshoot, audit, and tune your SQL Server. Includes creating custom templates, integrating with Performance Monitor data, and creating scripts for creating server-side traces. 7/21/2012 10:30:00 AM 7/21/2012 11:45:00 AM 8017 Kathi Kellenberger Developer Room 2 You have heard all about AlwaysOn, BI Semantic Model, and Power View. Did you know that SQL Server 2012 has a host of new T-SQL features? Attend this session to learn more about the Sequence object, new functions and enhancements to the OVER clause. 7/21/2012 9:00:00 AM 7/21/2012 10:15:00 AM 8018 Kathi Kellenberger DBA Room 1 How many SQL Server 2012 features can Aunt Kathi show you in an hour? Attend this session to find out. Demos, demos, demos... 7/21/2012 3:45:00 PM 7/21/2012 5:00:00 PM 8977 Kyle Neier Developer Room 2 Just like your grandma tested spaghetti to tell if it was done, we'll be throwing several of the new T-SQL enhancements against the wall to see what's good and what falls off. We'll silence the lion's RaiseRror by throwing some meaty exceptions. We'll bring together the old lovers 'Coalesce' and '+' for one last jaunt before they are banished by the Concat function. We'll even open the window on some of the new aggregate and analytical functions as well as some other t-sql enhancements introduced in SQL 2012. 7/21/2012 12:45:00 PM 7/21/2012 2:00:00 PM 8980 Craig Purnell Prof. Growth Room 6 Want to invest in your long term career success? You need to network. C’mon give it a try! It’s not that bad! This presentation will explain some in-person networking tips and some do’s and don’ts for networking on LinkedIn. Takeaways include: -How to find events -Tips on getting to most out of attending events -How to develop and maintain your network of contacts -A Review of Linkedin networking best practices and profile optimization strategies. 7/21/2012 9:00:00 AM 7/21/2012 10:15:00 AM 9199 Eddie Wuerch Advanced DBA Room 4 Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning seamlessly solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you. 7/21/2012 10:30:00 AM 7/21/2012 11:45:00 AM 9297 Jason Thomas BI Room 3 SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts. This session will talk about the basic functionalities of all the charts as well as some tips and tricks around them. Come to this session and take your charting skills to the next level. 7/21/2012 3:45:00 PM 7/21/2012 5:00:00 PM 9464 Andy Thiru Azure/Big Data Room 5 In this session, you will get introduced to SQL Azure and learn how to get started. We will explore how to migrate an existing on-premise SQL Server database to SQL Azure. We will then walkthrough how to manage and administer your SQL Azure servers and databases. We will take a look at how to connect and build applications using SQL Azure. Next, we will look at more advanced scenarios using new capabilities like reporting with SQL Azure Reporting, synchronizing data with SQL Azure Data Sync for hybrid scenarios and global reach. Finally, we will explore some of the things you should consider when using SQL Azure 7/21/2012 9:00:00 AM 7/21/2012 10:15:00 AM 9572 Sanil Mhatre Developer Room 2 Parameter Sniffing is usually thought of as the bad guy, in association with a performance problem in your database. Contrary to the popular belief, Parameter Sniffing is usually the good guy, continuously working under the hood to help your database applications run faster. However, it can sometimes go wrong, causing severe performance degradation of your queries. In this session we will discuss the workings of Parameter Sniffing and demonstrate how it helps improve the performance of your database applications. We will also explore how Parameter Sniffing can go wrong and its impact. Several ways to fix bad Parameter Sniffing will be demonstrated to help make an appropriate choice for your scenario. 7/21/2012 2:15:00 PM 7/21/2012 3:30:00 PM 9589 Craig Utley BI Room 3 Is your organization planning to build a data warehouse or BI solution? Data warehousing projects, like many large IT projects, have high failure rates. While the exact rate of failure for data warehousing projects is difficult to pin down, the causes of these failures fall into a small number of categories. It is obviously possible to successfully complete a data warehousing project and deliver value to the business. Craig Utley has seen Microsoft BI solutions in various states of completeness at over 30 companies worldwide and has seen some awesome successes and some spectacular failures. This session addresses the reasons data warehousing projects fail and how you can succeed in overcoming these obstacles. 7/21/2012 10:30:00 AM 7/21/2012 11:45:00 AM 9614 Allen White DBA 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. 7/21/2012 9:00:00 AM 7/21/2012 10:15:00 AM 9620 Sarah Barela Azure/Big Data Room 5 The recent growth of cloud computing has companies evaluating when how, not if, they will move their data offsite. Despite the benefits that the cloud, many DBAs are leery of jumping into the cloud, fearful that their sensitive data will become vulnerable. The goal of this session is to provide you a blueprint to design build your own SQL Server cloud, where you can control the server availability performance reliability, yet still take advantage of the resource elasticity and hardware flexibility of the cloud. In this session, I will demonstrate how to use features like always on, resource governor, policy based management PowerShell scripts to automate your servers behavior to achieve the benefits of the cloud without the risks 7/21/2012 2:15:00 PM 7/21/2012 3:30:00 PM 9623 Sarah Barela Design/Architecture Room 7 Recent major security breaches have not only exposed customer data, but also the system vulnerabilities DBAs must overcome daily. As data protection is a DBA’s primary responsibility, establishing an impenetrable environment to host the data is the first step towards risk-free security. How can DBAs ensure SQL Servers are fortified against the latest threats and vulnerabilities? In this session, we will go through the process of hardening your SQL Server from attack from Windows Server to the database level step-by-step. I will share will share with you how establish security baselines and monitor for changes to your security foundation. This session will provide specific actions for you to take back and apply to your servers. 7/21/2012 3:45:00 PM 7/21/2012 5:00:00 PM 9642 Jim Deppen BI Room 3 This session will explore the fundamental importance of Change Data Capture to an organization building a Business Intelligence infrastructure. Many organizations will spend large amounts of time and money researching Business Intelligence software and databases without understanding how key business metrics are consistently captured. The techniques and methodologies used to capture business events are the key success factors for a winning Business Intelligence strategy. 7/21/2012 9:00:00 AM 7/21/2012 10:15:00 AM 9752 Colleen Morrow Prof. Growth Room 6 Ever thought about trying your hand at blogging? Or maybe you've started a blog but struggle with what to write about. We'll take a beginner's look at blogging and examine common roadblocks, finding topics, building readership, and setting you on the road to blogging stardom. 7/21/2012 10:30:00 AM 7/21/2012 11:45:00 AM 9796 Jack Corbett DBA Room 1 Extended Events were introduced with SQL Server 2008, but without a UI, which meant using T-SQL to create and manage them and using XPath and XQuery to parse the output. Microsoft has added an Extended Events UI in SQL Server 2012 and also added additional events. With the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learning Extended Events. This session will show you how to take existing Traces and convert them to Extended Event Sessions. 7/21/2012 12:45:00 PM 7/21/2012 2:00:00 PM 10085 Andy Thiru Azure/Big Data Room 5 In this session, you will get introduced to SQL Azure Data Sync and learn how to get started. We will explore how to migrate data from an existing on-premise SQL Server database to SQL Azure and bi-directional data synchronization and data management capabilities allowing data to be easily shared across SQL Azure databases across multiple data centers. What you will learn: • Overview of SQL Azure • How to Get Started with SQL Azure Data Sync • Cloud to cloud synchronization • Enterprise (on-premises) to cloud • Cloud to on-premises. • Bi-directional or sync-to-hub or sync-from-hub synchronization 7/21/2012 3:45:00 PM 7/21/2012 5:00:00 PM 10120 Kevin Kline Prof. Growth Room 6 This session explores how to influence your manager and higher executives in the organization. In addition, this session explores how to convey information upwards without filtering out important information or self-censoring. This session delves into a variety of important behaviors, including: • Building credibility and influence with your boss • What is the most effective process to win explicit support for a new project? • How to get executives to spend money for something you think is important 7/21/2012 2:15:00 PM 7/21/2012 3:30:00 PM 10184 Wayne Sheffield Advanced DBA Room 4 SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to learn about all of the windowing functions in SQL Server 2012: Ranking functions, changes for windowing in the Aggregate functions, and the new Analytic and Sequence functions. We’ll examine how this latest implementation of the windowing functions allows us to perform running and sliding aggregations; retrieve data from adjacent rows in the partition, and much more – all without self-joins back to the source table. 7/21/2012 12:45:00 PM 7/21/2012 2:00:00 PM 10192 Tim Chapman Advanced DBA Room 4 The transaction log is the most important aspect of a SQL Server database. Separating the data and log files is usually good advice, but there is so much more about the transaction log that is misunderstood. Join Microsoft Premier Field Engineer Tim Chapman as he discusses data modification internals, write-ahead logging and the inner workings of the SQL Server transaction log. 7/21/2012 9:00:00 AM 7/21/2012 10:15:00 AM 10200 Kevin Boles Advanced DBA Room 4 Using User Defined Functions in your database code is like playing Russian Roulette with 5.97 bullets in the gun!! There are SOOOOO many ways they can kill you: staggering performance degredation, tempdb allocation issues and bad data!! Oh, did I mention performance issues?? Those include row-by-row processing under the covers, bad estimates leading to horrible query plans, voiding parallelization in the engine, etc. In this jam-packed session we will cover all this and also discuss several ways you can get rid of them. 7/21/2012 3:45:00 PM 7/21/2012 5:00:00 PM 10204 Kevin Boles Advanced DBA Room 4 What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it's use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine. 7/21/2012 2:15:00 PM 7/21/2012 3:30:00 PM 10250 Arie Jones Azure/Big Data Room 5 Putting big data in the cloud is not without its difficulties and the Microsoft Azure teams have been consistently upping the resource limits that you are able to utilize within a given instance. Those of us with larger capacity instances still have to hedge our bets when looking at moving to the cloud. That is until the recent release of SQL Azure Federations, which offers a native SQL Azure based option to possible unlimited scalability. In this session, we will break down the basics of sharding within SQL Azure Federations, explain what needs to be taken into consideration in terms of database design, and put you on the right path to a successful Federation based deployment. 7/21/2012 12:45:00 PM 7/21/2012 2:00:00 PM 10251 Arie Jones Design/Architecture Room 7 With an ever increasing workload, security is often hoisted upon the DBA. So where do you start? Sometimes it's better to start off by understanding what an attacker could do to you in order to get a clearer picture of what you need to do to prevent it. In this session, we will delve into the key features of the SQL Server and explain what the various attack vectors are, what an attack can do with them, and what you can do about them. We'll also look at important features such as SQL Audit that, while not helping to prevent, can definitely help you in definitely help in figuring out what is going on. It'll be AWESOME! 7/21/2012 9:00:00 AM 7/21/2012 10:15:00 AM 10352 Sarah Barela Prof. Growth Room 6 Whether you are searching for a new job or simply needing to relocate your desk, you need the right tools to make your request effective. Come hear how our Women in Technology (WIT) panel of experts have tackled these issues, and learn how you can give yourself the best opportunity to negotiate for what you want. Our panelists include Sarah Barela, Kevin Kline, Kathie Kellenberger and Deana Ritter. And this is not just for women!! 7/21/2012 12:45:00 PM 7/21/2012 2:00:00 PM 10529 Rameshdurai Palnisami Azure/Big Data Room 5 Having trouble in managing large scan data process for SQL Server? Efficient way to MODEL, PROCESS ANALYSE large scale data for SQL Server platform. Identifying common and client specific process steps to process client data. Parsing Efficient way to process data comes in multiple formats (Excel, Flat Files, Access etc. ) for SQL Server. Automate and schedule large scale data in parallel. Centralized management of client data model across multiple domains. 7/21/2012 10:30:00 AM 7/21/2012 11:45:00 AM