RocketScientist's Miscellaneous Ramblings
posts - 76, comments - 354, trackbacks - 3

April 2009 Blog Posts

What's the deal with SQL Server 2008 implementation?

What's the deal with SQL Server 2008 implementation? I was talking with a Microsoft representative at PASS and he asked me about our SQL Server 2008 implementation plan. "I don't have one." "Why not?" astonished look. "It's up to my ISV's to certify their applications, and they're not doing it.  I have software on SQL Server 2000 still, the ISV's aren't upgrading it and won't support it if I upgrade." Another astonished look. "So what can we do to fix that?" he asked. "I don't know." I didn't know then, I have a few ideas now. The problem is that the people who write software that work with SQL...

posted @ Friday, April 17, 2009 11:28 AM | Feedback (4) |

Aggregate Functions

I've run into this before, I ran into it today, and I'll probably run into it again. Why isn't there an aggregate function that concatenates strings? Besides the obvious "string don't get that big" (which I'd manage by manipulating my group by to fit) why not? Something like: CONCAT_AGG(column, separator) Where separator is a varchar that determines what goes between each string (space, comma-space, whatever). This would be pretty dang handy.

posted @ Thursday, April 16, 2009 11:25 AM | Feedback (4) |

So, what do you call a Santa that can turn into a wolf?

A Wereclaus.

posted @ Tuesday, April 07, 2009 11:00 AM | Feedback (2) |

Powered by:
Powered By Subtext Powered By ASP.NET