sqlsathistory

Nr: 3

Back to Main list

SQLSaturday #3 - Jacksonville 2008

Start Time (24h) Speaker Track Title
00:00:00 Andy Warren Classroom 1402 Beginning Transactional Replication
00:00:00 Andy Warren Classroom 1400 Mentoring Professional Development Plans
00:00:00 Brian Knight Classroom 1402 Backup and Recovery Basics
00:00:00 Brian Knight Classroom 1406 Finding a Job - Do's Dont's
00:00:00 Bryan Oliver Auditorium 110 Understanding Disk I/O Performance in SQL 2005
00:00:00 Bryan Oliver Classroom 1400 Benchmarking: The Forgotten Role of Performance
00:00:00 Brandie Tarvin Auditorium 110 Introduction to SQL Reporting Services
00:00:00 Chris Rock Classroom 1406 ASP.NET Dynamic Data Web Application
00:00:00 David Fekke Auditorium 110 LINQ For SQL Server
00:00:00 David Fekke Classroom 1404 Introduction to the Business Data Catalog
00:00:00 Darren Herbold Classroom 1404 Report Viewer Control for Web and Windows
00:00:00 Darren Herbold Auditorium 1202 SQL Server 2008 Business Intelligence
00:00:00 Fadi Albatal Classroom 1402 Comprehansive data protection for SQL Server
00:00:00 Geoff Hiten Auditorium 1202 SQL 2008 Overview
00:00:00 Geoff Hiten Auditorium 1202 SQL 2008 Policy Based Management
00:00:00 Jeffrey Garbus Auditorium 110 Choosing indexes for performance
00:00:00 Jeffrey Garbus Classroom 1400 Database Impact on Application Performance
00:00:00 Joe Healy Classroom 1406 ADO.NET Synchronization Services in .NET 3.5
00:00:00 Brian Kelley Classroom 1406 Protecting Your SQL Server from Treasure Seekers
00:00:00 Brian Kelley Classroom 1404 Trigger Happy Database Security
00:00:00 Kendal Van Dyke Classroom 1400 XML Features in SQL 2005
00:00:00 Kent Waldrop Auditorium 110 FAQs from the MSDN Transact SQL Forum
00:00:00 Devin Knight Classroom 1404 First Day/Month a DBA
00:00:00 Devin Knight Classroom 1406 Introduction to SSIS
00:00:00 Michael Mollenhour Classroom 1400 Smokin' Mirrors - SQL 2005 Mirroring Technology
00:00:00 Mark Polino Classroom 1404 Reporting in Microsoft Dynamics GP
00:00:00 Patrick Thompson Classroom 1402 Modeling People and Organizations
00:00:00 Plamen Ratchev Auditorium 110 Performance Tuning and Query Optimization
00:00:00 Plamen Ratchev Auditorium 1202 SQL Server 2008 T-SQL Enhancements
00:00:00 Pam Shaw Classroom 1406 Tips and tricks for dynamic Reports
00:00:00 Pam Shaw Classroom 1400 Gain RANK in your queries with the ranking functio
00:00:00 Rodney Landrum Classroom 1404 Building a DBA Repository with SSIS and SSRS
00:00:00 Sherif Elfayoumy Classroom 1406 Data Mining Concepts and Techniques
00:00:00 Shawn Weisfeld Auditorium 1202 SQL Server CLR
00:00:00 Tim Mitchell Classroom 1402 Programming SMO for Fun and Profit!
00:00:00 Trey Johnson Classroom 1402 An Introduction to Performance Point
00:00:00 Wes Dumey Auditorium 1202 Building a Data Warehouse Using SQL Server 2005

SessionID: 34938

Beginning Transactional Replication

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1402

Speaker: Andy Warren

Title: Beginning Transactional Replication

Abstract:

Replication is a very useful technology that often gets ignored because it seems to be a big scary black box. Join us for a beginner level session that looks at how to set up and use transactional replication for common scenarios and how to do with the few common problems you may run into using it.

SessionID: 34939

Mentoring Professional Development Plans

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1400

Speaker: Andy Warren

Title: Mentoring Professional Development Plans

Abstract:

