SQLSaturday #132 - Pensacola 2012 6/9/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. #sqlsat132 Pensacola State College, 1000 College Blvd. Pensacola FL 32504 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 2077 Telerik Platinum https://www.telerik.com http://www.sqlsaturday.com/files/a3fb63d6-9ff0-4953-b925-97f36eb8a9e6.jpg 60 170 2135 Idera Platinum http://www.idera.com http://www.idera.com/images/Logo-Idera.png 60 170 2228 Red Gate Software Gold Sponsor https://www.red-gate.com http://www.red-gate.com/assets/images/common/logo.png 60 170 2306 TeleVox Software Gold Sponsor http://www.televox.com http://www.televox.com/graphics/televox_wtag.jpg 60 170 2065 CTS, Inc. Silver Sponsor http://www.askcts.com/ http://sharepointsaturday.org/atlanta/SiteImages/sponsors/CTS_logo.jpg 60 170 2099 Bit-Wizards Silver Sponsor http://www.bit-wizards.com http://bitwizards.com/Bit-Wizards/media/Graphics/Logos/BitWizardsLogo170x60.png 60 170 2231 GrapeCity Silver Sponsor http://www.gcpowertools.com http://www.gcpowertools.com/Img/Company/GCPT170logo.jpg 60 170 2318 Microsoft Silver Sponsor http://www.microsoft.com http://www.microsoft.com/presspass/images/gallery/logos/web/mslogo-2.jpg 60 170 2345 TEKsystems Silver Sponsor http://www.teksystems.com/ http://www.saic.com/contractcenter/ites-2s/images/logos/tek.gif 60 170 2267 CozyRoc Bronze Sponsor http://www.cozyroc.com http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 2316 McGraw-Hill Professional Book Sponsor http://learnmore.mcgraw-hill.com/ http://www.mhprofessional.com/images/leanrmore_logo.gif 40 100 2321 O'Reilly Media Book Sponsor http://oreilly.com/ http://cdn.oreilly.com/images/sitewide-headers/ml-header-home-blinking.gif 40 100 2322 Murach Books Book Sponsor http://www.murach.com http://www.sqlsaturday.com/files/2482fe76-4040-40f4-8713-da4e71433f96.jpg 40 100 2030 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 2200 SQLJuJu Blog Sponsor http://www.sqljuju.com http://www.sqljuju.com/wp-content/uploads/2012/04/SQLJuJu100x40b.gif 40 100 2207 Bill Pearson (Island Technologies Inc.) Blog Sponsor http://digital-duke.com/ http://digital-duke.com/wp-admin/images/Digital-Duke.comBW.jpg 40 100 7568 SQLSaturday 132 BI 1780 6/9/2012 1:00:00 PM 6/9/2012 2:00:00 PM 7568 SQLSaturday 132 New in 2012 1776 6/9/2012 1:00:00 PM 6/9/2012 2:00:00 PM 7568 SQLSaturday 132 DEV 2171 6/9/2012 1:00:00 PM 6/9/2012 2:00:00 PM 7585 Rob Volk DEV 2171 Do your eyes glaze over at the mention of tuples, domains, or even basic SQL terms? Have you moved to SQL Server from MS Access, or Excel, or other non-relational database products? This session will help explain the basics of set theory and relational theory using actual Lego blocks. We will illustrate terms and concepts such as joins, unions, and set-based operations, and how you can translate them into actual SQL. If you're an absolute beginner to SQL, or feel overwhelmed by the baggage of computer data models, or would just like to play with Legos, you'll both enjoy and learn something during this session. 6/9/2012 2:00:00 PM 6/9/2012 3:00:00 PM 7588 Rob Volk MISC 1775 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! 6/9/2012 4:30:00 PM 6/9/2012 5:30:00 PM 7594 William E. Pearson III BI 1780 Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations. 6/9/2012 4:30:00 PM 6/9/2012 5:30:00 PM 7599 William E. Pearson III BI 1780 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. 6/9/2012 11:45:00 AM 6/9/2012 12:45:00 PM 7690 Rafael Salas New in 2012 1776 SQL Server 2012 makes major improvements to SSIS in a number of areas: development experience, troubleshooting, deployment and management. Many of these improvements are based on the new server side catalog (SSISDB) and are available only when you use the new Project Deployment Model. In this session, you will learn how to create projects using the new deployment model, deploy, track, execute and manage SSIS packages. We will also explore some of the improvements in SQL Server Data Tools -formerly known as BIDS-, and the server side user experience using SSMS. Whether you are new to SSIS or planning to upgrade your skills to the new version, you will find the information given in this session valuable. 6/9/2012 8:45:00 AM 6/9/2012 9:45:00 AM 7695 Ryan Duclos MISC 1775 SQL Azure Reporting is a CTP offering and part of the SQL Azure and Windows Azure Platform. The SQL Azure Reporting component is based on SQL Server Reporting Services (SSRS). It is a cloud-based service offerring a subset of SSRS technology. In this session we will go over the basic of getting SQL Azure Reporting setup and wired up. ***It is assumed that you have familiarity with designing/managing SSRS reports. 6/9/2012 3:15:00 PM 6/9/2012 4:15:00 PM 7724 Sven Aelterman New in 2012 1776 SQL Server Integration Services has received significant upgrades in SQL Server 2012. How to effectively upgrade SSIS packages to take advantage of the new SSIS features is the main driver behind this session. Primarily focused on upgrading packages from SSIS 2008, some notes will also be made about upgrading from SSIS 2005. 6/9/2012 2:00:00 PM 6/9/2012 3:00:00 PM 7725 Sven Aelterman DEV 2171 Currently in Release Candidate, SQL Server 2012 offers several new features and improvements. This session will cover the ones that are most of interest to application developers, including enhancements to T-SQL, FILESTREAM and developer tools (including SSIS). 6/9/2012 4:30:00 PM 6/9/2012 5:30:00 PM 7788 Robert Davis DBA Auditorium 2142 If you work with very large databases (VLDBs) that must be replicated, you should be using initialization from backup. There are a some misconceptions the have caused DBAs to assume that they could not use initialization from backup. In this session I will explore those misconceptions and prove that they are incorrect. Demos will include initializing a subscriber from a transaction log backup and performing a partial restore of a database and initializing the subscriber from the partial backup. 6/9/2012 2:00:00 PM 6/9/2012 3:00:00 PM 7792 Argenis Fernandez DBA Auditorium 2142 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. 6/9/2012 8:45:00 AM 6/9/2012 9:45:00 AM 7959 Devin Knight BI 1780 Who wouldn’t want to create unbelievable dashboards that executives can get excited about? PerformancePoint Services is perfect tool for creating interactive dashboards viewable from inside SharePoint. In this session Devin will talk you through getting up and running with PerformancePoint and how to create a basic Dashboard including a KPI, Scorecard and Report. 6/9/2012 8:45:00 AM 6/9/2012 9:45:00 AM 7962 Devin Knight BI 1780 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. 6/9/2012 2:00:00 PM 6/9/2012 3:00:00 PM 7965 Christopher Price Performance/Security 2172 We will explore data quality issues that face today’s business and how Data Quality Services 2012 can help IT Pros and Data Stewards meet those challenges. We will start from zero, build a knowledge base, profile data to train our knowledge base and then use that knowledge to highlight both the cleansing and matching capabilities of DQS. This session will also cover the DQS SSIS component that’s available in SQL Server 2012. 6/9/2012 10:30:00 AM 6/9/2012 11:30:00 AM 8014 Thomas LeBlanc BI 1780 This session will go through some old and new features of Integration Service 2012 to help with loading data into a Data Warehouse/Mart. The GUI has been improved visually during design and execution. The storage of packages has been update with Integration Service Catalogs. The Change Data Capture task helps with incremental updates. Logging has been improved for debugging. A demostration of creating your own Slowly Changing Dimension with current Tasks will be shown with some design hints. 6/9/2012 3:15:00 PM 6/9/2012 4:15:00 PM 8015 Thomas LeBlanc Performance/Security 2172 So you been using Execution Plans for a little while and want to know more. This session will look deeper into Nested, Merge and Hash Joins. What to look for in the memory grants will be discussed. Using MAXDOP and Cost Threshold will be demostrated to understand parallel plans. Demostrations will show Aggregate Iterators and how to find out if the optimizer is smarter than us. 2012 enhancements to execution plans will be shown throughout the demos 6/9/2012 11:45:00 AM 6/9/2012 12:45:00 PM 8025 James McAuliffe New in 2012 1776 FileTable and Statistical Semantic Search In SQL 2012 It’s like having the biggest junk drawer EVER. That’s often what our “Document Repositories” become. You know you have that golden nugget of information that you’re searching for, and it’s in there somewhere, but you can’t find it. This session explores a new feature of SQL 2012 called Statistical Semantic Search. It's like having a closet organizer on staff at all times. While full-text search lets you query the words in a document, semantic search lets you query the meaning of the document. New scenarios we will look into will include automatic tag extraction, related content discovery, and hierarchical navigation across similar content. 6/9/2012 3:15:00 PM 6/9/2012 4:15:00 PM 8139 Jorge Segarra DBA Auditorium 2142 In today's economic times, we are being asked to do more with less. Less budget, less hardware and yet our data needs keep growing! So how do we keep our database infrastructure humming along given these restrictions? In this session we will talk about different options of consolidation including: database-level consolidation, instance-level consolidation, and virtualization. Additionally we will also talk about some of the tools and methods you can use today to help you consolidate your SQL Server environment and do more with less! 6/9/2012 10:30:00 AM 6/9/2012 11:30:00 AM 8140 Jorge Segarra MISC 1775 We will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Server environment using this awesome new feature! 6/9/2012 2:00:00 PM 6/9/2012 3:00:00 PM 8147 Eric Wisdahl DBA Auditorium 2142 Imagine your business with fewer integration projects, coming in on time and under budget. Let us further imagine your business making great decisions based on the right data at the right time. In this session we will explore the concepts of data quality, as well as some of the tools and initiatives which relate to scoring your data and correcting your business processes for data input. This is NOT a presentation on Data Quality Services, although we will look at how this new tool might fit within your data quality initiatives. Return to the office informed and invigorated with the knowledge that bad data can be overcome! 6/9/2012 11:45:00 AM 6/9/2012 12:45:00 PM 8158 Bryan Soltis DEV 2171 SQL Azure is Microsoft’s cloud-based relational database platform for managing information in the Windows Azure. In this session, Bryan will cover several areas of managing data using Microsoft SQL Azure platform. Topics include migrating existing databases to SQL Azure, importing/exporting content, the SQL Azure management portal, management of SQL Azure databases using SQL Server Management Studio, and real-world scenarios using SQL Azure and Windows Azure. Also covered are deployment scenarios, including full Azure-based systems and hybrid solutions utilizing on-premise and off-premise platforms. 6/9/2012 10:30:00 AM 6/9/2012 11:30:00 AM 8166 Steve Jones Performance/Security 2172 There are a number of encryption options in SQL Server and this session will talk about many of them, looking briefly at TDE, hashing, encryption keys, and SSL encrpytion. 6/9/2012 4:30:00 PM 6/9/2012 5:30:00 PM 8167 Early Bird Session by Steve Jones DBA Auditorium 2142 A look at the Filestream and Filetable features in SQL Server that can allow you to handle unstructured data inside your SQL Server database. 6/9/2012 7:30:00 AM 6/9/2012 8:30:00 AM 8235 Bradley Schacht BI 1780 Excel Services is an extremely powerful tool that you can use inside your environment to help improve workflow and collaboration. Some of the topics discussed will include the service application, associating the application with your SharePoint site, data connections and the unattended service account. We will also talk about how PowerPivot for Excel translates into the SharePoint experience including setup, deployment and what happens in the background. Most of the time will be spent talking about PowerPivot and this exciting new technology. 6/9/2012 10:30:00 AM 6/9/2012 11:30:00 AM 8294 Tim Costello Performance/Security 2172 Synchronous and asynchronous components, memory buffers, data type choices. Tuning the data flow is all about choices. In this session we'll explore some of the choices that can give you the biggest performance boosts in your ssis data flow. Together we'll walk through creating a performance baseline, the differences between synchronous and asynchronous components and a few simple patterns we can implement to improve performance in our SSIS packages. 6/9/2012 8:45:00 AM 6/9/2012 9:45:00 AM 8320 Brian Kelley Performance/Security 2172 In warfare, understanding your enemy is a supreme advantage. The same is true when it comes to protecting SQL Server. We’ll get into the mindset of an attacker, looking at the methods and techniques attackers use to go after SQL Server. Once we understanding the threats, we’ll then examine defensive techniques to secure and protect our SQL Servers, using both new and creative methods, as well as the tried and true. 6/9/2012 2:00:00 PM 6/9/2012 3:00:00 PM 8322 Brian Kelley MISC 1775 Auditing is often a dirty word among DBAs because it equates to more work with little perceived business value. However, auditing is a necessary evil for most businesses and it usually falls to the DBA to ensure SQL Server is properly audited. In this session we'll look at what the operating system and SQL Server provide for us in order to meet the requirements of internal and external auditors, regulatory legislation, and even overbearing system owners who want to know everything about what's going on in their application. We'll consider what tools to use to quickly implement the properly level of auditing to meet the need. 6/9/2012 11:45:00 AM 6/9/2012 12:45:00 PM 8346 Mike Huguet DEV 2171 Windows Communications Foundation is a part of the .NET Framework that provides a unified programming model for rapidly building service-oriented applications that communicate across the web and the enterprise. You will learn why WCF exists and will get an introduction to the fundamental building blocks. We’ll run through some practical examples as well. This is an introductory level discussion on WCF, but requires at least an intermediate level .NET development experience. 6/9/2012 3:15:00 PM 6/9/2012 4:15:00 PM 8351 Mike Huguet DEV 2171 This session will cover an introduction of the SharePoint architecture, details on the more common customization and extensibility areas for developers including application pages, JavaScript, event receivers, workflows, web parts, and field types. We will also cover different options for developing composite solutions leveraging SharePoint data and hosting of your applications in SharePoint. Due to the amount of content, this session is mostly at the architectural level. There will be some demos, but there will not be a lot of depth in one particular area. To gain the most value out of this session it is suggested that you be at least an intermediate level web developer and some experience using SharePoint basic functions as an end user. 6/9/2012 8:45:00 AM 6/9/2012 9:45:00 AM 8588 Gareth Swanepoel New in 2012 1776 As a lone DBA in the scary world of the SQL Server 2012 Fire Swamp, you may be wary of the multiple threats of Lightning sand, Flame spurts Rodents of unusual size. In this session, come and learn how to map your way through these threats using new and improved DMV's and Extended Events. 6/9/2012 10:30:00 AM 6/9/2012 11:30:00 AM 8624 William Assaf Performance/Security 2172 A review of SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and more. 6/9/2012 3:15:00 PM 6/9/2012 4:15:00 PM 8632 Chad Churchwell New in 2012 1776 This presentation will focus on the concepts behind AlwaysOn, benefits it provides, and a demo of setting up AlwaysOn Availability groups 6/9/2012 11:45:00 AM 6/9/2012 12:45:00 PM 8648 Ed Wilson DBA Auditorium 2142 Learn Windows PowerShell best practices for DBA’s as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences 6/9/2012 4:30:00 PM 6/9/2012 5:30:00 PM 8692 Kevin Boles DBA Auditorium 2142 For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure! 6/9/2012 3:15:00 PM 6/9/2012 4:15:00 PM 8695 Kevin Boles New in 2012 1776 The breadth and depth of improvements in TSQL coming out with SQL Server 2012 represent the most significant changes in, well, probably ever! This fast and furious overview will touch on a large range of these goodies, with plenty of sample code for you to take home and review at your leisure! 6/9/2012 4:30:00 PM 6/9/2012 5:30:00 PM 8751 Tim Radney MISC 1775 It is easy to schedule full backups to run each night, but is that the right decision for your organization? You say you have a backup strategy, but what is your recovery strategy? Do you have a well-executed recovery plan? In this session Tim Radney will cover several methods for performing much needed backups and how to recover those backups. Full, Differential, File Group, Transaction logs and recovery the tail end of a the log. He will discuss industry best practices and hopefully cause you to validate and test your current strategy. 6/9/2012 8:45:00 AM 6/9/2012 9:45:00 AM 9076 Sponsor Spotlight Session - Red Gate DBA Auditorium 2142 Accidents happen, and when they happen to our computer systems, they are disasters. Steve Jones will talk about the disasters that are likely to occur in your computer systems and the steps you can take to minimize the impact to your environment. Tools used: SQL Backup Pro, SQL Virtual Restore, SQL Monitor 6/9/2012 1:00:00 PM 6/9/2012 2:00:00 PM 9079 Coffee and Snack Break DBA Auditorium 2142 Due to a late lunch, we will be having a mid-morning coffee and snack break. This will give you yet another opportunity to meet up with our sponsors! 6/9/2012 10:00:00 AM 6/9/2012 10:30:00 AM 9079 Coffee and Snack Break BI 1780 Due to a late lunch, we will be having a mid-morning coffee and snack break. This will give you yet another opportunity to meet up with our sponsors! 6/9/2012 10:00:00 AM 6/9/2012 10:30:00 AM 9079 Coffee and Snack Break New in 2012 1776 Due to a late lunch, we will be having a mid-morning coffee and snack break. This will give you yet another opportunity to meet up with our sponsors! 6/9/2012 10:00:00 AM 6/9/2012 10:30:00 AM 9079 Coffee and Snack Break Performance/Security 2172 Due to a late lunch, we will be having a mid-morning coffee and snack break. This will give you yet another opportunity to meet up with our sponsors! 6/9/2012 10:00:00 AM 6/9/2012 10:30:00 AM 9079 Coffee and Snack Break MISC 1775 Due to a late lunch, we will be having a mid-morning coffee and snack break. This will give you yet another opportunity to meet up with our sponsors! 6/9/2012 10:00:00 AM 6/9/2012 10:30:00 AM 9079 Coffee and Snack Break DEV 2171 Due to a late lunch, we will be having a mid-morning coffee and snack break. This will give you yet another opportunity to meet up with our sponsors! 6/9/2012 10:00:00 AM 6/9/2012 10:30:00 AM 9154 Sponsor Spotlight Session - Grape City Performance/Security 2172 See how to deliver the next generation of Business Intelligence software and analyze data using drag and drop operations. We will look using a Silverlight front end with interactive data analysis for uncovering new trends. Learn how to build interactive dashboards with multiple views of the same data, data binding, analyzing unstructured data, combining charts and Pivot tables into one project and more. Join Russ Fustino in this very informative developer oriented session. 6/9/2012 1:00:00 PM 6/9/2012 2:00:00 PM 9804 Kevin Grohoske DEV 2171 Microsoft’s SQL Server team has provided a unique set of capabilities for Business Intelligence. With Power Pivot, Power View, and SQL Server Reporting Services (SSRS) provides a full breadth of capabilities that can be utilized to mash up data across the enterprise. In this session we will walk through the product stack and determine how they can be utilized within your organization to provide greater insight into your business data. 6/9/2012 11:45:00 AM 6/9/2012 12:45:00 PM 9816 Lightning Talks MISC 1775 A chance for both new and seasoned speakers to present for 5 minutes on their favourite topic. Prizes awarded for the best and most entertaining lightning talk. 6/9/2012 1:00:00 PM 6/9/2012 2:00:00 PM 9923 Chris Eargle MISC 1775 Lambda expressions are a powerful feature of C#, one that can be wielded for good or evil. Attend this session for an adventure through the evolution of the C# language, from the depths of the delegate keyword to the expressiveness of the lambda expression. I will show you how anyone can easily learn to wield and empower code with lambda expressions. It's dangerous to go alone! 6/9/2012 10:30:00 AM 6/9/2012 11:30:00 AM