.NET news » Database Database Rss Feed

SQL Server – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name

How to find column used in a stored procedure.
17 Jul 2012, 12:56:00   Source: SQL Server – Find Column Used in Stored Procedure –...   Tags: Database

GUIDs as fast primary keys under multiple databases

Using the right approach can make GUIDs nearly as fast as integer primary keys on almost any database system.
2 Jun 2012, 07:39:00   Source: GUIDs as fast primary keys under multiple databases   Tags: Database

SQL Server: Custom Indexing for Latitude-Longitude Data

Find out how to create custom indexes for geographical data that includes latitude and longitude location information so that you can retrieve real-time data faster than ever.
31 May 2012, 18:00:00   Source: SQL Server: Custom Indexing for Latitude-Longitude Data   Tags: Database

Windows Phone: Behind the Scenes: A Windows Phone Feed-Reader App

See exactly how a group of Microsoft interns developed a robust Windows Phone feed-reader app with the latest technologies such as local database, background agent, Live Tiles and more.
31 May 2012, 18:00:00   Source: Windows Phone: Behind the Scenes: A Windows Phone...   Tags: Database

Document Databases : A look at them

A look at several Document database, and a look at how to use them
25 May 2012, 04:14:00   Source: Document Databases : A look at them   Tags: Database

RaptorDB - the Document Store

NoSql, JSON based, Document store database with compiled .net map functions and automatic hybrid bitmap indexing and LINQ query filters
11 May 2012, 09:24:00   Source: RaptorDB - the Document Store   Tags: Database

The Baker’s Dozen Doubleheader: 26 new Features in SQL Server Integration Services 2012 (Part 2 of 2)

The new release of SQL Server's Integration Services has many exciting new features

23 Apr 2012, 18:00:00   Source: The Baker’s Dozen Doubleheader: 26 new Features in SQL...   Tags: Database

Simple file system over SQLite

Implement an easy-to-use file system backed by a SQLite database.
30 Mar 2012, 06:19:00   Source: Simple file system over SQLite   Tags: Database

Finding numbers from a text in SQL Server.

This is an alternative for "Finding numbers from a text in SQL Server."
10 Mar 2012, 12:06:00   Source: Finding numbers from a text in SQL Server.   Tags: Database

Coding in Marble (Part 2)

I thought I'd follow up on my last technical post with a few extra details about the Marble pattern, despite the name of the article I mostly talked about the Wood pattern.  I guess perhaps this is timely because the use of Promises to represent asynchronous operations is increasingly popular,  but these notions are not really limited to context pattern, though promises do make for good examples.

So, what are the essential properties?

Wood:

objects tend to be smaller and more abundant (model the nodes not the tree) dependencies and dataflow tends to be represented on a per object basis dependencies frequently make long chains (such as a series of promises lashed to one I/O) each object is participating in its own dependency chain but it they are really all the same

Marble:

objects tend to be bigger (model the tree not the nodes) dependencies and dataflow tend to flow through these big objects, the dependencies are not dependent on the size of the problem but on the necessary transforms the dataflow that SQL uses for running a query is an example of this, complexity of plan is determined by joins/merges not by data size dependencies still can make long chains but the nature of the depenencies is expressed exactly once no matter how much data there is

Again, using promises as an example (and I am not down on promises at all, they work great, but you don't have switch to the wood pattern universally just because you have async i/o)

Wood:

create many async requests for data attach additional promises to these requests for processing end each promise chain with some operation to do whatever needs doing at the end (such as inserting stuff into a DOM)

Marble:

create many async results for data give the promises to a broker which will handle all of them (and maybe created them in the first place as needed) provide any number of handlers to the broker which will run those handlers on each datum as the promises resolve

In the marble pattern I can still write nice anonymous delegates if I choose, or I can provide a class or other handler, whatever is necessary.  However I don't create one handler instance for every datum.  I created one or more broker objects that handle the various stages of processing and coordinate some or all of the post steps. 

From a memory perspective Marble is much more economical and of course it doesn't have the terrible property that I'm making lots of long lived objects.  In the wood pattern everything ends up being long lived because everything lives at least as long as the I/O request is outstanding.

20 Feb 2012, 15:13:00   Source: Coding in Marble (Part 2)   Tags: Database