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.
Monthly Archives: May 2007
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?
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!
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.
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 […]
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