(Ovais Tariq) This is the second blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is aimed at the optimizer enhancement Multi Range Read (MRR). Its available in both MySQL 5.6 and MariaDB 5.5.
Other News
ColdFusion 10 – Cross-Linking Standard Session Management To WebSocket Session Management
(Ben Nadel) By now, we’re all used to ColdFusion’s standard session management – the one that’s typically powered by session cookies that get posted back to the server with every request. ColdFusion 10’s built-in WebSocket server does not operate on cookies; instead, the client (browser) establishes
Fix SQL Server Agent on Windows Failover Cluster
(Edwin Sarmiento) I was trying to install SQL Server 2008 R2 on a Windows Server 2008 R2 Failover Cluster, but the setup did not complete successfully. Upon further investigation, the issue seems to be caused by a DNS entry that was then fixed by the systems administrator.
Code Naming Conventions
Reader Comments Today I’m including more comments from our readers. Maurice shares his thoughts on Database Naming Conventions. William shares a new topic about the Activity Monitor interface inside Management Studio. Feel free to share your thoughts on these or other topics by sending an email to btaylor@sswug.org. Database Naming Conventions Maurice: What is the gain in adding a prefix […]
Intuitive and Innovative Editor – XML Reports
If you are equally and highly persisting for style and substance in creating reports, then availing the XML base to do so can work wonders instantly! You get to have unique code generator along with powerful editor, which makes it all simplified and extremely helpful in creating the XML reports. You
Reset Row Number For Each Group – SQL Server Vs MySQL
(Madhivanan) Continuing on my SQL Server vs MySQL series, we will see how same things can be done differently in SQL Server and MySQL.
SQL Server 2012 Integration Services – Package Variables
(Marcin Policht) In the recent articles published on this forum, we have been presenting new features of SQL Server 2012 Integration Services. Our presentations have been based so far on the Release Candidate 0 (RC0) of the product, offered as a free download since mid-November 2011.
Statically typed access to JSON and XML by using schema inference
(Steffen Forkmann) I’m happy to annouce a new nuget release of FSharpx.TypeProviders. The new version 1.5.3 allows to access JSON and XML in a strongly typed way. These new type providers are based on an XML type provider by Tomas Petricek. I added a write API and a JSON version.
Additional DB2 10 Resources
(Troy Coleman) DB2 10 is the most significant release IBM has shipped and this is reflected in its rapid adoption rate. Based on the number of customers I hear from who have either upgraded or say they’re in the process of migrating to DB2 10, I can’t think of another release that’s been so quickly
SQL Azure and Trust Services
(Buck Woody) Microsoft is working on a new Windows Azure service called “Trust Services”. Trust Services takes a certificate you upload and uses it to encrypt and decrypt sensitive data in the cloud. Of course, like any security service, there’s a bit more to it than that. I’ll give you a quick over