sqlsathistory

Nr: 4

Back to Main list

SQLSaturday #4 Tweener(Sat) - Orlando 2008

Start Time (24h) Speaker Track Title
00:00:00 Andy Warren SQL for DBA's Statistics in SQL Server
00:00:00 Michael Antonovich SQL for Developers Using CASE in TSQL
00:00:00 Robert Cain SQL for DBA's Introduction to SQL Server Full Text Searching
00:00:00 Brian Knight SQL for DBA's SQL Server 2008 New Feature Overview
00:00:00 Barry Ralston Business Intelligence Home Runs and DMX, Intro to Microsoft Data Mining
00:00:00 Chris Rock SQL for DBA's Using DDL Triggers
00:00:00 Judy Pipia SQL for Developers SOA Using SQL Server 2005 Service Broker
00:00:00 Jon Winer SQL for Developers CLR User Defined Functions - Real World Examples
00:00:00 Kendal Van Dyke SQL for Developers XML Features in SQL 2005
00:00:00 Rushabh Mehta Business Intelligence Introduction to Master Data Management (MDM)
00:00:00 Robert Skoglund Business Intelligence Analysis Services 2005 – Tips Tricks
00:00:00 Wes Dumey Business Intelligence Using SSIS to Solve Common Business Problems

SessionID: 34940

Statistics in SQL Server

Back to calendar

Event Date: 07-06-2008 - Session time: 00:00:00 - Track: SQL for DBA's

Speaker: Andy Warren

Title: Statistics in SQL Server

Abstract:

Ever wonder what statistics have to do with performance? How to create and maintain them? What does it mean when someone says "the stats were corrupted"? We're going to explain all that in more in this session that will take a topic that often seems dense and complex and make it approachable and usable!

SessionID: 34946

Using CASE in TSQL

Back to calendar

Event Date: 07-06-2008 - Session time: 00:00:00 - Track: SQL for Developers

Speaker: Michael Antonovich

Title: Using CASE in TSQL

Abstract:

Most languages support an extended version of the IF/THEN syntax and in TSQL it's CASE. It's syntax is a little finicky and to add to the confusion there are two different ways to use it! We'll look at how to use it both ways and show how it contrasts with the IF/THEN syntax. This is a beginner level session.

SessionID: 34949

Introduction to SQL Server Full Text Searching

Back to calendar

Event Date: 07-06-2008 - Session time: 00:00:00 - Track: SQL for DBA's

Speaker: Robert Cain

Title: Introduction to SQL Server Full Text Searching

Abstract:

Microsoft SQL Server contains the functionality you need to issue full-text queries against plain character-based data in SQL Server tables. Full-text queries could include words and phrases or multiple forms of a word or phrase. Come learn how to setup your own "Windows Live" like searches in your applications. Give your users search capabilities into their data. It's as easy as 1-2-3!

SessionID: 34979

SQL Server 2008 New Feature Overview

Back to calendar

Event Date: 07-06-2008 - Session time: 00:00:00 - Track: SQL for DBA's

Speaker: Brian Knight

Title: SQL Server 2008 New Feature Overview

Abstract:

Learn what's new in SQL Server 2008 for the DBA, Developer and BI professional. This session is demo-packed with the best features of why you should upgrade to SQL Server 2008.

SessionID: 35021

Home Runs and DMX, Intro to Microsoft Data Mining

Back to calendar

Event Date: 07-06-2008 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Barry Ralston

Title: Home Runs and DMX, Intro to Microsoft Data Mining

Abstract:

This session is intended to utilize the steroid era of baseball to introduce attendees to data mining with Microsoft technologies. The demonstration-oriented session will create data mining models, evaluate their effectiveness, and demonstrate accessing data mining model results using Data Mining Add Ins for Office 2007. Finally, in the spirit of the scientific method, all data will be available to attendees with which to attempt re-creation of the experiments / examples.

SessionID: 35066

Using DDL Triggers

Back to calendar

Event Date: 07-06-2008 - Session time: 00:00:00 - Track: SQL for DBA's

Speaker: Chris Rock

Title: Using DDL Triggers

Abstract:

In this session we'll create a database object (table, proc, functions) backup system using DDL Triggers in SQL Server 2005. This system is beneficial to both DBA's and developers.

SessionID: 35240

SOA Using SQL Server 2005 Service Broker

Back to calendar

Event Date: 07-06-2008 - Session time: 00:00:00 - Track: SQL for Developers

Speaker: Judy Pipia

Title: SOA Using SQL Server 2005 Service Broker

Abstract:

This session will introduce the Service Broker in SQL Server 2005. During this session we will discuss an overview of Service Broker architecture and delve into the objects needed to create a Service Broker solution. Finally, we will build a sample solution from start to finish using the Adventureworks database.

SessionID: 35246

CLR User Defined Functions - Real World Examples

Back to calendar

Event Date: 07-06-2008 - Session time: 00:00:00 - Track: SQL for Developers

Speaker: Jon Winer

Title: CLR User Defined Functions - Real World Examples

Abstract:

This exciting session will talk about why CLR UDF's are a good choice in many cases, why using UDF's will simplify your code, and then go into setting up environments for testing and debugging. We'll also be discussing a few hard learned tips and tricks that will help you when you start using UDF's.

SessionID: 35269

XML Features in SQL 2005

Back to calendar

Event Date: 07-06-2008 - Session time: 00:00:00 - Track: SQL for Developers

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

Introduction to Master Data Management (MDM)

Back to calendar

Event Date: 07-06-2008 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Rushabh Mehta

Title: Introduction to Master Data Management (MDM)

Abstract:

This session will provide an overview of the Master Data Management and also introduce the business value of MDM.In addition, we will look at Microsoft's master data management software.

SessionID: 35398

Analysis Services 2005 – Tips Tricks

Back to calendar

Event Date: 07-06-2008 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Robert Skoglund

Title: Analysis Services 2005 – Tips Tricks

Abstract:

A collection of examples for MDX, cube processing, dimension and hierarchy designs, aggregation designs, and security modeling, for the everyday developer. Accelerate your development with these samples!

SessionID: 35505

Using SSIS to Solve Common Business Problems

Back to calendar

Event Date: 07-06-2008 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Wes Dumey

Title: Using SSIS to Solve Common Business Problems

Abstract:

SSIS is a powerful tool used to automate data integration. Come learn about SSIS and how you can use it in your organization to solve common business problems.