Use this handy tip to determine the size of your SQL Server tables, which can be very useful for estimating the size and growth of a database over time.

A better approach than "hiding" columns in a DataGrid is simply to avoid creating the columns in the first place, as shown in this tip.

An update to a previous tip on retrieving the ID of the last inserted record, this version uses less code and avoids a search of the jobs table.

SQL Server offers several different data types for storing large amounts of data in table columns. But which should you use?

Does Oracle's acquisition of Sun mean a merger of their flagship conferences, Oracle OpenWorld and Sun's JavaOne, into a single co-located show?

Follow this procedure to deploy a CrystalReportViewer control to a production ASP.NET web site.

Create a running number column that shows the row number in a DataGrid control.

Discover how to call stored procedures and functions in MySQL from PHP using three database extensions: MySQL, MySQLi, and PDO.

A corrupt table in MS Access means lost time and data. It can lead to a loss of revenue or even employment. Learn how you might be able to recover most of the data when the worst happens.

Discover how to generate PHP classes that provide common MySQL database operations using the DAO design pattern.

The key to working with null values properly is to accommodate them consistently. Learn a few tricks that will help you do just that.

Instead of making one query to get the Max and Min values for a column, and then making another query to get additional information about those rows, you can do it all in one query.

Discover the underlying cause of Merge Constraint errors when merging DataSets.

Set the DataSource, DataTextField, and DataValueField properties correctly, and you're done.

Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.

Let SQL Server tell you which queries take the longest to run.

You can't let a little thing like not knowing a database's structure keep you from your work. Without identifying tables and columns, you can still find specific values and columns.

This workaround provides a way to evaluate the PropertyPath value of an object, even if it's not bound to a data consumer.

Using Oracle's PL/SQL, you can get complete table column descriptions using this command.

Unless you populated a recordset yourself, you may not know whether it contains a particular field.