sqlsathistory

Nr: 14

Back to Main list

SQLSaturday #14 - Pensacola 2009

Start Time (24h)	Speaker	Track	Title
00:00:00	Keith Rowe	Room 2172	Database Design Fundamentals
00:00:00	Shawn McGehee	Room 2172	Creating dasboard applications with SSRS and .NET
00:00:00	Steven Lane	Room 2169	WPF - XAML an Introduction
00:00:00	Sven Aelterman	Room 2176	FILESTREAM In Depth
00:00:00	Tim Mitchell	Room 2175	Unconventional ETL using SSIS Scripting
00:00:00	Andy Warren	2142 Auditorium	Introduction to SQL Server Statistics
00:00:00	Andy Warren	Room 2176	What is PASS?
00:00:00	Arie Jones	Room 2175	Streaming Applications using SQL Server 2008 Files
00:00:00	Arie Jones	Room 2172	Consulting Outside the Box: Using Creativity and P
00:00:00	Brian Knight	2142 Auditorium	Introduction to SQL Server Analysis Services(SSAS)
00:00:00	Brian Knight	Room 2176	MDX for SQL Programmers
00:00:00	Brad McGehee	Room 2176	Getting the Most Out of the SQL Server Profiler
00:00:00	Brad McGehee	2142 Auditorium	DBA 101: Best Practices Every DBA Should Know
00:00:00	Bryan Soltis	Room 2169	Integrating Silverlight 2.0 Into Web Applications
00:00:00	Jack Corbett	Room 2176	Getting Start with SQL Server Profiler
00:00:00	Ken Simmons	Room 2172	SQL Server Preproduction Tasks
00:00:00	Kent Waldrop	Room 2176	Apply Here
00:00:00	David Waugh	Room 2175	Using Wait-Time Analysis for Database Performance
00:00:00	Don Demsak	Room 2169	BI (Business Intelligence) For the .Net Guy
00:00:00	Eric Wisdahl	Room 2175	SSIS Configurations, Expressions and Constraints
00:00:00	Nathan Heaivilin	Room 2175	Introduction to Execution Plans
00:00:00	Jessica Moss	Room 2169	Creating Dashboards with PerformancePoint Server 2
00:00:00	Kevin Grohoske	Room 2169	A first look at Visual Studio 2010
00:00:00	Devin Knight	Room 2175	Best Practices and Performance Tuning SSIS
00:00:00	Vincent Mayfield	Room 2169	Building Scalable ASP.NET Applications
00:00:00	Vincent Mayfield	Room 2169	Introduction to Microsoft® Silverlight™
00:00:00	Plamen Ratchev	Room 2172	Advanced SQL Querying Techniques
00:00:00	Plamen Ratchev	Room 2176	Performance Tuning and Query Optimization
00:00:00	Patrick LeBlanc	Room 2175	Near Real-Time Data Warehouse-No Third Party Tools
00:00:00	Pam Shaw	Room 2172	Tips Tricks for dynamic Reporting Services Repor
00:00:00	Ryan Duclos	Room 2172	Reporting Services 2008 - Report Authoring
00:00:00	Russell Fustino	2142 Auditorium	* It's All About The Tools - TV Show Episode 3
00:00:00	Rodney Landrum	2142 Auditorium	The DBA Script Thumb
00:00:00	Steve Jones	2142 Auditorium	The Modern Resume: Building Your Brand

SessionID: 31252

Database Design Fundamentals

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2172

Speaker: Keith Rowe

Title: Database Design Fundamentals

Abstract:

Before you get immersed in all the technical details of SQL Server, let's talk about the fundamentals. What does it mean to normalize a database? How do I pick a natural primary key vs. a sequence? What about naming tables, views, columns, etc? We will use the "chalk talk" format. I will introduce a topic then ask the class to share their ideas and experiences with the topic. We will have plenty of fundamentals to cover, so I will serve as moderator to keep us on track. Quoting cycling great Greg LeMond - "Perhaps the single most important element in mastering the techniques and tactics of racing is experience. But once you have the fundamentals, acquiring the experience is a matter of time."

