Article Topics

All Articles

Peformance Tuning

Audit

Business Intelligence

Clustering

Reporting Services

Developer

General DBA

ASP.NET / ADO.NET

SQL Server 2008 - Worth the Wait

SQL Server’s first significant upgrade in three years features a number of envelope-pushing enhancements and improvements. Which will have the greatest impact on SQL administration and development? More...

Latest FAQ's

SSIS Lookups are Case Sensitive

Convert Number to Words in SSRS

After installing SP2 on SQL Server 2005 x64, when trying to ...

Remote Name Could not be Resolved in SQL Server Reporting Services ...

Latest SQL Server ASP.NET / ADO.NET Articles

Implementing a Generic Data Access Layer in ADO.NET Part 1
In Part 1 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.

Implementing a Generic Data Access Layer in ADO.NET Part 3
The 3rd and final of the 3 Part Series discussing the implementation of a provider independent Data Access Layer in ADO.NET.

Implementing a Generic Data Access Layer in ADO.NET Part 2
In Part 2 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.

ASP.NET Security [Part I]
An introduction to the ASP.NET methods for Authenticating and Authorizing users

Understanding the Page Life Cycle in ASP.NET
The Page Life Cycle is the series of events fired when a web page is requested. Undertstanding of the Life Cycle is key to developing ASP.NET applications.

Working with Transactions in ADO.NET
Transaction processing is an indispensible part of ADO.NET, a transaction guarantees that a block of statements will either be executed in its entirety or rolled back.

Caching in ASP.NET (Part II)
The second article in the caching series looks at using the Cache API.

Caching in ASP.NET (Part I)
Caching is probably the single quickest and most efficient method of boosting performance of ASP.NET applications. The first article in this series looks at Page Output Caching and Partial Page Caching.

Working with Exceptions in ADO.NET
The new version of ADO.NET includes powerful support for working with exceptions efficiently. This article throws light on how to handle exceptions efficiently when working with ADO.NET and highlights the best practices that can be followed in this context.

DataTable Enhancements in ADO.NET 2.0
ADO.NET 2.0 has added many new powerful features to the DataTable class including the ability to load a DataReader instance into a DataTable instance by using the Load method of the DataTable class, the DataTableReader, built-in serialization support.

View all articles for this topic