One of the tricky issues in entity relationship model is the recursive relationships. Sometimes an entity needs to refer to itself.

XAMPP is just another package of…

After years of torturing their SQL Server users, Microsoft provided a “better” way of paging records in version 2005, and it is a weird one! The following example is from their website, an article about ROW_NUMBER (Transact-SQL).

Just a way of using temporary tables in Microsoft SQL Server, if you want to duplicate one or more records quickly, you can use commands like this…

For those who are still using ancient data types such as CHAR be careful if you are also using REPLACE function in MS SQL servers…

First version …

Designing a perfect entity relationship diagram for our database together with a marvellous table structure is never good enough…

We had a database in MS SQL 2000 server. The server/database was configured NOT to use recursive triggers.

Sometimes I need to have a quick way of transferring data from one database to another running on a separate machine, especially when the table structures are identical or similar, it saves time. M$ SQL Server 2005 has a feature called linked servers.

Backup/restore databases: After the restore, you must revoke (sp_revokelogin) and grant access (sp_grantlogin) to users again, esp. if you are restoring the database on a different machine.