|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > What to teach a pure beginner???
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
What to teach a pure beginner???
|
|
| Eric Mamet 2002-11-08, 6:23 am |
| I have been requested to spend a couple of days with a pure SQL Server
beginner to teach him how to use this tool.
His background is ASP and MS Access and he is supposed to use this SQL
Server to write Intranet applications.
The subject is so vast I don't really have a clue where to start...
I was thinking of
- a simple Backup / Restore strategy
- normalisation and the importance of indexes
Do you have any suggestions?
Thanks
| |
| Allan Mitchell 2002-11-08, 7:23 am |
| If he is an ASP developer then maybe BACKUP and RESTORE is something the DBA
should do for him and leave him to learn SQL Server
What about syntax ?
http://www.mssqlserver.com/tsql/
If this guy is a developer then teach him what to look for in a bad
application from SQL Server's point of view (indexes, table scans,
statistics, Cursors)
If he has worked with MS Access then chances are he is thinking in rows so
that will be a good thing to wean him off
You are right there is a lot.
Give him Kalen's book and also Ken England's
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE, MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community for SQL Server
professionals - http://www.sqlpass.org
"Eric Mamet" <eric.mamet.nospam@reuters.com> wrote in message
news:O52CV0xhCHA.1960@tkmsftngp08...
> I have been requested to spend a couple of days with a pure SQL Server
> beginner to teach him how to use this tool.
>
> His background is ASP and MS Access and he is supposed to use this SQL
> Server to write Intranet applications.
>
> The subject is so vast I don't really have a clue where to start...
>
> I was thinking of
> - a simple Backup / Restore strategy
> - normalisation and the importance of indexes
>
> Do you have any suggestions?
>
>
> Thanks
>
>
| |
| Eric Mamet 2002-11-08, 7:23 am |
| That's part of the problem... He is everything: he will have to be the DBA
too!
"Allan Mitchell" <allan@no-spam.SQLDTS.com> wrote in message
news:OJYcjEyhCHA.2544@tkmsftngp11...
> If he is an ASP developer then maybe BACKUP and RESTORE is something the
DBA
> should do for him and leave him to learn SQL Server
>
> What about syntax ?
>
> http://www.mssqlserver.com/tsql/
>
>
> If this guy is a developer then teach him what to look for in a bad
> application from SQL Server's point of view (indexes, table scans,
> statistics, Cursors)
>
> If he has worked with MS Access then chances are he is thinking in rows so
> that will be a good thing to wean him off
>
> You are right there is a lot.
>
> Give him Kalen's book and also Ken England's
>
>
> --
>
>
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE, MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community for SQL Server
> professionals - http://www.sqlpass.org
>
>
>
> "Eric Mamet" <eric.mamet.nospam@reuters.com> wrote in message
> news:O52CV0xhCHA.1960@tkmsftngp08...
> > I have been requested to spend a couple of days with a pure SQL Server
> > beginner to teach him how to use this tool.
> >
> > His background is ASP and MS Access and he is supposed to use this SQL
> > Server to write Intranet applications.
> >
> > The subject is so vast I don't really have a clue where to start...
> >
> > I was thinking of
> > - a simple Backup / Restore strategy
> > - normalisation and the importance of indexes
> >
> > Do you have any suggestions?
> >
> >
> > Thanks
> >
> >
>
>
| |
| Geoff N. Hiten 2002-11-08, 10:23 am |
| Buy him the following books:
Inside SQL 2000 by Kalen Delaney
MCSE Training Kit for SQL 2000 Administration
SQL 2000 Resource Kit.
Teach him to use BOL and the knowledge base.
Set up a simple maintenance plan and walk him through it.
Make sure his resume is up to date, just in case.
--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com
"Eric Mamet" <eric.mamet.nospam@reuters.com> wrote in message
news:elTMxbyhCHA.1392@tkmsftngp12...
> That's part of the problem... He is everything: he will have to be the DBA
> too!
>
> "Allan Mitchell" <allan@no-spam.SQLDTS.com> wrote in message
> news:OJYcjEyhCHA.2544@tkmsftngp11...
> > If he is an ASP developer then maybe BACKUP and RESTORE is something the
> DBA
> > should do for him and leave him to learn SQL Server
> >
> > What about syntax ?
> >
> > http://www.mssqlserver.com/tsql/
> >
> >
> > If this guy is a developer then teach him what to look for in a bad
> > application from SQL Server's point of view (indexes, table scans,
> > statistics, Cursors)
> >
> > If he has worked with MS Access then chances are he is thinking in rows
so
> > that will be a good thing to wean him off
> >
> > You are right there is a lot.
> >
> > Give him Kalen's book and also Ken England's
> >
> >
> > --
> >
> >
> > Allan Mitchell (Microsoft SQL Server MVP)
> > MCSE, MCDBA
> > www.SQLDTS.com
> > I support PASS - the definitive, global community for SQL Server
> > professionals - http://www.sqlpass.org
> >
> >
> >
> > "Eric Mamet" <eric.mamet.nospam@reuters.com> wrote in message
> > news:O52CV0xhCHA.1960@tkmsftngp08...
> > > I have been requested to spend a couple of days with a pure SQL Server
> > > beginner to teach him how to use this tool.
> > >
> > > His background is ASP and MS Access and he is supposed to use this SQL
> > > Server to write Intranet applications.
> > >
> > > The subject is so vast I don't really have a clue where to start...
> > >
> > > I was thinking of
> > > - a simple Backup / Restore strategy
> > > - normalisation and the importance of indexes
> > >
> > > Do you have any suggestions?
> > >
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>
| |
| Allan Mitchell 2002-11-08, 11:23 am |
| Then take him through Backups and Restores. if he is doing them then these
may save him one day. This is coming from me who leans towards safety and
the DBA side of my job.
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE, MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community for SQL Server
professionals - http://www.sqlpass.org
"Eric Mamet" <eric.mamet.nospam@reuters.com> wrote in message
news:elTMxbyhCHA.1392@tkmsftngp12...
> That's part of the problem... He is everything: he will have to be the DBA
> too!
>
> "Allan Mitchell" <allan@no-spam.SQLDTS.com> wrote in message
> news:OJYcjEyhCHA.2544@tkmsftngp11...
> > If he is an ASP developer then maybe BACKUP and RESTORE is something the
> DBA
> > should do for him and leave him to learn SQL Server
> >
> > What about syntax ?
> >
> > http://www.mssqlserver.com/tsql/
> >
> >
> > If this guy is a developer then teach him what to look for in a bad
> > application from SQL Server's point of view (indexes, table scans,
> > statistics, Cursors)
> >
> > If he has worked with MS Access then chances are he is thinking in rows
so
> > that will be a good thing to wean him off
> >
> > You are right there is a lot.
> >
> > Give him Kalen's book and also Ken England's
> >
> >
> > --
> >
> >
> > Allan Mitchell (Microsoft SQL Server MVP)
> > MCSE, MCDBA
> > www.SQLDTS.com
> > I support PASS - the definitive, global community for SQL Server
> > professionals - http://www.sqlpass.org
> >
> >
> >
> > "Eric Mamet" <eric.mamet.nospam@reuters.com> wrote in message
> > news:O52CV0xhCHA.1960@tkmsftngp08...
> > > I have been requested to spend a couple of days with a pure SQL Server
> > > beginner to teach him how to use this tool.
> > >
> > > His background is ASP and MS Access and he is supposed to use this SQL
> > > Server to write Intranet applications.
> > >
> > > The subject is so vast I don't really have a clue where to start...
> > >
> > > I was thinking of
> > > - a simple Backup / Restore strategy
> > > - normalisation and the importance of indexes
> > >
> > > Do you have any suggestions?
> > >
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>
| |
| Eric Mamet 2002-11-08, 4:23 pm |
| Thanks Guys, I think I'm having a fair idea now...
Eric
PS: I'll make sure he updates his CV!
| |
| Wayne Snyder 2002-11-11, 8:23 am |
| For DBA add Admin 911 by Brian Knight to the book list...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"Eric Mamet" <eric.mamet.nospam@reuters.com> wrote in message
news:O52CV0xhCHA.1960@tkmsftngp08...
> I have been requested to spend a couple of days with a pure SQL Server
> beginner to teach him how to use this tool.
>
> His background is ASP and MS Access and he is supposed to use this SQL
> Server to write Intranet applications.
>
> The subject is so vast I don't really have a clue where to start...
>
> I was thinking of
> - a simple Backup / Restore strategy
> - normalisation and the importance of indexes
>
> Do you have any suggestions?
>
>
> Thanks
>
>
|
|
|
|
|