HTTPS - HyperText Transfer Protocol with Secure Sockets Layer. HTTPS is a protocol to transfer encrypted data over the Web.
There are two primary differences between an HTTPS and an HTTP connection work:
* HTTPS connects on port 443, while HTTP is on port 80
* HTTPS encrypts the data sent and received with SSL, while HTTP sends it all as plain text
HTTPS should be used while designing a online store or ecommerce website.
HTTP sends data collected over the Internet in plain text and freeware sniffer software tools can easily collect those data.
Things to consider:
* A Web server such as Apache with mod_ssl that supports SSL encryption
* A Unique IP address - this is what the certificate providers use to validate the secure certificate
* An SSL Certificate from an SSL certificate provider
Monday, April 28, 2008
Sunday, April 27, 2008
SQL SERVER trick
Tips and Tricks for Good Result from SQL SERVER
1. Store relevant and necessary information in the database instead of application structure or array.
2. Use normalized tables in the database. Small multiple tables are usually better than one large table.
3. If you use any enumerated field create look up for it in the database itself to maintain database integrity.
4. Keep primary key of lesser chars or integer. It is easier to process small width keys.
5. Store image paths or URLs in database instead of images. It has less overhead.
6. Use proper database types for the fields. If StartDate is database filed use datetime as datatypes instead of VARCHAR(20).
7. Use Like Clause properly, if you are looking for exact match use '=' instead.
8. Specify column names instead of using * in SELECT statement.
9. Write SQL keyword in capital letters for readability purpose.
10. Using JOIN is better for performance then using sub queries or nested queries.
11. Use stored procedures. They are faster and help in maintainability as well security of the database.
12. Use comments for readability as well guidelines for next developer who comes to modify the same code. Proper documentation of application will also aid help too.
13. Proper indexing will improve the speed of operations in the database.
14. Make sure to test it any of the database programming as well administrative changes.
1. Store relevant and necessary information in the database instead of application structure or array.
2. Use normalized tables in the database. Small multiple tables are usually better than one large table.
3. If you use any enumerated field create look up for it in the database itself to maintain database integrity.
4. Keep primary key of lesser chars or integer. It is easier to process small width keys.
5. Store image paths or URLs in database instead of images. It has less overhead.
6. Use proper database types for the fields. If StartDate is database filed use datetime as datatypes instead of VARCHAR(20).
7. Use Like Clause properly, if you are looking for exact match use '=' instead.
8. Specify column names instead of using * in SELECT statement.
9. Write SQL keyword in capital letters for readability purpose.
10. Using JOIN is better for performance then using sub queries or nested queries.
11. Use stored procedures. They are faster and help in maintainability as well security of the database.
12. Use comments for readability as well guidelines for next developer who comes to modify the same code. Proper documentation of application will also aid help too.
13. Proper indexing will improve the speed of operations in the database.
14. Make sure to test it any of the database programming as well administrative changes.
connecting asp with databse securely
http://dotnetbird.wordpress.com/2008/04/25/connecting-an-aspnet-website-to-sql-server-database-securely/
Friday, April 25, 2008
Current Week Number!!
To find the current week no. in C#.
int i = 0;
i = select todate(sysdate,w);
or
i = (DateTime.Now.DayOfYear)/7;
int i = 0;
i = select todate(sysdate,w);
or
i = (DateTime.Now.DayOfYear)/7;
Subscribe to:
Posts (Atom)