SQL Server 2005 session at dotNED

by Sander Gerz February 25, 2005 07:48

The Dutch .NET usergroup held its session at Integer yesterday. Marcel Peereboom was the host and held an interesting session on the new features of SQL Server 2005. It's a difficult task to be comprehensive as the featureset is so big. Most time was spend on features that affect the developer. The rhetorical question was raised what to develop in T-SQL and where to use C# (or other available languages that target the CLR). As T-SQL is set-based, most of the time that's obvious. Let the database-queries be done by the one that's most efficient at this task.

Nevertheless, I was, and still am, a bit puzzled by what Microsoft tries to accomplish by introducing a new queuing mechanism that's hosted in Sql Server. I'm talking about the SQL Server 2005 Service Broker. Why would I want to do message queuing in T-SQL? Can you still call this T-SQL? And the link here points to an article that has a tagline mentioning SQL Server applications. To me, the database is a storage container. And an efficient one at that. Stuff gets put in, and you get stuff out. Okay, this sounds very much like queuing. However, I feel much more comfortable using (reusable) classes, when devising a queuing mechanism. What would happen to the SQL-code when business logic is getting more complex? Oh sure, you can put business logic in stored procedures written in C#. How's that for maintainability! Some logic here, some logic there. And when the application blows up, you'd better have a solid tracing mechanism to figure out what went wrong.

Anyway, for anyone interested in how much SQL Server 2005 is going to cost, Microsoft just announced that.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

.NET

How to test the Visual Studio .NET betas and CTP

by Sander Gerz February 18, 2005 07:39

Since about a year or so I receive dvd-copies of beta and community technical previews (ctp) of Visual Studio .NET 2005 and Sql Server 2005. I usually hesitate to install these every time a new disc arrives, because it takes quite some time to set up a Virtual PC installation of the OS + VS.NET/Sql Server. And yes, I try to copy the OS from a clean image, but still...

Richard Clark introduces an idea (okay, he admits he's not the first with this one) that has my full support. Why not distribute the Virtual PC image with the full installation already in it? You get instant access to the latest features and get right to testing the new bits. How about that?

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Microsoft Tech·Ed 2005 Europe Website

by Sander Gerz February 15, 2005 08:13

The website for the Microsoft Tech·Ed 2005 Europe is live. There's also an rss-feed. The pre-conference seminars start on Monday 4 July.

 

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

.NET

Powered by BlogEngine.NET 1.4.5.0
Theme by Mads Kristensen | Modified by Mooglegiant