Non-Relational Data Stores
Igal Koshevoy of Pragmaticraft speaks about Comparing Non-Relational Databases: MongoDB, Tokyo Tyrant, CouchDB at the November 2009 OpenSQLCamp in Portland, Oregon. [youtube pVbxdH-ldpg]
An Overview of the MySQL Engine and its Latest Features
The first part of this talk describes the main principles behind MySQL’s query optimizer and execution engine, how the optimizer transforms queries into executable query plans, what these plans look like, and how they are executed. The second part of the talk describes the major improvements in the query engine …
MySQL Joins and Subqueries
Sheeri K. Cabral of the Pythian Group goes through the meanings of INNER, LEFT/RIGHT OUTER, CROSS, NATURAL joins, how to do a FULL OUTER JOIN in MySQL, and what STRAIGHT_JOIN means. She also goes through how to recognize when you want those types of joins, and best practices for the …
Writing Adapters for DataMapper
Some might think of DataMapper as a better, faster, competitor to ActiveRecord. However, they would be missing on of its greatest strengths. At its core, DataMapper provides a uniform interface on top of ANY persistance layer. All thats needed is a simple adapter class that can translate the native persistance …
Practical Entity Framework for C#: Entity Framework for ASP.NET
ADO Entity Framework can be used in ASP.NET as well. There are only minor things to keep in mind. The EntityDataSource makes using an Entity Model in ASP.NET much easier. This video demonstrates how to use Entity Framework in ASP.NET. http://msdn.microsoft.com/en-gb/vcsharp/dd565859.aspx
Microsoft SQL Server 2008 Reporting Services
Amit Goyal interviews author Michael Lisin about his new book, Microsoft SQL Server 2008 Reporting Services, the comprehensive guide to SQL Server 2008 Reporting Services. [youtube pfCKjUwWYGs]