SessionID: 32912

Creating dasboard applications with SSRS and .NET

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2172

Speaker: Shawn McGehee

Title: Creating dasboard applications with SSRS and .NET

Abstract:

Learn how to create useful dashboard reports for applications and integrate these reports into a .NET application for continual monitoring. We will create a report for a trouble ticketing system and an application to monitor the results with data refreshes and configurable monitoring settings.

SessionID: 33226

WPF - XAML an Introduction

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2169

Speaker: Steven Lane

Title: WPF - XAML an Introduction

Abstract:

This session will be an intoduction to the Windows Presentation Foundation. We will concentrate on XAML and declarative based programming.

SessionID: 33278

FILESTREAM In Depth

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2176

Speaker: Sven Aelterman

Title: FILESTREAM In Depth

Abstract:

SQL Server 2008 introduces a new way to store Binary Large Objects (BLOBs) in the database. This session will provide an introduction to FILESTREAM and then go into several of the uses of FILESTREAM, including n-tier applications and Reporting Services.

SessionID: 33585

Unconventional ETL using SSIS Scripting

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2175

Speaker: Tim Mitchell

Title: Unconventional ETL using SSIS Scripting

Abstract:

In this session, we will explore the Script Task and Script Component tools within SSIS. Learn how to break out of the traditional flat-file ETL mold and, using VB.NET or C#, create custom scripts to address unconventional transformations and related tasks.

SessionID: 34927

Introduction to SQL Server Statistics

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: 2142 Auditorium

Speaker: Andy Warren

Title: Introduction to SQL Server Statistics

Abstract:

This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you're a DBA or trying to get by without one, this session will give you the information you need to know.

SessionID: 34928

What is PASS?

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2176

Speaker: Andy Warren

Title: What is PASS?

Abstract:

PASS is the Professional Assocation of SQL Server, and it's the official not for profit group for SQL Server professionals. We'll talk about the annual PASS Summit (conference), chapters/user groups, regional events like SQLSaturday, and where PASS is going in the future. This will be an informal presentation with lots of time for questions and discussion.

SessionID: 34963

Streaming Applications using SQL Server 2008 Files

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2175

Speaker: Arie Jones

Title: Streaming Applications using SQL Server 2008 Files

Abstract:

SQL Server 2008 introduced the concept of the FILESTREAM support. Most DBAs whom have been around for a while have in one instance or another supported streaming applications by use of the VARBINARY(MAX) datatype in order to store file information within the database architecture. However, this has drastic limitations as the RDBMS are not typically set up to deal with data that is not accessible in terms of pages and extents. FILESTREAM support adds a new paradigm to the database platform by marrying the database system with the NTFS filesystem in order to overcome these old obstacles. In this session, we will delve into FILESTREAM support, what it takes to implement, and some of the extremely cool things that you can do with this new power

SessionID: 34966

Consulting Outside the Box: Using Creativity and P

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2172

Speaker: Arie Jones

Title: Consulting Outside the Box: Using Creativity and P

Abstract:

Often in the consulting world you encounter individuals whom grasp onto logical ideas and parables like Occam's razor “The simplest explanation for a phenomenon is most likely the correct explanation." However, in the database world, reaching these explanations often require more of an artistic flair of creativity in order to reach a successful answer.

This presentation will focus on some of the unique ways in which Perpetual Technologies consulting staff have formulated successful solutions in what seemed to be improbable circumstances and how the same principles can help you in your everyday endeavors.

SessionID: 35008

Introduction to SQL Server Analysis Services(SSAS)

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: 2142 Auditorium

Speaker: Brian Knight

Title: Introduction to SQL Server Analysis Services(SSAS)

Abstract:

In this session you'll learn the necessary information to launch a proof of concept at your company for Analysis Services. You'll learn how SSAS can speed up queries by pre-aggregating data and help you build scorecards and drag-and-drop ad hoc reports.

SessionID: 35009

MDX for SQL Programmers

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2176

Speaker: Brian Knight

