Ricky Datta Blog

Whidbey Beta 1 is up on MSDN Subscription.

http://msdn.microsoft.com/subscriptions/downloads/

Ricky

T-sql wish

I wish I could write the following in t-sql :

raiserror('Error in procedure %s, statement  [%s] stack trace [%s]', 1, 1, @@current_proc_name, @@current_statement, @@stack_trace)

where

@@current_proc_name = name of currently executing sproc
@@current_statement = current statement where error occurred
@@stack_trace = stack trace

I see no evidence in Yukon.

Buggiest dot net assembly : System.Web.Mail

Because of COM Interop, actual error messages are lost - so is the programmer.

Anyway, seems like there is a lot of dependency on OS version, office/outlook, ado combination

- very temperamental.

I have switched to an open source implementation - open smtp on source forge -

http://sourceforge.net/projects/opensmtp-net/

Highly recommended.

Ricky

dbcodegen

Check out my (commercial) sql server ado.net code generator

Features

sproc -> ado.net datareader classes
sproc -> ado.net dataset classes
tables -> xsd, classes
tables -> CRUD sprocs, classes

T-Sql wish - another one

I wish T-Sql had an Oracle like SGA system buffer which would keep records of

- all expensive (CPU, IO) queries made since startup
- all full table scans on large and medium tables

This way we do not have to hunt for table scans in the source code.

Maybe Yukon will deliver this - I do not see it from docs.

Scott Waters - How about the capability of adding Serverside like forums on

popular blog topics here.

Blog comments would become sort of like slashdot/serverside, user interface wise.
Somehow asp.net forums is not quite the same.

Too many Presentation Layers

We have

1. ASP.NET
2. WinForm
3. Now XAML

Why cant we have just one - a super ASP.NET which can run natively on web, windows, pda....

Or how about a common library with skin transformaers (adapters) which cut the cost ....

T-Sql wish - One more

TOP (n) operator is very useful.

How about MIDDLE (m,n) and LAST(n) operators (server side in Yukon) ?

I think ASP.NET programmers would love it.

T-SQL Trivia : What is the fastest way to insert multiple rows from middle tier memory to database table in a single transaction

Oracle Answer : insert from VARRAY(fixed size) in a special loop [ Bulk Collect Insert ]

Sql Server 7/2000 : insert ... from ... in (row 1, row 2, ...) - dynamic sql required.

Yukon team - Can you do better than Oracle ?

My wish list for T-SQL

- Support for ARRAY, RECORD, data types for locals and parameters
- CREATE OR REPLACE phrase ( I am sick of doing ...  if exists .. from sysobjects...drop...)
- PACKAGES or equivalent - what happened to this basic wish - at least a CLASS with sprocs as members

Wishing away...

What .NET community needs is a APACHE FOUNDATION like oragnization

APACHE FOUNDATION produces a lot of community based java software libraries.

How about such a foundation for .net software ?