I write this post with a mix of excitement and sadness. The exciting part is that I am helping form a new developer community site at http://www.TheRuntime.com . The sad part is that I will no longer be blogging at Codebetter. When Codebetter was first formed, myself and several other bloggers from DotNetJunkies...

Sahil just posted a nice little primer for getting started with the FOR XML clause in sql 2005 . Good start, however I feel like he missed a technique. One of my major gripes with working with FOR XML is when you have to join more than 2 tables in your query. FOR XML AUTO tends to create a child node...

Ready to pull my hair out over this one. Decided to use System.Transactions in my latest project, so being I'm doing my development on my local machine with a dev SQL Server 2005 install on a 2k3 machine I need to turn on MSDTC stuff... So running the code that uses system.transactions on the server...

It is undeniable that the blogosphere is becoming a prime time source of networking, information, and advertising. With this in mind, we've been watching the evolution of blogging. Authors like Scott Hanselman and Sahil Malik, business owners like Joel Spolsky and Eric Sink all are using the blogosphere...

Ok, it's been a bit of time since I posted some technical content. I seem to be the only codebetter blogger who has big business aspirations and is launching a real ISV so I've been trying to mix that content into the Codebetter feed for those of you who have similar aspirations. I think it's time to...

Scott doesn't . I do... sometimes. I generally prefer business objects and collections thereof for a good chunk of my ASP .NET applications. This is mostly because by extending business objects with properties, methods, and events I can gain a level of control that isn't possible with the dataset. Using...

I keep seeing a lot of examples in ASP .NET where sql server priviliges are given to the ASP.NET worker process. A few thoughts about this: By doing this you are expanding the damage that could be done if the ASPNET worker process was compromised. This is particularily so for those of you who give dbo...

Mike Lorengo and I are having a fantastic dialogue about complex objects and handling the display of their information in grids. I do recommend you read his post before continuing here. Don't mind me... I'll wait... Ok now that you're back I'd like to explain a little deeper on my preference for domain...

Some people have been discussing SQL Stored procedures lately. I figured I'd weigh in. As with most things programming, it really depends on what you're trying to accomplish. There are certain situations when lots of stored procedures are appropriate (application designed to run on a single database...

According to Frans , the announcement that SQL Server 2005 will be delayed until the end of 2005 also means that VS 2005 will be delayed until then as well... I guess this could have been predicted... -Brendan