Microsoft StreamInsight Intro

Microsoft released Microsoft StreamInsight with SQL Server 2008 R2.

This is an engine for real time data analysis.  It’s an alternative to traditional BI which typically crunch replicated data.  Instead, StreamInsight let’s you analyse the data as it comes to you (as a stream).

The programming model is built on top of LINQ with the twist that the...

EF Power Tools CTP1 Released

A little while ago, Microsoft released the first CTP of Entity Framework Power Tools.

Those power tools work on top of EF 4.1 and provide the following exciting features:

• Reverse Engineer a Code First Model from an existing database.  Now this comes with the caveat that everything is configured through...

Everything you ever wanted to know about SQL Azure Connection Security

See this TechNet article for a complete description of all the security topics:

http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-connection-security.aspx

Expression Trees: Part 4 – Simple mapping inversion

This is part of a series of blog post about expression trees in .NET 4.0.  The past blog entries are:

• Basics (1)
• Fetching Properties (2)
• Setting Properties (3)

In this article, I’ll cover simple mapping inversion using Expression Trees (ET).  By simple I mean that we’ll map two objects properties / fields...

No SQL overview

Microsoft is publishing a Blue Badge Insights white paper on NoSQL:  NoSQL and the Windows Azure platform.

The paper is quite interesting as it enumerates different archetypes of NoSQL databases (e.g. Key-Value Stores, Document Stores, Wide Column Stores, Graph Databases), their architecture traits and the Windows Azure offering in the area.