sqlsathistory

Nr: 16

Back to Main list

SQLSaturday #16 - South Florida 2009

Start Time (24h) Speaker Track Title
00:00:00 Adam Jorgensen DBA2 Performance Optimization Techniques
00:00:00 Adam Jorgensen BI Dive into Querying Analysis Services with MDX
00:00:00 Andy Warren DBA2 Introduction to SQL Statistics
00:00:00 Andy Warren DBA2 Social and Not so Social Networking for the DBA
00:00:00 Brian Knight BI Loading a Data Warehouse in SSIS
00:00:00 Brian Knight BI Introduction to SQL Server Analysis Services(SSAS)
00:00:00 Chad Miller DEV Powershell and SQL Server Administration
00:00:00 Chris Eargle DBA3 RESTful Data
00:00:00 David Lapides DBA4 Planning and Deploying Performance Point Server
00:00:00 David Lapides BI A tour of SQL Server and SharePoint Integration
00:00:00 Dean Richards DBA2 Tuna Helper - Proven Process for Tuning SQL
00:00:00 Jean-Claude Armand DBA3 DW Prescriptive Architecture Fast Track
00:00:00 Jeffrey Garbus DEV Choosing Indexes for Performance
00:00:00 Jeffrey Garbus DBA Indexing for Join Optimization
00:00:00 Jeffrey Garbus DBA2 High Availability options in SQL Server 2008
00:00:00 Jorge Segarra DBA Policy Based Management 101
00:00:00 Kendal Van Dyke DBA3 Transactional Replication: Beyond The Basics
00:00:00 Kendal Van Dyke DEV Configuring SQL Access for the Web Developer\Admin
00:00:00 Kendal Van Dyke DBA Working With XML in SQL Server
00:00:00 Devin Knight BI Best Practices and Performance Tuning SSIS
00:00:00 Martin Pichardo DEV SQL Server 2008 Spacial Data Type
00:00:00 Matt Larson DBA Wait-Time Based SQL Server Performance Management
00:00:00 Maximo Trinidad DEV PowerShell and SQL Server
00:00:00 Michael Antonovich DBA4 Save Time by Merging It
00:00:00 Michael Antonovich DEV Identifying and Removing Duplicate Records
00:00:00 Michael Mollenhour DBA4 SQL Smoking Mirrors
00:00:00 Michael Mollenhour BI SQL 2008 Data Mining
00:00:00 Pam Shaw DBA On Demand Report Subscriptions
00:00:00 Pam Shaw DBA Tips Tricks for dynamic SSRS Reports
00:00:00 Shervin Shakibi DBA4 Intro to SSIS
00:00:00 Shervin Shakibi DBA4 Advanced SSIS
00:00:00 Telmo Sampaio DBA3 SQL Server Beyond Relational
00:00:00 Vishal Shukla DBA3 ADO .Net Sync Services
00:00:00 Wes Dumey DBA2 Building a Data Warehouse using SQL Server 2008
00:00:00 Wes Dumey DBA4 Transitions: From Employee to Free-lance

SessionID: 34921

Performance Optimization Techniques

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA2

Speaker: Adam Jorgensen

Title: Performance Optimization Techniques

Abstract:

This will be an exciting deep dive into optimizing the performance of your Analysis Services Cubes. We will begin with an overview of the underlying query processing architecture. Then we'll jump into discussion and demonstration of techniques and best practices for enhancing query performance, maximizing aggregation value, partitioning, and improving processing performance, among other topics. This will be a great session for those of you who are looking for some under-the-hood insight into SSAS 2008.

SessionID: 34922

Dive into Querying Analysis Services with MDX

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: BI

Speaker: Adam Jorgensen

Title: Dive into Querying Analysis Services with MDX

Abstract:

This session will put you on the fast track to understanding the fundamentals of MDX and querying your Analysis Services Cubes. MDX is a very powerful tool in your cube development arsenal, but the learning curve can be steep. Together, we will discuss and demonstrate working with sets, tuples, and working with your data through the built in functions in MDX and Analysis Service 2008. Examples and demos will be common business cases you will use in your cubes day to day.

