Browse by Tags

Comb the tangled SQL server 2005 connection string and deploy the database to remote SQL server
Wednesday, February 20, 2008 12:48 AM

No matter how many ADO .net application I did and will write in the past and future, near and far, there is no way I can remember the long connection strings in indecipherable machine language. Normally I would do a quick search and grab whatever turns up on the first spot and stuff it in my web.config file. Normally I use access, normally it would work. Occasionally... Read More...

by xxxd

Filed under: database, SQL server 2005, ADO .NET

Some Dos and Dont's in designing website databases
Wednesday, January 23, 2008 2:22 AM

1. Choose the right data storage device Do not use XML files as the sole data storage device, for XML files are not ideal for constant data operations (delete, insert, update). Do not use Access database, because a. Access Database is not suitable for multiple concurrent users; b. Access database is not scalable. SQL server is a preferred database choice for... Read More...

by xxxd

Filed under: sql, database, website