Microsoft SQL Server Secrets for Developers

Microsoft SQL Server is a relational model database server produced by Microsoft. Its primary query languages are T-

SQL and ANSI SQL.
1. 5 Things SQL Server does different from what many developers expect
This talk is intended for the developer who knows about inner and outer joins, and knows how to write a T-SQL stored

procedure. But sometimes developers bump into ‘weird’ behavior of SQL Server. This sessions dives into 5 common

misconceptions developers have on SQL Server. We touch upon these topics: Transactions (nested transactions, the five

and a half isolation levels), stored procedures (do they really speed up my query, what is the effect of the pre-

compilation?), error handling (errors in a try block will jump to the catch block, don’t they?), statistics (SQL

Server builds them automatically, so I shouldn’t worry about them, right?) and index design (we have a wizard for

this, why would we need something else?).

Speaker : Nico Jacobs

2. Building the next generation of applications using SQL Server 2008 R2
New features in SQL Server 2008 R2 create new paradigms for designing and developing applications. This session will

introduce you to 3 exciting new features and the types of application that becomes possible: Complex event processing

(Codenamed Streaminsight), Data Tier Applications and Master Data.

Speaker : Dirk Gubbels

3. Inside SQL Server Integration Services with Andy Leonard
In this geekSpeak, Microsoft Most Valuable Professional (MVP) Andy Leonard discusses best practices for using

Microsoft SQL Server Integration Services (SSIS) in the enterprise. Andy explains what SSIS does well and doesn’t do

well and describes common struggles when learning SSIS (expressions, configurations, externalization, dynamic

properties, scripting). Other topics he’ll cover include deployment, execution methods, security, and design

patterns. This geekSpeak is hosted by Glen Gordon and G. Andrew Duthie.

The geekSpeak webcast series brings you industry experts in a “talk-radio” format hosted by developer evangelists

from Microsoft. These experts share their knowledge and experience about a particular developer technology and are

ready to answer your questions in real time during the webcast.

Guest Presenter: Andy Leonard, Architect, Unisys Corporation

4. ORM with ADO.NET Entity Framework in .NET 4.0
This session will be delivered by Kurt Claeys and Hans Verbeeck. If you are not using Object Relational Mapping yet,

you probably should reconsider quickly. The upcoming release of VS2010/.NET 4.0 brings us a new version of ADO.NET

Entity Framework. ADO.NET Entity Framework is now an enterprise ready ORM technology combining a great designer for

EDM modeling, support for database creation, better integration with stored procedures, an optimized query generator,

POCO support, code generation templates and now enables the use of entities in a multi-tier architecture. This

session shows you these topics from a practical approach and includes some best practices on ADO.NET Entity

Framework.

Speakers : Kurt Claeys, Hans Verbeeck


Download from Fileserve: