sqlsathistory

Nr: 47

SQLSaturday #47 - Phoenix 2011

Start Time (24h)	Speaker	Track	Title
00:00:00	Amy Lewis	Track 3	First Flight: Taking off with Analysis Services
00:00:00	Amy Lewis	Track 3	First Flight: Earn your ETL wings with SSIS
00:00:00	Bill Ramos	Track 4	SQL Server Data Collection Strategies
00:00:00	Bill Ramos	Track 1	The Making of the SQL Server Denali Always On Dash
00:00:00	Meredith Ryan-Smith	Track 1	Backup Basics - Knowing your Options and When to
00:00:00	Colin Smith	Track 1	Powershell for the DBA
00:00:00	Denise McInerney	Track 2	DBA as Protector of the Data: Notes from the Field
00:00:00	Dale Cunningham	Track 1	Using Confio Ignite 8 for Production Failures
00:00:00	Ira Warren	Track 5	(SSIS, TSQL and MDS) - Record Linkage(Fuzzy Matchi
00:00:00	Ira Warren	Track 3	Creating a Metadata Mart w/ SSIS - Data Governance
00:00:00	Janis Griffin	Track 1	Tuna Helper - Proven Process for Tuning SQL
00:00:00	Janis Griffin	Track 4	Performance Management – 2008 MDW - How Why
00:00:00	Jonathan Atkins	Track 2	TSQL Fun - Avoiding cursors
00:00:00	John Racer	Track 3	Empowering End Users with Report Models
00:00:00	John Racer	Track 4	Where Are My Reports? Managing Reporting Services
00:00:00	Michael Collins	Track 2	Database Development using Visual Studio
00:00:00	Michael Collins	Track 5	Introduction to Microsoft SQL Azure
00:00:00	Denny Cherry	Track 4	Back To Basics; Getting Back To The Basics of SQL
00:00:00	Denny Cherry	Track 4	Where should I be encrypting my data?
00:00:00	Denny Cherry	Track 1	SQL Server Clustering 101
00:00:00	Meredith Ryan-Smith	Track 5	Work/Life Balance? Just A Myth?
00:00:00	ORION GEBREMEDHIN	Track 3	SSRS-Subscriptions Render Device Settings
00:00:00	ORION GEBREMEDHIN	Track 3	SSAS Partitioning and Usage Based Optimization
00:00:00	Robert Miller	Track 6	MIrroring 101
00:00:00	Robert Miller	Track 6	Manage and Monitor Your Mirror
00:00:00	Tara Kizer	Track 5	Performance Tuning with Traces
00:00:00	William E Pearson III	Track 5	Getting Started with MDX
00:00:00	William E Pearson III	Track 5	Entity Strategies: Structuring Your Consultancy
00:00:00	Zach Mattson	Track 2	Powershell Eye for the Monitoring Guy

SessionID: 28645

First Flight: Taking off with Analysis Services

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Amy Lewis

Title: First Flight: Taking off with Analysis Services

Abstract:

Come learn how to create your first cube using SSAS. In this session, we will start from scratch and

create an Analysis Services solution including setting up the data source, data source view, dimensions, hierarchies, attribute relationships, and creating some custom measures. At the end of the session we will browse the cube using Excel to create some ad-hoc reports.

SessionID: 28646

First Flight: Earn your ETL wings with SSIS

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Amy Lewis

Title: First Flight: Earn your ETL wings with SSIS

Abstract:

Come learn how to use Integration Services to create an ETL (Extract, Transform, and Load) solution for populating

your data marts/data warehouse. This session will cover best practices for dimension and fact table loading, package configurations, package variables, error and event handling, and SSIS package deployments.

SessionID: 29048

SQL Server Data Collection Strategies

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 4

Speaker: Bill Ramos

Title: SQL Server Data Collection Strategies

Abstract:

In this sessions, you will learn about the various data collection strategies that are available for SQL Server 2008 R2 and with System Center Operations Manager to help you in troubleshooting and capacity planning for your applications. You'll see what strategies you can use during application development, deployment, and operating in production. You'll also learn how to use the data collected for capacity planning.

SessionID: 29049

The Making of the SQL Server Denali Always On Dash

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Bill Ramos

Title: The Making of the SQL Server Denali Always On Dash

Abstract:

SessionID: 29583

Backup Basics - Knowing your Options and When to

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Meredith Ryan-Smith

Title: Backup Basics - Knowing your Options and When to

Abstract:

Creating backups is one of the fundamental skills every DBA should know, but there are a plethora of choices when it comes to how you will back up your databases. Learn the options with SQL server, what each choice will do for you and when to use each one.

SessionID: 29586

Powershell for the DBA

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Colin Smith

Title: Powershell for the DBA

Abstract:

This will be a 100 level class that discusses the basics of powershell, how to set it up, how to use it, and how it will help the DBA be more productive.

SessionID: 29893

DBA as Protector of the Data: Notes from the Field

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Denise McInerney

Title: DBA as Protector of the Data: Notes from the Field

Abstract:

The DBA can be the last line of defense guarding the integrity of their company’s data. Taking this responsibility seriously will make you more successful in your job. This session will discuss how the DBA can proactively ensure the data in their transactional system is clean and correct. The presenter will take a comprehensive view of this crucial aspect of the DBA’s job, drawing on many real-life examples. The topics covered will include table design, transactions, change management, and coding standards. She will explain how these distinct topics are actually part of an integrated approach to data protection. The presenter will also describe how pessimism and vigilance can be valuable traits for a DBA.

SessionID: 30191

Using Confio Ignite 8 for Production Failures

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Dale Cunningham

Title: Using Confio Ignite 8 for Production Failures

Abstract:

A real life application of the Confio product Ignite8 to solve one companies serious production issues. This session will touch on many SQL Server tools, disciplines and resources and bring them all together into a synergy of useful index generation, interpreting execution plans, and using Benchmark Factory to get real performance measurements.

SessionID: 30395

(SSIS, TSQL and MDS) - Record Linkage(Fuzzy Matchi

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 5

Speaker: Ira Warren

Title: (SSIS, TSQL and MDS) - Record Linkage(Fuzzy Matchi

Abstract:

We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSIS and MDS). There are many facets to review. I would like to start by drawing concepts from several articles from experienced practitioners, either from academia or the commercial market. They will be footnoted at the end of the session. Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms

SessionID: 30396

Creating a Metadata Mart w/ SSIS - Data Governance

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Ira Warren

Title: Creating a Metadata Mart w/ SSIS - Data Governance

Abstract:

Recently I have had a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would have taken 1000's of hours of manual coding. For this client we implemented a reusable data driven architecture , via SSIS, that relys on a metadata mart. The end result a greatly reduced TCO(developemnt effort) for generating the code required vs manual cosing. In addition the process leaves behind a metadata mart to report on for auditing and other Data Governance efforts. We generated over 100,000 lines of code and over 3000 load scripts

SessionID: 30423

Tuna Helper - Proven Process for Tuning SQL

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Janis Griffin

Title: Tuna Helper - Proven Process for Tuning SQL

Abstract:

Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait type data, column selectivity, and several more that will help you succeed on future tuning projects.

SessionID: 30425

Performance Management – 2008 MDW - How Why

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 4

Speaker: Janis Griffin

Title: Performance Management – 2008 MDW - How Why

Abstract:

Management Data Warehouse (MDW) which was introduced in 2008 can provide DBAs with useful performance information about Disk Usage, Server Activity and Query Statistics. This presentation will explore how to set up MDW, look at its underlying schema / statistics and point out some of its shortcomings in comparison with other performance tools.

SessionID: 31007

TSQL Fun - Avoiding cursors

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Jonathan Atkins

Title: TSQL Fun - Avoiding cursors

Abstract:

Illustrate methods for cursor alternatives including real world examples using:

-set based logic -coalesce -while loops -common table expressions

SessionID: 31061

Empowering End Users with Report Models

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: John Racer

Title: Empowering End Users with Report Models

Abstract:

With the introduction of Report Builder in Reporting Services 2005, end users were given the tools to create self-service Reporting Services reports quickly and easily.

In this session we will discuss concepts of the Report Model including Entities, Attributes, Roles and other components. We will discuss organization and security within the Report Model to protect data and create a logical view for the business. Then we will cover the methods for creation of an over an existing database and modify them to support specific needs. Once we deploy the Report Model we will build reports and see how the evolution of the Report Builder has enhanced the self-service reporting experience.

SessionID: 31062

Where Are My Reports? Managing Reporting Services

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 4

Speaker: John Racer

Title: Where Are My Reports? Managing Reporting Services

Abstract:

Reporting Services has quickly become and enterprise class report delivery system. As such, user adoption can grow quite rapidly and before you know it higher usage can bring the Report Server to its knees. This is why monitoring and maintaining reporting services from the beginning is important part of any deployment.

In this session we will cover common scenarios for monitoring reporting services performance, tracking down performance issues and troubleshooting errors. We will also review solutions to improve performance in the report execution and engine configuration. Finally, we will discuss techniques to scale up and scale out to distribute load and isolate various forms of activity.

SessionID: 31768

Database Development using Visual Studio

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Michael Collins

Title: Database Development using Visual Studio

Abstract:

In this session, we'll look at using Visual Studio Database Edition tools in Visual Studio 2008 and 2010 to develop and deploy databases. We'll review how to manage your database changes, publish incremental changes to a development database, and how to deploy your database into a production environment.

SessionID: 31769

Introduction to Microsoft SQL Azure

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 5

Speaker: Michael Collins

Title: Introduction to Microsoft SQL Azure

Abstract:

You can't develop software in 2010 without considering the impact of running applications in the cloud instead of your own servers. Microsoft has expanded SQL Server to the cloud with SQL Azure. In this session, we'll take a look at SQL Azure and how to get started with it. We'll cover best practices of developing solutions based around SQL Azure. Finally, we'll cover what features that SQL Azure doesn't have and things that you have to know when developing applications for the Azure platform.

SessionID: 31983

Back To Basics; Getting Back To The Basics of SQL

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 4

Speaker: Denny Cherry

Title: Back To Basics; Getting Back To The Basics of SQL

Abstract:

We will be getting back to the basics of Microsoft SQL Server and looking in depth at all of the object types within SQL Server as well as the commands to work with them.

All to often people focus on the advanced high end parts of SQL Server without getting a good grounding in the basics of SQL Server.

SessionID: 31984

Where should I be encrypting my data?

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 4

Speaker: Denny Cherry

Title: Where should I be encrypting my data?

Abstract:

In this session we'll be looking at all the various places within the application stack that data can be encrypted. This includes the application layer, the database layer, encrypting over the wire, transparent data encryption, encrypting using your MPIO driver and offloading encryption to your HBAs.

SessionID: 31985

SQL Server Clustering 101

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Denny Cherry

Title: SQL Server Clustering 101

Abstract:

In this session we will cover the basics and delve into the advanced techniques which can be used to cluster Windows servers using the Windows Cluster Service, what sort of protection this provides you, and how to properly set up your clusters for a rock solid environment which will last you for many years to come. We will start with planning our cluster configuration, selecting our software, and walk through the process of clustering two servers together into an active passive cluster. We will cover the differences between a standalone machine and clusters with regard to licensing and multiple instance configurations.

SessionID: 32021

Work/Life Balance? Just A Myth?

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 5

Speaker: Meredith Ryan-Smith

Title: Work/Life Balance? Just A Myth?

Abstract:

SessionID: 32137

SSRS-Subscriptions Render Device Settings

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: ORION GEBREMEDHIN

Title: SSRS-Subscriptions Render Device Settings

Abstract:

This session will deal with a detailed explanation of SSRS report delivery methods. And will focus on the two types of report delivery subscriptions; standard and Data Driven Subscriptions. A working demonstration of both methods will be shown. In the render device settings, we will discuss how we can can use device information settings on the report server to customize rendering and to override the default values that are supplied by the server. A practical demonstration will be provided.

SessionID: 32138

SSAS Partitioning and Usage Based Optimization

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: ORION GEBREMEDHIN

Title: SSAS Partitioning and Usage Based Optimization

Abstract:

This session will describe OLAP Cube partitioning with practical examples. Hands on demonstration of OLAP cube Usage Based Optimization will be performed. The session will identify the QueryLogTable and QueryLogSampling settings , and how the contents of the QueryLogTable are used will be explained with practical examples.

SessionID: 32529

MIrroring 101

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 6

Speaker: Robert Miller

Title: MIrroring 101

Abstract:

An overview of Database Mirroring.

SessionID: 32591

Manage and Monitor Your Mirror

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 6

Speaker: Robert Miller

Title: Manage and Monitor Your Mirror

Abstract:

After creating and activating a Database Mirror, how do you manage and monitor your Mirror?

SessionID: 33312

Performance Tuning with Traces

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 5

Speaker: Tara Kizer

Title: Performance Tuning with Traces

Abstract:

We'll touch on SQL Profiler and review its best practices so that you don't impact the production system while gathering data. We'll take a deep dive into server-side traces (SQL Trace) and show how you can run a constant server-side trace with little impact on the production system. We'll also examine the things that I look for when troubleshooting performance issues.

SessionID: 33906

Getting Started with MDX

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 5

Speaker: William E Pearson III

Title: Getting Started with MDX

Abstract:

In this session 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: 33914

Entity Strategies: Structuring Your Consultancy

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 5

Speaker: William E Pearson III

Title: Entity Strategies: Structuring Your Consultancy

Abstract:

Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity.

SessionID: 34522

Powershell Eye for the Monitoring Guy

Back to calendar

Event Date: 19-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Zach Mattson

Title: Powershell Eye for the Monitoring Guy

Abstract:

Server monitoring can be expensive and is generally licensed for only critical production servers. In this session, learn how to utilize Powershell along with SMO to not only be proactive, but productive in monitoring the servers in your environment. Attendees will come away from the session with an understanding of how to read the server event logs, check backups, and collect performance metrics. This will be useful for general monitoring in your environment and can also be used for collecting data in a physical to virtual migration.

This site is open source. Improve this page.