sqlsathistory

Nr: 17

SQLSaturday #17 - Baton Rouge 2009

Start Time (24h)	Speaker	Track	Title
00:00:00	Brad McDonald	Infrastructure	The Basics of Scrum and Why it Works
00:00:00	Barry Ralston	BI/SQL Admin	BI Solutions for a Tough Economy
00:00:00	Brian Rigsby	.Net	Zen Coding
00:00:00	Joseph Besse	.Net	Test Driven Development
00:00:00	John Lauer	BI/SQL Admin	Providing Enhanced Business Value Using Scorecards
00:00:00	Mark Verret	SQL Development	SQL 2008 Reporting Services - Getting Started
00:00:00	Michael Moles	Infrastructure	TFS/VSTS 2010 sneak peek
00:00:00	Phillip Jackson	.Net	Codecraft
00:00:00	Phillip Jackson	SQL Development	Table-Valued Parameters (TVP)
00:00:00	Patrick LeBlanc	SQL Development	Introduction SQL Profiler
00:00:00	Ryan Duclos	.Net	Can you control your reports? (SSRS 2005)
00:00:00	Ryan Duclos	BI/SQL Admin	Reporting Services 2008 - Report Authoring
00:00:00	Ryan Richard	SQL Development	Indexing For Performance
00:00:00	Steve Jones	Infrastructure	The Modern Resume: Building Your Brand
00:00:00	Stacey Hopkins	SQL Development	Geospatial capabilities of SQL 2008
00:00:00	Kevin Boles	Infrastructure	Care and Feeding of TempDB
00:00:00	Kevin Boles	Infrastructure	Disk Partition Alignment
00:00:00	Thomas LeBlanc	BI/SQL Admin	RML Ultities
00:00:00	Tim Mitchell	BI/SQL Admin	SSIS: Beyond the Basics
00:00:00	Tim Mitchell	.Net	Custom ETL using SSIS Scripting
00:00:00	Trevor Barkhouse	Infrastructure	Deadlocks: Detection, Troubleshooting, and Prevent
00:00:00	Joseph Besse	.Net	Windows Communication Foundation
00:00:00	William Assaf	BI/SQL Admin	SSIS Introduction
00:00:00	William Assaf	SQL Development	DMV Overview

SessionID: 35010

The Basics of Scrum and Why it Works

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: Infrastructure

Speaker: Brad McDonald

Title: The Basics of Scrum and Why it Works

Abstract:

Scrum is a lightweight, agile project management framework that allows us to focus on delivering the highest business value in the shortest time. We will discuss real-world implementations from a project management and development perspective.

SessionID: 35024

BI Solutions for a Tough Economy

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: BI/SQL Admin

Speaker: Barry Ralston

Title: BI Solutions for a Tough Economy

Abstract:

Do all stakeholders in your organization ‘know the score’? In this tough economic climate, it is more important than ever to have visibility into the key metrics that determine organizational survival.

Excel Services provides a powerful and flexible tool for increasing visibility of key metrics throughout the organization. Through examples, this session will show attendees the most useful capabilities of Excel Services for collaboration, including Excel-based KPI’s, dashboards and charting. Learn how to leverage Excel experience to rapidly create SharePoint sites to securely share actionable information.

SessionID: 35029

Zen Coding

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: .Net

Speaker: Brian Rigsby

Title: Zen Coding

Abstract:

The philosphy of being a professional code craftsman.

SessionID: 35146

Test Driven Development

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: .Net

Speaker: Joseph Besse

Title: Test Driven Development

Abstract:

Test Driven Development using C#.net and NUnit – Introduction to test driven development and how to create and run tests using C#.net and NUnit.

SessionID: 35200

Providing Enhanced Business Value Using Scorecards

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: BI/SQL Admin

Speaker: John Lauer

Title: Providing Enhanced Business Value Using Scorecards

Abstract:

You hear people talk about scorecards and the differences between scorecards and dashboards. What are those differences and what do they mean to you? Scorecards using Microsoft BI tools are not difficult to create, but without proper planning and design they will miss the mark and fail to provide the desired business benefit. In this session you’ll learn about best practices in creating scorecards, as well as examine some unique client approaches to really get to the heart of the business problem.

SessionID: 35295

SQL 2008 Reporting Services - Getting Started

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: SQL Development

Speaker: Mark Verret

Title: SQL 2008 Reporting Services - Getting Started

Abstract:

Providing relevant data to both systems and end users via SQL 2008 Reporting Services. In this session I will provide an overview of reporting services and demonstrate several methods of deployment, including via Windows Sharepoint Services.

SessionID: 35328

TFS/VSTS 2010 sneak peek

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: Infrastructure

Speaker: Michael Moles

Title: TFS/VSTS 2010 sneak peek

Abstract:

A Look at some of the new cool features in TFS/VSTS 2010. Both from Project Managment, Coding and QA.

SessionID: 35347

Codecraft

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: .Net

Speaker: Phillip Jackson

Title: Codecraft

Abstract:

Winning a round of golf doesn't make you Tiger Woods. Knowing how to ride a bike doesn't make you Lance Armstrong and collecting a salary to do something doesn't mean you are proficient at it. Being able to write software that doesn't break and getting paid for it doesn't make you a professional.

Software development is a craft and, like every other craft, to be a master craftsman you must be one who practices it with great skill. Learn the tools of the craft, the discipline to use them and start your journey to becoming a master craftsman.

SessionID: 35348

Table-Valued Parameters (TVP)

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: SQL Development

Speaker: Phillip Jackson

Title: Table-Valued Parameters (TVP)

Abstract:

