No Silver Bullet vs. Agile Software
While there may be “no silver bullet” in software development, Agile Software methodologies provide a strong and compelling base from which to deal with the inherent complexities of software development.
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.
.NET Predicates (and a .RemoveAll() example)
What is a .NET Predicate and a C# example on how to use it.
Benefits of using ConnectionStrings Element Instead of AppSettings
With .NET 2.0 we can use .ConnectionStrings, and gain 3 benefits. – We can encrypt our connection strings on the fly using reg_iis (or by other methods), We can add SQL Cache Dependencies, By putting connection strings in the right place, we can take advantage of any new features that come out that use the ConnectionStrings element