SQL Server Starting Points

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings -

Several of you were helpful in disuading me from using Jet in a prior post.

I'm developing an application that needs a "person manager" attached to it,
with typical interfaces like "add person" "edit person" "get list of people"
plus some custom items.

A few questions.

I'm experienced in relational database design, access and .net, but not at
all in sql server:

1. How steep is the learning curve on SQL Server?

2. Any suggestions for good materials on getting started (most of the
documentation looks geared to those who are proficient with prior versions)

3. Any suggestions for how I can find a third party to get me started on
this -- most of the solution providers listed online seem to be looking to do
large turnkey packages. I'd be looking more for some part time development
and mentoring consulting to get this launched and then back in my hands. Any
ideas where I can find this (I'm just outside of NYC, fwiw).

Thanks for any pointers/suggestions!

kc
 
Greetings -

Several of you were helpful in disuading me from using Jet in a prior post.

I'm developing an application that needs a "person manager" attached to it,
with typical interfaces like "add person" "edit person" "get list of people"
plus some custom items.

A few questions.

I'm experienced in relational database design, access and .net, but not at
all in sql server:

1. How steep is the learning curve on SQL Server?

2. Any suggestions for good materials on getting started (most of the
documentation looks geared to those who are proficient with prior versions)

3. Any suggestions for how I can find a third party to get me started on
this -- most of the solution providers listed online seem to be looking to do
large turnkey packages. I'd be looking more for some part time development
and mentoring consulting to get this launched and then back in my hands. Any
ideas where I can find this (I'm just outside of NYC, fwiw).
Click to expand...

http://www.activeservers.net/ is a good host with many options (not my
company). They are in Seattle Washington, but I don't see that as a
problem. I'm in Arlington, TX. They have been hosting my sites for
about six years with no down time to speak of.

Take a look at their site and if you decide to contact them, tell them
Otis Mukinfus sent you to them. Somewhere in your email ask for Bob.

They host both .NET 2.0 and .NET 1.1. They also have SQL Server
Express installed on at least one of their servers. I'm using it for
forms based security on one of my sites.


Otis Mukinfus
http://www.otismukinfus.com
http://www.tomchilders.com
 
See >>> inline answers.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Kcamhi,

Just start, MSDN is full of samples, in fact it is SQLSever easier to use in
Net than OleDB because it has less exceptions.

A problem that exist with SQL Express is at the moment no maintenance tool,
which makes it for newbies more trouble full. However that the tool not yet
exist does not make it more helpful for you if you have a book which
describes the SQL maintenance tool.

With Full SQL sever 2005 it is just intall and start and use the SQL Server
management Studio, that is less complex (because of the way it was done,
although 6.5 was the worst and it became better and better) than all
previous versions were for that.

Just my thought,

Cor
 
There is a beta of the new SQL Server Management Studio Express that works.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Bill,

I had seen it, however did not know if it was working so thanks for your
information (I had mentioned all in an other message, however because that I
did not know the status I did skip it here).

Are you going to cover it in one of your books? In my opinion can that be a
great addition especial for all those going from Access to SQL.

Cor
 
Yes, it's on the "to-do" list (once it ships).

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Thanks all for the input and help on this.

Bill - I can't wait for your book... I could use it today!

For anyone else starting out before Bill's book hits... the SQL Server
tutorial in the Books Online download from microsoft is a decent starting
point.

Also, the community preview of the SQL Server Management Studio Express
seems quite powerful and has been very easy to get started with (along with
the tutorial).
 
Back
Top