SessionID: 34933

Introduction to SQL Statistics

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA2

Speaker: Andy Warren

Title: Introduction to SQL 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: 34934

Social and Not so Social Networking for the DBA

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA2

Speaker: Andy Warren

Title: Social and Not so Social Networking for the DBA

Abstract:

Should you be networking? In this session we'll talk about why you should be building a network now, how to build it, and how to keep track of and quantify your network. Along the way we'll talk about the most common social networks, why you should consider blogging, and some exercises you can do to strengthen your networking skills.

SessionID: 35002

Loading a Data Warehouse in SSIS

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: BI

Speaker: Brian Knight

Title: Loading a Data Warehouse in SSIS

Abstract:

In this session, you'll learn how to load a data warehousing using SSIS. See some of the challenges in data warehouse processing and how to get past some of those fact and dimension challenges.

SessionID: 35003

Introduction to SQL Server Analysis Services(SSAS)

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: BI

Speaker: Brian Knight

Title: Introduction to SQL Server Analysis Services(SSAS)

Abstract:

Want to deliver slice-and-dice data reports for your end users? Then you'll want to see this session on how to get started in SQL Server Analysis Services (SSAS). In this session, you'll be taken from the data warehouse phase forward into SSAS. You'll also see how to deliver reports to your users.

SessionID: 35056

Powershell and SQL Server Administration

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DEV

Speaker: Chad Miller

Title: Powershell and SQL Server Administration

Abstract:

In this sesssion we will look at automating common DBA tasks through Powershell. An overview of the CodePlex project SQL Serer Powershell Extensions will be provided. Specific topics covered include SSIS administration, replication and agent monitoring, performing simple ETL with Powershell and building graphs, charts and diagrams using Powershell.

SessionID: 35058

RESTful Data

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA3

Speaker: Chris Eargle

Title: RESTful Data

Abstract:

REST is an architectural style that allows for a layered, scalable, and

cacheable enterprise information system. With ADO.NET Data Services, a database can be surfaced to a service as a REST-style resource collection that is addressable with natural URIs and can be interacted with using the usual HTTP verbs: GET, POST, PUT, and DELETE. This session will describe RESTful Data, the benefits it conveys, and its uses. Then we will set up a data service using an existing database that developers would then access rather than accessing the database directly.

SessionID: 35082

Planning and Deploying Performance Point Server

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA4

Speaker: David Lapides

Title: Planning and Deploying Performance Point Server

Abstract:

Want to learn how to get Performance Point up and running in your environment? This session will describe the requirements, planning activities, deployment options as well as trips and tracks for ensuring your PPS depl;oyment is successful. Then we will will walk though an installation of PPS

SessionID: 35083

A tour of SQL Server and SharePoint Integration

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: BI

Speaker: David Lapides

Title: A tour of SQL Server and SharePoint Integration

Abstract:

Learn how to integrate databases, cubes, and reports into SharePoint, by leveraging features including Excel Services, the Business Data Catalog, Performance Point Dashboards and data query web parts. This session will describe the various SQL Server centric features of SharePoint and demonstrate how they can be used to create a cpomprehensive BI Portal.

SessionID: 35094

Tuna Helper - Proven Process for Tuning SQL

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA2

Speaker: Dean Richards

Title: Tuna Helper - Proven Process for Tuning SQL

Abstract:

Many DBAs and Developers are faced with tuning poorly performing SQL statements. 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 time data, indexing strategies, column selectivity and several more that will help the you succeed on future tuning projects.

SessionID: 35156

DW Prescriptive Architecture Fast Track

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA3

Speaker: Jean-Claude Armand

Title: DW Prescriptive Architecture Fast Track

Abstract:

This session will provide a Fast Track discussion into Data Warehouse architecture.

SessionID: 35174

Choosing Indexes for Performance

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DEV

Speaker: Jeffrey Garbus

Title: Choosing Indexes for Performance

Abstract:

Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

SessionID: 35175

Indexing for Join Optimization

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Jeffrey Garbus

Title: Indexing for Join Optimization

Abstract:

Everything you wanted to know about join optimization but were afraid to ask... Join types, indexing, and how the optimizer makes its selections