Title: MDX for SQL Programmers

Abstract:

This session will introduce the language for accessing data in SQL Server Analysis Services (SSAS) cube structures. SSAS is not just about ad hoc tools and end-user ‘slicing and dicing’ of data. The speaker will present the basic concepts of MDX including hierarchical navigation functions, sorting and ranking and creation of calculated members. The session will incorporate demonstration queries using OLAP structures readily available for self-led follow-up training.

SessionID: 35011

Getting the Most Out of the SQL Server Profiler

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2176

Speaker: Brad McGehee

Title: Getting the Most Out of the SQL Server Profiler

Abstract:

While many DBAs may understand SQL Server 2005/2008 Profiler basics, not too many know how to tap the full potential of this important utility. In this session, DBAs will learn many advanced techniques you can use to troubleshoot both SQL Server problems and performance issues, including: How to Identify and Analyze Slowly Performing Queries, How to Identify Deadlocking Issues, How to Identify Blocked Processes, How to Identify Excessive SP Compilations, How to Identify Excessive Table/Index Scans, How to Identify Memory Problems, and How to Correlate Profiler and System Monitor Data. Given the limited time available, not every possible use of Profiler can be discussed. But by learning these specific examples, the DBA will begin to have a f

SessionID: 35012

DBA 101: Best Practices Every DBA Should Know

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: 2142 Auditorium

Speaker: Brad McGehee

Title: DBA 101: Best Practices Every DBA Should Know

Abstract:

This session, which is designed for part-time or full-time DBAs with one year or less of DBA experience, explores some of the key best practices that all DBAs should be familiar with. The session is divided into two parts. The first covers "Check and Verify," which covers one-time tasks that should be performed on all SQL Servers, and "On-Going Tasks," which cover periodic tasks all DBAs should be performing. Because of time limitations, the focus is on what you need to do, not how to do it. This of this session as a basic checklist of what all DBA need to do to optimize performance and maximize server availablity.

SessionID: 35037

Integrating Silverlight 2.0 Into Web Applications

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2169

Speaker: Bryan Soltis

Title: Integrating Silverlight 2.0 Into Web Applications

Abstract:

A demonstration and walkthrough of techniques used to integrate Deep Zoom, Page Turner, and animations to deliver robust web applications using Silverlight 2.0 and Microsoft .NET technologies.

SessionID: 35061

Getting Start with SQL Server Profiler

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2176

Speaker: Jack Corbett

Title: Getting Start with SQL Server Profiler

Abstract:

Learn how to use SQL Server Profiler to troubleshoot, audit, and tune your SQL Server. Includes creating custom templates, integrating with Performance Monitor data, and creating scripts for creating server-side traces.

SessionID: 35069

SQL Server Preproduction Tasks

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2172

Speaker: Ken Simmons

Title: SQL Server Preproduction Tasks

Abstract:

This session will cover the tasks you need to perform before you hand over a new SQL Server to production in order to keep the server running smoothly. After this session, you should be able to create a script that best suits your organization in order to make moving a server into production a quick and easy process. While the session is geared towards new systems, many of these preproduction considerations apply to existing SQL Servers as well.

SessionID: 35073

Apply Here

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2176

Speaker: Kent Waldrop

Title: Apply Here

Abstract:

MVP Kent Waldrop takes a look at the CROSS APPLY and OUTER APPLY operators and steps through a number of scenarios where these two operators might be useful. Topics included include use of the APPLY operators with table functions, substituting inline table functions for scalar functions to improve performance, use of the APPLY operator in conjunction with XML and more.

SessionID: 35088

Using Wait-Time Analysis for Database Performance

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2175

Speaker: David Waugh

Title: Using Wait-Time Analysis for Database Performance

Abstract:

"Using Wait-Time Analysis for Database Performance Monitoring and

Tuning"

There are many ways to use wait events for performance tuning, but often there is confusion on exactly what the data means. The wait event data may be analyzed at the wrong level or not detailed enough. Confio will focus on these problems and review several real-life case studies using wait event data coupled with Wait-Time based performance analysis to solve the most difficult performance related issues.

