Click here to Skip to main content
13,596,062 members

Database

The top 50 Articles on Database

Latest Articles

by Alen Toma
EntityWorker.Core - an alternative to entity Framework
by Bojan Sala
SqlBinder is a free, open-source library that helps you transform a given SQL template and a set of conditions into any number of valid SQL statements along with their associated parameters.
by harleydk
How to generate a pie chart with Grafana and MS SQL
by Artem Moroz
Simple utility for creating backups of SQL Server databases on a schedule

Discussions

by Alen Toma on tip/trick "EntityWorker.Core an alternative to...
by Alen Toma on tip/trick "EntityWorker.Core an alternative to...
by mukhlim greatsoft on tip/trick "EntityWorker.Core an alternative to...
by rchacko on article "Create First Data WareHouse"
by Alen Toma on tip/trick "EntityWorker.Core an alternative to...
13 Jan 2016
Sebastien Lorion
A reader that provides fast, non-cached, forward-only access to CSV data.
4 Feb 2009
C.L. Moffatt
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
6 Sep 2005
Carlos Antollini
Simple database access using an ADO class.
8 Nov 2002
Daniel Turini
SQL Server database best practices
26 Jan 2018
Mehdi Gholam
NoSql, JSON based, Document store database with compiled .net map functions and automatic hybrid bitmap indexing and LINQ query filters (now with standalone Server mode, Backup and Active Restore, Transactions, Server side queries, MonoDroid support, HQ-Branch Replication, working in Linux, .net
23 Jan 2005
Colin Angus Mackay
Discusses various aspects of SQL Injection attacks, what to look for in your code, and how to secure it against SQL Injection attacks.
24 Jun 2011
Rob Groves
A C++ wrapper around the SQLite embedded database library.
26 Apr 2008
Sudipta Chaudhari
This article gives a brief introduction about Triggers in SQL Server 2000/2005.
21 Jul 2014
Mubin M. Shaikh
Learn creation of OLAP Cube in SSAS (SQL Server Analysis Services) using Microsoft BIDS (Business Intelligence Development Studio) Environment and Data Warehouse
31 Oct 2007
David Veeneman
A simple, straightforward tutorial that will get you up to speed on the fundamentals of NHibernate as quickly as possible
23 Jul 2002
Carlos Antollini
A list of ODBC DSN Connection Strings.
14 Jan 2013
liron.levi
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
28 Apr 2009
Al-Farooque Shubho
As part of a series of articles on several data access optimization steps in SQL Server, this article focuses on using indexing to optimize data access.
1 Jun 2009
Al-Farooque Shubho
As part of a series of articles on data access optimization steps in SQL Server, this article focuses on refactoring and applying TSQL best practices to improve performance.
14 May 2016
yuvalsol
POCO generating application for SQL Server
22 Aug 2004
Matt Newman
A beginners guide to accessing a SQL or MSDE Server with C#
3 Jun 2011
Kanasz Robert
In this article, I will show you how to create a basic DB schema comparison tool for SQL Server 2005 and SQL Server 2008.
11 Aug 2016
Mehdi Gholam
Smallest full text search engine (lucene replacement) built from scratch using inverted WAH bitmap index, highly compact storage, operating in database and document modes
25 Mar 2008
Qwertie
Demonstrates a variety of Windows Forms data binding features through several simple examples.
4 Jun 2013
Sivaraman Dhamodharan
Talks about Clustered and Non clustered index in SQL 2005 and how it works, what is the need for it.
8 Nov 2011
Kanasz Robert
This article is about library for scripting SQL Server database objects and examples representing how this library can be used.
12 Mar 2013
Hafiz Muhammad Suleman
This article clears the differences between the On cluase and Where clause when used with left join.
28 Jul 2014
Bernardo Castilho
A component that makes it easy to use Entity Framework in WinForms projects, including design-time binding support.
14 Nov 2004
Lars-Inge Tønnessen
An article on how to setup and configure the MSFT MSDE 2000.
20 Aug 2011
Kanasz Robert
In this first part of series of articles about database performance optimization I will discuss about indexing strategies and index maintenance.
17 Nov 2009
Etienne Rached
Connect C# to MySQL using MySQL Connector/Net, Insert, Update, Select, Delete example, Backup and restore MySQL database from C# or .NET application
8 Aug 2015
adriancs
A tool to export and import MySQL database in .NET
18 Oct 2017
Mauricio David
1 alternative  
A simple, fast and free embedded .NET NoSQL Document Store in a single data file. Inspired on MongoDB, supports collections, POCO classes, Bson Documents, indexes, stream data and LINQ expressions.
23 Jan 2012
Mehdi Gholam
Smallest, fastest embedded nosql persisted dictionary using b+tree or MurMur hash indexing. (Now with Hybrid WAH bitmap indexes)
10 Jun 2009
Pascal Ganaye
DbfDotNet is a very fast and compact fully managed standalone database/entity framework, for the .Net Framework.
15 Mar 2003
Mauricio Ritter
This article describes the process of inserting data in a DataSet and then submitting this changes to the database. It targets the issue when having IDENTITY/AutoNumber columns in the database.
2 Aug 2017
Andrew Rissing
GenericParser is a C# implementation of a parser for delimited and fixed width format files.
14 Sep 2013
Mubin M. Shaikh
In this article, I am going to show you the importance of data warehouse.
11 Dec 2013
Shivprasad koirala
Quick revision of 25 important ADO.NET Entity Framework interview questions with answers.
11 Oct 2013
Mehdi Gholam
Even faster Key/Value store nosql embedded database engine utilizing the new MGIndex data structure with MurMur2 Hashing and WAH Bitmap indexes for duplicates. (with MonoDroid support)
21 Jun 2000
Konstantin Vasserman
How to display multiple pages of records in ASP
6 Jan 2001
Stefan Chekanov
CODBCRecordset class is intended to be full replacement of all ClassWizard generated CRecordset derived classes in MFC projects.
1 Nov 2010
Kanasz Robert
In this article, I will show you how to backup and restore databases using Server Management Objects
26 Feb 2014
Shivprasad koirala
This article will discuss about 11 important database designing rules.
3 Jan 2014
Sander Rossel
The first of two, everything you need to create the most amazing queries!
3 Mar 2008
Alex Baker
Change collation order for all text columns in a database
8 May 2008
Danilo Corallo
An easy-to-use .NET solution for Job Scheduling with pluggable actions that runs on a Windows Service. Back up your SQL Server Express and much more!
22 Sep 2009
Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
17 Oct 2009
Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
25 Jun 2014
Marla Sukesh
In this article we will learn basics about DW, BI, SSIS and ETL Process
12 May 2011
Niladri_Biswas
In this article we will learn creation of subreports, drilldown reports, custom coding and expression, web service and wcf service consumption frm SSRS,custom paging and sorting, working with databars and indicators with real time examples
7 Mar 2005
Vic Mackey
An extended stored procedure for SQL Server that implements an optimized MD5 hash algorithm. Very small DLL (barely 7 KB).

Advertise | Privacy | Cookies | Terms of Service
Web04 | 2.8.180621.3 | Last Updated 10 Aug 2007
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid