If you like to paste scripts into the command window when creating SQL Server 2000 jobs in Enterprise Manager, you should be aware of the 3200-character limit. You won't get a warning unless your script does not parse correctly because of the spot where it was cut off. You will get a warning if you choose Open to open a script file.
I just discovered the SqlBulkCopy class in .Net 2.0, and it seems awesome! Now I don't have to shell out to BCP anymore! We'll see though, I haven't done any performance testing yet...
How is it possible that I'm just learning about the "GROUP BY ALL" option? It sounds like it would save a lot of time. It worries me though that Microsoft says not to use it anymore because it will be removed from a future version. Is there a good alternative?
For any telephone/cellular service provider who cares, you should be implementing the option of caller-specific voicemail greetings on your system. The scenario happens quite often: I know somebody specific is going to call me during a period in which I'll be unavailable, and I have a specific message just for them, e.g. "I'm mowing the lawn but I'll be ready when you get here" or something like that. Also, having a web page to administer the whole voicemail system and contacts would be great. Feel ......
If you want to build your own composite control for ASP.Net and you want to create in such a way that when you set a property in the designer window, the setting is reflected in the aspx code, placing this attribute on each public property is the key:
[DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]