Click here to Skip to main content

Database

The top 50 Articles on Database

Latest Articles

by Shivprasad koirala, Marla Sukesh
This is the part 3 of the series Learn MSBI step by step
by essentialSQL
In today’s lesson you’re going to learn about grouping results returned from your queries using the GROUP BY clause. The objectives of today’s lesson are to: Learn to how to group results using GROUP BY Use aggregate functions to perform calculations Understand how to filter groups using the HAVING
by essentialSQL
In this lesson you are going to explore how to do pattern matching with the SQL Where clause LIKE operator.  Using this phrase allows us perform partial matches of data values and obtain answers to questions which can’t be done with conventional comparisons. The lesson’s objectives are to: lea
by essentialSQL
Introduction One of the biggest issues beginning SQL writers have is being able to write queries that use more than one table.  In this series of articles we are going to show you how to write a query that combines, or joins, data from more than one table. Once you have gone through the examples [&#

Discussions

by Afzaal Ahmad Zeeshan on Article "Connecting to MySQL 5.0 from Visual...
by Nji, Klaus on technical blog "Get Ready to Learn SQL: 8....
by CodingK on article "Learn Microsoft Business intelligence...
by sameerapdn on Article "Connect csharp to Mysql"
by Member 11177214 on article "WITH (NOLOCK) example"
10 Nov 2011
Sebastien Lorion
A reader that provides fast, non-cached, forward-only access to CSV data.
10 Jul 2007
Marcos Meli
An easy to use .NET library to read/write strong typed data from files with fixed length or delimited records (CSV). Also has support to import/export data from different data storages (Excel, Acces, SqlServer, MySql)
6 Sep 2005
Carlos Antollini
Simple database access using an ADO class.
3 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.
8 Nov 2002
Daniel Turini
SQL Server database best practices
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.
23 Jul 2002
Carlos Antollini
A list of ODBC DSN Connection Strings.
12 Sep 2005
Huseyin Altindag
ADO.NET for beginners.
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
13 Jan 2013
liron.levi
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
20 Jun 2014
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)
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.
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.
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.
26 Apr 2008
s.india
This article gives a brief introduction about Triggers in Sql Server 2000/2005.
11 Mar 2013
Hafiz Muhammad Suleman
This article clears the differences between the On cluase and Where clause when used with left join.
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.
14 Nov 2004
Lars-Inge Tønnessen
An article on how to setup and configure the MSFT MSDE 2000.
22 Aug 2004
Matt Newman
A beginners guide to accessing a SQL or MSDE Server with C#
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.
22 Jun 2013
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
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.
22 Jan 2012
Mehdi Gholam
Smallest, fastest embedded nosql persisted dictionary using b+tree or MurMur hash indexing. (Now with Hybrid WAH bitmap indexes)
6 Jan 2001
Stefan Chekanov
CODBCRecordset class is intended to be full replacement of all ClassWizard generated CRecordset derived classes in MFC projects.
21 Jun 2000
Konstantin Vasserman
How to display multiple pages of records in ASP
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
25 Mar 2008
Qwertie
Demonstrates a variety of Windows Forms data binding features through several simple examples.
13 Apr 2004
Darren Weir
Deploy your SQL Server 2000 database with scripts.
28 Jul 2014
Bernardo Castilho
A component that makes it easy to use Entity Framework in WinForms projects, including design-time binding support.
10 Jun 2009
Pascal Ganaye
DbfDotNet is a very fast and compact fully managed standalone database/entity framework, for the .Net Framework.
10 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)
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!
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).
17 Oct 2009
Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
1 Nov 2010
Kanasz Robert
In this article, I will show you how to backup and restore databases using Server Management Objects
3 Mar 2008
Alex Baker
Change collation order for all text columns in a database
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
15 Feb 2003
Tarun Jain
A detailed look at the concepts involved in data binding and controlling data binding.
13 Jan 2005
Deyan Petrov
Generic data access component for different datasources, sprocs/SQL, implicitly propagated transactions, explicitly managed transaction contexts etc.
15 Apr 2006
Raj Lal
A dynamic web application needs an admin section for CRUD actions on the records/tables in the database. Wouldn't it be nice to have a database admin, which can be plugged to any web application? Just give your SQL connection string and it dynamically manages all table operations in just five pages.
15 Sep 2004
Xinjie ZHANG
With ADO.NET, a database can be regarded as a virtual XML document. XPath query and XSLT transformation are naturally available.
1 Apr 2012
Not Active
A C# Windows application to store and retrieve photos from a SQL Server database.
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.
16 Jan 2005
Sumit Amar .
1 alternative  
Stored procedure to generate INSERT..VALUES statements in SQL Server.
20 Jun 2009
Charles T II
A Data Access Framework using Generics, Lambda Expressions, Fluent Interfaces, and the SqlProviderFactory.
27 Sep 2003
Gareth Edwards
This article describes how to pass the equivalent of an array, into a stored procedure, showing a number of different data types. This technique doesn't have the size limitations that a number of other techniques suffer from.
13 Nov 2010
Kanasz Robert
In this first part of the tutorial, I will show you how to create data storage objects (databases, tables, Views ...) using SMO.
15 Mar 2013
Jeremy Todd
Using the right approach can make GUIDs nearly as fast as integer primary keys on almost any database system.

Advertise | Privacy | Mobile
Web01 | 2.8.141022.2 | Last Updated 10 Aug 2007
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid