SQL Server 2005 is Microsoft's biggest SQL release ever with an estimated 1 million beta testers worldwide, and large numbers of UK companies already using and evaluating the product. Hear how SQL Server fits with Microsoft's product strategy and how central SQL Server is to the Windows Server System, Microsoft's integrated technology stack.

SQL Server 2005 is a vitally important part of the Windows Server System Strategy and Microsoft's biggest SQL release ever. Hear how SQL Server fits with Microsoft's product strategy and how central SQL Server is to the Windows Server System.

This session will provide an introduction to the sessions covered in this second day of the Security track, which will build on the learning's from day one and show how application Security strategies can provide real business benefits. We will also cover Microsoft's drive for Trustworthy Computing and how this important initiative has been progressing and driving change for non attendees from Day one.

In this session we'll look at the #1 developer feature in SQL Server 2005: the integration of the .NET Common Language Runtime. Come along to find out how developers for SQL Server 2005 can write .NET code in languages such as C# and VB.NET in order to implement stored procedures, user defined functions and types and other artefacts for running inside the database server. We'll look at how we make use of the in-process data provider to obtain data from SQL Server and we'll also step outside the database to look at the new features in ADO.NET 2.0 such as query notifications and asynchronous commands.

Microsoft SQL Server 2005 is the next version of the successful SQL Server product family. This new edition offers a number of enhancements to provide a product for today's environment. This session looks at the key areas that concern IT professionals. You will find out about various security enhancements, including the authentication changes and the granularity of permissions that the product allows, changes to improve service availability and replication of data, and improvements in the manageability of the product.

A security strategy for an organisation is most effective when data is protected by more than one layer of security. A defense-in-depth security strategy uses multiple layers of defense. If one layer is compromised, it does not necessarily follow that the security of your entire organisation will be compromised. A defense-in-depth strategy increases an attacker's risk of detection and reduces an attacker's chance of success. This session will build on existing knowledge of Windows security and show how to enhance security for applications and Windows Server System components - covering security best practices for Microsoft SQL Server, Microsoft Exchange Server and Microsoft Windows Small Business Server. You will also learn about technologies to protect data and restrict access to sensitive information.

Does the arrival of .NET programming for SQL Server mean that T-SQL is dying off? Is it looking a little sickly, perhaps? Will we have to create our tables using managed C++? The short answer is, of course, a resounding "No!". You can get the longer answer by coming to this session where we'll look at the spectrum of new features that have been added to T-SQL for SQL Server 2005. If you're used to writing T-SQL error handling code with @@ERROR and GOTO's then you absolutely need to see T-SQL's new exception handling capabilities. If you've tried to mix OLTP and Reporting in the same database you'll be interested to see the new options around transaction isolation. If you've ever worked with the database then you'll be interested in the plethora of new fancy bits to play with such as support for pivot tables, common table expressions and much, much more. Come along. Pull up a chair. Take your shoes off :-)

Real-Time Communications and Collaboration (RTC) technologies are helping to break down the barriers between working, communicating, and collaborating. Live Communication Server (LCS) is an Enterprise Instant Messaging (IM) and Presence Solution and an RTC platform. This session will provide you with an overview of this solution and how it integrates with Office 2003 and our other enterprise offerings. Explore how LCS, can be coupled with Microsoft Exchange 2003 and Outlook 2003 to provide increased security and collaboration for users, providing a single user console for both messaging and instant messaging needs. Demos will show the LCS interface, the Windows messenger client, and integration with Office.

This session will build on existing knowledge of server and client security and receive advanced prescriptive guidance to secure servers and clients in high-security environments. The session will provide in-depth information on additional techniques for securing servers and will demonstrate technologies and practices you can use to enhance security for local and remote clients. We'll see how Windows XP SP2 and Windows Server 2003 SP1 security enhancements can deliver advanced security when implemented with the prescriptive guidance.

Do you store relational data? Do you process XML? There aren't many developers today who can answer "no" to those questions. In SQL Server 2005, XML becomes a rich data type that the database understands deeply in order to provide rich query and modification semantics. In this session we'll take a long, hard look at the new XML data type in the database and how we interact with it. We'll then widen the discussion to include other XML features such as "FOR XML" enhancements, XML web service capabilities and programming XML from the client side.

