SQLSaturday #103 - Curacao 2012 2/25/2012 12:00:00 AM (GMT-04:00) Caracas, La Paz SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat103 Curacao , Netherlands Antilles 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 1630 Red Gate Software Ltd Gold Sponsor http://www.red-gate.com/ http://www.red-gate.com/archive/redgatelogo_black.jpg 60 170 1782 University of the Netherlands Antilles Gold Sponsor http://www.una.an/ http://www.sqlsaturday.com/files/95ec98d4-d80d-41f6-abb2-be7f75fa43b0.PNG 60 170 1783 OReilly Silver Sponsor http://oreilly.com/ http://cdn.oreilly.com/images/sitewide-headers/ml-header-community.png 60 170 1730 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 60 170 1830 MarkTab Consulting Blog Sponsor http://www.marktab.net http://www.marktab.net/images/MarkTabNet_100x40.gif 60 170 1852 SQLvariant Blog Sponsor http://sqlvariant.com/wordpress http://sqlvariant.com/BlogSupport/Images/SQLvariant_Logo.png 60 170 1905 Radney Consulting Blog Sponsor http://www.timradney.com http://tradney.files.wordpress.com/2011/06/me2.jpg 60 170 5863 William E. Pearson III BI and T-SQL tracks UNA Classroom 1 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. 2/25/2012 9:00:00 AM 2/25/2012 10:00:00 AM 5865 William E. Pearson III BI and T-SQL tracks UNA Classroom 1 Microsoft BI Architect and SQL Server MVP Bill Pearson overviews PowerPivot for Excel, the client side of Microsoft’s foray into self-service BI. The targeted audience includes BI professionals who are seeking an introduction to what PowerPivot offers their organizations. Among others interested will be Excel power users who are fluent with PivotTables and want to understand the new capabilities. 2/25/2012 11:15:00 AM 2/25/2012 12:15:00 PM 5866 Roy Ernest DBA Tracks UNA Classroom 2 This presentation will explain the three W's (What, When and Why) regarding Resource governor, This presentation will also provide some Best practice guides for using Resource governor. We will also look at its limitations as well. We will look in depth the three basic fundamentals to the resource governor: Resource pool, workload group and classifier functions. We will also be looking at how to leverage the Resource governors to control runaway queries, limiting parallelism. 2/25/2012 2:45:00 PM 2/25/2012 3:45:00 PM 5882 Rohan Joackhim DBA Tracks UNA Classroom 2 This session will take you from the basics to the intermediate level of policy based management (PBM) in SQL Server 2008.What are Facets, Policies, Categories and Execution Modes? How you can manage over 500 SQL Server instances in a high availability environment using predefined policies? What policies are important for you and how to implement them? How do we evaluate and find out the failed policies? All these will be answered during this presentation. 2/25/2012 4:00:00 PM 2/25/2012 5:00:00 PM 5948 Tim Radney DBA Tracks UNA Classroom 2 You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. Whether you are a seasoned DBA or just starting out, this session should be informative and something you can relate to. 2/25/2012 11:15:00 AM 2/25/2012 12:15:00 PM 5949 Tim Radney DBA Tracks UNA Classroom 2 TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session. 2/25/2012 9:00:00 AM 2/25/2012 10:00:00 AM 7056 Rob Volk BI and T-SQL tracks UNA Classroom 1 In a world…where DBAs are blamed, mistreated, and overworked…one man….WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, hiding and obfuscating data and code, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys! 2/25/2012 4:00:00 PM 2/25/2012 5:00:00 PM 7057 Rob Volk BI and T-SQL tracks UNA Classroom 1 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! 2/25/2012 1:30:00 PM 2/25/2012 2:30:00 PM 7059 Rob Volk BI and T-SQL tracks UNA Classroom 1 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! 2/25/2012 10:15:00 AM 2/25/2012 11:15:00 AM 7146 Roy Ernest DBA Tracks UNA Classroom 2 In this interactive session, you will gain a good knowledge on the three new auditing technology introduced in SQL Server 2008 onwards. You will learn how to set up Change tracking, Change Data capture and SQL Audit, its pros and Cons. 2/25/2012 10:15:00 AM 2/25/2012 11:15:00 AM 7941 William Pearson BI and T-SQL tracks UNA Classroom 1 SSRS 2008 R2 provides powerful capabilities to help us develop sophisticated reports from Microsoft SQL Server Analysis Services. Unfortunately, many of these features, such as the server aggregation function, are commonly ignored by report developers. The result: redundant work in the reporting layer. In this session, BI Architect and MVP Bill Pearson exposes ways to optimize reporting from SSAS by writing MDX that leverages, rather than replicates, what the cube is designed to do best. 2/25/2012 2:45:00 PM 2/25/2012 3:45:00 PM 7944 Tim Radney DBA Tracks UNA Classroom 2 In this session you will hear from Tim Radney why you should involve yourself in organisation like SQL Pass. 2/25/2012 1:30:00 PM 2/25/2012 2:30:00 PM