small devs with Sql Server 2012/VS 2011

Discussion:

(too old to reply)

Mauricio Sthandier

2012-02-22 01:05:34 UTC

hi,
I have to develop small apps for a retailer. A few forms and
reports... something simple. Although both quite anew, intend to use
SQL Server 2012/VS 2011 because anyway I have to learn them again, as
haven't used the platform for a while, my last app for this company
was VB 6 and SQL Server 2000 :).

Does it look like a natural pair ? I'd like to think this overhaul
will last some years, as it did before.
Ah well if so... some basic samples (data maintenance, "hello world"
report) will be greatly appreciated to ramp up. I do work coding but
in another platform.

thanks, regards

Bob Barrows

2012-02-22 12:06:50 UTC

Permalink

Post by Mauricio Sthandier
hi,
I have to develop small apps for a retailer. A few forms and
reports... something simple. Although both quite anew, intend to use
SQL Server 2012/VS 2011 because anyway I have to learn them again, as
haven't used the platform for a while, my last app for this company
was VB 6 and SQL Server 2000 :).
Does it look like a natural pair ? I'd like to think this overhaul
will last some years, as it did before.
Ah well if so... some basic samples (data maintenance, "hello world"
report) will be greatly appreciated to ramp up. I do work coding but
in another platform.
thanks, regards

You should post in a .Net (dotnet) group. The database is just a database,
and everything you learned about querying databases and SQL DML with your
vb6/sql2000 app will be applicable to sql2012. The differences will be in
the front-end, and will also depend on what language/platform you will be
using for the front-end. VS (Visual Studio) is basically just an editor used
for several Microsoft languages, including the .Net languages (VB.Net, C#,
etc.). It can be used to create a Windows Forms application (that runs on a
desktop), or an ASP.Net app that runs on a web server and is accessed by
browsers on client machines. So before posting to one of the groups, that's
the other question you have to decide: desktop application (fat client) vs
web application (thin client). Good luck.

Mauricio Sthandier

2012-02-22 15:30:23 UTC

Permalink

Post by Bob Barrows

thanks, it makes sense. I guess tried to focus on a suitable IDE/
platform for developing with SQL Server 2012. I could use Access for
the dev, but SQL Server historically has given me all the flexibility/
capability the retailer needed (we'll use Express edition, at least
initially).
I've been sneaking some new code and seems it changed a lot from old T-
SQL... I'm mainly a DB developer and prefer to hold as much logic as
can in the database. If can use a thin client only for presentation/
validation, I'll go for it. Will also give a try on the PowerPivot.

regards,

Bob Barrows

2012-02-22 16:25:02 UTC

Permalink

Post by Mauricio Sthandier
I've been sneaking some new code and seems it changed a lot from old
T- SQL... I'm mainly a DB developer and prefer to hold as much logic
as can in the database.

Basic T-SQL has not changed all that much. There are some new functions and
statements that make things that used to be hard to do a little easier but,
the basic

select <field list> from tablename where <criteria> order by <field list>

has not changed.

The ability to create CLR (.Net) procedures was added back in SQL 2005:
that's probably the biggest change since your SQL 2000 days, but it's still
possible to create an application using nothing that did not work in SQL
2000.

If you want to work with the newer features, I would suggest picking up a
book. 2012 is still in infancy: it's official release date is next month..
Note the name of this book:
http://www.google.com/products/catalog?q=sql+server+2012+books&hl=en&safe=active&prmd=imvnsa&biw=1250&bih=905&um=1&ie=UTF-8&tbm=shop&cid=893334706719814
8792&sa=X&ei=qxZFT6CrFYHrgQfM6dGLBA&ved=0CIUBEPMCMAU