Brent Ozar, renowned SQL Server consultant recently shared few techniques for improving productivity with SQL Server.
Mozilla is scaling websites from thousands to hundreds of millions of users through simple scaling patterns they have learned internally according to Brandon Burton, web operations engineer at Mozilla. The lessons learned include caching, scaling out web servers, asynchronous jobs, and databases.
The 5.6 series for MySQL has reached the point where Oracle feels comfortable in releasing an updated MySQL Enterprise Edition for its paying customers. This version includes a significantly updated version of InnoDB with full text search and online DDL.
Salesforce.com has open sourced Phoenix, a Java layer enabling developers to run SQL queries on Apache HBase. Update: An interview on Phoenix with James Taylor, Lead Developer at Salesforce.com, has been appended.
Few months back, Microsoft announced HDInsight, Microsoft’s Hadoop distribution for managing, analysing and making sense out of large volumes of data. InfoQ connected with Val Fontama, Senior Product Marketing Manager for SQL Server, to know more about how the Enterprise Big Data @ Microsoft story is panning out.
Microsoft recently released several enhancements to Windows Azure Management Portal with support for 6 additional languages, database improvements and enhancements for virtual machines and networking including support for operation logs.
During the PASS Summit 2012, a technical conference for SQL Server professionals, Microsoft announced Hekaton, an in-memory row-based data management system targeted at transaction processing (TP) workloads. Besides the advertised increase in TP speeds of up to 10x for old applications and up to 50x for new optimized ones, Microsoft touts Hekaton as being fully integrated into SQL Server.
Several new Hadoop-based frameworks where announced during this year O’Reilly Strata Conference + Hadoop World 2012 in New York last week.
MariaDB has announced a preview of the Cassandra Storage Engine. This is a plugin that allows MariaDB to access Cassandra clusters using normal SQL syntax.
Oracle recently announced a new migration tool, which provides an ability to quickly migrate data and applications from Microsoft SQL Server to MySQL with less time and effort. The migration tool which has been integrated into MySQL Workbench, allows visual design, development and administration of MySQL databases with an advanced logging and security mechanism.
Microsoft continues to invest in Node.js, this time by introducing a new, open source SQL Server Driver and new Node-specific features in WebMatrix.
VMware has today announced VMware vFabric Suite 5.1, adding automated deployment, enterprise open source support, and PostgreSQL capabilities, as well as an expansion to the SQLFire in-memory database.
Amazon has announced support for .NET on AWS Elastic Beanstalk and a new RDS service for SQL Server, bringing better manageability to .NET/SQL Server apps hosted on AWS.
Want to try out Hadoop with the Microsoft Stack and figure out what capabilities this brings to you? We point to some resources that can help.
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.