Microsoft SQL Server Secrets for Developers

Microsoft SQL Server Secrets for Developers
English | English | WMV3 1024 x768 | MP3 48 Kbps | 2.37 GB
Genre: eLearning

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:

Code

http://www.fileserve.com/file/nZ4qaW2
http://www.fileserve.com/file/937jVWv
http://www.fileserve.com/file/QHaesKS
http://www.fileserve.com/file/fV5XPKn
http://www.fileserve.com/file/dp4mu2U
http://www.fileserve.com/file/6pXUkd3
http://www.fileserve.com/file/A6QZyJA
http://www.fileserve.com/file/cXfwjqP
http://www.fileserve.com/file/xQsg5W7
http://www.fileserve.com/file/fWgnYrP
http://www.fileserve.com/file/8tgMWkN
http://www.fileserve.com/file/5RgyUPS
http://www.fileserve.com/file/SXwcQw4