This will be a very interactive session as we discuss professional development plans including why you should write it down, what to do when your manager doesn't care, finding time and funding to implement your plan, and what to do when your plan doesn't quite work out. We'll also discuss finding a mentor and the value that a mentor can add to your career.

SessionID: 34978

Backup and Recovery Basics

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1402

Speaker: Brian Knight

Title: Backup and Recovery Basics

Abstract:

An overview of how to plan for, implement, and monitor a sound backup and recovery strategy for your databases using SQL Server 2005. Using a simple, one server environment as an example, this session will look at the kinds of questions you should ask when creating backup and recovery plans, and how to know whether your backup and recovery plans are actually meeting the needs of your business.

SessionID: 34980

Finding a Job - Do's Dont's

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406

Speaker: Brian Knight

Title: Finding a Job - Do's Dont's

Abstract:

Presented by Comsys

SessionID: 35030

Understanding Disk I/O Performance in SQL 2005

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 110

Speaker: Bryan Oliver

Title: Understanding Disk I/O Performance in SQL 2005

Abstract:

Understanding Disk I/O performance can lead to improved overall SQL Server Performance. In this presentation we will look at the effects of RAID, SAN how to configure them for optimal disk performance. We will also cover how to measure the performance of I/O through perfmon and look at some simple ways to graph and manage this data so that over time we can understand the effects of I/O performance on the SQL Servers we manage.

SessionID: 35032

Benchmarking: The Forgotten Role of Performance

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1400

Speaker: Bryan Oliver

Title: Benchmarking: The Forgotten Role of Performance

Abstract:

SessionID: 35046

Introduction to SQL Reporting Services

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 110

Speaker: Brandie Tarvin

Title: Introduction to SQL Reporting Services

Abstract:

An overview of how to create basic reports using SQL Server Reporting Services 2005. This session will touch on how to create data sources, data sets, set report properties and use the most common features required for the basic report. The Adventure Works sample database will be used in the demonstration.

SessionID: 35057

ASP.NET Dynamic Data Web Application

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406

Speaker: Chris Rock

Title: ASP.NET Dynamic Data Web Application

Abstract:

This session will go over the new Dynamic Data Web Application available with the ASP.NET 3.5 Extensions.

Using Visual Studio 2008 we will build our model using LINQ TO SQL. Then we will see how easy it is to create a website based on our model that easily allows you to edit the data in your tables.

We're also going to look under the hood at what type of TSQL is generated from our LINQ TO SQL class.

SessionID: 35086

LINQ For SQL Server

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 110

Speaker: David Fekke

Title: LINQ For SQL Server

Abstract:

This session will be an introduction into how to use the .NET 3.5 Linq framework to query and modify data in SQL Server.

SessionID: 35087

Introduction to the Business Data Catalog

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1404

Speaker: David Fekke

Title: Introduction to the Business Data Catalog

Abstract:

This session is an introduction to the Office Sharepoint Server Business Data Catalog (BDC). The session will show to expose enterprise data from SQL Server into your MOSS environment. Learn about how to create the application definition xml that Sharepoint uses to view data from SQL Server and web services.

SessionID: 35097

Report Viewer Control for Web and Windows

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1404

Speaker: Darren Herbold

Title: Report Viewer Control for Web and Windows

Abstract:

This session will show you how to use the report viewer controls in both WinForm and Web applications, and offer some good tips for using them effectively.

SessionID: 35098

SQL Server 2008 Business Intelligence

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 1202

Speaker: Darren Herbold

Title: SQL Server 2008 Business Intelligence

Abstract:

SQL Server 2008 has taken a leap forward in BI. In this session you'll learn about the key new features in SQL Server 2008 for the business intelligence person.

SessionID: 35121

Comprehansive data protection for SQL Server

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1402

Speaker: Fadi Albatal

Title: Comprehansive data protection for SQL Server

Abstract:

We will explore how SQL Server SAN integration is designed to deliver comprehensive SQL Server database protection, rapid recovery and high availability. We will also discuss how SAN Smart Copies easily enable parallel processing for data mining, and testing and development environments.

SessionID: 35123

SQL 2008 Overview

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 1202

Speaker: Geoff Hiten

