Posted in Technology

Recursive Relationships in Databases

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

Posted in Technology

To upgrade or not to upgrade XAMPP 1.7.3

XAMPP is just another package of…

Posted in Technology

Paging records in MS SQL Server 2005

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).

Posted in Technology

MS SQL Server: Temporary Tables

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…

Posted in Technology

MS SQL Anomalies 3

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…

Posted in Technology

Deceiving MS SQL Server: UPDATE Command

First version …

Posted in Technology

Broken SQL objects: Views, functions, stored procedures, triggers

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

Posted in Technology

MS SQL Server: Anomalies 2

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

Posted in Technology

MS SQL Server: Using Remote Servers (Linked Servers)

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.

Posted in Technology

MS SQL Server: Anomalies

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.