473,554 Members | 2,093 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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...specifi cally 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 1754
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*******@nosp am.higdonconsul ting.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 responsibilitie s
include these areas, Inside SQL Server 2000 <www.insidesqls erver.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***@REMOVETH ISSPAMapmsoluti ons.ca> wrote in message
news:7U******** ************@ne ws01.bloor.is.n et.cable.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...specifi cally 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*******@nosp am-earthlink.net> wrote in message
news:r2******** ***********@new sread2.news.atl .earthlink.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 responsibilitie s
include these areas, Inside SQL Server 2000 <www.insidesqls erver.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***@REMOVETH ISSPAMapmsoluti ons.ca> wrote in message
news:7U******** ************@ne ws01.bloor.is.n et.cable.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...specifi cally 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***@REMOVETH ISSPAMapmsoluti ons.ca> wrote in message
news:YP******** ***********@new s02.bloor.is.ne t.cable.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*******@nosp am-earthlink.net> wrote in message
news:r2******** ***********@new sread2.news.atl .earthlink.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 responsibilitie s
include these areas, Inside SQL Server 2000 <www.insidesqls erver.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***@REMOVETH ISSPAMapmsoluti ons.ca> wrote in message
news:7U******** ************@ne ws01.bloor.is.n et.cable.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...specifi cally 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***@REMOVETH ISSPAMapmsoluti ons.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
2432
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, PHProjekt and others...But these 3 CMS were "unable to connect to MYSQL". Sure I looked and read all the docs & install files...I'm lost here - if...
7
1761
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 tell you all about the language. That is, what are the methods, functions, modules, syntax, punctuation, etc. No problem there! Meanwhile, I'm...
6
1566
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 employer thinks even with the previous experience noted above, I am incapable of picking up .NET (they are hiring from outside) so I want to learn it...
5
1224
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 any desire to setup a full blown server. Should I give up on learning ADO.NET or is there an alternative?
1
1535
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 DCOM, I was wondering if anyone could recommend a good book for learning DCOM: what it is, what it can do, how to program and use it ...
1
1377
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 development server, then deploy to the live server, or do most people develop on their pc locally and then deploy to a development server ? Thanks
26
2946
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 already knows java very well. And what is the best way to learn C, books, tutorials, or what? Thanks, any response would be great.
4
1525
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): "Microsoft Internet Explorer a rencontré un problème et doit fermer. Nous vous prions de nous excuser pour le désagrément encouru.". I don't believe...
2
3162
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 (langauge and how to create databases in SQL Server). My question is where is the best place to start learning these tools? Are courses in ASP.NET...
6
2660
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 looked at XAMPP. XAMPP doesn't have a lot of documentation and running mySQL really slowed the Windows computer (required O.S. -- sorry!) Any...
0
7530
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7808
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7570
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7893
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5441
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3570
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3556
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2022
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1141
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.