Presenter :

Session :

Up and Running with Microsoft SQL Server 2005 Reporting Services

Track :

EDM

Session code :

EDM312

Synopsis :

Adam Cogan will show real world examples of this server-based platform when used for creating, managing, and delivering Web-based reports. Reporting Services 2005/2008 combines the data management capabilities of SQL Server and Microsoft Windows Server with Microsoft Office System applications to deliver real-time information to support daily operations and decisions.

Presenter :

Session :

Developing Business Intelligence Solution Using SQL Server 2005

Track :

EDM

Session code :

EDM224

Synopsis :

This session will cover how to use different BI components (RS, SSIS, AS) in SQL Server 2005 to build a complete end-to-end BI solution, including information presentation to the end user. The session will cover best practices in designing data warehouse, SSIS packages, analysis services cube, sample code to display the analysis services data in the corporate portal and the process/flow of building a BI solution based on SQL Server 2005.

Presenter :

Session :

Business Intelligence enhancement in SQL Server 2008

Track :

EDM

Session code :

EDM241

Synopsis :

In this session, we will look at the new feature and improvement that is available in the SQL Server Integration Services, Analysis Services & Reporting Services 2008 such as Analysis Services Dimension Design, Star Join Query Optimization, and improvement in the Analysis Services storage structure, personalization extensions, Change Data Capture and new SSIS script environment.

Presenter :

Session :

Data Mining for Business Users

Track :

EDM

Session code :

EDM322

Synopsis :

This session will dive deep into the usage of Excel as a front end tool for data mining. It will provide demonstrations and real life examples of how data mining might be used by business users who may or may not have a background in statistics or mining.

Presenter :

Session :

.NET: LINQ and DLINQ

Track :

EDM

Session code :

EDM242

Synopsis :

LINQ - Language Integrated Query. But what is that? It's a set of language extensions for C# and VB.NET that allow querying of objects in a SQL like manner. LINQ can be used on objects, XML, databases and more. Specifically for databases is DLINQ. Using DLINQ SQL code becomes typesafe and early bound. No more SQL errors at runtime because of typos in strings. Learn how LINQ and DLINQ will simplify your code and increase software quality.

Presenter :

Session :

Business Intelligence for the Masses with SQL Server 2005

Track :

EDM

Session code :

EDM235

Synopsis :

Business Intelligent is a big buzz word these days in many organizations. Business Decision Makers come up with an endless list of requests for the IT department in order to fulfill their business needs. Are you one of them who are struggling to satisfy them? Join us in this exciting session to realize the list of BI offerings from SQL Server for your end users, by using Microsoft Excel for data mining and Internet Explorer for reporting.

Presenter :

Session :

How to Destroy Your SQL Database in 10 Simple Steps

Track :

EDM

Session code :

EDM244

Synopsis :

Having a database in an organization is more than just common, however, the chances of messing up a database can be equally common!
In this session, we will be sharing with you on some of the common mistakes that database administrators and programmers make along areas such as configurations, queries, security settings, design, maintenance and the applications around it.

Presenter :

Session :

Microsoft SQL Server Always-On Technologies: Disaster Recovery Strategies for Isolated Damage and Human Error

Track :

EDM

Session code :

EDM333

Synopsis :

When disaster strikes, how can your database system recover quickly and with the smallest impact to production? Come to this session to find out! Features discussed include: Online Index Operations, Partial Database Availability, Online Piecemeal Restore and for prevention/monitoring - Data Definition Language (DDL) Triggers, Event Notifications, and Agent Alerts.

Presenter :

Session :

Building High Performance SQL 2005 Databases (SQL 2005: Fast & Furious)

Track :

EDM

Session code :

EDM232

Synopsis :

Have you ever experienced the occasional slowdown of your Microsoft SQL Server 2005 or of an application built on top of it? The causes can often be traced to a poorly designed application, improperly configured system or to design issues of SQL Server 2005 itself. You want to be able to diagnose the causes and take corrective actions when necessary. Join this session as we present the methodology to troubleshoot common performance problems, including resource bottlenecks, locking and blocking. Techniques presented in this session can also be used for general performance monitoring of the SQL Server 2005.

Presenter :

Session :

The Next Release of Microsoft SQL Server: Data Warehousing Enhancements

Track :

EDM

Session code :

EDM336

Synopsis :

Come learn about the enhancements in the next version SQL Server for Data Warehousing. The next version of SQL Server provides a comprehensive, scalable Data Warehouse platform that enables organizations to build your DW faster with data integration platform, manage your growing data volumes with an enterprise ready relational database and deliver actionable insights with the integration with the Microsoft BI platform.

Presenter :

Session :

Analysis Services Best Practices Part 1: Design and Storage

Track :

EDM

Session code :

EDM313

Synopsis :

