SQLSaturday #103 - Curacao 2012

Event Date: 02/25/2012 00:00:00

Event Location:

University of Curacao
111 Jan Noorduynweg
Willemstad, Curaçao, Netherlands Antilles

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: Tame Your Unruly Data…With Constraints!

Abstract: 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!

Speaker(s):

Rob Volk

Track and Room: BI and T-SQL tracks - N/A

Title: Getting Started with MDX

Abstract: 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.

Speaker(s):

William E Pearson III

Track and Room: BI and T-SQL tracks - N/A

Title: What, When and Who - Auditing 101

Abstract: 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.

Speaker(s):

Roy Ernest

Track and Room: DBA Tracks - N/A

Title: It is TEMPDB, Why Should You Care?

Abstract: 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.

Speaker(s):

Tim Radney

Track and Room: DBA Tracks - N/A

Title: What when and why - Resource Governor

Abstract: 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.

Speaker(s):

Roy Ernest

Track and Room: DBA Tracks - N/A

Title: You Inherited a Database, Now What?

Abstract: 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.

Speaker(s):

Tim Radney

Track and Room: DBA Tracks - N/A

Title: Getting involved and Getting ahead

Abstract: In this session you will hear from Tim Radney why you should involve yourself in organisation like SQL Pass.

Speaker(s):

Tim Radney

Track and Room: DBA Tracks - N/A

Title: PowerPivot for Excel 2010

Abstract: 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.

Speaker(s):

William E Pearson III

Track and Room: BI and T-SQL tracks - N/A

Title: Revenge: The SQL!

Abstract: 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!

Speaker(s):

Rob Volk

Track and Room: BI and T-SQL tracks - N/A

Title: SQL Server 2008 Policy-Based Management (PBM)

Abstract: 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.

Speaker(s):

Rohan Joackhim

Track and Room: DBA Tracks - N/A

Title: Serene Velocity: Reporting Services and SSAS 2008

Abstract: 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.

Speaker(s):

William E Pearson III

Track and Room: BI and T-SQL tracks - N/A

Title: Revenge: The SQL Part 2: The Sequel!

Abstract: 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!

Speaker(s):

Rob Volk

Track and Room: BI and T-SQL tracks - N/A

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Tim Radney

Twitter: - @tradney

LinkedIn: Tim Radney

Contact: http://www.timradney.com

Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

Contact: http://weblogs.sqlteam.com/robv/

Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

Contact: http://weblogs.sqlteam.com/robv/

Tim Radney

Twitter: - @tradney

LinkedIn: Tim Radney

Contact: http://www.timradney.com

Roy Ernest

Twitter: - @RumblingDBA

LinkedIn: Roy Ernest

Contact: http://www.sqlservercentral.com/blogs/dba_rumblings/

Roy Ernest (Twitter: @RumblingDBA) currently works as the Manager of the IT-DBA Department for Zarb Corporation. He is the Leader of the Curacao SQL Server User group. Roy is very active in the SQL Server community and volunteers his time for the PASS organization. You can read his blog at http://www.sqlservercentral.com/blogs/dba_rumblings/default.aspx.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Rohan Joackhim

Twitter: - @rohanjoackhim

LinkedIn: Rohan Joackhim

Rohan has been working with SQL Server since 2001. His experience includes SQL Server projects dealing with HP Europe, financial institutions in Canada and data centers in the Dutch Caribbean. He is currently dealing with databases in 24/7 high availability environments . He was an active member and a presenter of the PASS chapter Toronto. Rohan holds a Bachelor of Computer Engineering degree and he is MCDBA SQL Server 2008 and ITIL V3 certified.

Tim Radney

Twitter: - @tradney

LinkedIn: Tim Radney

Contact: http://www.timradney.com

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

Contact: http://weblogs.sqlteam.com/robv/

Roy Ernest

Twitter: - @RumblingDBA

LinkedIn: Roy Ernest

Contact: http://www.sqlservercentral.com/blogs/dba_rumblings/