Attendees, access your Virtual Conference material here: www.ftpconferences.com/vc You’ll find your username and password on the first page of your proceedings booklet!

September 12
KEYNOTE: Data Access with Visual Studio .NET
MDX Without Fear
Build Next-Gen OLAP Apps with XML for Analysis
Exploring T-SQL in SQL Server
SQLXML 3.0: SQL and XML Done Right
SQL Under Siege: Injection Attacks and How to Prevent Them

SQL Live! Sessions — September 11

Microsoft-Sponsored Breakfast Session: Development Opportunities with the New Microsoft Office System
Robert Green, Microsoft
Heavy investments in standards-based XML and .NET technologies provide developers with a host of new development opportunities around the Microsoft Office System. Come see how XML leads to better solutions for end users and enables information to be more easily captured, used and repurposed throughout organizations. New tools and interfaces in the Microsoft Office System give developers greater control over the use and flow of XML data and allow Visual Studio .NET developers to extend their skills to Office applications using everything from ASP.NET to Web services to network deployment.
8 a.m.

Microsoft.com Application Framework
Larry Jordan ,Microsoft.com Development Manager, Microsoft
This presentation will take a deep look at the .NET adoption on Microsoft.com that provides a centralized framework for content aggregation ,presentation and programmability. The presentation will focus on the use of various XML capabilities in .NET and net- work distribution model of Web Services that make up the architecture of Microsoft.com.
9 a.m.

Indexing for Performance — Finding the Right Balance
Kimberly L. Tripp, SYSolutions, Inc.
There is no other area in the product where you can get better performance gains than with indexes. Ironically, this is also the most misunderstood and improperly maintained area as well. In this session we will look at what indexes are, why they are beneficial, when they can become a burden and how to get the best balance of indexes for performance. This session will cover quite a few recommendations, a very broad number of concepts — including index maintenance and numerous tips on how to get better performance without being an indexing and internals expert.
10:30 a.m.

Understanding Logging and Recovery — What Programmers Always Avoid Until It's too Late!
Kimberly L. Tripp, SYSolutions, Inc.
When the transaction log fills (or becomes large) many developers run right for automating periodic truncation of the transaction log. While you have simplified one problem, you have created another. In this session you will learn best practices for keeping the transaction log manageable, how transaction logging affects performance and recovery as well as when to set and or change between each of the Recovery Models. Know how to minimize data loss!
11:45 a.m.

Pedal to the Metal: Maximize your SQL Server’s Performance
Gert Drapers, SQLDev.Net
Do you understand what Performance Monitor is trying to tell you? Go beyond the query-based culprits of poor performance; learn to apply queuing and wait theory to determine the bottlenecks within your SQL Server environment. This session will detail how to combine the theory of queues and wait with the information supplied by performance counters, virtual tables, DBCC commands and SQL Trace to identify hotspots in your environment.
2 p.m.

Max Rows/Sec: How to Optimize Data Loading Performance
Gert Drapers, SQLDev.Net
If you have 100 million+ rows of data to load each night, what is the best data loading strategy? Learn how BCP and BULK INSERT really work, learn to take advantage of them, and to create the most optimal data loading application. This session discusses the internals and architecture of bulk data loading. What is the best way to load blobs, perform inline data type conversions, and use partitioning? These issues and more will be discussed in detail.
3:15 p.m.

The Need for Speed
Robert Patton, Optimum Technology
No query can run fast enough. Instead of relying on tuning specific queries, learn how to write better queries! Come and learn how to get your data in the fastest and most efficient manner, how to build a better WHERE clause, how to write queries that are more likely to reuse execution plans and how to avoid many of the more common pitfalls. You'll leave knowing how to write your queries, making them and all other queries that execute simultaneously perform better.
4:30 p.m.

SQL Server Query Tuning for the Software Developer
David Gugick, Intrinsic Design
This session will deliver a step-by-step approach for tuning queries in SQL Server for optimal performance. Learn how to analyze database activity, optimize queries and address performance problems using SQL Server tools like Query Analyzer and Profiler. Learn to interpret query execution plans and performance metrics. Learn the best use of clustered and non-clustered indexes for optimizing your queries. You’ll find out why stored procedures are the preferred method of SQL execution.
5:45 p.m.

SQL Live! Sessions — September 12

Data Access with Visual Studio .NET
Most mission-critical applications created with Visual Studio start with data access - from Oracle SQL Server,DB2,legacy data stores, From the impact of XML to the move from ADO to ADO how Visual Studio developers approach data access is being redefined. With native CLR-support promised in the Yukon release of SQL Server, more changes are afoot. Get a new perspective on where data access is today and how to architect your applications so they won ’t be made obsolete by the substantial changes on the horizon.
9 a.m.

MDX Without Fear
Andy Catlin, Citigate Hudson
Multi Dimensional Expressions (MDX) has emerged as the SQL-like standard across OLAP vendors. MDX is the key to building non-trivial OLAP applications. We'll write MDX including code that allocates portions of an ancestor member's value across its descendants (useful in budgeting and forecasting applications) and projects Relative Percentage Contribution of a descendant member to an ancestor. You'll also see how to prototype MDX queries as MDX expressions and you'll get a deep understanding of members, tuples, and sets.
10:30 a.m.

Build Next-Gen OLAP Apps with XML for Analysis
Andy Catlin, Citigate Hudson
Microsoft offers XML for Analysis (XML/A) as an alternative OLAP programming interface to ADO MD. In this presentation, you'll see how you can use XML/A today to create great .NET applications, and how you'll be able to further leverage XML/A as it becomes increasingly important in the Yukon timeframe. We'll look at a case study where XML/A was used to communicate between a Java Applet cube browser and a Microsoft Analysis Services cube.
11:45 a.m.

Exploring T-SQL in SQL Server
Johnny Papa, MJM Investigations
This session will demonstrate how to use stored procedures, triggers, functions, views and other T-SQL constructs in enterprise solutions. We'll examine basic T-SQL planning and demonstrate key points with code examples, including special T-SQL commands that enhance queries and improve interaction of stored procedures with ADO. We'll also cover auditing databases using triggers, calling ActiveX servers from T-SQL, and using temp tables to improve query performance.
2 p.m.

SQLXML 3.0: SQL and XML Done Right
Don Kiely, Third Sector Technologies
Microsoft has been trickling out XML features for SQL Server 2000 ever since it was originally released, and the pace is increasing as Yukon approaches. The third version of the SQLXML tools contains some easy and efficient ways to integrate XML data into applications, including setting up SQL Server as a Web services server. It even includes managed classes for use with .NET applications. During this session you'll see how to build this XML tier into your applications and see how the various tools fit together.
3:15 p.m.

SQL Under Siege: Injection Attacks and How to Prevent Them
Don Kiely, Third Sector Technologies
SQL injection attacks are the buffer overrun vulnerability of the database world. Hidden from view and hard to track down, they can allow someone with moderate database knowledge and an evil heart to run random code in your SQL Server. Are you checking code for these kinds of attacks? Is your server vulnerable? This session will explore how these attacks work, the progressive methods an attacker can systematically ferret out details of your server and expose information, and how to lock down your server to prevent against these attacks.
4:30 p.m.