SQLSaturday #110 - Tampa 2012 3/10/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. #sqlsat110 K-Force 1001 East Palm Avenue Tampa FL 33605 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 2031 Kforce, Inc Platinum http://www.kforce.com http://www.sqlsaturday.com/files/6fea9427-b8f9-4447-a7d1-194525003fa9.jpg 60 170 1890 Soaring Eagle Consulting, Inc. Gold Sponsor http://www.soaringeagle.biz http://www.confio.com/English/Images/Logos/soaring-eagle.jpg 60 170 1678 Idera Gold Sponsor http://www.idera.com http://www.idera.com/images/promos/Idera_60.jpg 60 170 1758 Quest Software Gold Sponsor http://www.quest.com http://www.sqlsaturday.com/files/9b063b33-d3b2-4594-8fbe-d7580783e6d1.png 60 170 1779 Pragmatic Works Gold Sponsor http://www.pragmaticworks.com http://pragmaticworks.com/images/pw_logo.jpg 60 170 1829 LaSalle Computer Learning Center Gold Sponsor http://www.lasallecomputer.com http://www.lasallecomputer.com/index_images/lasallelogo.gif 60 170 1851 Penton (SQL Server Pro) Gold Sponsor http://sqlmag.com http://dl.dropbox.com/u/54908182/SQLServerPro_Logo.png 60 170 1874 DATAVERSITY Gold Sponsor http://www.dataversity.net/ http://www.dataversity.net/wp-content/uploads/2011/08/DV-TM-724-Header.jpg 60 170 1665 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 1870 SQL Sentry Silver Sponsor http://www.sqlsentry.net http://www.sqlsentry.net/images/ext/SQLSentryLogo148.jpg 60 170 1777 Agile Bay Silver Sponsor http://www.agilebay.com http://dl.dropbox.com/u/26442812/logo350x70.gif 60 170 1706 GrapeCity, Inc. Silver Sponsor http://www.gcpowertools.com http://www.gcpowertools.com/Img/Company/GCPT170logo.jpg 60 170 1800 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1863 Linchpin People LLC Bronze Sponsor http://www.linchpinpeople.com http://linchpinpeople.com/wp-content/uploads/2012/02/linchpin_logo_trans.png 60 170 1866 Incepture Bronze Sponsor http://www.incepture.com http://www.sqlsaturday.com/files/1a18ab18-c2da-4a42-9bfc-164c761159f6.jpg 60 170 1877 Morgan Kaufmann Book http://www.mkp.com http://mkp.com/wp-content/themes/Reshma_MK/images/mk_logo.jpg 40 100 1834 MarkTab Consulting Blog Sponsor http://www.marktab.net http://www.marktab.net/images/MarkTabNet_100x40.gif 40 100 1733 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 1701 StrateSQL Blog Sponsor http://www.jasonstrate.com/ http://www.jasonstrate.com/images/StrateSQLBanner.jpg 40 100 6163 Jim Murphy B In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works. 3/10/2012 8:00:00 AM 3/10/2012 9:00:00 AM 6165 Suresh Rajappa LaTam Upstairs This dession discusses the common design pitfalls when implementing EDW and how to avoid them. This session includes the realworld example too. 3/10/2012 10:30:00 AM 3/10/2012 11:30:00 AM 6175 William E. Pearson III A As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence. 3/10/2012 8:00:00 AM 3/10/2012 9:00:00 AM 6192 Robert Biddle C You've just been assigned a data warehouse project. Maybe you've figured out what tables you want to work with, but outside of that you don't really know how to get started. In this session you'll learn how to load a data warehouse using SSIS, as well as techniques that you can use for any platform. 3/10/2012 2:15:00 PM 3/10/2012 3:15:00 PM 6195 Devin Knight A 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. 3/10/2012 4:45:00 PM 3/10/2012 5:45:00 PM 6198 Jose Chinchilla B Microsoft has shifted gears towards the new Business Intelligence Semantic Model (BISM) in SQL Server 2012. But what does it mean to Analysis Services cube developers? Join Jose to understand what BISM is and the Analysis Services roadmap. Jose will demo how to develop and deploy BISM models to the new Vertipaq engine and how to interface with them. 3/10/2012 4:45:00 PM 3/10/2012 5:45:00 PM 6206 Josh Fennessy LaTam Upstairs Often missing from many BI projects is the ability for users to quickly and effectively submit data BACK to the reporting system. Luckily, when these reporting systems are built from a SSAS cube foundation, we have a potential answer. Writeback is often an underused feature in SSAS cubes. In this session, attendees will learn how to create their own writeback partitions, and create end user interfaces to submit data to them in Excel. Also a deep-dive into the architecture of the writeback implementation in SSAS will be covered, as well as some limitations to the technology that are important to know before designing a solution. 3/10/2012 2:15:00 PM 3/10/2012 3:15:00 PM 6212 Janis Griffin C 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. 3/10/2012 9:15:00 AM 3/10/2012 10:15:00 AM 6243 David Eichner A 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. 3/10/2012 2:15:00 PM 3/10/2012 3:15:00 PM 6268 Chris Albrektson A Are you still ramping up on SSRS? In this session Chris will show you how to create your first SSRS report. In this session we will cover all of the basics including some best practices to get you up to speed when creating reports. This session was designed for someone with little to no experience with SSRS. 3/10/2012 1:00:00 PM 3/10/2012 2:00:00 PM 6269 Michael Hinckley LaTam Downstairs This session is an overview of the various BI solutions within SharePoint highlighting the scopes of each and who and what it takes to get them deployed. Starting with Excel, PowerPivot, Performance Point and InfoPath Services. 3/10/2012 10:30:00 AM 3/10/2012 11:30:00 AM 6314 Nathan Heaivilin Cafe Ever wonder what happens when a query is processed? Got a process that is running slow at the office and your boss in looking at you for answers? Want to look like a hero to your boss for fixing something that no one else could figure out? Then you might want to consider this session. Execution plans tell you what steps were taken to generate the results sets you did. In analyzing these plans, you can figure out what you are doing that is not efficient, so you can fix it. This session will give you the foundation you will need to do analysis so you can write better code and help your company with their performance issues. 3/10/2012 2:15:00 PM 3/10/2012 3:15:00 PM 6407 Rob Volk LaTam Upstairs 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! 3/10/2012 4:45:00 PM 3/10/2012 5:45:00 PM 6632 Kevin Boles LaTam Upstairs This is a wonderful session for those that don't yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples. We will also show how bad performance can be when suboptimal joins are used. 3/10/2012 8:00:00 AM 3/10/2012 9:00:00 AM 6634 Kevin Boles Cafe Time for another deep dive from TheSQLGuru, this time on the transaction log. Architecture and internals, monitoring, tuning/optimizing will all be covered. A great learning experience on another pillar of the SQL Server relational engine. 3/10/2012 3:30:00 PM 3/10/2012 4:30:00 PM 6644 Michael Antonovich LaTam Downstairs In this session, we will examine how to create connections to an external data source (SQL Server) using SharePoint Designer. Once the External Data Content Type exists, we can display and manipulate the data within SharePoint using an External List. But you will see in this session that you can also surface the data to Outlook and use the data in a disconnected mode. You will also see how to use external data sources within a Word document template with the assistance of QuickParts. The final demonstration (time permitting) shows how you can use the external data in an InfoPath form. 3/10/2012 9:15:00 AM 3/10/2012 10:15:00 AM 6655 Rob Volk A 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! 3/10/2012 10:30:00 AM 3/10/2012 11:30:00 AM 6710 Max Trinidad LaTam Downstairs This session will show the side-by-side similarity in building a PowerShell query vs T-SQL. I will demo some scripting techiniques in buidling a PowerShell query, building Hash table objects, ways to read and display the information. If the person knows how-to write T-SQL script, then it makes it easy to understand How-To write a PowerShell query. 3/10/2012 1:00:00 PM 3/10/2012 2:00:00 PM 6720 Andy Warren A SQL Server has a robust and granular system for granting and denying access to users, but all too often we see applications running as DBO or even sysadmin. Why? Part of is that same granular system can be overwhelming and part is that many developers don't see the point in applying such granular security. In this introductory level presentation we'll start at the beginning with creating and managing logins, take a quick look at system roles, and then get into the nitty gritty of users and roles and permissions at the database level. Along the way we'll talk about why its so important to set security at the database and not just rely on the application enforced security. 3/10/2012 9:15:00 AM 3/10/2012 10:15:00 AM 6742 Dmitri Korotkevitch Cafe Messages, Queues, Contracts, Services, Routes, Endpoints, Transport and Dialog security…What could be easier to understand? While complexity of implementation is one of the factors that make us afraid of using service broker there is another one - we often don't recognize the use cases where service broker would benefit a system. This session focuses on the latter case. While it provides very high level overview of Service Broker Architecture, the goal of this presentation is to discuss WHEN to use Service Broker. This session outlines several service broker-friendly patterns and shows a few examples based on real life Service Broker implementations in both centralized and distributed systems. 3/10/2012 1:00:00 PM 3/10/2012 2:00:00 PM 6805 Wayne Sheffield C Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, 'When do I use one or the other and what are the various impacts of doing so?' 3/10/2012 3:30:00 PM 3/10/2012 4:30:00 PM 6847 Chris Price B 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 out-of-the-box. 3/10/2012 10:30:00 AM 3/10/2012 11:30:00 AM 6874 Jen Underwood B Get mobilized! Mobile business intelligence and mobile applications are hot in 2012. Learn how to leverage Microsoft Business Intelligence and SQL Server data platform technologies with a variety of mobile devices. The session will cover several options, tips, tricks, best practices and field lessons learned. 3/10/2012 1:00:00 PM 3/10/2012 2:00:00 PM 6893 Bradley Schacht LaTam Downstairs 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. 3/10/2012 8:00:00 AM 3/10/2012 9:00:00 AM 6906 Jason Hofferle LaTam Downstairs The release of PowerShell version 2 introduced a new technology for managing Windows computers remotely. Everyone from desktop support to enterprise administrators can benefit from the capabilities available with PowerShell Remoting. Learn how it works, what it can do and why you want it enabled in your environment. 3/10/2012 2:15:00 PM 3/10/2012 3:15:00 PM 6920 Allen White LaTam Downstairs We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly. 3/10/2012 3:30:00 PM 3/10/2012 4:30:00 PM 7033 Gareth Swanepoel B 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. 3/10/2012 9:15:00 AM 3/10/2012 10:15:00 AM 7044 Christina Leo Cafe 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. 3/10/2012 8:00:00 AM 3/10/2012 9:00:00 AM 7074 David Liebman Cafe In this session we will take a look at some strategies for building Business Intelligence solutions on the Windows Azure platform. We’ll see methods for transferring on-premises data to the cloud, report deployment to Windows Azure Reporting Services and options for performing ad-hoc analysis. We’ll look at some of the challenges faced when moving BI into the cloud, such as high-performance ETL, schema management and transient fault handling. 3/10/2012 4:45:00 PM 3/10/2012 5:45:00 PM 7147 Sebastian Meine LaTam Upstairs This presentation looks behind the scenes of how SQL Server physically organizes the data on disk. We will talk about Heaps, B+Trees, RIDs, Keys, Seeks and Scans. The materials covered will allow you to make a more informed decision about what type of index to use when. 3/10/2012 9:15:00 AM 3/10/2012 10:15:00 AM 7150 Jorge Segarra C 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! 3/10/2012 8:00:00 AM 3/10/2012 9:00:00 AM 7330 Brian Kelley C 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. 3/10/2012 1:00:00 PM 3/10/2012 2:00:00 PM 7339 Jeffrey Garbus Cafe This session provides 2 case studies of poorly performing T-SQL code, and works through rewrites into better performing code. 3/10/2012 9:15:00 AM 3/10/2012 10:15:00 AM 7393 Russell Fustino LaTam Upstairs When you are working on a project that involves photos, where are you going to store your photos? How will you review your photos? A free solution would be nice, huh? ? Lots of storage would be nice as well! How about using photos in a Phone 7 app?Answer… SkyDrive. It’s great! It is a solution to for easy free way to share, print, download and review photos from just an individual, or from a team of multiple editors. To check, it out ahead of time, go to http://skydrive.live.com and the developer portal at: http://msdn.microsoft.com/en-us/windowslive. We will take a look at the SkyDrive Connect API’s and the SkyDrive Phone 7 app as well! 3/10/2012 3:30:00 PM 3/10/2012 4:30:00 PM 7460 Eddie Wuerch Cafe 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. 3/10/2012 10:30:00 AM 3/10/2012 11:30:00 AM 7522 Robert Hatton LaTam Upstairs Nearly every Data Warehouse, Data Mart, or OLAP Cube is challenged by changes over time. How do you report on a store that was in a different territory last year? What do you do when a product changes categories? This session will show you how to design SQL Tables that model time and accurately model changes over time. 3/10/2012 1:00:00 PM 3/10/2012 2:00:00 PM 7541 Richie Rump C The IT industry is now being dominated by projects. This session is designed to present a high-level foundational knowledge of the project management process as defined by the Project Management Institute. It will also focus on the tools that data professionals can use to deliver projects ontime and on budget. 3/10/2012 4:45:00 PM 3/10/2012 5:45:00 PM 7548 James McAuliffe B 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. Using the new features of Statistical Semantic Search in SQL 2012 is 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 explore will include automatic tag extraction, related content discovery, and hierarchical navigation across similar content. 3/10/2012 2:15:00 PM 3/10/2012 3:15:00 PM 7564 Michael Wells B Do you cringe every time 'Patch Tuesday' rolls around? Does the idea of applying 70-80% fewer Windows patches on your SQL Servers appeal to you? Join us and learn about this and other benefits that can be achieved by running SQL Server 2012 (Denali) on the Core edition of Windows Server. While Core edition has been used primarily for infrastructure servers like Domain Controllers and DNS servers, SQL Server 2012 now brings support for running the database engine. This session will talk about when you may want to consider running SQL on Server Core and will guide you through the task of installing and configuring your server when you no longer have most of the Windows configuration tools that you may be used to. 3/10/2012 3:30:00 PM 3/10/2012 4:30:00 PM 7578 Luis Figueroa LaTam Downstairs In this session Luis will demonstrate how to use change tracking and Change Data Capture to very quickly update data warehouse dimensions. He will cover different SQL Server 2008 scenarios and the new Change Data Capture functionality in SSIS 2012. 3/10/2012 4:45:00 PM 3/10/2012 5:45:00 PM 7619 Brian McDonald A 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!!! 3/10/2012 3:30:00 PM 3/10/2012 4:30:00 PM 7634 Kendal Van Dyke C As the number of SQL Server versions and features grow over time so does the the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn't enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up clustering? Or maybe you want to try out the latest SQL 2012 release candidate...virtualization offers a convenient way to do any or all of these. In this session we'll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual playground on your own machine. 3/10/2012 10:30:00 AM 3/10/2012 11:30:00 AM 7787 Pam Shaw C Lunch will be served next door at the Cantina. 3/10/2012 11:45:00 AM 3/10/2012 12:45:00 PM 7787 Pam Shaw Cafe Lunch will be served next door at the Cantina. 3/10/2012 11:45:00 AM 3/10/2012 12:45:00 PM 7787 Pam Shaw A Lunch will be served next door at the Cantina. 3/10/2012 11:45:00 AM 3/10/2012 12:45:00 PM 7787 Pam Shaw B Lunch will be served next door at the Cantina. 3/10/2012 11:45:00 AM 3/10/2012 12:45:00 PM 7787 Pam Shaw LaTam Downstairs Lunch will be served next door at the Cantina. 3/10/2012 11:45:00 AM 3/10/2012 12:45:00 PM 7787 Pam Shaw LaTam Upstairs Lunch will be served next door at the Cantina. 3/10/2012 11:45:00 AM 3/10/2012 12:45:00 PM