SQL Notes

Types of database users:

1. Native Users
2. Application Programmers
3. Sophisticated users
4. Specialized users

---

Aggregate functions in SQL:

1. Avg
2. Min
3. Max
4. Sum
5. Count

---

ACID Properties:

• Automicity: All or none tasks should be performed
• Consistency: No transactions execute concurrently
• Isolation: One transaction should be isolated from the other
• Durability: Any change in database remains permanent even if there is system failure

Configuring Login Controls on ASP.NET 2.0 website

Yesterday i stucked in configuring Login controls on my ASP.NET website, after spending a lot time in searching on net i found the solution from microsoft website,
Here are some of the steps to configure Login controls on ASP.NET page,

there are two ways:

one is using command prompt and another is using GUI provided by Microsoft,

1)using command prompt:
open cmd, type “cd C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin”, press enter

type “aspnet_regsql -E -S ./SQLEXPRESS -A all”, press enter

syntax:
aspnet_regsql -E -S {servername} -A all

this will create new database and configure it for using following features,

Membership
Profile
RoleManager
Personalization
SqlWebEventProvider

2)using GUI:

go to C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin

and open the file aspnet_regsql.exe

a wizard openes, Click next button and configure it according to your needs.

and you’re done!!

SCHOOL’s OUT, ITS TIME TO PLAY

India rocks!!