SQL2TheMax SessionsThursday, February 14
KEYNOTE: Build Petabyte Databases with SQL Server
Jim Gray
Microsoft Research Group
Microsoft
Emerging applications need to store billions of megabytes (petabytes). We'll begin by sketching some of these apps and their requirements. We'll then focus on two large databases: the TerraServer which has morphed into the TerraService Web service. We'll explain that evolution and the current efforts on geo-spatial data. We'll then look at the SkyServer and the Virtual Observatory presented: its goal is to put all astronomical data online and accessible as Web services. The SkyServer has a demanding data mining component. Database technology can revolutionize the way computational science is done: moving it from a script+files metaphor to a visual data miner metaphor. Come and find out what it can do for you.
8 a.m.
KEYNOTE: One Company's View on Web Services
William A. Swope
Intel
Expanding Web service applications on Intelｮ architecture represents a significant opportunity to software developers. Intel is a building block supplier to the worldwide Internet community, providing the microprocessors that power the majority of servers and personal computers in the world today. Join William A. Swope, Vice President and Co-General Manager of Intel's Software and Solutions Group, in a discussion of Intel's view on Web services.
9:15 a.m.
Tune Up Your SQL Server 2000 Databases with Better Indexing
Kimberly L. Tripp-Simonnet
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. We will define and demonstrate the amazing performance gains that can be recognized with the right indexes in the right places at the right time. We will focus on improving performance for SARGs, Joins and Aggregates. We'll discuss what types of indexes can give performance gains in each of these areas but for consistent, long-lasting performance gains you must maintain them.
10:30 a.m.
Integrate SQL Server 2000 XML with ADO .NET
Laura Barker
Empowered Software Solutions
Learn the fundamentals of SQL Server XML features and how to use the "FOR XML clause" for maximum effect. We値l show you how to create stored procedures to return the XML and what the XML DOM is and how to use it. Plus, you値l find out how to code the ADO .NET to access the data in SQL Server 2000 and the use of strongly typed datasets using XSD and SQL Server 2000 stored procedures. We値l tie up all this to a Web Form application using a treeview control.
12:30 p.m. DATA
Index Maintenance: Why & Automation
Kimberly L. Tripp-Simonnet
SYSolutions, Inc.
If you want to keep a database compact and keep the performance optimal, you must de-fragment your indexes. Understanding the structures of indexes and why indexes can become fragmented is half the battle, but knowing the right way to rebuild and how to automate the process is the other half. We'll look at critical index rebuild options such as FILLFACTOR as well as compare the different options available for rebuilding the indexes. We will compare CREATE with DROP_EXISTING vs. DBCC DBREINDEX vs. DROP and CREATE vs. DBCC INDEXDEFRAG as well as show you how to easily automate your index rebuilds.
12:30 p.m. FUNDAMENTALS
Multidimensional Expression Queries for ADO Programmers
Don Kiely
Third Sector Technologies
MDX queries are the key to accessing multidimensional data stored in today's data warehouses. Vaguely similar to SQL, it is different enough with curly brackets and constructs to provide a new learning curve. Together we'll cover the most important MDX language features and look at many queries to solve common data access tasks. We'll also demonstrate how the data structures returned by MDX relates to the structures in an OLAP cube, as well as discuss the SQL Server PivotTable Services, part of Analysis Services, that allow an application to interact with multidimensional data.
1:45 p.m. DATA
Working with Linked Servers
Michel Ulens
United Solutions bvba
MS SQL Server has been enjoying increasing popularity as a database platform. But of course, many organizations have other RDB platforms installed. Linked servers provide an elegant solution for organizations wanting to integrate MS SQL server apps with other (legacy) RDB platforms. We'll demonstrate how to accomplish this by linking to an Oracle database, and giving a clear example of how to extend the power and flexibility of your database needs.
1:45 p.m. FUNDAMENTALS
SQL Server Security
Michel Ulens
United Solutions bvba
This is your chance to learn about security from the developer of one of the largest-scale secure SQL Server applications in Europe. You'll see how to set up security in SQL Server, and then keep it secure. Knowing how to set up users, assign them rights, create user roles, use security information in your own applications, and audit granted rights is just a few detailed steps away.
3 p.m. DATA
Distributed Partitioned Views
Ken Henderson
Author
We will show you what works and what doesn't with DPVs, what to watch out for, how to tune DPVs for maximum performance, and how to avoid common mistakes. We'll discuss the basics of settings up DPVs in the first place, along with advanced topics such as troubleshooting problems with DPVs and speeding up DPVs that perform poorly.
3 p.m. FUNDAMENTALS
Data Mining with MS Analysis Services
Andrew Brust
Progressive Systems Consulting
SQL Server's Analysis Services technology discovers patterns and correlations in data and makes predictions about new data that you can use for targeted marketing and mailing. We'll illustrate how to maximize SQL Server 2000's data mining power through demos that build a mining model on a relational database. We'll then show you how to write code to run predictions on new data sets yourself. Finally, we'll also look at how Microsoft's XML for Analysis spec, ADO and ADO .NET tie in to the picture.
4:15 p.m. DATA
Error Handling in Transact SQL
Josef Finsel
G.A. Sullivan
Error handling within Transact SQL can be confusing for programmers. One reason is because the purpose of error handling in T-SQL is different from the type of error handling that we do in Visual Basic or C# in dealing with transactions. We'll walk you through how error handling in SQL Server is different from error handling in other programming languages and teach you different ways to implement error handling in stored procedures. We'll include how ADO .NET handles the errors that get raised.
4:15 p.m. FUNDAMENTALS
Manage Slowly Changing Dimensions with DTS and T-SQL
Trey Johnson
Encore Development
Dive deep into the management of the three types of Slowly Changing Dimensions, with Data Transformation Services and Transact SQL. We値l start with an overview of the three Slowly Changing Dimension types and practical examples of each. We値l then explore these practical examples further through demonstrations of techniques for managing the dimension loading process in both Data Transformation Services and Transact SQL from relational and non-relational data staging environments. Finally, it will all be tied together with a benchmark comparison of the techniques that show when each technique is appropriate.
5:30 p.m. DATA
SQL Dialects: Using Multiple RDBMSs
Judy Bowman
Author
More and more database users are working with multiple RDBMSs. The transition is often difficult, until you figure out how to apply what you know about system A to system B. Areas with a lot of overlap despite differences are system tables (and using them to generate SQL), most SQL commands, and SQL functions. Areas with bigger hurdles in understanding include generating sequential numbers, and using stored procedures and cursors. Our goal is to get you comfortable with a selection of SQL dialects: you'll leave knowing how and where to look for variations from what you've already learned.
5:30 p.m. FUNDAMENTALS
SQL2TheMax SessionsFriday, February 15
KEYNOTE: Architect Analytical Applications with SQL Server and .NET
Dave King
Senior Vice President of Product Development and Chief Technology Officer, Comshare
Analytical applications are packaged software that focuses on the optimization of business operations and opportunities. This keynote will explore and demonstrate how Microsoft's Analysis Services can be used in concert with .NET technologies-including SOAP and XML for Analysis-to deliver analytical information to decision makers in real time, anywhere on any device.
9 a.m.
OLAP with Microsoft Analysis Services, Part I and II
Andrew Brust
Progressive Systems Consulting
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. We will define and demonstrate the amazing performance gains that can be recognized with the right indexes in the right places at the right time. We will focus on improving performance for SARGs, Joins and Aggregates. We'll discuss what types of indexes can give performance gains in each of these areas but for consistent, long-lasting performance gains you must maintain them.
10:15 a.m. & 11:30 a.m. OLAP
Intro to Replication
Michael Hotek
Independent Consultant
We'll show you how to become an expert in the main replication methods, including the trade offs between methods, and how you evaluate replication as a solution in your environment. You'll leave with an understanding of replication and be able to intelligently evaluate and select a replication method to fit a business problem.
10:15 REPLICATION
Create Generic Replication Scripts
Ron Talmage
Prospice, LLC
The replication scripts produced by Enterprise Manager are not applicable to general situations. Together we'll produce replication scripts that are more structured and general purpose. You'll walk away with a better grasp of replication than ever before and leave with plenty of code to make replication easier when you go back home.
11:30 p.m. REPLICATION
Special Lunchtime Presentation: SQL Server 2000: Tips & Tricks and Otherwise Cool Stuff
Kimberly Tripp-Simonnet
SYSolutions, Inc.
SQL Server 2000 offers options to Developers and Admins unlike any other version, but there are still areas that seem to get overlooked. We'll look at some of the lesser-known features of SQL Server to make sure that you've turned over every leaf. Topics will include Case Sensitive Searching in a Case-Insensitive Database, Minimizing Transactional Code by Setting Variables within an Update statement, Parameterized Messages including setting their State, Creating Cool Constraints, VLDB Best Practices for Backup (using File/Filegroup Backups) and Saving Production Tables from Production dBAs. Plus, we will give you lots of excellent code examples to make your job easier.
12:30 p.m.
XML Web Services and SQLXML 3.0
Jay Schmelzer
Clarity Consulting
The SQLXML web releases provide several new features for interacting with a SQL Server 2000 database via XML technologies. SQLXML 3.0 continues to build on these features, adding the ability to expose SQL Server 2000 data via XML based web services. We値l show you how to create XML Web Services using SQL Server 2000 stored procedures, SQLXML Templates and consume them from a .NET application.
1:30 p.m. XML
Optimize Stored Procedure Performance
Ken Henderson
Author
We will discuss SQL Server performance tuning from the perspective of stored procedures. We'll talk about how to maximize the procedure cache, how to achieve maximum plan reuse, avoid recompiles, and troubleshoot stored procedures that don't perform very well.
1:30 p.m. SCALABILITY
Use SQLXML on SQL Server 2000, Part I
Brian Matsik
Author
Learn how to install and configuring SQLXML on IIS and SQL Server 2000 with ease. We'll cover security configuration and typical "do" and "don't" issues with the add-in. We'll also further explore the use of templates for generating XML results from SQL Server and finish up with a look at the schema and analysis of the SQL to XML conversion.
2:45 p.m. XML
The Need for Speed
Robert Patton
PurchasingFirst
No query can run fast enough. Often developers use the execution plan as a clutch to tune specific queries. Instead of relying on tuning specific queries, make your data access perform better by writing your queries better. Learn when and how you should use the various data transfer methods available to you to make your queries lightning-fast.
2:45 p.m. SCALABILITY
ASP.NET Using XML Data Directly from SQL Server
Don Kiely
Third Sector Technologies
SQL Server 2000 introduced some powerful techniques built on XML for accessing data in a cross-platform format. You can retrieve data in a native XML format, customize the format however your application needs it, and even update existing relational data using XML data. The result is a much more flexible Web application that can send data to any client and receive data from any platform. We'll explore the extensions to Transact SQL, HTTP features, and ASP extensions built into SQL Server that can provide all these benefits to your ASP application and much more.
4 p.m. XML
Tales From the Trenches: Real World Performance Tuning
Michael Hotek
Independent Consultant
Proper planning can eliminate headaches and frustration. Why not learn from someone else's tales of woe: Learn how to avoid severe problems after deployment by following a few important tips. We'll dig into some of the basic coding and design constructs that work well and those that don't. You'll see what techniques have been developed over the years to quickly evaluate an environment, target major bottlenecks, document the problems, break those problems down, and how to patch or fix them. You'll get nothing but pragmatic advice derived from real experiences and environments at real clients.
4 p.m. SCALABILITY
Use SQLXML on SQL Server 2000, Part II
Brian Matsik
Author
Building on the first session's materials, we will cover the larger topic of XDR schemas and updategrams. We will take the existing installation of SQLXML and extend the functionality to allow for database mapping and auto-generation of the SQL statements. We will once again look at the SQL to XML layer and what is occurring on the server. Finally, we will look at updategrams as an interface to send data back to the server for inserts, updates, and deletes.
5:15 p.m. XML
Resolve Deadlocks
Ron Talmage
Prospice, LLC
Finding and resolving SQL Server 2000 deadlocks can be a very difficult task. Together we'll use Profiler and the -T1204 trace flag to find and resolve various kinds of deadlocks. This session will give you every tip and trick available for tackling these nasty problems with ease.
5:15 p.m. SCALABILITY
|
