Hendrik Swanepoel

Browse by Tags

All Tags » Database (RSS)
Sorry, but there are no more tags available to filter with.
Cleaning a Microsoft Access DB
I have been fortunate enough in my career to mainly use MS SQL Server as my applications' data store. With all the small spin off products that we are pushing at the moment, we need to make these applications available without the luxury of using SQL Server (or MSDE). Thus I've been working with Access in the last few days. It hasn't been going too bad, but a few stuff are new to me. I'm not used to the T-SQL capabilities, the field types are different, etc. I'm also working of a factory model for...
Posted: May 19 2004, 07:52 AM by hendrik | with 107 comment(s)
Filed under:
Using XML as a datastore
I have recently started developing an app that has a real simplified datastructure, so I opted for storing the data in an a xml file. This gives me the benefit of real easy deployment - and if I use mono to compile my code, it's platform and db independent. To manipulate and read it, I just load it into a dataset and work on the datatables. This works fine and dandy, but there are a few things to look out for... Watch out for objects modifying the file at the same time. If you have 2 different objects...
Posted: May 17 2004, 08:50 PM by hendrik | with 2 comment(s)
Filed under:
Web interfaces for SQL Server
I saw this link on Yosi Taguri's WebLog Taguri's WebLog . It links to a download for a web interface to SQL Server, released by MS. It's got import export functionality, which is great. Another similar tool, which I think I heard of through Armand a long while ago, is ASP.Net enterprise manager . This has a nicer interface, but doesn't really have anything as advanced as importing and exporting that I'm aware of. None of these products enables inline editing of data, as does Enterprise Manager. ...
Posted: May 05 2004, 07:44 AM by hendrik | with no comments
Filed under: