Developer Pills - All Comments

re: iPhone 3G suck!!!

Nathan Pledger — Tue, 02 Sep 2008 22:53:27 GMT

I have a Nokia N95 8Gb, having defectd from Sony Ericsson. More features, half the price! And you don't look quite as pose-ish!

re: 32 Hours Recharge Cocktail

Adel Khalil — Thu, 21 Aug 2008 10:26:57 GMT

nothing really but i advice against using this, just for absulote situations :D

re: 32 Hours Recharge Cocktail

Fady Anwar — Mon, 18 Aug 2008 18:55:12 GMT

tell me about the side effects :D

re: 32 Hours Recharge Cocktail

Waleed Abdelwahab — Sun, 17 Aug 2008 06:56:14 GMT

cool, I'll try this out today, I hope this wouldn't be my last thing to write.

re: New Start, Wide Horizon

Adel Khalil — Tue, 29 Jul 2008 16:33:33 GMT

challenge seeker, however that turn out to be not that good, so i'm going to stay awhile in my next job i guess few years of stability won't hurt.

re: New Start, Wide Horizon

Waleed Abdelwahab — Mon, 28 Jul 2008 06:32:05 GMT

your resume indicates a very short working periods for each and every employer, what does this mean in your point of view? a challenge seeker or a work ruiner?

re: Annoying problem Outlook 2007 Syndication fails

screwms — Fri, 16 May 2008 03:46:11 GMT

yes it does. ms hasnt fixed e problem even though its may 2008. only way is to install IE7??

true or false emails

true or false emails — Thu, 15 May 2008 06:09:15 GMT

Pingback from true or false emails

re: Make sure you read this blog

Fady Anwar — Fri, 14 Mar 2008 01:01:57 GMT

thanks for the blog link man, i was searching for such thing long time ago

re: Mark Miller latest post in promoting CodeRush, shocking

Fady Anwar — Sat, 08 Mar 2008 01:35:38 GMT

LOL, THAT is hilarious

everyone loves boobs :D and with code, they look even more sexy :P

Sara the super model writes code faster than you!

Dennis van der Stelt — Mon, 25 Feb 2008 08:55:50 GMT

Adel Khalil wrote a post about Mark Miller's latest post on his weblog. And now I'm continuing

re: obstructed folders under TortoiseSVN

Camille Espanol — Tue, 29 Jan 2008 10:48:46 GMT

Well the thing is this situation can turn into a pretty fucked up one if you were only handling files that aren't in the depo yet, with the 'add' status attached. Then you're screwed, all you can do is delete, and write those again.

re: The Myth of Stored Procedures Preference

Adel Khalil — Sun, 20 Jan 2008 21:36:25 GMT

More good news that even if you haven't used params ( which you should never ) SQL Server will cach the execution plan.

re: The Myth of Stored Procedures Preference

James Gregory — Fri, 11 Jan 2008 12:23:21 GMT

People seem to be ignorant of, or simply forget, that using dynamic sql does note equate to injecting values. Dynamic SQL can be, and should be, used with parameters just as you do stored procedures.

If you use parameterised sql then your cached plans are just as efficient as stored procedures.

re: The Myth of Stored Procedures Preference

Ellery Familia — Wed, 09 Jan 2008 17:12:19 GMT

This article is full of holes... the most obvious ones is the attack on SP security. If you implement SPs correctly, then this would not be a problem:

string s = "EXEC sp_GetCustomerByEmail '" + txtEmailAddress.Text + "'";

Even if txtEmailAddress.Text = "'; DROP DATABASE myDB", since the user executing that stored procedure only has rights to executing stored procedures and not random SQL... CERTAINLY not DROP rights, the Sql injection problem you mention does not exists, unless an incompetent developer creates it.

In answer to your "performance" attack, Yes.. SQL Server caches execution plans for random SQL, but not to the level that it does for SPs. SQL Server stores several execution plans for SPs and selects the best plan based on parameters, all tables and joins involved, as well as other costs calculations such as I/O and pages involved.

If you're using random SQL, you SQL statements must match perfectly in order for an execution plan to be reused.