Article Topics

All Articles

Performance Tuning

Audit

Business Intelligence

Clustering

Reporting Services

Developer

General DBA

ASP.NET / ADO.NET

Write for Us

Share you SQL Server knowledge with others and raise your profile in the community More...

Latest FAQ's

SQL Server Reporting Server (SSRS) service is failing to start ...

Cannot Start SQL Server Service

Users are able to connect to report manager but not able ...

Errors when SQL Server Snapshot Replication is Running

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