I’ll focus on basic data manipulation queries and follow up with future articles about altering the database itself and more advanced query concepts if there is enough interest.

With the framework, Microsoft seeks to tie programming languages and database queries without making them SQL-specific, according to DeMichillie.

Learn how you can develop WinForms-based database applications more quickly with VS 2005 and SQL Server 2005 Express.

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Assuring optimal performance of database applications starts with coding properly formulated SQL. Poorly written SQL and application code is the cause of most performance problems. As much as 75% of ...

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

When I am working with an Oracle database, I still find myself using SQL*Plus for many quick and dirty database queries. In particular, I often look up constraints in SQL*Plus. In this post, I ...

Microsoft rolled out another round of prerelease versions of Visual Studio 2005, .Net Framework 2.0 and SQL Server 2005 as it strives to hit its revised ship dates during the second half of the year.

Learn More. DENVER—Microsoft will release Windows Server 2008, SQL Server 2008 and Visual Studio 2008 together on Feb. 27, 2008 in what will be the companys single largest launch ever.