Title: SQL 2008 Overview

Abstract:

Find out what is really in the new SQL 2008 product. Learn what features are going to impact your job and your systems. Session is 50% Administrator content and 50% T-sQL Developer content.

SessionID: 35124

SQL 2008 Policy Based Management

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 1202

Speaker: Geoff Hiten

Title: SQL 2008 Policy Based Management

Abstract:

Learn how to scale your DBA efforts across your entire SQL Infrastructure and guarantee your systems work the way you want.

SessionID: 35171

Choosing indexes for performance

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 110

Speaker: Jeffrey Garbus

Title: Choosing indexes for performance

Abstract:

Understand how the optimizer selects indexes, and how you can design accordingly.

SessionID: 35173

Database Impact on Application Performance

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1400

Speaker: Jeffrey Garbus

Title: Database Impact on Application Performance

Abstract:

How to approach getting to the root cause of difficult application performance problems, based on numerous case studies from actual professional services engagements by Jeff Garbus. What to do when you think it is the database…What to do when it is not the database (including convincing the disbelievers). How to move from a reactive APM methodology to a proactive APM methodology and best practices.

SessionID: 35196

ADO.NET Synchronization Services in .NET 3.5

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406

Speaker: Joe Healy

Title: ADO.NET Synchronization Services in .NET 3.5

Abstract:

Explore how you can build offline smart client applications in a RAD way that synchronizes backend database with a local Microsoft SQL Server Compact Edition store using the Microsoft Synchronization Services for ADO.NET. Use the Microsoft Visual Studio Designer to help build a two-tier application and N-tier application that incrementally downloads data that can be cached on a SQL Server Compact Edition store. We can also explore how to perform bidirectional synchronization with conflict detect

SessionID: 35247

Protecting Your SQL Server from Treasure Seekers

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406

Speaker: Brian Kelley

Title: Protecting Your SQL Server from Treasure Seekers

Abstract:

In this presentation, we'll look at ways of securing SQL Server and coding secure means of data access for an organization's sensitive data. This presentation will cover all audiences, from system administrators, to database administrators, to developers. We'll look at features common in both SQL Server 2000 and 2005 as well as some of the newer features and how to use them for SQL Server 2005.

SessionID: 35248

Trigger Happy Database Security

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1404

Speaker: Brian Kelley

Title: Trigger Happy Database Security

Abstract:

In this session we'll look at the use of triggers for security and auditing. DML, DLL, and logon triggers will all be covered. We'll look at both good and bad ways of implementing triggers as part of an overall security solution.

SessionID: 35268

XML Features in SQL 2005

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1400

Speaker: Kendal Van Dyke

Title: XML Features in SQL 2005

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 new XML data type, do basic XML 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!

SessionID: 35272

FAQs from the MSDN Transact SQL Forum

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 110

Speaker: Kent Waldrop

Title: FAQs from the MSDN Transact SQL Forum

Abstract:

01 Count Occurrences

01 Repalce Function with no accounting for strings that end with spaces 02 Replace Function with sensitivity for strings that end with spaces

02 Looping 01 Filter based on State List 02 Filter based on State List with Numbers Table 03 Numbers Table 04 _Numbers Function

03 Last Day of the Month 01 Last Day of the Month 02 Nth Day m of the Month 03 Calendar Table Reference Information

04 String or Numeric Part 01 Split Left Hand

SessionID: 35281

First Day/Month a DBA

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1404

Speaker: Devin Knight

Title: First Day/Month a DBA

Abstract:

So you're starting your first DBA job because someone was willing to take a chance on you. You have thousands of questions and don't know who to ask. This session is for anyone looking for tips on how to get your first job, improve your skills and gain confidence as a DBA.

SessionID: 35282

Introduction to SSIS

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406

Speaker: Devin Knight

Title: Introduction to SSIS

Abstract:

In this session, Devin Knight shows you the basics of SQL Server Integration Services (SSIS) and how to use it in a real word example. He shows you how to create your first end to end SSIS package that loops through a series of files and loads them dynamically.

SessionID: 35333

Smokin' Mirrors - SQL 2005 Mirroring Technology

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1400

Speaker: Michael Mollenhour