SessionID: 35102

BI (Business Intelligence) For the .Net Guy

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2169

Speaker: Don Demsak

Title: BI (Business Intelligence) For the .Net Guy

Abstract:

You have heard the buzz around Business Intelligence and SQL Server Analysis Services 2008, but you’re a .Net developer and are wondering how to add BI to your .Net applications without having to use Reporting Services, well this is the session for you. We will give you a short introduction to SSAS, show you how to build a data access framework on top of the ADOMD.Net provider to gain access to your SQL Server OLAP Cubes, develop parameterized MDX Queries, and expose the query results via WCF and ASP.Net.

SessionID: 35117

SSIS Configurations, Expressions and Constraints

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2175

Speaker: Eric Wisdahl

Title: SSIS Configurations, Expressions and Constraints

Abstract:

This session will look in depth at some of the more powerful aspects of Integrations Services: Expressions, Package Configurations, and Precedence Constraints. A short tutorial will show the users how to build up a package structure to allow logging to a remote location determined through configurations as well as capturing errors, destroying the error file if no errors are present and emailing a configurable user if any errors are found.

SessionID: 35132

Introduction to Execution Plans

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2175

Speaker: Nathan Heaivilin

Title: Introduction to Execution Plans

Abstract:

Execution plans are a great tool for finding performance issues in your code. Learn the basics of how to read them and use that knowledge to tune you queries and maximize your performance.

SessionID: 35187

Creating Dashboards with PerformancePoint Server 2

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2169

Speaker: Jessica Moss

Title: Creating Dashboards with PerformancePoint Server 2

Abstract:

The monitoring and analytics (MA) portion of PerformancePoint Server allows companies to manage their key performance indicators. This session will discuss methods of designing dashboards, deployment scenarios, and ways to integrate SharePoint with the PerformancePoint dashboard. While the next version of the PerformancePoint Server MA will be included in SharePoint, the design concepts from PPS 2007 will still be applicable in future versions.

SessionID: 35277

A first look at Visual Studio 2010

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2169

Speaker: Kevin Grohoske

Title: A first look at Visual Studio 2010

Abstract:

Microsoft has released Beta 1 of Visual Studio 2010. In this presentation we will briefly review the new language and IDE features. We will also review the new built-in capabilities for technologies such as WCF, WF, WPF, AJAX, MVC, and Parallel Computing.

SessionID: 35283

Best Practices and Performance Tuning SSIS

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2175

Speaker: Devin Knight

Title: Best Practices and Performance Tuning SSIS

Abstract:

In this session you will learn some of the most common mistakes in SSIS that can cause performance issues. Then Devin will discuss some best practices that you can take back and use in packages you develop.

SessionID: 35302

Building Scalable ASP.NET Applications

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2169

Speaker: Vincent Mayfield

Title: Building Scalable ASP.NET Applications

Abstract:

Building Scalable ASP.NET Applications for the Enterprise with NLB and Clustering Network Configurations.

Most ASP.NET Developers are able to build ASP.NET Applications. However, few understand the principles of building scalable Enterprise Applications that are deployable in a Network Load Balanced or Clustered Server network configuration. This seminar targets advanced developers who desires to understand the considerations required in designing and building a scalable ASP.NET Applications. Topics covered in this seminar include: The NLB and Clustered Network Topology, Handling State, Inproc versus SQL Server State Management, Sticky Sessions, Programming Considerations, Database Considerations, and Statistics.

SessionID: 35303

Introduction to Microsoft® Silverlight™

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2169

Speaker: Vincent Mayfield

Title: Introduction to Microsoft® Silverlight™

Abstract:

Learn more about Microsoft® Silverlight™ technology that delivers the next generation of media and rich interactive applications for the web. Topics include: evolution of the user interface, cross platform user experience, flexible programming model, low cost delivery of media, and evaluating the technology for your business. This seminar is targeted for non-developers, managers, network administrator, and database administrators, who what to learn more about this new and exciting technology.

SessionID: 35350

