Nr: 103
SQLSaturday #103 - Curacao 2012
SessionID: 23482
What, When and Who - Auditing 101
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: DBA Tracks
Speaker: Roy Ernest
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.
SessionID: 26676
Getting involved and Getting ahead
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: DBA Tracks
Speaker: Tim Radney
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.
SessionID: 27843
Serene Velocity: Reporting Services and SSAS 2008
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: BI and T-SQL tracks
Speaker: William E Pearson III
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.
SessionID: 32522
SQL Server 2008 Policy-Based Management (PBM)
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: DBA Tracks
Speaker: Rohan Joackhim
Title: SQL Server 2008 Policy-Based Management (PBM)
Abstract:
SessionID: 32564
Revenge: The SQL Part 2: The Sequel!
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: BI and T-SQL tracks
Speaker: Rob Volk
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!
SessionID: 32565
Revenge: The SQL!
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: BI and T-SQL tracks
Speaker: Rob Volk
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!
SessionID: 32567
Tame Your Unruly Data...With Constraints!
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: BI and T-SQL tracks
Speaker: Rob Volk
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!
SessionID: 32668
What when and why - Resource Governor
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: DBA Tracks
Speaker: Roy Ernest
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.
SessionID: 33614
You Inherited a Database, Now What?
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: DBA Tracks
Speaker: Tim Radney
Title: You Inherited a Database, Now What?
Abstract:
SessionID: 33615
It is TEMPDB, Why Should You Care?
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: DBA Tracks
Speaker: Tim Radney
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.
SessionID: 34368
Getting Started with MDX
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: BI and T-SQL tracks
Speaker: William E Pearson III
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.
SessionID: 34370
PowerPivot for Excel 2010
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: BI and T-SQL tracks
Speaker: William E Pearson III
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.