Passwords Security in Your Database

When ASP.NET developers think of Web security and authentication, three options typically come to mind: Windows authentication, forms authentication, and passport authentication.
If you're building an Intranet application within your organization, for instance, you might choose to use Windows authentication. Configuring Windows authentication within IIS is fairly straight forward and involves only two steps.
First, we make sure that Integrated Windows Authentication is checked and Anonymous Access is unchecked for a Web application by following the steps outlined below:

1. Right-click on the Web app directory within IIS and select Properties.


2. Select the Directory Security tab from the application's Properties dialog.


3. Select the Edit… button within the Anonymous Access and Authentication control panel.


4. Uncheck Anonymous Access and make sure that Integrated Windows Authentication is checked similar to the figure below.

Speed Optimization in ASP.NET 2.0 Web Applications

Overview

Developing a web application that responds to users requests quickly is a target and a challenge for all web developers. ASP.NET was designed with speed optimization and performance improvements in mind. The set of enhancements like: Pages compilation, and Automatic storage on the server are new to ASP.NET.

However, these enhancements are not enough to protect you from slow performance when a large number of  http requests are simultaneously processed by your web application.

To write a well performing web application you must make a balance between four common performance measures. These measures are:

Execution Time: It is the time taken to process a request. This is measured as the time elapsed between the first byte received from the server and the last one.

Response Time: It is the time between issuing a request and the first byte received as a response from the server.

Scalability: It measures the performance of a web application against resources (memory, processors, or computers) allocated for it.

Throughput: It is the number of requests your application can serve in a time unit, usually a second.

What follows is a list of areas that you can invoke to harvest for techniques that you can use to develop a high performance ASP.NET application.

Deleting Rows Duplicate when the table doesn’t have a primary key

Were you ever in need of something like, deleting duplicate rows when the table doesn’t have a primary key. If yes, read on!

This article gives a quick way of deleting duplicate records from a given table, that doesn’t have a primary key. Also, we will NOT use cursors, loops, temporary tables (global or local) but still accomplish the mission. Interesting! isn't it. Please read on!

First lets create a simple table with two columns and name the table as ‘DeleteDupsTable’.

How to Write a Simple login page in Asp.net

Yesterday I stumbled across a post that was posted on our forum. I was very busy with other things, when Sheo started a conversation based on that post. I was looking at it until he updated the untagged code that was posted. By looking at the Stored Procedure I could see that the poster was lost and his Stored Procedure approach failed him. In this Article am going to explain how to write a simple login in Asp.net.

SQL query optimization part 2

SQL query optimization part 1

Debugging Stored Procedures in SQL Server 2005

Were you ever in need of debugging a stored procedure in SQL Server 2005. Any .NET Developer is well versed with debugging .NET applications. The .pdb files will be used internally to serve the purpose. Pdb files will have the mapping information from Native to MSIL and ultimately to the .NET code. I will not get into the internals of how this happens as this article falls under the SQL Server category.

Paging of Large Resultsets in ASP.NET

An article about optimization and performance testing of MS SQL Server 2000 stored procedures used for paging of large resultsets in ASP.NET

• Download PagingTest Solution (C#) - 55.8 Kb
• Download Paging_Procedures SQL script - 2.48 Kb
• Download Paging_LargeTable SQL script - 0.6 Kb