Title: Smokin' Mirrors - SQL 2005 Mirroring Technology

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

Reporting in Microsoft Dynamics GP

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1404

Speaker: Mark Polino

Title: Reporting in Microsoft Dynamics GP

Abstract:

How do you find the right *^%$^ table for reporting on data in Microsoft Dynamics GP? It's a common question and yes, the table structure is a bit unusual. I'll cover the basic structure and lots of tools you can use to figure out how get the right tables when building a Crystal, SSRS or other report using Dynamics GP data as the source.

SessionID: 35342

Modeling People and Organizations

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1402

Speaker: Patrick Thompson

Title: Modeling People and Organizations

Abstract:

This session will go through some common approaches and issues associated with representing people and organizations. It will include reviews of some common models (for example, X.500 based models and PIM inspired models such as VCard) and discuss the implications of current dominant scenarios, particularly social applications together with various strategies for representing and integrating this data with a relational database.

SessionID: 35363

Performance Tuning and Query Optimization

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 110

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 for query tuning. Finish with explanation of parameter sniffing and different solutions.

SessionID: 35364

SQL Server 2008 T-SQL Enhancements

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 1202

Speaker: Plamen Ratchev

Title: SQL Server 2008 T-SQL Enhancements

Abstract:

SessionID: 35369

Tips and tricks for dynamic Reports

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406

Speaker: Pam Shaw

Title: Tips and tricks for dynamic 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: 35370

Gain RANK in your queries with the ranking functio

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1400

Speaker: Pam Shaw

Title: Gain RANK in your queries with the ranking functio

Abstract:

In this session, we will explore the ranking functions that were part of the new feature set added with SQL 2005. These allow the addition of a ranking column to your result sets that can be used to manipulate data sets without the need of the dreaded cursors. We will explore Row_Number, Rank, Dense_Rank and NTile along with ways that they can greatly optimize queries. We will also see the use of CTE’s while demonstrating some of their uses.

SessionID: 35404

Building a DBA Repository with SSIS and SSRS

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1404

Speaker: Rodney Landrum

Title: Building a DBA Repository with SSIS and SSRS

Abstract:

SessionID: 35426

Data Mining Concepts and Techniques

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406

Speaker: Sherif Elfayoumy

Title: Data Mining Concepts and Techniques

Abstract:

Have you always thought of revealing insights from your database/data warehouse but was deterred by the lack of tools and the lack of knowledge of what techniques and algorithms to use? SSAS solves the first problem with its comprehensive suite of tools and algorithms. In this session I will cover the basic data mining concepts and techniques that may help you get your first data mining project off the ground. My focus will be on the various techniques of effective predictive modeling.

SessionID: 35431

SQL Server CLR

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 1202

Speaker: Shawn Weisfeld

Title: SQL Server CLR

Abstract:

In this talk we will talk about all the things that the CLR can do in SQL Server (Stored Procedures, Triggers, Functions, etc.).

SessionID: 35480

Programming SMO for Fun and Profit!

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1402

Speaker: Tim Mitchell

Title: Programming SMO for Fun and Profit!

Abstract:

Managing numerous SQL Servers can be very difficult. Fortunately, Microsoft has provided a rich programmatic interface to allow DBAs to easily manage SQL Servers, databases, and objects. Using SMO objects, a code-savvy DBA can automate otherwise tedious manual tasks: you can create and monitor backups and agent jobs, stop and start services, administer users and logins, and much more, on all of your SQL installations with ease.

SessionID: 35481

An Introduction to Performance Point

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1402

Speaker: Trey Johnson

Title: An Introduction to Performance Point

Abstract:

Microsoft Office 2007 Performance Point is the latest addition to the Microsoft BI technologies. This session gives you a practical introduction to getting started using the BI platform you have built using SQL Server Database Engine, Analysis Service and Reporting Services.

SessionID: 35508

Building a Data Warehouse Using SQL Server 2005

Back to calendar

Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 1202

Speaker: Wes Dumey

Title: Building a Data Warehouse Using SQL Server 2005

Abstract:

Learn the basics of data warehousing on the Microsoft platform. This will be a fun session and you'll learn a lot.