Nr: 4
SQLSaturday #4 Tweener(Sat) - Orlando 2008
SessionID: 34940
Statistics in SQL Server
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
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
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
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
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
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
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
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
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)
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
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
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: