SQLSaturday #167 - Columbus GA 2012 9/8/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. #sqlsat167 Columbus State University 4225 University Ave Columbus GA 31907 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 2461 Linchpin People LLC Gold Sponsor http://www.linchpinpeople.com http://linchpinpeople.com/wp-content/uploads/2012/02/linchpin_logo_trans.png 60 170 2371 Pragmatic Works Silver Sponsor http://pragmaticworks.com/services/training/Default.aspx http://pragmaticworks.com/images/logo/PragmaticWorksLogo.jpg 60 170 2438 Idera Silver Sponsor http://www.idera.com http://www.idera.com/campaign_images/logo_Idera_tag_170x60.png 60 170 2440 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2521 Atlanta MDF Silver Sponsor http://www.atlantamdf.com http://tradney.files.wordpress.com/2012/07/atlantamdf_logo_horizontal_for_sql_saturday.png 60 170 2332 Red Gate Bronze Sponsor http://www.red-gate.com http://www.red-gate.com/archive/redgatelogo_black.jpg 60 170 2431 CozyRoc LLC Bronze Sponsor http://www.cozyroc.com http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 2527 Melissa Data Bronze Sponsor http://www.MelissaData.com http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif 60 170 2619 SQLskills Bronze Sponsor http://www.SQLskills.com http://www.sqlskills.com/SQLskillsLogo.jpg 60 170 2638 Wrox Bronze Sponsor http://www.wrox.com http://a2.twimg.com/profile_images/1352261395/New_WROX_Logo_RGB_reasonably_small.jpg 60 170 2509 SQL Cruise Personal Sponsor http://sqlcruise.com/2013-cruises/ http://sqlcruise.com/wp-content/uploads/2012/08/sqlsat_sqlcruise_sm.png 40 100 9920 SQLSaturday 167 Track 1 Room 1 9/8/2012 12:30:00 PM 9/8/2012 1:15:00 PM 9920 SQLSaturday 167 Track 2 Room 2 9/8/2012 12:30:00 PM 9/8/2012 1:15:00 PM 9920 SQLSaturday 167 Track 3 Room 3 9/8/2012 12:30:00 PM 9/8/2012 1:15:00 PM 9920 SQLSaturday 167 Track 4 Room 4 9/8/2012 12:30:00 PM 9/8/2012 1:15:00 PM 9928 Jon Boulineau Track 3 Room 3 If you've been writing T-SQL code for a while, but have never delved into what happens after you submit your queries there is a whole world that you are missing. Taking the next step as a T-SQL developer requires understanding the basics of the SQL Server architecture and what it means to use a declarative language. Have you ever wondered why cursors are so slow, why query performance can be unpredictable, or how you can begin to analyze your queries more deeply? In this session we will cover what SQL Server has to do to turn your T-SQL code into the results you expect and how you can use this knowledge to make your code better. 9/8/2012 10:15:00 AM 9/8/2012 11:15:00 AM 9971 Mark Swofford Track 1 Room 1 The first 24 months are extremely important in our careers when we’ve been offered the opportunity to take on the ‘DBA’ role. To be successful, it takes a solid foundation of general concepts, career development, training, fearlessness, confidence, and mentorship from more experienced professionals. Organization, planning, and having a roadmap to where you are going will be crucial to your success. This session will bring these topics together so you can set your GPS to success avenue. 9/8/2012 1:15:00 PM 9/8/2012 2:15:00 PM 10161 Jim Wooley Track 4 Room 4 As systems grow and evolve, we need tools to help manage these changes, including tracking changes to the database schemas, producing scripts to synchronize the changes between servers, and refactoring the corresponding application code based on the new structures. You'll see how you can use tools in Visual Studio and SSDT to help manage these changes better. 9/8/2012 2:30:00 PM 9/8/2012 3:30:00 PM 10169 Brian K McDonald Track 2 Room 2 SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this deep dive session, I will cover topics like: - What is reporting services and what can it be used for? - New Features included in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access. ** This session is SQL Saturday favorite and is always packed full. Don't miss it ** 9/8/2012 3:45:00 PM 9/8/2012 4:45:00 PM 10295 Devin Knight Track 4 Room 4 With all the great new features added to SSIS in SQL Server 2012 it is important to understand how they can make your development life easier. This session will not only highlight what is new in SSIS but also show how your existing solutions can be adapted to utilize the latest features. Topics will include changes to usability, deployment, configuration and management. 9/8/2012 1:15:00 PM 9/8/2012 2:15:00 PM 10296 Devin Knight Track 1 Room 1 Power View has the capability of creating eye-popping visualizations within SharePoint 2010. It provides intuitive ad-hoc reporting that can be used by a variety of business users to make critical decisions. In this session you will learn how to design your own dazzling reports using Power View. 9/8/2012 3:45:00 PM 9/8/2012 4:45:00 PM 10346 Robert Chad Churchwell Track 3 Room 3 This session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology. Discussed will be design decisions for snapshot, transactional, and merge replication. Also discussed will be agent profiles and optimizations for replication. What type of replication to use to solve specific business needs will also be covered. 9/8/2012 2:30:00 PM 9/8/2012 3:30:00 PM 10370 Kevin Boles Track 2 Room 2 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. 9/8/2012 2:30:00 PM 9/8/2012 3:30:00 PM 10515 Julie Smith Track 2 Room 2 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. 9/8/2012 1:15:00 PM 9/8/2012 2:15:00 PM 10592 Christopher Price Track 3 Room 3 With SQL Server 2012 it has never been easier to empower your data stewards and give them greater control over the data management process. Dive in as we integrate Master Data Services and Data Quality Services into a data warehouse. We will explore how Master Data Services and the new plugins available in 2012 can facilitate the management of your organization’s master data. A look at Data Quality Services will highlight how it can be leveraged to provide value to the data management process through its cleansing and matching capabilities. Finally, we evaluate the options available to integrate back into the data warehouse. 9/8/2012 11:30:00 AM 9/8/2012 12:30:00 PM 10593 Christopher Price Track 2 Room 2 Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization's master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available both out-of-the-box and through the excel plug-in. 9/8/2012 10:15:00 AM 9/8/2012 11:15:00 AM 10629 Tom Norman Track 3 Room 3 I don't know how the Sql Server will perform! You can't do that! Yes, we can! Yes, we did! It runs better than our physical server. Need to add a CPU in less than 5 minutes, no problem. Need more memory, sure. Give me 5 minutes. Thin provisioning, thick provisioning? Can I put as many Sql Servers as I want on the Host? What is a Host and a Guest? What is causing my Sql Server to run slow, is it the virtual, operating system or Sql Server? How do I know? What is the licensing for Sql Server? How do you monitor it? How is it working? Let’s find all of these answers. 9/8/2012 9:00:00 AM 9/8/2012 10:00:00 AM 10630 Tom Norman Track 1 Room 1 Peanut Butter and Mayonnaise? No, Policy Based Management What can it do for me? Do I really need it? How do I install and configure it? How can it help me to pass audits? Who is that masked man you got into my database. You mean each server can really be configured the same. Let's explore Policy Based Management and what it has to offer us in better management of our Sql Servers. 9/8/2012 10:15:00 AM 9/8/2012 11:15:00 AM 10663 Michael French Track 1 Room 1 WARNING: Do not quit your job after this presentation. Have you ever thought about becoming an Independent Contractor? Would you like to transition from Full Time Employment to Consulting? Do you want to know how to get started? If so, then this lively session is for you. The session will cover the basics of running a consulting business and a selling yourself as a Technical Resource. We will conclude with an open discussion about the business side of technology. 9/8/2012 2:30:00 PM 9/8/2012 3:30:00 PM 10831 Stuart Ainsworth Track 4 Room 4 Agile development is all the rage, but how do the principles apply to database administrators? This presentation will introduce the basics of the Agile Manifesto, and explain how they can be applied to non-development IT work, such as database administration, maintenance, and support. We’ll cover scrum (one of the most popular development methodologies) and kanban, and identify some of the common struggles with implementing them in an organization. This is an interactive discussion; please bring your tales of success and your horror stories. 9/8/2012 9:00:00 AM 9/8/2012 10:00:00 AM 10842 Andy Thiru Track 1 Room 1 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 9/8/2012 9:00:00 AM 9/8/2012 10:00:00 AM 10851 Pam Shaw Track 2 Room 2 In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create. 9/8/2012 9:00:00 AM 9/8/2012 10:00:00 AM 10884 Geoff Hiten Track 4 Room 4 Good Code, Bad Code. It can be the difference between a server running smoothly and an unresponsive piece of junk. This session digs into what makes some SQL code perform faster and scale better. Session is almost all interactive demo. 9/8/2012 3:45:00 PM 9/8/2012 4:45:00 PM 10889 Geoff Hiten Track 1 Room 1 AlwaysOn is the new High Availability technology suite for Microsoft SQL Server 2012 that allows for multiple HA and DR solutions along with hardware reuse and reporting scale-out. Learn what AlwaysOn can do and how it works. 9/8/2012 11:30:00 AM 9/8/2012 12:30:00 PM 10903 Erik Monchen Track 2 Room 2 As a BI Administrator or report designer, you've probably been asked many times by the business to create a dashboard to present some data. What makes a good dashboard though? The more information, the better? The more colors, the better? In this session you will get tips about designing dashboards, graphs, tables, gauges and maps with the goal of how you can impress your end user with the most efficient designed reports. This session is less technical than others, since it covers aspects and tips that you can take into consideration to create your reports as clear, understandable and usable as possible. The session consists of some general tips and tricks, followed by examples of designs and how to optimize these. 9/8/2012 11:30:00 AM 9/8/2012 12:30:00 PM 10930 Robert Cain Track 3 Room 3 Business Intelligence is one of the hottest job skills in the IT field. DBAs and Database Developers are being asked to implement databases with non-traditional design, and are having a lot of new vocabulary thrown their way. In this talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean. 9/8/2012 1:15:00 PM 9/8/2012 2:15:00 PM 11182 Aaron Nelson Track 4 Room 4 You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool. 9/8/2012 11:30:00 AM 9/8/2012 12:30:00 PM 11187 Raffle Drawing Track 4 Room 4 Raffle 9/8/2012 5:00:00 PM 9/8/2012 5:30:00 PM 11187 Raffle Drawing Track 3 Room 3 Raffle 9/8/2012 5:00:00 PM 9/8/2012 5:30:00 PM 11187 Raffle Drawing Track 2 Room 2 Raffle 9/8/2012 5:00:00 PM 9/8/2012 5:30:00 PM 11187 Raffle Drawing Track 1 Room 1 Raffle 9/8/2012 5:00:00 PM 9/8/2012 5:30:00 PM 11188 Tim Radney Track 3 Room 3 In this session I will discuss and show the benefits of utilizing compression. I will be demonstrating native SQL Compression as well as a third party tool. I will show examples of my real world testing and share the numerous benefits of SQL Compression. 9/8/2012 3:45:00 PM 9/8/2012 4:45:00 PM 11199 William E Pearson III Track 4 Room 4 In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. 9/8/2012 10:15:00 AM 9/8/2012 11:15:00 AM