How To Isolate Code To Run only on Certain Servers
Occasionally with websites, the need arises to have a block of code that executes only on a particular set of servers–whether local development servers, or client servers, or production servers. In particular, you may find this useful if you have code you want to run only on development servers. How, then, can you accomplish this?
Use Enum (C#) instead of magic numbers
Enumerations (enums) make your code much more readable and understandable. How to use enums to enrich your code. Includes C# and VB.NET enum example
Proper Use of Static Functions
A static function is static because you do not need to create an instance of the class in order to use it. Some popular static functions are located in the Math library, for example, Math.Min(x,y). Your class or function can be static when it has no need for class or member variables, and it is also compact and stateless. Don’t forget, you have to still consider thread safety!
Prefix tables with dbo. in your SQL
A power tip on increasing your query execution speed is to prefix your table and stored procedure names with dbo. By prefixing with dbo, Our database makes one less call. Normally, when you do not use the dbo keyword, on a query such as Select * from Users where UserID = @UserID, it will first check the user’s schema to see if that table exists for them.
Visual SourceSafe 2005 Tip (VS2005) – Keywords
Using Visual SourceSafe, we can put some text at the top of our source file and it will automatically be updated by SourceSafe when you check in the file. See below for an example. // Last updated by: // $Author: Sameera $ // $Date: 4/13/07 11:16a $ This will allow you to quickly see who [...]
HttpContext Can Break Object Oriented Principles
How incorrect use of HttpContext can break object oriented principles and how to fix it.
Successful Server Migration using the HOSTS file
What is the Windows HOSTS file, and how to use the HOSTS file to test your site before re pointing the server during a server migration to successfully ensure a seamless migration with no down time.