SQL

The ORM Debate: Experts Weigh In

A lot of controversy has been generated recently over blog posts "ORMs are a thing of the past" and (the more poetically titled) "A Farewell to...

17 replies - 5180 views - 10/20/09 by Mitch Pronschinske in News

Jailer: Database Subsetting and Sampling Tool.

If you use an enterprise application, you probably maintain full-size copies of the production database to meet development and testing requirements. Numerous...

0 replies - 1114 views - 05/26/09 by Wisser in Announcements

How to find duplicate row in a table - MSSQL

The below given query will fetch the duplicate rows in MSSQL with number of occurance of each row.SELECT <all column names - comma seperated>,...

0 replies - 2303 views - 09/01/08 by arunbiji in Tips and Tricks

Handy SQL with IntelliJ IDEA

If a project you are working on requires referring to an SQL database, you can, actually, use one of the numerous SQL clients, or type commands in the command...

0 replies - 3101 views - 08/26/08 by Irina Megorskaya in News

Maintaining A SQL Server Database - Maintenance Plans

This video shows you how to create a maintenance plan in SQL Server 2005 to backup and maintain your database. It also shows you how to use choose the right...

1 replies - 2064 views - 07/19/08 by Schalk Neethling in News

Efficient Paging in SQL Server 2005

It is a little bit off topic for my blog, but I came across a situation today while at work where I needed to page the results of a stored proc, but at the...

1 replies - 2867 views - 07/10/08 by justin_etheredge in News

PHPLinq As Cool As Real LINQ?

I read about the PHP Implementation of LINQ called PHPLinq. Frankly, I was sceptical about it. Finally, I gave it a try. I still remain sceptical... Let me...

1 replies - 2992 views - 07/10/08 by mikeborozdin in News

ASP.NET - Preventing SQL Injection Attacks

Consider a simple web application that requires user input in some fields, lets say some search box. Suppose a user types the following string in...

0 replies - 14126 views - 06/18/08 by Schalk Neethling in News