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. 6 1760
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!
"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
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.
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.
> 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.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
anyone has used these or other
CMS-e-Learning type tools - please let me know. I need to create an...
|
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 finding that there is very little (that I can find) about how
to do basic logistical things related...
|
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 independently. I have several books on .NET and XML etc. but am at the point where I need to be able work...
|
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?
|
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 ...
| |
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
|
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.
|
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 this working as designed despite this pb shows me that Microsoft has still progressed to make in...
|
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 and Intro
to SQL server where I should start or are there even more basic items
I need to learn...
|
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
other suggestions for a simple localhost? I don't need FTP, SSL, etc.
Thanks,
Dave
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| |
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |