Premium Sponsor
Premium Sponsor


Advanced Search
Popular Articles
Popular Authors
SubMain - Developer Tools
 »  Home  »  Data Programming  »  SQL Server
SQL Server

» ADO.NET 3.5, LINQ, and the Entity Framework
by Larry Blake | Published 08/14/2009 |  | Rating:

Murach's ADO.NET 3.5, LINQ, and the Entity Framework by Anne Boehm, comes in both Visual Basic and C# 2008 versions.  Larry Blake reviews it.

[read article...]
» Book Review: Murach's SQL Server 2005 For Developers
by Scott Waletzko | Published 03/11/2007 |  | Rating:

A review of Murach's SQL Server 2005 for Developers tutorial and reference book, written by Scott Waletzko (Skystone Software).

[read article...]
» An introduction to SQL Server Management Objects
by David Jeavons | Published 01/02/2007 |  | Rating:


SQL Server Management Objects (SMO) is a collection of objects that allow you to work with SQL Server 2005 databases in a managed environment. Previous to SQL Server 2005 you could use SQL Server Distributed Management Objects (DMO) to work with SQL Server 6.0, 6.5, 7 and 2000 (including MSDE) servers. For the most part, the objects provided with SMO will also work with SQL Server 2000, only those features specific to SQL Server 2005 will not work against a 2000 server.

This article aims to introduce a few of the basic operations that can be performed using SMO such as connecting to an SQL Server, managing databases, tables and stored procedures and performing backup and restore operations against an SQL Server.

[read article...]
» Testing for Security in the Age of Ajax Programming
by Bryan Sullivan | Published 10/13/2006 |  | Rating:

Ajax programming, which allows a web page to refresh a small portion of its data from a web server, is an exciting technology that has recently been introduced. However, this type of programming can also leave applications open to SQL injection and similar attacks. It is important for the developer to test the application thoroughly for vulnerabilities before passing it on to the QA department. And the QA engineer needs to learn to "think like a hacker." Learn more about securing your website's Ajax programming.


This article has been written by Bryan Sullivan, who is a development manager at SPI Dynamics, a Web application security products company. 

[read article...]
» All About IDENTITY Columns in Sql Server 2000
by Anjali Chelawat | Published 10/05/2006 |  | Rating:


Article Contents


·         About IDENTITY columns

·         Functions associated with IDENTITY column

·         Examples

·         A Few Tips

·         Points To Remember

[read article...]
» Advanced Caching Techniques in ASP.NET 2.0
by Sandeep Joshi | Published 05/05/2006 |  | Rating:

Web application development is one of the key business process areas in software industry. A web application has a long life only if the user visits the application with interest.

To keep the user interest in your web site, two factors are important. One is easy navigation and the other is fast data retrieval. The most dramatic way to improve the performance of a database driven Web application is through caching.

This article delves into the caching mechanism, available with ASP.NET 2.0. The author takes a walk through ASP.NET 1.1 caching practices as well as a comparison with ASP.NET 2.0 changes.

[read article...]