SQLSaturday #119 - Chicago 2012 5/19/2012 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. #sqlsat119 DeVry University - Addison Campus 1221 North Swift Road Addison IL 60101-6106 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 1947 Quest Software You Rock! http://www.quest.com/ http://www.quest.com/images/common/quest_logo.gif 60 170 2235 TEKsystems You Rock! http://www.teksystems.com https://www.olin.edu/innovationlab2/TEK_full%20color_high.jpg 60 170 2240 DeVry University You Rock! http://www.devry.edu/ http://www.dal.devry.edu/Images/hdr_ul_2logos.gif 60 170 2250 Magenic You Rock! http://magenic.com http://www.sqlsaturday.com/files/551720aa-2ff2-4bc3-b4d2-b6dfe05e7674.png 60 170 2119 Idera Gold Sponsor http://www.idera.com http://www.idera.com/images/Logo-Idera.png 60 170 2243 Red Gate Software Ltd Gold Sponsor http://www.red-gate.com/ http://www.red-gate.com/assets/images/common/logo.png 60 170 2289 SoftChoice Upgrade Gold Sponsor http://www.softchoice.com http://www.sqlsaturday.com/files/f96e9692-89e0-40bc-a06c-18c9a7f8d7af.png 60 170 1806 CozyRoc Silver Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1872 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2044 SQLHA Silver Sponsor http://www.sqlha.com http://www.sqlha.com/wp-content/themes/sqlha/images/logo.png 60 170 2209 Perpetual Technologies, Inc. Silver Sponsor http://pti.net http://www.pti.net/logo/logo170x60.jpg 60 170 2257 SQL Sentry, Inc. Bronze Sponsor http://www.sqlsentry.com http://www.sqlsentry.com//UI/customMenu/headLogo.png 60 170 1696 StrateSQL Blog Sponsor http://www.jasonstrate.com http://www.jasonstrate.com/images/StrateSQLBanner.jpg 40 100 1737 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 1841 MarkTab Consulting Blog Sponsor http://www.marktab.net http://www.marktab.net/images/MarkTabNet_100x40.gif 40 100 2057 Steve Hughes - Data on Wheels Blog Sponsor http://www.dataonwheels.com http://dataonwheels.files.wordpress.com/2011/12/dataonwheelslogolglines.png 40 100 2110 Noel McKinney Blog Sponsor http://noelmckinney.com/ http://noelmckinney.com/wp-content/uploads/2010/09/Noel-seated-compressed-NOTNULL-e1284844743579.jpg 40 100 2141 joshuafennessy.com Blog Sponsor http://joshuafennessy.com http://joshuafennessy.files.wordpress.com/2012/03/joshuafennessybanner.png 40 100 2185 SQLFriends Blog Sponsor http://sqlfriends.org http://sqlfriends.org/wp-content/uploads/2012/04/SQLFriends.png 40 100 6482 Bob Pusateri Track 1 214 SQL Server's data compression feature can be a great tool for both getting more bang out of your storage dollar and increasing query performance. In this session we'll cover the different types of data compression, the nitty-gritty behind how they work, and how to make sure you're getting the most out of them. 5/19/2012 9:15:00 AM 5/19/2012 10:30:00 AM 6483 Ted Krueger Track 6 118 As a seasoned DBA, we often forget the basics of query tuning may be an area others haven’t been introduced to. Tuning can be a mystery for developers and DBAs that are starting out with SQL Server. Each operation and its cost can lead to lengthy research escapades, determining if the work is even worth the time to attempt a change in the overall execution plan. This session is going to discuss the basics of tuning; however, we can't end there. The second half of the session, the discussion portion, will focus on the key operations in the execution plan. The overall goal of the session is to take away knowledge on how to start with a query and use execution plans to refine it and turn it into a finely tuned process. 5/19/2012 10:45:00 AM 5/19/2012 12:00:00 PM 6492 Jason Strate Track 4 217 There's a lot that goes on under the covers of SQL Server with your indexes. But it's not as secretive as you might think. Most of this information is made available to you through DMVs. While this information is useful - you need a clear understanding of what is in the DMVs in order to understand what is going on. In this session we'll take a dive into sys.dm_index_operational_stats to find out what it does and what you can do with this information. 5/19/2012 1:00:00 PM 5/19/2012 2:15:00 PM 6495 Jes Borland Track 7 215 You have mastered the art of linking a dataset to a table in SQL Server Reporting Services. You have solid, reliable reports that you and others depend on. Learn how to take them from basic to 'wow', using features such as tablix, lists, images, and charts. At the end of this session, you will be familiar with: - Report properties such as headers, footers and backgrounds - Tablix properties such as ToolTip and NoRows - How to build and customize a matrix - How to effectively use lists, an often-overlooked feature - Adding charts to make reports visually appealing and easy to understand 5/19/2012 1:00:00 PM 5/19/2012 2:15:00 PM 6504 Tim Ford Track 3 216 Taking the periodic table of elements into consideration I've created The Periodic Table of Dynamic Management Objects as a reference tool for these functions and views that have become so critical for today's SQL Server DBA to performance tune and gain metadata insights into their various SQL instances. In navigating the table we will examine key DMVs and DMFs of interest: requests, sessions, wait stats, indexes, system information will all be covered. We will also delve into how these DMOs - just like their elemental counterparts - can be combined to yield interesting insights into your servers. We will also look at how things can go awry as well! Like mixing vinegar and baking soda, sometimes combining DMOs can cause a big mess too! 5/19/2012 1:00:00 PM 5/19/2012 2:15:00 PM 6508 Michael Sexton Track 5 117 Too often ETL systems do not incorporate error handling. When things break at 2 AM – and they ALWAYS break at 2 AM – some poor on call person must get out of bed and deal with something that should have been caught and handled by the code itself. This session will cover ways for you to help your poor on-call colleagues get a full night’s sleep, thereby gaining you their eternal gratitude. 5/19/2012 4:00:00 PM 5/19/2012 5:15:00 PM 6516 Argenis Fernandez Track 4 217 In this demo-packed session we will explore the use of SysInternals tools like Process Monitor, Process Explorer, and many others to troubleshoot various problem scenarios with SQL Server. This session is not for the faint of heart and is tailored toward those adventurous DBAs who often like to step out of their comfort zone. A fair knowledge of Windows OS internals is recommended. 5/19/2012 2:30:00 PM 5/19/2012 3:45:00 PM 6585 Colleen Morrow Track 8 218 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. 5/19/2012 2:30:00 PM 5/19/2012 3:45:00 PM 6593 Scott Shaw Track 6 118 Presentation on licensing, huh. Boring? Maybe. Important? Absolutely! Being a DBA isn't just all fun and games. There are also some serious things to take care of. Licensing SQL Server is one of those and doing it right can mean the difference between a few thousand dollars or a few hundred thousand dollars. This session will discuss how to license SQL Server specifically for the transition from a physical to a virtual environment. You'll find that maybe, more than anything else, it will be the way SQL Server is licensed that determines how you configure your entire virtual infrastructure. 5/19/2012 1:00:00 PM 5/19/2012 2:15:00 PM 6663 Mark Tabladillo Track 1 214 This presentation describes SQL Server Data Mining (SSDM) for SQL Server Professionals. Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business Intelligence Development Studio (BIDS), highlighting Integration Services, and PowerShell. The interactive demos are based on Microsoft's Contoso Retail sample data. Finally we will evaluate where Microsoft data mining can help you in a practical business environment, which may include Oracle and SAS. 5/19/2012 10:45:00 AM 5/19/2012 12:00:00 PM 6664 Brent Ozar Track 2 116 You’re minding your own business in your corner office – well, no, you’re a DBA, so it’s just your cubicle – when somebody says, “Did you know about this SQL Server over here?” Suddenly, you have to find out what the server’s doing, how it was set up, and whether things are working correctly. In this real-time session, Brent will show you how he tackles unknown servers in 60 minutes to find problems, take an inventory, and set the server up for easier management down the road. 5/19/2012 10:45:00 AM 5/19/2012 12:00:00 PM 6735 David Eichner Track 7 215 Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. 5/19/2012 10:45:00 AM 5/19/2012 12:00:00 PM 6770 Shelly Noll Track 8 218 A current trend among application developers to is move data storage away from a traditional relational database model. This presentation will provide an introduction into the technology known as NoSQL. We will discuss who’s who in the NoSQL world and explain the different ways that NoSQL databases store data. We will also cover which types of applications are best suited for the NoSQL approach and when a relational database would be a more appropriate choice. 5/19/2012 10:45:00 AM 5/19/2012 12:00:00 PM 6772 Janis Griffin Track 6 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. 5/19/2012 2:30:00 PM 5/19/2012 3:45:00 PM 6777 Allan Hirt Track 1 214 Over the years, one of the most common questions I am asked is, 'How can I configure a cluster on my machine?' Ask no more! Production should never be the only place you have clusters. Having the ability to create a cluster that you can use as a sandbox for testing or as an instruction tool for presentations and demonstrations is something every DBA should have in their arsenal. This session will demystify the 'magic' behind configuring a cluster on your laptop or desktop using either Vmware Workstation or Microsoft's Hyper-V in Windows Server 2008 R2, and show how to configure things like the virtual machines, the domain controller, and the iSCSI storage solution. 5/19/2012 1:00:00 PM 5/19/2012 2:15:00 PM 6954 Tom Norman Track 2 116 I have this database which must meet all of these governmental regulations. Just like the government to make life a lot harder but wait, now they say I most also meet International regulations. Can this be true? Why me? Let's look at what we can do to help us pass audits and comply with the laws around us. I need to install TDE, what do I do? Move the database to other server, can I do that? I used certificates, can I change them. I don’t like governments making me do all this stuff, it complicates my database. What does TDE do to my backups? Can I remove it? Auditing, no, let’s run for the hills. Let’s see how Sql Server can help us with these issues. 5/19/2012 4:00:00 PM 5/19/2012 5:15:00 PM 6958 Aaron King Track 8 218 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. 5/19/2012 9:15:00 AM 5/19/2012 10:30:00 AM 6995 Ben DeBow Track 2 116 Do you know what SaaS and DaaS are? If not, you should. SQL Server as a service (SaaS) and database as a service (DaaS) are otherwise known as the private cloud – the ability to offer your customers (external or internal) a reliable, scalable, and manageable way to easily deploy SQL Server systems and databases. At the end of the day they essentially want to push a button and get what they asked for. This is what the private cloud experience should enable for them. While you may do some of this now, come learn how to take it to the next level and design a service offering that will enable your organization to be agile, yet not leave you tearing out your hair worrying about it. 5/19/2012 2:30:00 PM 5/19/2012 3:45:00 PM 7053 Warren Sifre Track 2 116 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. 5/19/2012 9:15:00 AM 5/19/2012 10:30:00 AM 7140 Aaron Lowe Track 6 118 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. 5/19/2012 4:00:00 PM 5/19/2012 5:15:00 PM 7299 Dave Levy Track 7 215 Poor database performance is the 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. 5/19/2012 9:15:00 AM 5/19/2012 10:30:00 AM 7493 Hope Foley Track 5 117 Importing data is as common to SQL Server as bacon is to a savory breakfast sandwich. As most of us love to eat those breakfast sandwiches, SQL Server Integration Services (SSIS) loves to eat data in an Import/Export kind of way. Although a green chain of boxes in SSIS can be the ruling “Happy Dance” of any DBA or SQL Developer, we must still consider the performance of those tasks. In this session, we will go through performance tuning in SSIS 2012 after a successful SSIS package has been developed. When we are finished with this session, not only will you still have the mystic of green colors of successful execution of your SSIS import and export tasks, but the turbo boosters will be turned on as well. 5/19/2012 10:45:00 AM 5/19/2012 12:00:00 PM 7754 Josh Fennessy Track 5 117 More often than not, a SQL DBA will also be requested (or required) to administer *other* applications in the SQL universe. These applications are often the BI stack, SSIS, SSRS, and SSAS. In this session, you will learn not only what each of these applications does, but also some behind the scenes views into how they work. At the end of this session, you will have a better feeling of what to look for when something goes wrong, and have the knowledge to be proactive with your Business Intelligence implementations. This session will focus on the SSIS, SSRS, and SSAS engines in this session. Not a session for developers, we will be focusing on the ADMINISTRATION of these applications/services only. 5/19/2012 9:15:00 AM 5/19/2012 10:30:00 AM 7774 Ross LoForte Track 3 216 Want to learn Microsoft solutions around Big Data integrating structured and unstructured data to unleashing insights on all data. This session on the Big Data solution running Hadoop on Windows and Windows Azure, then integrating the Microsoft BI solution to provide a conbined view of all data. During the session, the attendees will get a peek on a demo Hadoop Azure running a Big Data MapReduce solution, then using PowerPivot and PowerView to view the data. 5/19/2012 10:45:00 AM 5/19/2012 12:00:00 PM 7795 Luke Jian Track 1 214 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 5/19/2012 4:00:00 PM 5/19/2012 5:15:00 PM 7947 Bill Fellows Track 5 117 Slow running packages? SSIS consuming all your resources? No idea what it's doing? After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for. 5/19/2012 1:00:00 PM 5/19/2012 2:15:00 PM 7979 Mark Vaillancourt Track 6 118 Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment. 5/19/2012 9:15:00 AM 5/19/2012 10:30:00 AM 8033 Norman Kelm Track 5 117 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. 5/19/2012 2:30:00 PM 5/19/2012 3:45:00 PM 8069 Erin Stellato Track 3 216 There are many DBCC statements at the disposal of Database Administrators and Developers. Some are used for the greater good; others can wreak havoc in your system. The majority of these commands are informational, but if you’re not careful you can introduce chaos or at worst, lose data you may never find again. In this session we will explore DBCC commands that are useful for the DBA and developer, and cover when to use them and how. Expect demonstrations that provide a practical application of these commands - both documented and not - that database professionals can utilize quickly and easily. 5/19/2012 4:00:00 PM 5/19/2012 5:15:00 PM 8249 Christina Leo Track 4 217 Creating a query plan can be a time consuming and expensive process. To avoid repeating these potentially costly steps, SQL Server stores its query plans, in the plan cache where they can be reused as needed. In this session, we’ll look at how the plan cache is organized, what plans are saved, when plans are reused and when they are recreated, methods for observing the contents of the plan cache, and finally, methods for manipulating plan reuse and recreation. 5/19/2012 10:45:00 AM 5/19/2012 12:00:00 PM 8407 David Klee Track 3 216 Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, and this session will provide valuable insight into how to properly prepare for and implement a successful virtualization campaign for ALL of your SQL Server environments and prepare your organization for the change. Practical tips, tricks, and gotchya’s will be discussed in this dynamic dialog session. 5/19/2012 9:15:00 AM 5/19/2012 10:30:00 AM 8419 Eddie Wuerch Track 8 218 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 5/19/2012 4:00:00 PM 5/19/2012 5:15:00 PM 8484 Rob Farley Track 7 215 SARGability is such a significant thing in the database world, and goes far beyond 'Keep your columns on the left and functions on the right'. In this talk, you'll be able learn principles that will affect not only how easily your data can be located, but also the way that joins are performed and more. You can even learn ways to tune poorly performing queries without having to rewrite anything. 5/19/2012 4:00:00 PM 5/19/2012 5:15:00 PM 8486 Rob Farley Track 7 215 There are a bunch of new T-SQL functions in SQL Server 2012, and as usual there's a combination of the 'this is really useful' and the '...but there's a caveat'. In this presentation, Rob will take you through the new analytic functions, show you how they seriously enhance your reporting ability, and show you some of the ways that they don't behave the way you might expect. You may not be using SQL Server 2012 yet, but you're bound to recognise some of the problems that these functions solve. 5/19/2012 2:30:00 PM 5/19/2012 3:45:00 PM 8511 Kevin Boles Track 1 214 Take your relational data warehouse query performance all the way to ELEVEN!! The Column Store Index is a new feature that allows for stunning performance. We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas. 5/19/2012 2:30:00 PM 5/19/2012 3:45:00 PM 8519 Mike Donnelly Track 4 217 There are some great new tasks in SSIS 2012 to take advantage of (CDC) Change Data Capture. I'll walk you through adding CDC to your database and tables and then updating incremental changes using the New CDC Control Task, CDC Source and CDC Splitter. 5/19/2012 4:00:00 PM 5/19/2012 5:15:00 PM 8520 Craig Purnell Track 4 217 We will review the upgrade process to SQL Server 2012. An upgrade is 75% project planning and 25% execution. Everyone knows that, right? Actually, no. A checklist of considerations a company would likely encounter coming from SQL Server 2005/2008 or R2. The pros and cons of in place upgrade vs. the build out new approach. There will be many real world lessons learned sprinkled in as the presenter has led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor, deprecated features and how to test for them 5/19/2012 9:15:00 AM 5/19/2012 10:30:00 AM 8535 Andy Thiru Track 2 116 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, scaling and sharding databases with SQL Azure Federations and syncsynchronizing 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. 5/19/2012 1:00:00 PM 5/19/2012 2:15:00 PM 8545 Arie Jones Track 3 216 Most DBAs at one time or another have been taught the importance of master data management(MDM), which is comprised of a set of processes and tools in order to keep your non-transactional data in a consistent state. However, with today’s fast paced environment and tightening budgets most DBAs lack the resources to properly implement it. With the upcoming release of SQL Server 2012, Microsoft has taken their second swipe at providing a tool known as Master Data Services(MDS) to aid the DBA in this endeavor. In this session, you will learn the how Master Data Services is implemented in SQL Server 2012, setting up models, working through the Excel plug-in, and utilizing DQS and business rules to help with that dirty data. 5/19/2012 2:30:00 PM 5/19/2012 3:45:00 PM 8676 SQL Saturday Track 1 214 SQL Saturday Chicago 5/19/2012 7:30:00 AM 5/19/2012 8:45:00 AM 8677 SQL Saturday Track 1 214 SQL Saturday Lunch 5/19/2012 12:00:00 PM 5/19/2012 12:45:00 PM 8678 SQL Saturday Track 1 214 SQL Saturday End of the Day Recap 5/19/2012 5:30:00 PM 5/19/2012 6:00:00 PM 8679 SQL Saturday Track 5 117 Quest You Rock Session - Come here about these awesome tools for SQL Server! 5/19/2012 12:00:00 PM 5/19/2012 12:45:00 PM 8679 SQL Saturday Track 6 118 Quest You Rock Session - Come here about these awesome tools for SQL Server! 5/19/2012 12:00:00 PM 5/19/2012 12:45:00 PM 9114 Wendy Pastrick Track 2 116 Join several of the local Women in Technology as they share their experience and take questions from the attendees. ALL ARE WELCOME! 5/19/2012 12:00:00 PM 5/19/2012 12:45:00 PM 9744 Dave Levy Track 8 218 Take advantage of the deep wealth of knowledge from our experts at SQL Saturday by asking them anything and everything you may want to know or troubleshoot about SQL Server 5/19/2012 1:00:00 PM 5/19/2012 2:15:00 PM