473,320 Members | 1,732 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Learning SQL Server

Hi group.
I have been working with ColdFusion and SQL Server for some time
now....abour 4 years I guess. I have developed various web applications
successfully. The scenario I am in is that a company would like me to come
on with them as a lead database admin type guy. I would still do a little CF
development....but mostly it will be data management with SQL Server.
Now....like I said...I have worked with databases for quite a
while...specifically SQL Server, and I am quite comfortable with it......but
Im kinda worried that the position involves a lot more than I have done.
Mind you I will have first hand knowledge of the database in place which is
what this position is for....so I have somewhat of an advantage. But....Im
just wondering if I should do a short course that teaches me the ins and
outs again. It's like I develop databases by winging it. Know what I mean. I
think I know what I am doing...but what if I don't? Just wondering what your
thoughts are.
Jul 20 '05 #1
6 1746
I know what you mean, the best way to shape your "winging it" into best
practices is to pick up some good books. Kalen Delaney's Inside SQL
Server 2000 is excellent for the admin side and some development.
Knowing normalization and the relational model can only help you as
well. I don't know of a good normalization book (sure someone does) but
for relational model, Celko's Data and databases is written well.

In the next release of SQL Server (Yukon) there are a lot more
programming capabilities built-in.

HTH + GL

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #2

"Ray Higdon" <ra*******@nospam.higdonconsulting.com> wrote in message
news:3f***********************@news.frii.net...
I know what you mean, the best way to shape your "winging it" into best
practices is to pick up some good books. Kalen Delaney's Inside SQL
Server 2000 is excellent for the admin side and some development.
Knowing normalization and the relational model can only help you as
well. I don't know of a good normalization book (sure someone does) but
for relational model, Celko's Data and databases is written well.

In the next release of SQL Server (Yukon) there are a lot more
programming capabilities built-in.

HTH + GL

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


"Database Modeling & Design" is a nice book. It has good
coverage of normalization (and denormalization). And of
course as the title implies it covers design and analysis (i.e
indexes and so on) quite well. A nice medium sized
paperback of about 350 pages. I've got the 3rd edition.
the author is Toby Teorey. It's well written too, not too
heavy on RDB theory, but enough so as to be a practical
guide to the essential RDB concepts.

I'm not a real "DB person" myself either, but I use it so much
that I really need the kind of background that the book covers.

Bruce
Jul 20 '05 #3
Depending on the size of your organization, you may need to wear two
hats: development DBA and operational DBA. It seems you already have a
bit of experience in database development. To excel in this area, it's
quite helpful to have a solid understanding of data modeling and
relational theory so you might consider adding to your knowledge of
those areas, if needed.

The operational side is a different beast and concentrates of
backup/recovery, maintenance, tuning, etc. If your responsibilities
include these areas, Inside SQL Server 2000 <www.insidesqlserver.com> is
a very good resource as well as a thorough perusal of the Books Online.

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Member" <sa***@REMOVETHISSPAMapmsolutions.ca> wrote in message
news:7U********************@news01.bloor.is.net.ca ble.rogers.com...
Hi group.
I have been working with ColdFusion and SQL Server for some time
now....abour 4 years I guess. I have developed various web applications successfully. The scenario I am in is that a company would like me to come on with them as a lead database admin type guy. I would still do a little CF development....but mostly it will be data management with SQL Server.
Now....like I said...I have worked with databases for quite a
while...specifically SQL Server, and I am quite comfortable with it......but Im kinda worried that the position involves a lot more than I have done. Mind you I will have first hand knowledge of the database in place which is what this position is for....so I have somewhat of an advantage. But....Im just wondering if I should do a short course that teaches me the ins and outs again. It's like I develop databases by winging it. Know what I mean. I think I know what I am doing...but what if I don't? Just wondering what your thoughts are.

Jul 20 '05 #4
It is more development more so than the operational aspect.

Would you have any recommendations on books that would help the development
side?

"Dan Guzman" <da*******@nospam-earthlink.net> wrote in message
news:r2*******************@newsread2.news.atl.eart hlink.net...
Depending on the size of your organization, you may need to wear two
hats: development DBA and operational DBA. It seems you already have a
bit of experience in database development. To excel in this area, it's
quite helpful to have a solid understanding of data modeling and
relational theory so you might consider adding to your knowledge of
those areas, if needed.

The operational side is a different beast and concentrates of
backup/recovery, maintenance, tuning, etc. If your responsibilities
include these areas, Inside SQL Server 2000 <www.insidesqlserver.com> is
a very good resource as well as a thorough perusal of the Books Online.

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Member" <sa***@REMOVETHISSPAMapmsolutions.ca> wrote in message
news:7U********************@news01.bloor.is.net.ca ble.rogers.com...
Hi group.
I have been working with ColdFusion and SQL Server for some time
now....abour 4 years I guess. I have developed various web

applications
successfully. The scenario I am in is that a company would like me to

come
on with them as a lead database admin type guy. I would still do a

