Stream and Complex Event Processing from a Relational Guy's Eye

This is a re-post from my previous blog. However, as that blog has now gone to the big blog repository in the sky (or wherever blogs go to when they are no more), I decided to repost this, seeing how CEP and StreamInsight are becoming more and more popular.

Read More ...

SQL Server 2008 R2 August CTP

Yesterday I downloaded and installed the August CTP of SQL Server 2008 R2, and today I played around with it for a while. So, what are my impressions?

Read More ...


As the saying goes; "It is hard to learn an old dog new tricks", but...  Even though I am a really old dog, I hope I'll be able to learn a bit about "social networking", and therefore I created an account on Twitter a couple of days ago. Hopefully I'll be able to be more active on Twitter than what I've been here at the blog. Well, that should not be too hard, seeing how infrequent I post here.

Anyway, my twitter account is @nielsberglund, so if you are interested you know where to go.

Debugging in SQL Server 2008

As good as SQL 2005 was (well, still are), one disappointment was that you needed Visual Studio if you wanted to debug your stored procedures. Seriously, what was MS thinking when they did that, especially as in SQL 2000, Query Analyzer had debug capabilities?!!

Read More ...

SQL Server 2005 and DMV's

One of the first thing I usually do after having installed a new version of SQL Server is to snoop around at the system tables to see what new tables there are and what they can give me information about.

Read More ...