[dba-VB] C# - Direct data manipulation

Gustav Brock Gustav at cactus.dk
Fri Dec 4 09:32:07 CST 2009


Hi John

LINQPad does pure SQL too, though not with IntelliSense, and error messages seem to be those from SQL Server.

/gustav


>>> jwcolby at colbyconsulting.com 04-12-2009 15:43 >>>
 >they operated with the concept "scared of the database" meaning that the web developers should 
just be presented with ready-made views because SQL to these was like black magic.

I actually think that is a good thing, developers who just use data shouldn't need to be learning 
SQL Server to get their data.

That is really not the audience I am addressing however.  IMHO the built-in editor of SQL Server 
should either be removed entirely or at least brought into the current century.  It is notepad with 
pretty colors.  How many millions of man hours have been wasted trying to track down errors when the 
only error message presented was "error near (insert some unrelated thing here)".  Why bother even 
throwing up an error like that, and that is 99.9% of the errors I have EVER seen in two years 
working with SQL Server.

Notepad, with pretty colors.

For all of the rude comments us Access developers get about Access being "a toy", the code editor in 
Access is in a complete other galaxy from the code editor in SQL Server.  SQL Server editor looks 
like it was designed in 1986 and never upgraded.

Of course with the "real men don't use code editors" mentality of the DBA side of the fence I can 
see why MS doesn't bother spending time on this.

Someday I really am going to have to figure out how to use VS to run / debug my SPs and stuff.  To 
me VS just seems over-the-top complex for the level of stuff I am trying to do.  An Access type of 
code editor would be just the right level of convenience and capability - built right into SSMS.

John W. Colby
www.ColbyConsulting.com 


Gustav Brock wrote:
> Hi John
> 
> One reason could be that many web developers know little about database design, thus they are being forced to leave that to a DBA. A chief developer once told at a tech meeting I attended, that they operated with the concept "scared of the database" meaning that the web developers should just be presented with ready-made views because SQL to these was like black magic.
> 
> /gustav





More information about the dba-VB mailing list