Database
D LINQ : How to Map Columns Which Auto Generate Values At the Database
2009-05-11
I have being working on a software application made on .Net and recently my client asked me to use D LINQ instead of SQL.
D LINQ has great benefits loaded! As I started working with DLINQ I started to know that preventing SQL injection is not a headache anymore and misspelled SQL queries will not trouble [...]
How to (Full and Transaction Log) backup and restore a database in Microsoft SQL Server 2005
2008-12-04
In this article I will discus how to backup a database as a FULL backup or with Transaction Log (Tail Log) backup and how to restore the database, how to recover transactions made after you taking the backup, etc.
Since it is not easy to use and organize images in the post itself I have uploaded [...]
Oracle Trunc Function
2008-11-24
Among various helpful functions provided by Oracle, Trunc function took my attention today because I had to fix a defect where some one has misunderstood and misused this function.
As the name itself suggests, the trunc function is capable of truncating a value. This function can be used either on a date type value or a [...]