little CF
development....but mostly it will be data management with SQL Server.
Now....like I said...I have worked with databases for quite a
while...specifically SQL Server, and I am quite comfortable with

it......but
Im kinda worried that the position involves a lot more than I have

done.
Mind you I will have first hand knowledge of the database in place

which is
what this position is for....so I have somewhat of an advantage.

But....Im
just wondering if I should do a short course that teaches me the ins

and
outs again. It's like I develop databases by winging it. Know what I

mean. I
think I know what I am doing...but what if I don't? Just wondering

what your
thoughts are.


Jul 20 '05 #5
> Would you have any recommendations on books that would help the
development
side?
SQL Server 2000 Programming by Example

Ken Henerson's Guru's Guide to Transact-SQL

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Member" <sa***@REMOVETHISSPAMapmsolutions.ca> wrote in message
news:YP*******************@news02.bloor.is.net.cab le.rogers.com... It is more development more so than the operational aspect.

Would you have any recommendations on books that would help the development side?

"Dan Guzman" <da*******@nospam-earthlink.net> wrote in message
news:r2*******************@newsread2.news.atl.eart hlink.net...
Depending on the size of your organization, you may need to wear two
hats: development DBA and operational DBA. It seems you already have a bit of experience in database development. To excel in this area, it's quite helpful to have a solid understanding of data modeling and
relational theory so you might consider adding to your knowledge of
those areas, if needed.

The operational side is a different beast and concentrates of
backup/recovery, maintenance, tuning, etc. If your responsibilities
include these areas, Inside SQL Server 2000 <www.insidesqlserver.com> is a very good resource as well as a thorough perusal of the Books Online.
--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Member" <sa***@REMOVETHISSPAMapmsolutions.ca> wrote in message
news:7U********************@news01.bloor.is.net.ca ble.rogers.com...
Hi group.
I have been working with ColdFusion and SQL Server for some time
now....abour 4 years I guess. I have developed various web

applications
successfully. The scenario I am in is that a company would like me to
come
on with them as a lead database admin type guy. I would still do a

little CF
development....but mostly it will be data management with SQL
Server. Now....like I said...I have worked with databases for quite a
while...specifically SQL Server, and I am quite comfortable with

it......but
Im kinda worried that the position involves a lot more than I have

done.
Mind you I will have first hand knowledge of the database in place

which is
what this position is for....so I have somewhat of an advantage.

But....Im
just wondering if I should do a short course that teaches me the

ins and
outs again. It's like I develop databases by winging it. Know what
I mean. I
think I know what I am doing...but what if I don't? Just wondering

what your
thoughts are.



Jul 20 '05 #6
Member (sa***@REMOVETHISSPAMapmsolutions.ca) writes:
It is more development more so than the operational aspect.

Would you have any recommendations on books that would help the
development side?


I still think that Kalen's book is good reading. There's not so much
about data modelling there, but you get some hinch about optimizer
internals and understanding of how the optimizer and indexes works is more
important for development than for operations.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Sean | last post by:
While checking out opensourcecms.com - I found only 3 CMS - e-Learning tools. Are there more and has anybody used the 3.(Claroline - Moodle - Segue) I have has much success with PHPNUKE, Guppy,...
7
by: Ryan Walker | last post by:
Hi, I'm getting started with python and have almost zero programming experience. I'm finding that there are tons of tutorials on the internet -- such as the standard tutorial at python.org -- that...
6
by: kneejerkreaction | last post by:
I'm seeking advice on learning .NET I have experience in ASP, HTML, Vb, Vbscript and Javascript but want to learn .NET I also have some experience with SQL Server and Oracle databases. My...
5
by: Chuck Bowling | last post by:
From the walkthroughs I'm starting to get the impression that the only way I'm going to be able to learn about ADO.NET is to go out and buy SQL Server 7.0. I already own MS Access and don't have...
1
by: Bruno van Dooren | last post by:
Hi, currently we have an intern writing an OPC server for us in C++. OPC is a hierarchy of classes based on DCOM. When the intern leaves I will have to maintain that server. since i am new to...
1
by: TM | last post by:
I am trying to learn ASP.net as part of my learning of .net in general, and was wondering how applications are developed and then deployed most of the time ? Do people do development on a...
26
by: mfasoccer | last post by:
I am sorry if this is an inappropriate place to put this post, if so please delete it. I am wondering about a few things. Do you guys recommend learning C as a second language, as someone who...
4
by: Jean-Marc Blaise | last post by:
Hi, I have been trying to register for E-Learning for MS-SQL2005 ... but IE aborts any time before the registration is finished ... (after sign-up, or information fill up, or before those steps):...
2
by: lmaurer | last post by:
Hi all, I have been charged with learning how to create web pages that will function as data capturing tools. From the research I have done, it looks like I need to learn ASP.net and SQL Server...
6
by: Dave Boland | last post by:
I'm in the process of learning the finer points of AJAX to do some really cool things, but I need a way to try code. I don't want to pay for a server that supports php and mySQL for learning, so I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.