Eric Barro
ebarro at verizon.net
Thu Mar 27 19:53:25 CDT 2008
John, The launch event is a good one to go to not to mention the fact that you get FREE software from Microsoft. I just came back from one in Spokane, WA and I was amazed at how far the technology has developed. I'm still developing web-based apps on .NET 1.1 and here Microsoft already has .NET 3.5 out there. I'm glad I skipped over 2.0 because the presentation I saw (specifically Visual Studio 2008) had better ways of doing stuff. LINQ for SQL takes querying SQL to another level. In fact the presenter went as far as to say that the "old notion" of creating stored procedures for faster code execution no longer holds true in some cases because the compiler and LINQ and the whole architecture takes programming (using those tools) to a new paradigm. Ah, yes...more learning to take place in the coming months. The presenters typed in and ran actual code and explained everything and did away with all the standard presentation slides from Microsoft. It was truly a developer's presentation. I saw them connect to a SQL server database, drag and drop a couple of related tables, drag and drop the stored procedures they wanted to run and then develop right in Visual Studio 2008. Of course someone still has to write the sprocs but as mentioned by the presenters, there will be cases when you won't need to write sprocs when you use LINQ. Here's a LINK to LINQ... ;) http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.a spx And yes...my eyes are glazed over as well. Mind you...this is not child's play because of the totally new concepts and ways of doing things. Eric -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, March 27, 2008 10:39 AM To: 'Discussion concerning MS SQL Server' Subject: Re: [dba-SQLServer] Being helpful >The follow up upgrade to sql server, that is SqlServer 2008 will >provide a lot of really cool tools such as intellisense, and the ability to run the same script across multiple servers etc. neat stuff, along w/ things like db compression etc. I shall sit on my wallet then and wait for SQL Server 2008. I am going to a product launch down in Charlotte next month and should get my copy there. It sounds like it will be worth the time to learn the new environment. Of course that means a whole new set of books. My wife HATES my books, at $45-$60 apiece. Has anyone seen any 2008 books that they can recommend? BASIC PROGRAMMING! ;-) John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: Thursday, March 27, 2008 1:25 PM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] Being helpful it would seem that you may look forward to the ever upgrade path from M$. while there are current purchasable apps you can get for Sql Server such as Sql Prompt (2.0 free or 3.0purchase) that provide intellisense and really help speed up much of the syntax building process there are also other tools from similar vendors that will help with syntax problems etc. The follow up upgrade to sql server, that is SqlServer 2008 will provide a lot of really cool tools such as intellisense, and the ability to run the same script accross multiple servers etc. neat stuff, along w/ things like db comrpession etc. Until then, I think the community has been helpful, and so long as we all try to stay ontopic we can avoid another rant gone wrong. -- Francisco On Thu, Mar 27, 2008 at 10:16 AM, jwcolby <jwcolby at colbyconsulting.com> wrote: > Much of my frustrations come from switching from a development > environment like .Net or Access to the query editor in SQL Server. > Even in the relatively basic Access we have modules and classes, > intellisense, syntax checking, error handlers, compile time errors > that actually mean something and so forth. > What a jarring contrast to switch to SQL Server query editor. > > But I am making progress. > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > -- -Francisco http://sqlthis.blogspot.com | Tsql and More... _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com