.NET news » Database

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…

This article look at how to use the SqlBulkCopy class to efficiently execute bulk operations against Microsoft SQL Server.

This short introduction to.NET shows Access and SQL Server developers how to use a development tool to create connections to data and a user interface to manipulate that data.