SQL Server 2005 is making great strides in harnessing the power of Business Intelligence and delivering it to an ever larger audience. This session will provide you with an overview of the new features in Analysis Services, including the radically new Unified Dimensional Model which combines OLAP world with the best of the relational world. You will also learn about new data mining algorithms, improvements in the relational model for data warehouse support and how reporting services is improved with a new end user tool, Report Builder. Much of the presentation will be based on a demonstration of the product, showing many of the new features and contrasting them with SQL Server 2000.

This session will build on existing knowledge of server, client and network security and learn practical strategies for implementing security best practices across your IT environment. It will show that by aligning to business needs, you can show business value and allow the business to support the IT security investment requirements. You will also learn real-world strategies for patch management and network security and how to troubleshoot problems with existing security configurations. The session will also discuss best practices for enhancing security across heterogeneous environments including legacy and third-party systems.

In this session we'll take a look at the new features that SQL Server 2005 has for the B.I. developer. We'll introduce Business Intelligence Development Studio and the new features such as triggers and traces within the engine itself. We'll look at the new support for Key Performance Indicators, the simplified dimension model and the new algorithms and features in data mining. We'll also look at SQL Server 2005 Reporting Services and how to make use of it from within your applications, including how to design reports using Report Designer and interacting with the Report Server through Web Services. We'll explore all of the new features in the 2005 version, including integration with Visual Studio 2005, the work that has been done around Analysis Services, improved report interactivity and the new built-in controls for Windows Forms & ASP.NET Web Forms applications.

Designed to inrease the security, reliability and productivity, Service Pack 1 (SP1) to dramatically changes the security equation for Windows Server 2003. One way this is achieved is by reducing the attack surface of Windows Server 2003 and bolstering its security. As plugging old holes and incrementally tuning server performance is not enough to meet the challenges of increasingly aggressive attacks SP1 also delivers exciting enhancements and dynamic new functionality to Windows Server 2003. This session will provide you with a technical overview of SP1, including Windows Firewall, Post-Setup Security Updates and Security Configuration Wizard.

This session introduces the Security Risk Management Guide, which has been designed by Microsoft to help organisations establish a process for risk assessment, cost benefit analysis, and implementation of security countermeasures. The guide also provides information on establishing an ongoing process of security risk management. The session takes a qualitative approach to risk management, tying in best practices from both the industry as well as Microsoft's internal IT Group.

This session is all about taking advantage of new features in SQL Server 2005 to get your data to where you need it to be. We'll look at getting data to the phone in your pocket and the PDA in your bag by developing applications with the new SQL Server 2005 Mobile Edition and how replication can be used to make that data available. We'll also introduce other new features in replication such as the ability to publish data from Oracle databases. From there, we'll broaden our discussion to look at how we can get all kinds of data into and out of SQL Server by developing applications that make use of the new SQL Server Integration Services (formerly Data Transformation Services (DTS)). We'll look at the new pipeline architecture and Visual Studio development environment for Extracting, Transforming and Loading data with SQL Server 2005. Whether you already know DTS or are new to the topic we think you'll be pretty excited by what SQL Server Integration Services can do for you.

This is your opportunity to learn about SQL Server Integration Services (SSIS), the new Extract Transform and Load (ETL) tool in SQL Server 2005. This is a completely new product employing new concepts and features to replace the Data Transformation Services tool in SQL Server 2000. . A major change is the separation of workflow and data transformation. Also included are numerous new transformations and workflow options, whilst limiting features have been lifted completely. This new product should be suitable for the most complex and stressful enterprise applications whilst also remaining straight forward to use. It will more than challenge the performance and functionality of the leading ETL tools on the market today.

Many people view the task of securing their wireless network as a hugely complex endeavour - it doesn't have to be. Some vendors advocate VPN technology or firewalls as the only way to secure wireless - these can be expensive, and complex for users and administrators alike. This session will look at the easy-to-implement, standards-based approach to high security wireless LANs. Using Windows XP and Windows Server implementing industry standards such as WPA, 802.1X and PEAP, we will show you how to build a serious Wireless LAN security infrastructure that is simple to manage and with a great user experience. On the way we'll navigate through the myriad wireless standards and acronyms and look at the some of the experiences of implementing the largest wireless network in Europe - Microsoft's campus in Reading.

12:50-14:00

The SQL Server 2005 Toolbox: A look at the expanded toolset for working with SQL Server 2005

15:50-17:00

The SQL Server 2005 Toolbox: A look at the expanded toolset for working with SQL Server 2005