Click here to Skip to main content

Database

Great Reads

by Jonathan de Halleux
A helper framework for generation of SQL queries in C++ and Lua
by Michael N. Haephrati
The DataTune system was one of the earliest data cleansing systems.
by Ravindra T C
Explains how to use MySQL with the Entity Framework.
by Mika Wendelius
Some simple scenarios to calculate running totals in SQL Server.

Latest Articles

by Shivprasad koirala, Marla Sukesh
This is the part 3 of the series Learn MSBI step by step
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 [&#
by essentialSQL
Introduction Database normalization is process used to organize a database into tables and columns.  The idea is that a table should be about a specific topic and that only those columns which support that topic are included. For example, a spreadsheet containing information about sales people and c
by essentialSQL
Note:  This is the second in a series of articles covering joins. The series starts with the article Introduction to Database Joins.  All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.  You can get started using these free tools

Research Library

Database administrators, developers, QA analysts and performance...
Dell Toad DBA Suite for Oracle complements Oracle Enterprise Manager by...
DBAs and developers working with IBM DB2 often use IBM Data Studio....
Toad for IBM DB2 is a powerful tool for the database administrator. But...

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"

All Articles