jwcolby
jwcolby at colbyconsulting.com
Fri Oct 23 13:37:09 CDT 2009
> Not long ago you were just starting to use SQL Server! So much to know, so little time. John W. Colby www.ColbyConsulting.com Dan Waters wrote: > Hi John, > > Not long ago you were just starting to use SQL Server! > > I thought I would make a comment that MS has announced that they will be > 'equalizing' C# and VB.Net. I don't remember if that's going to occur with > VS 2010 or later. But after the change, using C# or VB.Net will be just a > syntax preference choice! > > I'm going to learn VB.Net because it's closest to what I already know. > > Dan > > -----Original Message----- > From: dba-vb-bounces at databaseadvisors.com > [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: Friday, October 23, 2009 9:02 AM > To: Discussion concerning Visual Basic and related programming issues. > Subject: Re: [dba-VB] C# replace a special character > > > I cannot think of anything that I would want to do outside of Access...is > that sad or what? > > That is sad indeed. Nice that you have so much Access work that you never > need to consider anything > else though. > > I have a ton of SQL Server work for one specific client. While I can and do > use Access to perform > this work it is not very efficient. My biggest issue is simply that Access > is single threaded so > when I start a long running stored procedure out on the server, Access comes > to a screeching halt. > > I have logging processes running in the code that executes these stored > procedures. So I time how > long, what the SP name is, what specific file is being created or loaded, > date / time that the step > occurred etc. When a SP starts to run, Access locks up. I cannot see the > status log (through the > Access FE) that tells me where I am in the process. > > As you can see, while Access does function, for this kind of thing it > functions poorly. > > Personally, for a variety of reasons I am moving to C#.Net for this kind of > development. C# is now > widely accepted as a valid language by my clients, it is extremely powerful, > and it is pretty darned > fast, though it will not be as fast as a native EXE. C# has a ton of > database stuff available to it > (though I am not there yet), it has multi-threading (though I am not there > yet), and on a Windows > environment it can do pretty much anything I can imagine doing (and I have a > very active > imagination). Additionally it can be used from right inside of SQL Server > (though I am not there yet). > > For me, C# makes a lot of sense. It has a steep learning curve though. If > it weren't for the fact > that I am a consultant first and foremost, I would go with VB.Net. I > "played" with VB.Net quite a > bit in the past and it was a bit easier to come up to speed on, and every > bit as powerful as C# > within the domain of problems I would ever attempt. > > However if I ever need to sell my .Net skills, C# is just an easier sell. > > John W. Colby > www.ColbyConsulting.com > > > Max Wanadoo wrote: >> But what can you do with it? >> >> I cannot think of anything that I would want to do outside of Access...is >> that sad or what? >> >> Fast is good, but fast doing nothing is nothing. >> >> I can do nothing instantaneously! >> >> Max > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >