SQL Zone - The social network for developers

NoSQL: A Life Without Schema

alkampfer@nablasoft — Mon, 06 Feb 2012 21:03:31 +0000

NoSql is not a replacemente for SQL databases, but it is a valid alternative for a lot of situations where standard SQL is not the best approach to store your data. Since we were taught that whenever you need to store data on a “data store” and you need to query that data for retrieval, SQL is the best solution, you have only to decide what Sql Engine to use and the game is done. ...

DataSets, TableAdapters, and Transient Retry Logic For SqlAzure

DaveMBush — Sat, 04 Feb 2012 18:43:14 +0000

The main project I’m working on these days is moving several web sites to Azure. It is something I’ve wanted to be able to try for a while. I’m working with several other agencies on this project and some microsoft consultants so there is some good guidance along the way. One of the things I wasn’t aware of until yesterday is that SqlAzure can shut down in the middle of your code...

Nothin' But .NET Baby!

mitchp — Thu, 02 Feb 2012 05:00:00 +0000

So why do the Java developers get all the attention on DZone? Well sure DZone has roots in Java, but we've been in the .NET game for some time now. And it's time for the .NET community to show it's pride and join the conversation happening among all enterprise developers. Preview Text: Having trouble finding good C#, ASP.NET, SharePoint, or...

GAE Finally Supports Django!

cjsmith — Wed, 01 Feb 2012 16:18:50 +0000

Yesterday, Google announced the release of App Engine 1.6.2, which includes some impressive new features. But the one that has most developers talking is the long-awaited arrival of Django support for Google's Cloud SQL. Preview Text: Google announced the App Engine 1.6.2 release, which includes Django support for Cloud SQL. More features and...

Windows Phone / SQL Server Compact Resources List

ErikEJ — Fri, 27 Jan 2012 13:19:21 +0000

This blog post collects links to relevant blog posts and articles about Windows Phone support for SQL Server Compact. You can also follow me on Twitter (@ErikEJ) to get notified of any SQL Server Compact related news. MSDN Local Database Overview for Windows Phone How to: Create a Basic Local Database Application for Windows Phone Article Type: ...

Microsoft SQL Azure Codename "Cloud Numerics" Lab Release

egenesky — Tue, 24 Jan 2012 17:10:23 +0000

Microsoft's SQL Azure Labs About page describes its projects as a series of "working prototypes" that represent . . . Eric Genesky

Algorithm of the Week: Data Compression with Diagram Encoding and Pattern Substitution

stoimen — Tue, 24 Jan 2012 14:36:33 +0000

Two variants of run-length encoding are the diagram encoding and the pattern substitution algorithms. The diagram encoding is actually a very simple algorithm.

A Depressive Journey With MongoDB

egenesky — Mon, 23 Jan 2012 05:56:41 +0000

Disclaimer You are about to read a long story on how I got burnt with MongoDB and depressed with it. I am not blaming MongoDB, anyone using, advocating or developing it. I am blaming myself for this. MongoDB is a good tool. You can use it but just make sure it is what you need and it handles your requirements very well. This is not specific to MongoDB but applies to every tool we use. ...

Node.js and NoSQL: What You Need to Know

egenesky — Mon, 16 Jan 2012 20:23:20 +0000

For developers who might be interested in developing appications in node.js with a NoSQL data store, check out nodeup's eleventh podcast, downloadable here: Eric Genesky

Machine Learning: Ensemble Methods

riho — Mon, 16 Jan 2012 12:50:05 +0000

Ensemble Method is a popular approach in Machine Learning based on the idea of combining multiple models. For example, by mixing different machine learning algorithms (e.g. SVM, Logistic regression, Bayesian network), ensemble method can automatically pick the best algorithmic model that fits the data the best. On the other hand, by mixing different parameter set of the same algorithmic...

DZone Top Article of 2011: 3 Components of a Successful Project

Brian Swan — Fri, 13 Jan 2012 15:52:50 +0000

Earlier this month I attended the monthly meeting of the Seattle PHP Meetup Group. In ways I didn’t expect, it was a very interesting meeting. The content itself was interesting enough (we were talking about database design), but what I found even more interesting was how the meeting dynamics provided a good reminder of what goes into a successful software project.References ...

Searching relational content with Lucene's BlockJoinQuery

mikemccand — Mon, 09 Jan 2012 05:59:33 +0000

Lucene's 3.4.0 release adds a new feature called index-time join (also sometimes called sub-documents, nested documents or parent/child documents), enabling efficient indexing and searching of certain types of relational content. Article Type: How-to Mitchell Pronsc...

Neo4j Graph Database vs MySQL

renepickhardt — Mon, 26 Dec 2011 07:51:40 +0000

For my social news stream application I am heavily thinking about the right software to support my backend. After I designed a database model in MySQL I talked back to Jonas and he suggested to search for a better suiting technology. A little bit of research brought me to a Graph database called Neo4j. Article Type: Opinion/Editorial ...

MongoDB for MySQL folks - Part 2

papablues — Fri, 23 Dec 2011 05:51:40 +0000

In this second part of a series of blogs on using a NoSQL database, in this case MongoDB, aimed at MySQL users, I will describe querying a bit. And it's probably not what you expected if you haven't tried a NoSQL database or MongoDB more specifically, before. The first blogpost on this subject is here. Article Type: How-to ...

Going Native with SQL Server – Introduction

nhaslam — Mon, 19 Dec 2011 20:57:45 +0000

This is the first in a series of blog posts I’m planning to do, in preparation for a potential SQLBits session in March 2012. This article will introduce how, at the most basic level, SQL Server can be communicated with using C++ and Native code, rather than using the .NET Framework.References Reference: Going Native with SQL Server –...