Nr: 2
SQLSaturday #2 - Tampa 2008
SessionID: 34920
TSQL Basics for Developers
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 3
Speaker: AJ Warnock
Title: TSQL Basics for Developers
Abstract:
A quick and basic introduction to TSQL with a few tips thrown in.
Finished with a few stupid developer tricks that cause you problems.
THIS WILL BE VERY BEGINNER and DEVELOPER ORIENTED.
If approved, i will provide a better and more complete session description.
SessionID: 34935
Transactional Replication For Beginners
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 2
Speaker: Andy Warren
Title: Transactional Replication For Beginners
Abstract:
Transactional replication is an amazing product that is often ignored because it looks complicated. In this session we'll show you that you can set up replication in as little as 10 minutes, talk about some of the basic configuration options, and then field as many questions as time permits.
SessionID: 34984
Introduction to SQL Server Integration Services
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 1
Speaker: Brian Knight
Title: Introduction to SQL Server Integration Services
Abstract:
In this session, you'll learn the basics of SQL Server Integration Services (SSIS) by example with a real world ETL example. By the end of the session, you'll know how to use SSIS to load dozens of files quickly in a loop and process them with some basic rules. No previous SSIS experience is needed for this session.
SessionID: 34985
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 1
Speaker: Brian Knight
Abstract:
SessionID: 35026
SMO (SQL Management Objects) for SQL Server 2005
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 4
Speaker: Brandon Kelly
Title: SMO (SQL Management Objects) for SQL Server 2005
Abstract:
SQL Management Objects (SMO) for SQL Server 2005 represent a .Net managed API for controlling almost all of SQL Server's functions. Find out how to manage everything from the Job Scheduler to database schemas with ease in a .Net world. Demos will include live samples that can be used with Northwind or AdventureWorks that each attendee can take home with them.
SessionID: 35053
Persisting and Tracking Workflows Using SqlServer
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 5
Speaker: Bayer White
Title: Persisting and Tracking Workflows Using SqlServer
Abstract:
SessionID: 35080
SQL Server Data Access Tips and Techniques
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 4
Speaker: David Hayden
Title: SQL Server Data Access Tips and Techniques
Abstract:
You have optimized and tuned your SQL Server Database and now you need to access the data from your application. Learn and explore the variety of ways you can access the data using ADO.NET, the Data Access Application Block, LINQ To SQL, ADO.NET Entity Framework, ADO.NET Data Services, and the ASP.NET 3.5 Dynamic Data Framework. In this session we will walk-thru and build several examples for each technique as well as discuss tips, strengths, and weaknesses. Come with your questions and explore the wonderful world of data access to SQL Server!
SessionID: 35168
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 5
Speaker: Jeffrey Garbus
Abstract:
I present everything you wanted to know about index selection, but didn't know who to ask. Questions are welcome. Covered: Index types, how the optimizer selects indexes, forcing indexes.
SessionID: 35169
Writing Determinate Functions
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 5
Speaker: Jeffrey Garbus
Title: Writing Determinate Functions
Abstract:
Determinate functions (also called characteristic functions) were originally used before SQL introduced the case statement. They allow you to make decisions mathematically, rather than with logic, which can make code dramatically faster. This session is not for people afraid of simple algebra.
SessionID: 35189
Migrating DTS Packages to SSIS
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 1
Speaker: Jessica Moss
Title: Migrating DTS Packages to SSIS
Abstract:
Upgrading to SQL Server 2005 can be a major challenge for companies, but migrating your DTS packages to SSIS packages doesn't have to be. This session will walk you through the steps needed to migrate your packages, including using the Upgrade Advisor and the Package Migration Wizard. We will discuss the items that the Wizard can handle, how to adjust for items that the Wizard can handle, and when it is best to throw the Wizard out the window.
SessionID: 35190
Logging in SQL Server Integration Services
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 3
Speaker: Jessica Moss
Title: Logging in SQL Server Integration Services
Abstract:
SessionID: 35197
Database Change Management with Team System
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 2
Speaker: Jim Blizzard
Title: Database Change Management with Team System
Abstract:
Ever make a bunch of changes to your database then lose track of what you’ve changed? Frustrated with trying to come up with consistent, “meaningful” test data to test your applications? Wish you could unit test your database? Ever forget to make a backup copy of your stored procedure before you made that one line change (that happens to crash the system)? Tired of feeling like you’re not part of the team? Come see how you can take control of your database development with Team System.
SessionID: 35327
20 Things You Need to Know About Analysis Services
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 4
Speaker: Mark Landry
Title: 20 Things You Need to Know About Analysis Services
Abstract:
This is an updated version of a popular presentation given at the Tampa SQL Server Users Group in mid-2005. It now includes SSAS 2005 enhancements and UDM architecture.
Topics covered include:
What is Analysis Services?
Why do you need it?
Basic Cube Concepts: Hierarchies, Measures, Tuples
Multidimensional Expressions (MDX) Capabilities
Security
Architecture
Resources
SessionID: 35341
Normalization and all that
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 5
Speaker: Patrick Thompson
Title: Normalization and all that
Abstract:
SessionID: 35380
Tips and Tricks for Reporting Services
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 3
Speaker: Pam Shaw
Title: Tips and Tricks for Reporting Services
Abstract:
SessionID: 35389
Introduction to Master Data Management (MDM)
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 1
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: 35390
Managing SSIS Packages
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 1
Speaker: Rushabh Mehta
Title: Managing SSIS Packages
Abstract:
The key to long term success of SSIS based systems is a planned approach to configuration management and deployment. A carefully architected approach can simplify the management of the many variables within an organization that affect the functioning of these packages. These variables include server name, database names and file system, among others. In this session on management and deployment of SSIS, we will identify most of these variables that support our packages. Later, strategies for man
SessionID: 35395
Designing an Analysis Services cube
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 3
Speaker: Robert Hatton
Title: Designing an Analysis Services cube
Abstract:
Designing an Analysis Services cube is a completely different undertaking than designing a relational database. This presentation will cover the steps needed to design a cube, as well as the fundamental concepts needed for a good design.
SessionID: 35407
Comparing Python and PowerShell DBA Scripting
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 2
Speaker: Ronald Dameron
Title: Comparing Python and PowerShell DBA Scripting
Abstract:
This session will discuss how DBAs can use scripting languages like Python, IronPython, and PowerShell to automate repetitive tasks across multiple database servers.
SessionID: 35430
SQL Server CLR
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 2
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: 35464
Getting With it With With (and Over On It, Too)
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 5
Speaker: Terry Bomberger
Title: Getting With it With With (and Over On It, Too)
Abstract:
SessionID: 35519
SQL Server 2005 Reporting Solutions
Event Date: 16-02-2008 - Session time: 00:00:00 - Track: Room 3
Speaker: Xidan Zhou
Title: SQL Server 2005 Reporting Solutions
Abstract:
In this session we are going to discuss how to create reports with parameters and the different ways to setup report parameters, including multivalued parameters. Then we'll look at how to create a Mailing Label report using SQL 2005 Report Server.