SessionID: 35176

High Availability options in SQL Server 2008

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA2

Speaker: Jeffrey Garbus

Title: High Availability options in SQL Server 2008

Abstract:

SQL Server 2008 high availability options include Clustering, Database Miroring, Replication, and Log Shipping. If you are wondering which ones are best, and under what curcumstances... come on over.

SessionID: 35233

Policy Based Management 101

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Jorge Segarra

Title: Policy Based Management 101

Abstract:

We will be learning an overview of this powerful new feature in SQL 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Servers!

SessionID: 35262

Transactional Replication: Beyond The Basics

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA3

Speaker: Kendal Van Dyke

Title: Transactional Replication: Beyond The Basics

Abstract:

At some point in every DBA's career they'll be probably be asked to work with transactional replication but most DBAs don't look under the covers once they're done walking through the setup wizards. In this session we'll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies.

Session Goals: • Understand core concepts of transactional replication including: replication topologies, publishers, distributors, agents, agent profiles. Learn how to configure advanced options such as vertical and horizontal filtering • Demonstrate how to monitor transactional replication performance • Lear

SessionID: 35263

Configuring SQL Access for the Web Developer\Admin

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DEV

Speaker: Kendal Van Dyke

Title: Configuring SQL Access for the Web Developer\Admin

Abstract:

This session will demonstrate the ways that ASP ASP.NET applications can be configured to make connections to SQL Server from different versions of IIS so that we can keep our servers secure and our DBAs happy.

Session Goals: • Learn when to use SQL logins and when to use Windows Authentication • Understand the concept of impersonation • Learn how ASP and ASP.NET applications can be configured to use impersonation to make secure connections to SQL Server • Learn how to configure IIS 5, 6, 7 and Windows XP, 2003, and 2008 to support impersonation

SessionID: 35265

Working With XML in SQL Server

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Kendal Van Dyke

Title: Working With XML in SQL Server

Abstract:

XML in SQL 2000 wasn't very exciting and it was easy to dismiss it altogether by just relying on developers to handle any XML needed within the application. SQL 2005 changes the game and this session will show you how to use the XML data type, do basic operations on XML data, and showcase the changes to FOR XML that make it so much more useful. This isn't a session to convince you to use XML, but to show you what you can do with XML if you do need to use it!

Session Goals: • Learn how to use FOR XML PATH and WITH NAMESPACE clauses • Understand the basic use of the XML data type and XML schema collections • Learn how to use XML DML to manipulate XML data

SessionID: 35285

Best Practices and Performance Tuning SSIS

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: BI

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: 35296

SQL Server 2008 Spacial Data Type

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DEV

Speaker: Martin Pichardo

Title: SQL Server 2008 Spacial Data Type

Abstract:

This session will provide an introductory and intermediate look at the Microsoft SQL server 2008 Spacial data types.

SessionID: 35297

Wait-Time Based SQL Server Performance Management

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Matt Larson

Title: Wait-Time Based SQL Server Performance Management

Abstract:

SessionID: 35298

PowerShell and SQL Server

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DEV

Speaker: Maximo Trinidad

Title: PowerShell and SQL Server

Abstract:

Learn how DBA's and Developers can take advantage of this new .NET scripting technology - PowerShell 2.0. This is a "most" to learn IT/.NET skill. In this session will discuss the difference between using SMO and the new integrated SQLPS in assisting managing your SQL Server 2000/2005/2008.

SessionID: 35322

Save Time by Merging It

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA4

Speaker: Michael Antonovich

Title: Save Time by Merging It

Abstract:

The SQL Server 2008 MERGE command combines the features of the Insert and Update commands into a single powerful statement. You can now insert new data into one table while also updating or deleting data from an existing table with a single statment. In this sessionk we will explore this new addition to your TSQL toolbox in SQL Server 2008 to show how to merge two tables without creating duplicate records, how to synchronize two tables, how to use the OUTPUT clause with MERGE to save deleted records from the merge into an archival table, and how indexing effects the performance of MERGE statements and more.

SessionID: 35323

Identifying and Removing Duplicate Records

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DEV

