We are getting closer! Combining your input, speaker availability and their skills the list below is the result...
Database Administration & Development Track
This track will have content for both the developer and administrator. For the developer,get up to speed on the powerful new developer features in SQL Server 2005, including many new and updated services that go beyond the traditional database features and can significantly enhance developer productivity. For the administrator learn how to get the most from SQL Server 2000 today and discover how, with SQL Server 2005, you can deliver breakthrough performance, securely, and reliably with the most powerful and productive suite of tools to manage SQL Server across your enterprise.
Title: SQL Server 2005: End-to-End Part 1 (Design and Build)
Abstract: There are a number of steps involved in the creation of a database application. In this series of sessions we look at the full application lifecycle, from design and build, through deployment and operations to adding BI features to the final application. Throughout the series, you'll see best practices for approaching each phase, so if you are looking for the best way to build SQL Server 2005 applications, then these three sessions are the place to start. In the first of this series we look at the process of designing and building a SQL Server 2005 database application. The session covers design and architecture decisions, focusing on many of the new choices provided by SQL Server 2005 and goes on to look at how to implement this application using Visual Studio 2005 and SQL Server 2005. We cover decisions related to the choice of tier for implementing application functionality, the choice of technology in SQL Server 2005 to use for various implementation scenarios and the specifics of how to implement the features decided upon.
Australian Speaker: Jeremy Boyd [firstname.lastname@example.org]
New Zealand Speaker:Jeremy Boyd [email@example.com]
Title: SQL Server 2005: End-to-End Part 2 (Deploy and Operate)
Abstract: There are a number of steps involved in the creation of a database application. In this series of sessions we look at the full application lifecycle, from design and build, through deployment and operations to adding BI features to the final application. Throughout the series, you will see best practices for approaching each phase, so if you are looking for the best way to build SQL Server 2005 applications then these three sessions are the place to start. In the second of this series we look at how to take the application that was designed and built in the first session and deploy it into a production environment. We review many of the decisions that you can make with regards to setting the environment up to achieve great reliability, scalability, availability and security. We also look at how SQL Server 2005 helps you manage and operate your application more efficiently once it is deployed, including looking at how the new management and operation tools let you monitor your systems and schedule common tasks, giving you more time to focus on value added tasks.
Australian Speaker: Tony Bain?
New Zealand Speaker:Tony Bain?
Title: Upgrade and Migration: Planning Considerations for SQL Server 2005
Abstract: The new features of SQL Server 2005 are well worth the upgrade effort, but how do you upgrade your existing systems painlessly? This session drills into the necessary upgrade planning: preparing to upgrade, choosing the best upgrade strategy, and identifying incompatibility issues. Learn tips and techniques on how to reduce your upgrade down time and how to best utilize the upgrade tools. This session has live demos of the Upgrade Advisor tool and in-place upgrade features of SQL Server 2005.
New Zealand Speaker:
Title: Backup and Recovery Strategies for SQL Server 2005
Abstract: SQL Server 2005 offers an extended feature set for data availability, backup and recovery. For VLDB systems, these new features can offer minimal impact to production data availability even in the event of disk failure or human error. Come to this session to see how VLDB strategies, which include partitioning, can offer more options to keep your database online, as well as offer fast recovery times. Key features covered are: Table/Index Partitioning targeted Backup/Restore, online recovery and Database Snapshots. In this session, a damaged partitioned database that remains available even through catastrophic disk failure as well as demo recovery of the database while still online. Finally, we talk about how database snapshots work, suggesting how to use the feature to offer easier and faster recovery paths in the event of human error. Attend this session to learn how to keep your VLDB more available and minimize data loss!
Australian Speaker: Ron Talmage
New Zealand Speaker:Ron Talmage
Title: Together at Last: Combining XML and Relational Data in SQL Server 2005
Abstract: SQL Server 2005 now has native support for XML. This brings new opportunities to combine relational and XML data to provide flexibility with your data store. In this session, see how the XML data Type is implemented in SQL Server 2005 and take an in-depth look at the other features that help you work with this new data type, including XQuery and XML Indexing.
Australian Speaker: Jeremy Boyd?
New Zealand Speaker:Jeremy Boyd?
Title: Be More Productive: A Guided Tour of the New Management Tools in SQL Server 2005
Abstract: Learn how the next generation of SQL Server 2005 tools can increase your productivity. This session drills into the new features of the tools, and demonstrates how to best leverage them to increase your efficiency. Come away with tips and techniques for increasing your productivity with the new tools. This session is filled with demos of Management Studio, SQL Agent, Profiler/Replay, Database Tuning Advisor & SQLCMD.
Michael RaheemNew Zealand Speaker:
Title: High Availability in SQL Server 2005 & Scalability Strategies in SQL Server 2005
Abstract: SQL Server 2005 Table and Index Partitioning: Improving Scalability and Manageability for Large Databases
Title: SQLCLR v T-SQL: Best Practices for Development in the Database & SQLCLR Internals: SQL Server 2005 as a CLR Runtime Host
Abstract: SQL Server hosts the .NET runtime in process; this is different than the way other databases host program execution engines. This session explores the inner workings of the SQL Server-CLR relationship and discusses how SQL Server ensures that CLR code runs safely, securely, and efficiently.
Australian Speaker: Greg Low
New Zealand Speaker:Greg Low
Title: Understanding Isolation in SQL Server 2000 and 2005
Abstract: SQL Server 2000 offers four levels of isolation -- a full implementation of the ANSI/ISO standards for isolation. But, did you know the standards mostly cover data access and behavior, not implementation? Because of this, different products can behave differently and have different "phenomena" occur in each level. In this session, we cover the four standard isolation levels and how they work by default in ALL releases of SQL Server as well as the new features offered in SQL Server 2005. SQL Server 2005 offers two new flavors of isolation whose enforcement is very different than the traditional levels... new to this release are non-blocking, non-locking read transactions where readers don't block writers and writers don't block readers. See how BOTH of these new settings are turned on as well as when/why you should use them. If you want to make your data more available and minimize livelocks and deadlocks, this is the place to be!
Title: Migrating from Oracle to SQL Server 2005 <<Combined with>> Get More from Your Oracle Data with SQL Server 2005
Abstract: This session covers the many options available to you help you migrate your existing Oracle applications to SQL Server 2005. It highlights real customer experience with the migration process and showcases some SQL Server 2005 specific features, such as Oracle publishing, that significantly ease the work.
Australian Speaker: Jason Buck
New Zealand Speaker:?
Title: Understanding Index Usage and Indexing Best Practices in SQL Server 2005
Abstract: While many indexing best practices continue from SQL Server 2000, there are some new features of which you should be aware. SQL Server 2005 offers more options to cover queries alleviating some SQL Server 2000 restrictions. In this session, we review a good strategy for table clustering, look at supporting non-clustered indexes and focus on non-clustered covering as well as Indexed Views. Finally, in addition to index creation we briefly cover the new online operations and how they will impact your table design. If you want optimal table structures, better data availability as well as a strategy for indexing for performance, this is the session to attend!
Title: What Nobody Told You About Protecting SQL Server
Abstract: Jesper's at it again…Showing us how Hackers take your work apart and how you can protect…Not to be missed! Just securing your SQL Server 2005 database is not enough. If you develop unsecured applications then all your good work on the server can be lost. In this session we look at how to connect to the new security model in SQL Server 2005 as well as best practices for creating secure applications, including native data encryption and how to ensure that all your data moving between SQL Server 2005 and your application is secured.
Australian Speaker: Jesper Johansson
New Zealand Speaker:Jesper Johansson
Title: Integrated Innovation: Using ADO.NET 2.0 with SQL Server 2005
Abstract: SQL Server 2005 and ADO.NET 2.0, along with the rest of the .NET Framework 2.0, have been in the works for some time now and they bring lots of innovation with them -- not only that, they've been carefully designed to work together and provide the best platform for integrated database application development. In this session we discuss the key features that make ADO.NET 2.0 and SQL Server 2005 a winning combination. We touch on topics such as using ADO.NET inside SQL/CLR, System.Transactions integration, asynchronous command execution, and new data type support.
Title: Architecting a Large Scale Data Warehouse with SQL Server 2005
Abstract: This session discusses best practices and real-world experience in architecting a large scale and high volume data warehouse using SQL Server 2005. Review the techniques required to handle the transformation and loading of over two billion rows of transactional data on a semi-weekly basis. See how the advanced features of SQL Server 2005 Integration Services and Relational Database -- including indexing and table partitioning, CLR user defined functions, pivot functions, etc. -- contributed to a successful solution.
Australian Speaker: Mark Morton?
New Zealand Speaker:
Title: Developing SQL Server 2005 OLAP Applications with ADO MD.NET
Abstract: ADO MD.NET lets developers create great BI front-ends by combining the best of ADO.NET and classic ADO MD. The MDX query language has been enhanced to leverage new SQL Server 2005 features like server-side key performance indicators. We discuss how to use these and other technologies to create compelling front ends and feature-rich middle tiers around your SQL Server 2005 OLAP cubes. Whether you're new to OLAP or a seasoned pro, this session gives you the roadmap you need to integrate with the SQL Server release that will truly deliver on the promise of BI.
Australian Speaker: danny tambs?
Title: Real-Time BI with SQL Server 2005 Analysis Services
Abstract: Real-Time BI with SQL Server 2005 Analysis Services (real Abstract pending)