Table-valued parameters are a new parameter type in SQL Server 2008. Table-valued parameters are declared by using user-defined table types. You can use table-valued parameters to send multiple rows of data to a Transact-SQL statement or a routine, such as a stored procedure or function, without creating a temporary table or many parameters. Ever wanted to sent a list to a stored procedure? We will show you how!

SessionID: 35367

Introduction SQL Profiler

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: SQL Development

Speaker: Patrick LeBlanc

Title: Introduction SQL Profiler

Abstract:

What is the SQL Profiler? Looking for a trouble shooting tool or a performance tuning tool, then you should be using the SQL Profiler. In this session I will provide an overview of some typical yet practical everyday uses of the SQL Server Profiler.

SessionID: 35383

Can you control your reports? (SSRS 2005)

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: .Net

Speaker: Ryan Duclos

Title: Can you control your reports? (SSRS 2005)

Abstract:

Having trouble or trying to figure out how you can navigate to your reports through your application, without creating a complete dashboard? This session will show you how to navigate and control your reports through your application using links. Also let you know what additional options you have out of the box with the different rendering extensions available.

SessionID: 35384

Reporting Services 2008 - Report Authoring

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: BI/SQL Admin

Speaker: Ryan Duclos

Title: Reporting Services 2008 - Report Authoring

Abstract:

Introduction to Reporting Services 2008 and an overview of some the Report Authoring changes from Reporting Services 2005 and Reporting Services 2008.

SessionID: 35415

Indexing For Performance

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: SQL Development

Speaker: Ryan Richard

Title: Indexing For Performance

Abstract:

Everything you need to know about SQL Server indexing! Specific areas of focus include: understanding index physical structures, evaluating index usefulness and selection, generating and maintaining index statistics, and optimizing queries using indexes. There will be many demonstrations to illustrate key topics and recommendations.

SessionID: 35438

The Modern Resume: Building Your Brand

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: Infrastructure

Speaker: Steve Jones

Title: The Modern Resume: Building Your Brand

Abstract:

SessionID: 35447

Geospatial capabilities of SQL 2008

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: SQL Development

Speaker: Stacey Hopkins

Title: Geospatial capabilities of SQL 2008

Abstract:

What does the introduction of spatial capabilities in SQL Server 2008 mean? In this session we will go over the standards, data types, and implementation of SQL 2008's spatial features. Also, we will discuss how to implement geospatial data and some possible implications and ramifications spatial data that might result.

SessionID: 35470

Care and Feeding of TempDB

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: Infrastructure

Speaker: Kevin Boles

Title: Care and Feeding of TempDB

Abstract:

Well, every single SQL Server instance in existence has a tempDB, so I expect to see everyone in attendance for this presentation on the hows, whys and wheretofors of this very important database!

SessionID: 35471

Disk Partition Alignment

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: Infrastructure

Speaker: Kevin Boles

Title: Disk Partition Alignment

Abstract:

EVERYONE can benefit from this presentation!! Improper disk alignment will rob the server of 15-50% IO throughput capability. We will cover what disk partition alignment really is, how it affects performance and how you can get it done correctly.

SessionID: 35476

RML Ultities

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: BI/SQL Admin

Speaker: Thomas LeBlanc

Title: RML Ultities

Abstract:

Microsoft Support (CSS, formerly PSS) has made available a ultitiy to do an analysis of a trace file. This session will go through an explanation of how to use this utility and interpret the results.

RML Utilities can answer questions about where the most resources are being consumed, queries that are responsilble for heavy usage, changes in plans during trace and if queries are running slow in comparison to other traces.

SessionID: 35477

SSIS: Beyond the Basics

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: BI/SQL Admin

Speaker: Tim Mitchell

Title: SSIS: Beyond the Basics

Abstract:

In this session, we'll explore some of the useful tasks and data flow components of SSIS. Join in as we review the File System Task and the For Each Loop container, as well as data flow components including the Lookup Transformation, the Conditional Split, and the Derived Column. This session will include various demonstrations using SSIS 2008.

SessionID: 35478

Custom ETL using SSIS Scripting

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: .Net

Speaker: Tim Mitchell

Title: Custom ETL using SSIS Scripting

Abstract:

SessionID: 35489

Deadlocks: Detection, Troubleshooting, and Prevent

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: Infrastructure

Speaker: Trevor Barkhouse

Title: Deadlocks: Detection, Troubleshooting, and Prevent

Abstract:

As an enterprise application grows and load increases, some concurrency issues are bound to surface. Deadlocks are one of the more aggravating of this class of problems. Fortunately, each release of SQL Server includes better tools for troubleshooting deadlocks. Trevor will provide a strong foundation on deadlocks and then demonstrate approaches for handling them in SQL Server 2000, 2005, and 2008.

SessionID: 35493

Windows Communication Foundation

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: .Net

Speaker: Joseph Besse

Title: Windows Communication Foundation

Abstract:

Communication breakdown: What is WCF and what you can do with it. We’ll cover the basic ideas behind WCF and then show a practical example of using it to build N-tiered applications.

SessionID: 35515

SSIS Introduction

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: BI/SQL Admin

Speaker: William Assaf

Title: SSIS Introduction

Abstract:

See a sample of what SQL Server Integration Services has to offer with some real-life examples and usage demos that will inspire you to take advantage of the powerful engine of SSIS. Your old DTS packages will shiver in fear.

SessionID: 35517

DMV Overview

Back to calendar

Event Date: 01-08-2009 - Session time: 00:00:00 - Track: SQL Development

Speaker: William Assaf

Title: DMV Overview

Abstract:

A tour of Dynamic Management Views in SQL 2005 and 2008, covering the most important DMV's and getting you started on getting the most you can out of these crucial performance indicators.

This site is open source. Improve this page.