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 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
by essentialSQL
Outer 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 using my Guide Getting Started Using SQL Server. In th
by Jitendra Ku. Sahoo
In this article we will discuss about fill factor and its effect on query performance.
by essentialSQL
This is the third in a series of posts teaching normalization. The second post focused on the first normal form, its definition, and examples to hammer it home. Now it is time to take a look at the second normal form.  I like to think the reason we place tables in 2nd normal form is to narrow [&#823

Research Library

Dell Toad DBA Suite for Oracle complements Oracle Enterprise Manager by...
Whether you are new to Toad for Oracle or have been using it for...
DBAs and developers working with IBM DB2 often use IBM Data Studio....
Toad for Oracle is the database management tool of choice for both...

Discussions

by Gian Paolo 33 on article "Nested XML from SQL to JSON"

All Articles