Speaker: Michael Antonovich

Title: Identifying and Removing Duplicate Records

Abstract:

Perhaps you inherited a database with one or more tables having duplicate potential keys or maybe even entire duplicate records or maybe you generated a recordset from a SELECT statement that has duplicate records. In any case, you have a problem. You need to identify which tables have duplicate records or duplicate index values, isolate those records, and then delete only the duplicate records from the table. This session will focus on the functions and methods that you can use to identify and remove duplicate data from your tables.

SessionID: 35329

SQL Smoking Mirrors

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA4

Speaker: Michael Mollenhour

Title: SQL Smoking Mirrors

Abstract:

In this session I will demonstrate how to configure Mirroring for both high availability and offloading reporting stress via database snapshots. I will also cover the different modes of mirroring and how they may affect performance.

SessionID: 35330

SQL 2008 Data Mining

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: BI

Speaker: Michael Mollenhour

Title: SQL 2008 Data Mining

Abstract:

In this session I will demonstrate datamining with SQL Analysis Services. This session will demonstrate the analytic powers incorporated into the SQL AS Engine, and show how these can be integrated with Reporting Services and Excel.This session will mainly focus on new features available for SQL 2008

SessionID: 35372

On Demand Report Subscriptions

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Pam Shaw

Title: On Demand Report Subscriptions

Abstract:

This session will explore subscriptions which are the scheduled delivery process defined within Reporting Services. We will explore what is required to create subscriptions, what options are available and how we can manipulate these for use on demand. We will review some practical applications that would require use of on demand subscriptions.

SessionID: 35373

Tips Tricks for dynamic SSRS Reports

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Pam Shaw

Title: Tips Tricks for dynamic SSRS Reports

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: 35434

Intro to SSIS

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA4

Speaker: Shervin Shakibi

Title: Intro to SSIS

Abstract:

A 100 level session for those who are new to SSIS. This beginner session will discuss entry level SSIS topics and if there is time, dive into some intermediate topics.

SessionID: 35436

Advanced SSIS

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA4

Speaker: Shervin Shakibi

Title: Advanced SSIS

Abstract:

A continuation of the previous session this session will discuss advanced SSIS topics.

SessionID: 35462

SQL Server Beyond Relational

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA3

Speaker: Telmo Sampaio

Title: SQL Server Beyond Relational

Abstract:

Participate in an architecture review showcasing the use of SQL Server 2008 Spatial features and the filestream data. The session will focus on a pre-defined solution architecture using SQL Server 2005 with pure relational data and after a brief introduction of new features in SQL Server 2008, changes will be presented and discussed with the group, culminating in a new architecture.

SessionID: 35503

ADO .Net Sync Services

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA3

Speaker: Vishal Shukla

Title: ADO .Net Sync Services

Abstract:

The ability to support mobile and remote workers is becoming more and more important for organizations every day. It is critical that organizations ensure users have access to the same information they have when they are in the office. In today’s discussion we will see how Sync Services for ADO.NET, which is a part of the Microsoft Sync Framework (MSF), enables synchronization of information between database systems and how Sync Services for ADO.NET helps developers avoid many of the common issues associated with taking data offline.

SessionID: 35510

Building a Data Warehouse using SQL Server 2008

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA2

Speaker: Wes Dumey

Title: Building a Data Warehouse using SQL Server 2008

Abstract:

In this session we will go through a data warehouse lifecycle project

using SQL Server and SSIS to demonstrate how to build the data warehouse. A general overview and code presentation will be provided.

SessionID: 35511

Transitions: From Employee to Free-lance

Back to calendar

Event Date: 08-08-2009 - Session time: 00:00:00 - Track: DBA4

Speaker: Wes Dumey

Title: Transitions: From Employee to Free-lance

Abstract:

Have you ever wondered what it would be like to practice using SQL skills

as a contractor/consultant? Are you concerned about the pitfalls of moving from a full time opportunity to a free-lance role? Come to this discussion and learn how to make a successful transition from full time to the free-lance world. Learn what pitfalls await and how to design a successful career plan.

This site is open source. Improve this page.