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
Otis Mukinfus - 03 Jan 2006 00:43 GMT
In linw:
>Greetings -
>
[quoted text clipped - 19 lines]
>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).
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
William (Bill) Vaughn - 03 Jan 2006 03:46 GMT
See >>> inline answers.

Signature
____________________________________
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.
__________________________________
> Greetings -
>
[quoted text clipped - 23 lines]
> documentation looks geared to those who are proficient with prior
> versions)
>>>>> I would suggest my new book but it won't be ready until Summer. I
>>>>> agree, many of the help topics and books assume quite a bit. I'm
[quoted text clipped - 10 lines]
> Any
> ideas where I can find this (I'm just outside of NYC, fwiw).
>>> I would try to attend one of the conferences like VSLive (Boston is
>>> nearby). I'll be speaking there and hopefully they'll offer one of my
[quoted text clipped - 3 lines]
>>> help or point you in the right direction. I'm an INETA speaker so
>>> perhaps your UG can invite me out there to talk.
hth
> Thanks for any pointers/suggestions!
>
> kc
Cor Ligthert [MVP] - 03 Jan 2006 09:32 GMT
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
William (Bill) Vaughn - 03 Jan 2006 19:28 GMT
There is a beta of the new SQL Server Management Studio Express that works.

Signature
____________________________________
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,
>
[quoted text clipped - 14 lines]
>
> Cor
Cor Ligthert [MVP] - 04 Jan 2006 13:30 GMT
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
William (Bill) Vaughn - 04 Jan 2006 19:56 GMT
Yes, it's on the "to-do" list (once it ships).

Signature
____________________________________
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,
>
[quoted text clipped - 6 lines]
>
> Cor
kcamhi - 05 Jan 2006 04:29 GMT
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).
> Greetings -
>
[quoted text clipped - 23 lines]
>
> kc