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.

Check out the latest Visual Studio third-party add-ons, including one that helps you edit your database's data and properties during a debug session.

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.

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

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 ...

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

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or the database is slow. In the ...

SQL Basics I: Data Queries —covers database terminology and the four basic query types. SQL Basics: SELECT statement options —covers the SELECT statement in detail and explains aggregate ...

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 ...

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.