Anyone against static functions being used in Data Access Layer(DAL)?

I think its a good idea to declare your DAL methods as static since DAL is more or less is a utility layer, putting/getting values from the DB. Note that static methods are different from static member variables. Unless you are using static variables I don't think there would be any concurrency issues. Please check this article for details:
http://www.codeproject.com/csharp/codeconcepts.asp