SQLSaturday #126 - Indianapolis 2012 7/28/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. #sqlsat126 The University of Indianapolis 1400 E. Hanna Ave Indianapolis IN 46227 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 1762 Perpetual Technologies, Inc. Silver Sponsor http://PTI.net http://www.pti.net/logo/logo170x60.jpg 60 170 1790 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2361 Melissa Data Silver Sponsor http://www.Melissadata.com http://www.melissadata.com/home/new-2009/melissa-data-logo.GIF 60 170 2458 Delivra Silver Sponsor http://www.delivra.com/ http://editor.ne16.com/Delivra/delivra-logo_170x60.jpg 60 170 2467 Lantech Training Silver Sponsor http://www.LantechTraining.com http://www.lantechtraining.com/WebDesignImages/ltech_logo_180.jpg 60 170 2520 TEKsystems Silver Sponsor http://www.teksystems.com http://www.teksystems.com/Images/Layout/HomeFlash/teksystems.gif 60 170 1810 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 2482 Apparatus Bronze Sponsor http://www.apparatus.net http://www.apparatus.net/images/logos/apparatus-sql.png 60 170 2463 Pluralsight Friends of SQL Saturday http://www.pluralsight-training.net/microsoft/ http://s.pluralsight.com/mn/img/sh/logo-v2.png 40 100 2502 SAPIEN Technologies, Inc. Friends of SQL Saturday http://www.sapien.com/software/primalscript http://pti.net/images/sapien300.jpg 40 100 2522 Red Gate Software Friends of SQL Saturday http://www.red-gate.com/ http://www.red-gate.com/assets/images/common/logo.png 40 100 2525 SQL Sentry Friends of SQL Saturday http://www.sqlsentry.net/ http://www.sqlsentry.net/UI/customMenu/headLogo.png 40 100 1828 StrateSQL Blog Sponsor http://www.jasonstrate.com http://www.jasonstrate.com/images/StrateSQLBanner.jpg 40 100 2028 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 2062 Steve Hughes - Data on Wheels Blog Sponsor http://www.dataonwheels.com http://dataonwheels.files.wordpress.com/2011/12/dataonwheelslogolglines.png 40 100 2365 Craig Purnell Blog Sponsor http://www.craigpurnell.com http://www.craigpurnell.com/wp-content/uploads/2012/03/CraigPurnellSQLSatLogo.jpg 40 100 2453 retracement Blog Sponsor http://tenbulls.co.uk http://retracement.files.wordpress.com/2012/07/retracement_sponsor_logo.png 40 100 2504 Aaron King Blog Sponsor http://www.aaronstanleyking.com http://4.bp.blogspot.com/-93_zp7_4Cd0/TdJ1A5UaQWI/AAAAAAAAAGY/YewNZMA39-U/s1600/AaronStanleyKingBanner60.png 40 100 7042 Aaron King Track 5 Trustees C In this presentation Aaron will cover how to collect data from multiple SQL Servers using SQL Server 2008 Integration Services (SSIS). Then he will use SQL Server Reporting Services (SSRS) to report detail on that data. After that he will use SQL Server Analysis Services (SSAS) to create a KPI. Finally he’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided. 7/28/2012 9:45:00 AM 7/28/2012 10:45:00 AM 7050 Warren Sifre Track 2 UIndy Hall B 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). 7/28/2012 2:15:00 PM 7/28/2012 3:15:00 PM 7092 William E Pearson III Track 3 UIndy Hall C A Dynamic Dialog session: Whether you’re considering implementing business intelligence for the first time, have completed projects in the past (and are perhaps looking at later phases), or are somewhere in between, an investment in this session will likely pay dividends. Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog about common pitfalls or traps that we can encounter in designing and implementing BI. We’ll discuss, as a group, environmental and other challenges we have experienced, and share ways to avoid or minimize them, in our ongoing efforts with BI. 7/28/2012 1:00:00 PM 7/28/2012 2:00:00 PM 7139 Aaron Lowe Track 5 Trustees C As protectors of arguably, the most important asset companies’ have we are tasked with ensuring quality, security and performance. However the ways in which we utilize and obtain those assets are often not formalized and therefore suffer from degraded quality. Let's discuss some strategies that can be implemented to not only raise the bar of quality, but also make you sleep easier at night. 7/28/2012 2:15:00 PM 7/28/2012 3:15:00 PM 7455 Ted Krueger Track 1 UIndy Hall A er wanted to create clones of yourself to get all your work done faster? I will demonstrate how SSIS can help you perform your DBA tasks as if there were more than one of you. You will leave the session knowing how to use SSIS to automate tasks such as performance monitoring above (and below) the normal health checks and transporting databases from one environment to another. You will also learn how SSIS can be used in assisted HA and DR failover strategies as well as backup solutions that go beyond the simple BACKUP statement. We’re going to take SSIS and make it a standard tool for your administrative tasks! 7/28/2012 11:00:00 AM 7/28/2012 12:00:00 PM 7713 Dave Fackler Track 5 Trustees C Many casual users of SSIS (including database professionals using the SSMS Import/Export Wizard) don't necessarily understand the inner workings of SSIS and what factors impact performance. During this session, we'll look at different aspects of SSIS and discuss their impact on package performance. We'll take a deep dive into the Data Flow component, looking at how SSIS manages data as it moves from sources, through transformations, and then to destinations. Finally, we'll talk about several of the top performance killers casual SSIS users experience and discuss strategies for overcoming these common issues. 7/28/2012 1:00:00 PM 7/28/2012 2:00:00 PM 8037 Norman Kelm Track 3 UIndy Hall C Everyday more DBAs and SQL developers are given responsibility for ETL development. They have a strong SQL background with little or no .Net language programming experience. As they progress with SSIS, they can come up against perceived limitations in the capabilities of SSIS using only the built-in tasks. What they may not realize is the extensibility available to SSIS via the Script Task. This presentation will provide them with the tools they need to move beyond that perceived limitation. Updated for SSIS 2012. 7/28/2012 9:45:00 AM 7/28/2012 10:45:00 AM 8436 Craig Purnell Track 3 UIndy Hall C 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/28/2012 11:00:00 AM 7/28/2012 12:00:00 PM 8729 Allen White Track 1 UIndy Hall A Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform. 7/28/2012 8:30:00 AM 7/28/2012 9:30:00 AM 8757 Hope Foley Track 4 Trustees A/B Ted Krueger will join Hope in presenting this session. Consulting is a mystical career path that is often questioned: should I do it, can I do it and why should I do it? Come join us on a discussion of the Pros and Cons to consulting with an emphasis on SQL Server and Microsoft Technologies. We'll field questions with real world experiences. Once you leave this open floor session, you'll be able to make better choices in your own professional development and how consulting may or may not effect it. 7/28/2012 3:30:00 PM 7/28/2012 4:30:00 PM 8759 Wendy Pastrick Track 1 UIndy Hall A Issue a 'SELECT {data} FROM {myTable}' statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time. 7/28/2012 9:45:00 AM 7/28/2012 10:45:00 AM 8760 Wendy Pastrick Track 3 UIndy Hall C Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring. We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly. 7/28/2012 2:15:00 PM 7/28/2012 3:15:00 PM 8961 Scott Klein Track 3 UIndy Hall C With more and more companies moving to a cloud solution, the necessity to easily and efficiently scale their database solution is critical. This session will discuss how to scale SQL Azure using SQL Azure Federations, a recent addition to SQL Azure that provides the ability to build scalable, elastic, and multi-tenant solutions in SQL Azure. SQL Azzure Federations bring the sharding pattern into SQL Azure as a first class citizen as a way to achieve greater scalability and performance from the database tier of your application through horizontal partitioning at the database level. This session will look at Federations from a real-world point of view, by applying Federations to a real-life database. We will also look at performance benefits. 7/28/2012 3:30:00 PM 7/28/2012 4:30:00 PM 9137 Luke Jian Track 3 UIndy Hall C Optimal configuration and maintenance of the I/O subsystem is critical and can ultimately be responsible for higher response times of your applications. The HDDs are by design about 1 million times slower than the memory or CPU. In this session we analyze the different options that exist for durable storage, what are their pros and cons . Solid state drives are a viable option and we are going under the covers to see how you can best use them as an alternative to a large and expensive SAN in your infrastructure 7/28/2012 8:30:00 AM 7/28/2012 9:30:00 AM 9141 Josh Fennessy Track 2 UIndy Hall B In this session, attendees will be treated to an introduction to tabular mode. Installation, configuraiton, development tips, maintance, and end user reporting options will all be introduced. A description of BISM and what it means for our beloved Multi-Dimension cubes will be discussed. Attendees wanting to know when to use tabular, and when to stick with multi-dimensional will want to attend this introductory session. 7/28/2012 1:00:00 PM 7/28/2012 2:00:00 PM 9207 Adam Belebczuk Track 4 Trustees A/B One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups and the ability to have readable secondary replicas. In this session, we will cover the pros and cons of using AlwaysOn as well as the basics of how to set it up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications databases, are currently using Database Mirroring, or if you're just curious about AlwaysOn, then you won't want to miss this session. 7/28/2012 9:45:00 AM 7/28/2012 10:45:00 AM 9346 Ira Whiteside Track 5 Trustees C Fuzzy Matching, Similarity Matching or Record Linkage is the most critical and least understood process in any Data Warehouse, BI, Integration, Big Data , Data Quality, MDM , Social Network or integrating crap effort. Over at LinkedIn there is Group run by Henrik Liliendahl Sorensen for Data Matching, Bill Winkler, principal researcher at the US Census' has written a series of white papers on record linkage and particular a technique called 'Blocking Indexs'. In addition we wil cover William Cohen Research Professor, Machine Learning Department, Carnegie Mellon University white papers an implementations. Presented will be our collection of 'real world' examples(Code) and you will leave a master of record linkage and the concepts behind it 7/28/2012 11:00:00 AM 7/28/2012 12:00:00 PM 9514 Rob Volk Track 2 UIndy Hall B Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page! 7/28/2012 9:45:00 AM 7/28/2012 10:45:00 AM 9528 Brent Dragoo Track 4 Trustees A/B Sometimes, bad things happen in a server, and someone has to investigate. What kinds of tools are out there for Database Adminstrators, and what are some common methods that we can use to explore what has happened the 'aftermath' of something going wrong? This session will explore some methods, tools, and examples that I've used as the database administrator to uncover and analyze 'what went wrong'. 7/28/2012 1:00:00 PM 7/28/2012 2:00:00 PM 9574 Sanil Mhatre Track 5 Trustees C 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/28/2012 8:30:00 AM 7/28/2012 9:30:00 AM 9626 Julie Smith Track 4 Trustees A/B Every organization that stores data stores dirty data, and suffers with how best to handle this unpleasant fact.Organizations must rely on people to deal with data problemseither by paying them to clean it or paying them to work around it. Either way it is costly and only becomes more so over time. Finally with the release of SQL Server 2012, there is a tool to help. Learn how to use the key parts of Data Quality Services: how to create a Knowledge Base, how to create Data Cleansing Projects to cleanse data both in the DQS client and inside SSIS 2012, and how DQS Matching Projects can integrate with Master Data Services for de-duplication of data. Session focuses on DQS, but also explains how DQS, MDS, and SSIS work together. 7/28/2012 8:30:00 AM 7/28/2012 9:30:00 AM 9643 Joe McTaggart Track 1 UIndy Hall A SharePoint is a rapidly growing application that relies heavily on SQL Server. In this session, we will discuss what a DBA needs to know to successfully manage instances hosting SharePoint databases. What configurations options are best for a SharePoint workload? What kind of maintenance shoule be performed? How should databases be provisioned? What the heck are all these databases for anyway? We will also discuss some nomenclature and key components of SharePoint to help better communicate with SharePoint application teams. 7/28/2012 3:30:00 PM 7/28/2012 4:30:00 PM 9644 Joe McTaggart Track 2 UIndy Hall B Perfomance is a concern for every dba. How do you baseline performance? What do you do when users complain about performance? What tools can you use to gather data and how do you analyze that data? We will start a basic performance troubleshooting methodology and move into more specifics of what data to collect and how to use that data to isolate a performance problem. 7/28/2012 11:00:00 AM 7/28/2012 12:00:00 PM 9730 Ludwig Armbruster Track 5 Trustees C SSRS 2012 provides a brand new feature called data alerts. It allows users to monitor changes in report data and send data alert messages by email when report data follow rules that define data of interest to you. This session introduces this great new feature and will show real world scenarios for its application. 7/28/2012 3:30:00 PM 7/28/2012 4:30:00 PM 9750 Mike Hillwig Track 2 UIndy Hall B See those things around your ankles? You hope they're your socks because no DBA wants to be caught with their pants down. Whether you're an accidental DBA, a DBA who has just inherited a bunch of servers, or someone who works in a shop that won't buy monitoring tools, this session will help you get basic monitoring in place to make sure you know what's going on in your environment. You'll learn how to implement seven simple scripts that perk their ears up and start barking like a dog after a stranger walks in the house. They are the canary in your coal mine. You'll know when backups fail, when they run longer than usual, when data files are getting full, when transaction logs have excessive VLFs, and more. 7/28/2012 8:30:00 AM 7/28/2012 9:30:00 AM 9859 Kevin Boles Track 2 UIndy Hall B 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/28/2012 3:30:00 PM 7/28/2012 4:30:00 PM 9899 Shaun Watts Track 4 Trustees A/B Many DBA's and sysadmins are starting to use PowerShell to automate routine/daily tasks. A task that can be time consuming to setup on each server is performance monitoring with Perfmon. A great way to automate that task is to use PowerShell. So, let's take a venture into PowerShell land and see how to write our very first script. Along the way we will capture performance counters and then export them to a blg formatted file for viewing. 7/28/2012 11:00:00 AM 7/28/2012 12:00:00 PM 9929 Kyle Neier Track 4 Trustees A/B Powershell has become a very popular scripting language for Windows, Exchange, Sharepoint and other admins. In this session, we'll get our heads down and our inner geek on as we explore how Powershell can add value to our lives a DBAs. We'll explore how Powershell can handle common tasks as well as several tasks that are difficult or even impossible with TSQL. We'll wrap up by discussing how Powershell could be used to fully automate your install and post-install processes, standardizing your environment. Get your typing skills honed as you will leave here desiring to never click again. 7/28/2012 2:15:00 PM 7/28/2012 3:15:00 PM 9940 Eddie Wuerch Track 1 UIndy Hall A 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. 7/28/2012 2:15:00 PM 7/28/2012 3:15:00 PM 9948 Arie Jones Track 1 UIndy Hall A 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/28/2012 1:00:00 PM 7/28/2012 2:00:00 PM