Download the SQLAjax Whitepaper    Tutorials and Sample Applications                  

 
Related Links

ASP.NET Generic Handlers as Replacements for Three-tier Web Servers
http://www.brainbell.com/tutorials/ASP/Generic_Handlers_(ASHX_Files).html

Securing Stored Procedures Against SQL Injection Attacks
http://palisade.plynt.com/issues/2006Jun/injection-stored-procedures/

Using Stored Procedures from ASP.NET Tutorial
http://www.aspfree.com/c/a/ASP.NET/Using-TSQL-Stored-Procedures-with-ASPNET-20/

IBM PHP-based Version of the SQLAjax Model
http://www.ibm.com/developerworks/web/library/wa-aj-end2end1/

IBM's Introduction to AJAX
http://www.ibm.com/developerworks/edu/wa-dw-wa-ajax-i.html

The Curse and Blessings of Dynamic SQL (a classic, highly recommended for TSQL beginners)
http://www.sommarskog.se/dynamic_sql.html

Replacing Cursors and Loops with Set Operations
Converting a Column to a Comma-delimited String with One SELECT Statement
http://www.sqlbook.com/SQL/Create-comma-delimited-list-27.aspx

Replacing Cursors with Loops and Tally Tables
http://www.sqlservercentral.com/articles/TSQL/62867/

TSQL Programming FAQ/How-do-I on aspfaq.com
http://sqlserver2000.databases.aspfaq.com/

Web Design and Search Engine Optimization Tutorials http://usability.about.com/od/aboutusability/Usability_Basics_What_is_it_and_Why_is_it_Important.htm

Web Design with Visio Articles on Google
http://www.google.com/search?hl=en&q=web+design+visio



"SQLAjax" web application: Less code on the web server...More-scalable...Easier to maintain:

 


Why do we use highly-scalable database application platforms like SQL Server, Oracle, and DB2 as data storage engines, but not take advantage of their performance and scalability power for our "business logic" code? Why can't AJAX code simply pass XML or JSON messages to databases through simple HTTP handlers like .NET .ashx files? Object-oriented approaches like SOAP and ORM tightly-bind data and UI code between the browser and the web, and therefore are often the exact opposite of what service-oriented architecture is all about.


Major Links on AJAX: AjaxPatterns.org, Taconite, innerHTML issues, Web 2.0, Developer.com
Books: Foundations of Ajax by Asleson and Schutta, AJAX Patterns and Best Practices by Gross


"When used in massive quantities, Ajax applications can clog up network traffic. A more important concern, in turn, is that the large amount of traffic exposes Ajax applications to Web services vulnerabilities. When these vulnerabilities are exploited, the system or applications will perform poorly."
-- http://www.ibm.com/developerworks/web/library/wa-aj-speed.html 

All rights reserved 2006, 2007, 2008