Advanced SQL Querying Techniques

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2172

Speaker: Plamen Ratchev

Title: Advanced SQL Querying Techniques

Abstract:

This session will focus on analytical ranking functions in SQL Server 2005/2008 and their use, implementing paging, string concatenation with XML PATH, pivoting, unpivoting, and separating elements in a string/column.

SessionID: 35352

Performance Tuning and Query Optimization

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2176

Speaker: Plamen Ratchev

Title: Performance Tuning and Query Optimization

Abstract:

This session will focus on common performance problems, considerations, and solutions. Review of methods for isolating long running queries and techniques for writing better SQL. Learn how to use dynamic management views and functions in SQL Server 2005/2008 for query tuning. Finish with explanation of parameter sniffing and different solutions.

SessionID: 35365

Near Real-Time Data Warehouse-No Third Party Tools

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2175

Speaker: Patrick LeBlanc

Title: Near Real-Time Data Warehouse-No Third Party Tools

Abstract:

The near real-time data warehouse was created to satisfy the needs of our billing department. The data is replicated into the extraction area of the warehouse using Microsoft SQL Server Transactional Replication. When inserts and/or updates occur a message is sent to the message queue via a trigger. There are two C# .net console apps that run, which can also run as a service, that constantly checks the message queue. When

the app finds a message it processes it. The transformation and loading of the warehouse occurs here. Inside of the actual warehouse databases there is a schema named Meta. The schema houses information that is used by the warehouse processor. These tables contain information such as stored procedures and SSIS packages to

SessionID: 35374

Tips Tricks for dynamic Reporting Services Repor

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2172

Speaker: Pam Shaw

Title: Tips Tricks for dynamic Reporting Services Repor

Abstract:

This session we will present methods to create very dynamic reports. We will demonstrate data driven formatting and layouts. We will review how to setup data sources that are more portable as well as see how templates make it easier to have more consistent report formats. We will review emailing reports and how this can be integrated into your current application.

SessionID: 35382

Reporting Services 2008 - Report Authoring

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Room 2172

Speaker: Ryan Duclos

Title: Reporting Services 2008 - Report Authoring

Abstract:

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

SessionID: 35386

* It's All About The Tools - TV Show Episode 3

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: 2142 Auditorium

Speaker: Russell Fustino

Title: * It's All About The Tools - TV Show Episode 3

Abstract:

Did you ever feel inundated with developer tools? Did you ever feel you're missing something that could make your life easier as a developer and a power user? There are so many tools available to choose from and it keeps getting tougher to keep up with them. Tool familiarity continues to be one of the top developer challenges. This series of seminars is all about tools for developers, by developers. Join Microsoft Florida Developer Evangelist Russ Fustino MVP Stan Schultes and others as they bring you demos and discussion about their favorite developer tools. This episode includes but is not limited to these tools; Live Services Live ID, Expression Blend, Visual Studio Debugger, Live Mesh and more. (Session begins at 1:00)

SessionID: 35405

The DBA Script Thumb

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: 2142 Auditorium

Speaker: Rodney Landrum

Title: The DBA Script Thumb

Abstract:

This session will present a top 10 (maybe 20) list of queries and tools that DBAs can use daily. The idea is that everything is included on a single 1G or less thumb drive to be portable. From simple T-SQL statements to full blown SSIS packages, the session demonstrates how to interogate, diagnose, report on, and resolve issues that are most prevalent for DBAs: disk space, security, backup locations, database and server documentation, performance and much more. All queries, which are SQL 2000, 2005 and yes even 2008 tried and true will be made available in the session to copy to your own thumb drive. If you are lucky you might even receive a free coveted thumb to store the queries.

SessionID: 35439

The Modern Resume: Building Your Brand

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: 2142 Auditorium

Speaker: Steve Jones

Title: The Modern Resume: Building Your Brand

Abstract:

Steve Jones, founder of SQL Server Central talks about how to update your resume to fit into today's modern world, and take advantage of the tools offered by blogging, social networking, and more.

This site is open source. Improve this page.