RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX


More articles by Susan Sales Harkins

Author Bio
Susan Sales Harkins is an independent consultant and the author of several articles and books on database technologies.
For Database Development Zone | September 19, 2009
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.
For Database Development Zone | August 12, 2009
The key to working with null values properly is to accommodate them consistently. Learn a few tricks that will help you do just that.
For Database Development Zone | August 6, 2009
Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.
For Database Development Zone | July 16, 2009
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.
For .NET Zone | July 10, 2009
One of your first steps to serious .NET development should be creating and implementing flexible typed datasets to maintain control and protect the validity of your data.
For Database Development Zone | June 20, 2009
From monitoring e-mail messages to distributing reports for users, SQL Server's database mail proves quite useful. Learn how to use it in SQL Server 2000 and SQL Server 2005/2008.
For Database Development Zone | June 5, 2009
If you're a .NET newbie coming from Access or SQL Server, let .NET do the hard work of creating a connection to foreign data. Then customize the resulting control to add functionality.
For Database Development Zone | May 20, 2009
You can easily limit or group a recordset, but doing both to the same recordset takes a bit of hand coding. Find out how both SQL Server and MS Access can handle the task.
For Database Development Zone | April 10, 2009
This short introduction to .NET shows Access and SQL Server developers how to use a development tool to create connections to data and a user interface to manipulate that data.
For Database Development Zone | March 7, 2009
A column alias seems like a great tool for referencing complex expressions, but SQL Server doesn't work that way. Learn a simple workaround.
For Database Development Zone | February 20, 2009
Deleting all the data in a SQL Server database doesn't have to involve complex code. The undocumented stored procedure sp_MSForEachTable safely bypasses built-in limitations to accomplish this common task.
For Database Development Zone | December 18, 2008
Access can offer a lot of help with missing values, but finding and generating missing values in a field of sequential values requires a bit of code. Find it here.
For Database Development Zone | November 13, 2008
Maintaining a database often means schema changes. Before you change or delete anything, be sure to check for dependent objects.
For Database Development Zone | October 17, 2008
Getting to the data you need is always a challenge. Views can provide a "no muss, no fuss" way to retrieve the data you need—whether it's in the current database or another.
For Database Development Zone | September 25, 2008
Learn how executing frequent backups and maintaining healthy transaction logs in SQL Server leads to quick recovery. Failing to do so can mean having to re-enter a lot of data.
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date