|
Careful Consideration of Deleting |
|
|
By host on
10/25/2007 12:57 PM
|
|
|
|
“To delete, or not to delete: that is the question. Whether ‘tis nobler in the database to accumulate the bits and bytes of outrageous data or to take arms against a sea of auditors and by techie-speak end them?”
Now that I have sufficiently geek-ized Hamlet for my intro; I would like to say a few words regarding the deletion of data. In the design of an application, whether or not to allow data to be deleted from a database through the user interface should be very carefully considered.
Considerations of how the system will be used, how extensively the system is used, value of the data, data relationships and other dependencies are important. It would be unrealistic to say “never delete”; although, it could be argued that deleting should be rarely used.
Carefully listen to those who are defining your development specifications. I have often found that when it is requested to have the ability to delete a r ...
|
 |
|
|
More...
|
|
|
Eliminating Duplicate Records |
|
|
By host on
10/21/2007 12:12 AM
|
|
|
|
In the magic world of Pleasantville, software executes without a flaw, data is entered into databases clean and without error. DBAs and Developers spend their days playing chess in the park while their applications hum along in the server room. Unfortunately, we do not live in Pleasantville and there are times when data that is entered into databases is duplicated. Regardless of the cause of the duplication, the cleanup can be a challenge.
If you were working with a small set of data, or simply a glutton for mind-numbing work, one could simply scroll through the records deleting every other record thus cleaning up the du ...
|
|
|
|
|
More...
|
|
|
Get Involved With a SQL User Group! |
|
|
By host on
10/15/2007 10:13 PM
|
|
|
|
I, as a co-founder of a local user group, strongly encourage all IT professionals to either get involved with a local user group. If there is not one available, consider starting one. A user group is extremely valuable to not only ones career as a professional; but also to the community as a whole.
Prior to being involved in a user group, I was the only developer (at most, I was one of two) in the company in which I worked. I didn't have many in my circle of friends and co-workers to discuss development issues. This was very frustrating because my exposure was only as wide as my local bookstore or the internet. Fortunately, I had a conversation with a local Microsoft consultant who in turn included me in the building process of a local SQL Server user group. Now my circle of influence is much larger and I feel like I am indeed a valuable part of the Indianapolis Developer Community.
There ...
|
|
|
|
|
More...
|
|
|
IndyTechFest |
|
|
By host on
10/14/2007 4:00 PM
|
|
|
On Saturday, October 13th, 2007, IndyTechFest was unleashed upon Indianapolis... or was it that Indianapolis was unleashed upon IndyTechFest? With 560+ registered and 350+ actually in attendance (for the entire day!) this event was successful beyond expectations.
 The event was planned by 4 of my good friends (Brad Jones, Dave Leininger, Mark McClellan, Bob Walker) and Me. As leaders of very active user groups ( IndyNDA and IndyPASS) we felt that it was important that the two groups pull together to provide a spectacular event for the developer/DBA community of ...
|
|
|
|
|
More...
|
|
|
DotNetNuke |
|
|
By host on
7/22/2007 7:15 PM
|
|
|
|
I am a software developer who mainly uses Visual Studio .Net for my projects and have used it in the past for building web sites (the prior website on this very domain was built with Visual Studio .Net). A couple of years ago a good friend of mine recommended that I check out DotNetNuke. My initial thoughts were skeptical and wasn’t sure if I would spend my time researching this tool.
After a few months, a project came my way to develop a new site for a local user group. My good friend was part of this project and made a good case for using DotNetNuke for its development. The implementation was a little tricky; but made easier with the assistance of my resident veteran DotNetNuke junkie.
When it came time to begin filling the site with content, I was amazed at how easy it was and immediately understood the benefits of offering websites that can easily be maintained by their owners from anywhere and without any special tools beyond the interface presented by DotNetNuk ...
|
|
|
|
|
More...
|
|