SQL Zone | The social network for developers

Mitch Pronschinske04/12/10
9928 views
0 replies

Gear6's Memcached Adds the Best of Both Worlds: MySQL and NoSQL

One technology that continues to push the limits of data caching and massive web persistence is Gear6's Web Caching Server. Think of Gear6 Web Cache as a Memcached distribution on steroids. It can run in the datacenter or the cloud (EC2, GoGrid) while...

Peter Zaitsev04/12/10
1139 views
0 replies

How to know if you’re updating Slave you should not ?

When replication runs out of sync first question you often ask is if someone could be writing to the slave. Of course there is read_only setting which is good to set in the slave but it is not set always and also users with SUPER privilege bypass it.

Mitch Pronschinske04/07/10
11002 views
0 replies

VC Funding Down in 2009 for OSS, But There's Good News Too

The 451 Group released its data today regarding venture capital funding for open source software in 2009. As a result of the struggling world economy, open source VC funding took a hit last year with a drop in the number of deals and in the average size of...

Mitch Pronschinske04/05/10
6229 views
4 replies

Comparing Red Gate SQL Prompt to SQL Server IntelliSense

Third parties like Red Gate have sold tools that provide IntelliSense functionality for several years now. Microsoft's SQL Server 2008 now threatens these third parties' business by including the original IntelliSense for free. It's now up to companies to...

Dan Wilson04/05/10
55794 views
14 replies

What To Do When A Hard Drive Fails

When a hard drive crashes, you can lose all your data. Corrupt hard drives happen out of the blue and for seemingly no good reason. If your hard drive fails, what can you do?One option is to call a hard drive recovery company. If your data is worth a lot...

Mitch Pronschinske04/01/10
14705 views
0 replies

Case Study: How OSS Helped One Startup Beat Larger Companies

Many companies are still not comfortable with using a software solution unless they are paying for it. However, tech companies that use mainly Open Source Software in their development stack, once a rarity, are now becoming more common. The overall...

Mitch Pronschinske03/30/10
6884 views
0 replies

Datastore Controls in the 1.3.2 GAE SDK

The GAE team delivered the 1.3.2 SDK update last week, and with it came significant new datastore controls. The SDK allows GAE developers to use eventually consistent reads and datastore deadlines. The SDK also includes API enhancements and new security...

Shashank Tiwari03/29/10
25568 views
2 replies

Effectively combining Flex and Hibernate: The basics

Flex and Java can be combined effectively to create robust and scalable rich internet applications. Flex enables the creation of an interactive and engaging user interface. Java provides a robust platform for a number of server centric features including data...

Mitch Pronschinske03/26/10
7750 views
0 replies

Oracle Set to Grow with Sun; Forecast Indicates Economic Upturn

After many months of grappling with the EU over the Sun acquisition and the fate of one popular open source database, Oracle is quickly reaping the benefits of its purchase. The software giant reported its third quarter (of its 2010 fiscal year) earnings...

Mitch Pronschinske03/25/10
7956 views
0 replies

Terracotta and EnterpriseDB Team Up For High-Performance Private Clouds

Terracotta recently announced another strategic alliance, this time with EnterpriseDB, a PostgresSQL-based database vendor. Their partnership is aimed at addressing the technical challenges in scaling the data layer in private clouds. Under their...

Mitch Pronschinske03/24/10
12800 views
2 replies

Tools for Moving from an SQL Database to Hadoop

More organizations, small and large, are interested in moving their data from SQL relational databases to an Apache Hadoop back end. Although SQL is always a solid option in many cases, Hadoop has advantages in data processing that are battle-tested by...

Peter Zaitsev03/22/10
3010 views
0 replies

Is your MySQL Server Loaded ?

So you're running the benchmark/stress test - how do you tell if MySQL server is really loaded ? This looks like the trivial question but in fact, especially when workload consists of simple queries I see the load generation and network really putting a...

Michael Ceranski03/20/10
4420 views
0 replies

How to Backup a SQL Express Database

There are a lot of programs that ship with SQL Express these days. For example, when you install development tools like Visual Studio or SharePoint it is common practice to bundle it with an express version of SQL Server. Most of the time, SQL Express is...

Giorgio Sironi03/18/10
6397 views
0 replies

How improved hardware changed programming

This is a follow-up to the previous post, CPUs speed and technology innovations. As we have outlined in the previous post, the memory size and computing power available to the average programmer has increased thousands of times from the first years of his...

Mitch Pronschinske03/10/10
15566 views
0 replies

Cassandra Usurping MySQL on Twitter

One source had confirmed that Twitter was working with the NoSQL data store, Cassandra, late last year. Some more details have finally surfaced about this quiet transition from a MySQL + Memcached system to Cassandra. The MyNoSQL blog recently interviewed...