.NET news » Database

Wrapping up his examination of MongoDB, Ted Neward discusses predicate queries, aggregate functions and LINQ support, and provides some tips on hosting the NoSQL database in a production environment.

Let go of your traditional relational database thinking if you want to understand how Windows Azure Table storage works, says Julie Lerman. Luckily for you, she’s done the hard work to grasp the new concepts and help you get up to speed.

In this article, I'd like to help you get started with MongoDB, from install to your first project. In addition, I'll show a little bit about the LINQ provider and let you play with it on your own.

The Common Table Expression that was introduced in SQL Server 2005 has long been something of an issue for me. I could reproduce the syntax to get what I wanted, but I couldn't honostly say I understood what was going on there. I always need a mental picture to understand something, and that was just missing.

Recently I think I figured out model that helps me work with them and explain how, although different, they're actually analogous to recursion in normal programming.

With this article I would like to share a simple but useful little tool: ExportWizard, a Step Wizard for Database Export. It guides users through a few simple steps to choose a database object (table, view, or query), select columns, and export the data in any of the standard formats (CSV, HTML, XML, or SQL).

MongoDB is one of the principal tools of the NoSQL movement, which offers alternatives to the traditional relational database system. Learn its strengths and weaknesses as Ted Neward examines the document-based database in detail in the first of a series of columns.

An intro to RavenDB - a new open source .NET document database using .NET 4.0 and VS 2010

All about SQL Indexes - Query Optimizer, Index, Unique Index, Clustered Index, Full Text Index, XML Index and SQL commands to create, delete, and rename SQL indexes.

Basic CRUD methods with some other interesting features

Integrating data into applications or reports is one of the most important, expensive and exacting activities in building enterprise data warehousing and reporting applications. SQL Server Integration Services which first appeared in MS SQL Server 2005 and continued into MS SQL Server 2008 provides a one-stop solution to the ETL Process. The ETL Process consists of extracting data from a data source, transforming the data so that it can get in cleanly into the destination followed by loading the transformed data to the destination. Enterprise data can be of very different kinds ranging from flat files to data stored in relational databases. Recently storing and exchanging data in XML has become common as exchanging data in XML format has many advantages…