February 2009 - Posts

• Writing ANSI Standard SQL is not practical.

  Writing ANSI Standard SQL is not practical - this is the conclusion I came to after several years of writing portable applications, which had to work against both SQL Server and Oracle. Let me elaborate. T he best practice is to use stored procedures. Read More... Posted Tuesday, February 24, 2009 5:30 PM by Alexander Kuznetsov | 8 Comments Filed under: Database Unit Testing, Transact SQL, ANSI SQL

• Should I Always Keep My Presentation Logic in My Presentation Layer?

  Well I have just read a post by Jonathan Kehayias named SQL Tip: Keep your Presentation Logic in your Presentation Layer I cannot say I completely agree with it. Of course if all the following assumptions are true: You already have a presentation layer Read More... Posted Friday, February 20, 2009 5:08 PM by Alexander Kuznetsov | 3 Comments Filed under: SQL Server, Database Programming, Transact SQL