Posts
119
Comments
115
Trackbacks
22
April 2007 Entries
SQL job command - max chars
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.
posted @ Friday, April 20, 2007 5:20 AM | Feedback (1)
SqlBulkCopy
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...
posted @ Tuesday, April 10, 2007 10:06 PM | Feedback (7)
T-SQL and GROUP BY ALL

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?

 

posted @ Monday, April 09, 2007 6:37 PM | Feedback (1)
multi-million dollar idea...

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 free to pay me for the preceding advice.

[][]
  >
`---

posted @ Saturday, April 07, 2007 9:18 PM | Feedback (0)
settings transfer from designer to code in composite control in asp.net

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)]

posted @ Tuesday, April 03, 2007 7:05 PM | Feedback (0)
News