Justin Dearing presents a brief introduction to MongoDB, and focuses on interacting with it in Mono via the official 10gen driver. Techniques for handling business logic in application code, such as LINQ are discussed. This is a very code centric talk.
In this article, Grzegorz Gogolowicz and Trent Swanson tackle the problem of generating reports in SQL Server Reporting Services when the source is scanned images and other supplied formats yet a fixed layout report or pixel perfect report is the desired outcome.
Bart De Smet explains Reactive Extensions (Rx), a library for composing computations over asynchronous event streams of data for .NET and Javascript, the concepts and implementation of Rx and more.
SQL Test is the user interface for tSQLt, the open source unit testing framework for SQL Server. From the SQL Test window, users can create test classes, view existing unit tests, execute them, and view the results within a dockable panel in SQL Server Management Studio.
With SQL Server abandoning OleDB in favor of ODBC, it is no surprise that SQL Server Integration Services is finally picking up ODBC support. Another important feature slated for SSIS 2012 is the much needed support for CSV files.
Microsoft has released SQL Server 2012 Release Candidate 0. There are many new features, including: AlwaysOn, better performance management, more reporting and visualization tools, Columnstore index, and FileTables. The product will come in 3 main editions: Standard, Business Intelligence and Enterprise.
Amazon has announced two licensing deals with Microsoft. The first eliminates the licensing fees for running Microsoft software on EC2 for BizSpark members. The second allows all developers to run the preview of SQL Server 2012 on EC2. It should be noted that normal EC2 service rates still apply for both.
SafePeak is a plug-and-play Dynamic Database Caching Solution, designed to improve data access performance for Applications built on SQL Server. It offloads the read queries and stored procedures which perform “Select” by dynamically caching in-memory result sets, thereby reducing read response time and overall database load.
Microsoft has added LocalDB support in .NET Framework 4. LocalDB is a free developer edition of SQL Server “Denali” meant to provide most of the server’s API but without management overhead.