Microsoft SQL Server 2005 Analysis Services includes a complete re-architecture of the Online Analytical Processing (OLAP) engine from Microsoft SQL Server 2000. This is the first of two independent presentations that focus on the performance and scalability aspects of the Analysis Services architecture. These presentations cover each aspect of cube design in detail and provide specific guidance on how to design for optimal performance. This presentation covers cube design and storage while the second presentation covers MDX and calculations. In this presentation, we will discuss cube modeling (emphasizing the importance of attribute relationships), partitioning strategies, aggregation management and cube processing.

Presenter :

Session :

Analysis Services Best Practices Part 2: Multi-dimensional Expressions (MDX) and Calculations

Track :

EDM

Session code :

EDM321

Synopsis :

Microsoft SQL Server 2005 Analysis Services includes a complete re-architecture of the Online Analytical Processing (OLAP) engine from Microsoft SQL Server 2000. These presentations cover each aspect of cube design in detail and provide specific guidance on how to design for optimal performance. The first presentation covers cube design and storage while this presentation covers MDX and calculations. In this presentation, we take a look under the hood of the OLAP formula engine to understand how MDX queries and calculations are evaluated, along with a sneak peek into some performance related work coming in the next release. Finally we point out common gotchas for poor performance in MDX and best practices to address them.

Presenter :

Session :

Be More Productive With SQL Server 2005 Tools

Track :

EDM

Session code :

EDM343

Synopsis :

Learn how the SQL Server 2005 tools can make your life easier. This session drills into the features and demonstrates how to best leverage your efforts toward efficiency. Learn tips and techniques for effectively using SQL Server tools, understand how they work under the hood and find out how these tools can make your job easier. This session features demos of Management Studio, Profiler/Replay, Database Engine Tuning Advisor, etc.

Presenter :

Session :

Microsoft SQL Server 2008: Overview

Track :

EDM

Session code :

EDM214

Synopsis :

This session provides an overview of the next release of SQL Server that is currently under development. We cover the core value-proposition, major themes and scenarios, and some specific improvements. We also cover the new development processes being used to build this release and the release timeline.

Presenter :

Session :

Things You Need to Know for a Painless Upgrade to Microsoft SQL Server 2005

Track :

EDM

Session code :

EDM331

Synopsis :

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. The session has live demos of Upgrade Advisor and in-place upgrade features of SQL Server 2005.

Presenter :

Session :

High performance CLR Procedures in SQL 2005

Track :

EDM

Session code :

EDM425

Synopsis :

This session covers the designing of CLR stored procedures and showcases the high-performance applicability of CLR functions inside SQL server 2005. It also talks about custom data types and how .NET objects can be stored in SQL 2005 and re-purposed for high performance algorithms.

Presenter :

Session :

Choosing the Right Edition of Microsoft SQL Server 2005

Track :

EDM

Session code :

EDM311

Synopsis :

SQL Server 2005 is available in a number of editions to best match the demands of business applications. But, one of the common mistakes is choosing the wrong edition of SQL Server to support your business. In this session, you can learn about the differences between various editions of SQL Server along with a detailed description of the exclusive features in each edition. This session provides practical usage scenarios and benefits of each edition along with demos. Learn how to choose the right edition of SQL Server to support you data requirements; whether it is a small personal database, a large enterprise application, a scalable solution or a mobile application.

Presenter :

Session :

Why Upgrade to SQL Server 2005

Track :

EDM

Session code :

EDM326

Synopsis :

Do you know what benefits you can deliver to your organization just by upgrading to the Microsoft SQL Server 2005 database engine? Attend this session to find out. Even if you do not use any of the new features in SQL Server 2005, such as database mirroring and table partitioning, or writing stored procedures in Microsoft .NET languages, you can still reap great benefits. This session introduces the many new features in SQL Server 2005 that you can utilize, without rewriting your applications or undertaking any new development efforts. We provide many examples where you can improve your system's performance, concurrency, and availability simply by upgrading.

Presenter :

Session :

Obtaining and interpreting SQL Server Query Plans

Track :

EDM

Session code :

EDM334

Synopsis :

Optimizing query execution performance is a topic that is always important for SQL administrators and developers. To improve performance and detect bottlenecks, it is important to understand how your queries are executed by SQL Server. In this session, we show you various ways of obtaining query execution plans, with and without knowing the application source code. Then, we explain how execution plans are interpreted, what operators exist, what they do and what to look out for when trying to optimize query performance.

Presenter :

Session :

SQL Server High Availability – Mirroring and Clustering

Track :

EDM

Session code :

EDM323

Synopsis :

SQL Server provides various methods to improve availability of databases and to protect them from failure of disks, servers or whole data centers. In this session, we provide an overview of clustering, database mirroring and other HA technologies and demonstrate how they work in live demos.