In-Memory Databases are very near to becoming widely adopted, says David Campbell of Microsoft in his article “The coming in-memory database tipping point”. He also explains Microsoft’s strategy around this space.
Microsoft has released SQL Server ODBC drivers for the 64 bit version of Linux. These drivers are intended for C and C++ developers using Red Hat’s Enterprise Linux 5 and Enterprise Linux 6.
2012 marks the fifth year since Microsoft started courting PHP developers. The popular language can be found in everything from their entry level IDE WebMatrix to the high-end cloud platform Windows Azure. SQL Server is a major part of the overall initiative and they are making sure the PHP drivers take advantage of SQL Server 2012’s new features.
FluentData is a new introduction to the micro-ORM family that aims to be more straightforward to use than full ORMs like NHibernate and Entity Framework. It uses a fluent API and supports SQL Server, SQL Azure, Oracle, and MySQL.
Oracle fires a new round for the heart of the NoSQL market. This 7.2 release of MySQL Cluster has new features putting it head to head with other NoSQL solutions including REST, memcached wire protocol, NoSQL C++, and standard MySQL interfaces. Oracle boasts 70x speed gains for complex queries using MapReduce like distributed joins. Is the world ready for a MySQL/NoSQL hybrid from Oracle?
tSQLt is a free, open-source framework for unit testing in SQL Server. By writing tSQLt test cases, developers can create fake tables and views based on production data, then compare expected versus actual results. Tests can be created directly in SQL Server Management Studio.
Hybrid SQL-NoSQL database solutions combine the advantage of being compatible with many SQL applications and providing the scalability of NoSQL ones. Xeround offers such a solution as a service in the cloud, including a free edition. Other solutions: Database.com with ODBC/JDBC drivers, NuoDB, Clustrix, and VoltDB.
VMware releases SQLFire 1.0 a distributed SQL database geared towards high availability and horizontal scalability which offers table replication, table partitioning and parallel execution of queries.
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.
The Code First approach means that the object model is created in code, and then the database structure is generated from that model. Code First Migrations allows developers to make changes to the database via code, many of which can be done automatically.
Until now, Postgres was only available to Heroku customers for use with Heroku platform apps. This new service can be used from anywhere and with any Postgres client. Apps can connect from Heroku, Google App Engine, Microsoft Azure, Cloud Foundry, EC2, or from your local computer while PostgreSQL is supported by most modern programming languages - including Perl, Python, Ruby, Scala ...
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.
VMware is adding support for PostgreSQL to CloudFoundry, it's open source PAAS solution.
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.