SQL Server - PDC09 Prep Guide For Server Guys+Gals

  • Article

image This post focuses on a series of select sessions closely related to the Windows Server platform. Read all related posts.

The post highlights selected sessions and gives guidance on what to read or which website to check out to make the most out of your visit to PDC2009.

Certainly not complete but something to get you started.

SQL Server Sessions @PDC2009

Making Microsoft SQL Server 2008 Fly

Hear best practices for getting the fastest query processing for general-purpose applications, including logical and physical database design, statistics management, query design, query tuning, problems areas to avoid, and more. Learn which query constructs cause the query optimizer to rely on guesses rather than accurate statistical estimates for the number of rows returned by sub-plan. Also learn how to work from an understanding of your query and update patterns to develop a high-performance set of indexes for database tables. Find out how parameters and local variables effect plan selection and optimality, and how that can impact performance of your applications. See how how your choice of data types for join keys can affect join performance, and how data compression affects CPU overhead and I/O.

Resources:

Microsoft Semantic Engine

See how the Microsoft Semantic Engine brings search, structured query, and analytics together in a simple, unified Search-Discover-Organize usage model. Learn how it addresses the need to have unified access to structured and unstructured enterprise data through easy to use analytical tools. Also learn how to enable business insight to support decision making at all levels within the enterprise. Get an overview of the Semantic Engine, its architecture, the product and its APIs.

Resources:

Microsoft Project Code Name “Repository”: Using Metadata to Drive Application Design, Development, and Management

Come see how to use the Microsoft SQL Server "Repository" to increase speed and accuracy of development, deployment, maintenance, and management of your enterprise applications. The "Repository" is a central management database for application lifecycle metadata. Learn how to perform impact analysis, architecture validation, and manage application configuration/deployment using the UML, CLR, Identity, and deployment models in the "Repository".

Introduction to Microsoft SQL Server 2008 R2 StreamInsight

Microsoft SQL Server 2008 R2 includes an exciting new platform called StreamInsight for building rich data processing over real-time event streams. This technology is ideal for applications that need to process high volumes of event stream data with no latency. Learn the basics of how to build a StreamInsight input adapter for monitoring an event stream, how to construct real-time queries in LINQ and install them in the highly scalable StreamInsight engine, and how to build a StreamInsight output adapter to visualize the results from your queries.

Resources:

Advanced Microsoft SQL Server 2008 R2 StreamInsight

This is the second session in a series focusing on Microsoft SQL Server 2008 R2 StreamInsight, a new platform for building rich data processing over real-time event streams. Come get a detailed architectural walkthrough of the three major components of StreamInsight: input and output adapters SDK, the StreamInsight engine runtime, and the semantics of the continuous standing queries hosted in the StreamInsight engine. Learn how the engine deals with out-of-order data arrival and how to achieve close to real-time latency for queries. Examine best practices for performance and scalability, and hear a few case studies of real-world StreamInsight implementations and the lessons learned from them.

Resources:

  • see above session
Simplifying Application Packaging and Deployment with Microsoft SQL Server 2008 R2

Come explore the new enhancements in SQL Server 2008 R2, known as Application and Multi-Server Management, which enable a more efficient way to develop, deploy, and manage data-tier applications and instances. See how a new single unit of deployment for database applications is integrated with Microsoft Visual Studio and helps enable developers to more quickly write higher quality database applications, author deployment policies based on the needs of their applications, and hand off a single package to database administrators. Also learn how improvements combine a first-class Transact-SQL IDE with a new Visual Studio 2010 project template known as .DACPAC (Database Application Component) to produce a comprehensive model of the objects, policies and runtime resources required by a data-tier application.

Resources:

Developing Rich Reporting Solutions with Microsoft SQL Server 2008 R2

SQL Server Reporting Services (SSRS) provides a comprehensive platform for developing and delivering rich enterprise reporting functionality over the Web. SSRS reports support rich data visualization and navigation features, and can be rendered in most popular formats. Come get a quick review of SSRS report development, and explore some of the key improvements in SQL Server 2008 R2, including new map visualizations, a new component library, using existing reports as a data source for the new PowerPivot functionality in Microsoft Excel 2010, and an improved AJAX enabled Report Viewer control for building Web-based reporting solutions.

Resources:

See you @PDC09.