Database Administration Survey

Hi,

We are a systems research group at the Computer Science department
at
Rutgers University, and are conducting a survey to understand details
about network, systems and database administration. We hope that this
information would help us recreate a realistic environment to help
research in 'systems management'.

We request network, systems, and database administrators to take this
survey. As an incentive, all surveys completed in their entirety will
be
entered into a drawing of a number of $50 gift certificates (from
Amazon.com).

We hope you have a few minutes to take the survey which is located at:

http://vivo.cs.rutgers.edu/administration_survey.html

Research in our group:
The goal of our research is to improve the overall availability and
maintainability of services. Since administrators form an integral part
of these services, a key aspect of this work is to build environments
and tools that ease the task of service administration. In particular,
environments which would help administrators know how their actions
might impact the real service (before performing them for real), we
believe would be useful in preventing inadvertent actions. This survey
tries to understand the existing environments, what administrators do
currently to test the 'validity' of their actions, and the difficulties
they face in doing so. The two specific systems we are looking at are
networks and databases, as we believe these are important components of
many services.

If you have any questions regarding this survey or our work, feel free
to email us:
Fabio Oliveira (fabiool at cs || rutgers || edu), or
Kiran Nagaraja (knagaraj at cs || rutgers || edu)

Thanks for your time,

Fabio Oliveira
PhD student, Vivo Research Group (http://vivo.cs.rutgers.edu)
Rutgers UniversityTo anyone who is wondering the survey is not very long and none of the
questions were dollar related, which was my first suspicion.

In my opinion the survey suffers from the flaw of allowing you to
identify several databases are in use in your shop, but does not allow
associating the answers/problems identified to any one database
product.

HTH -- Mark D Powell --|||"Mark D Powell" <Mark.Powell@.eds.com> wrote in message
news:1106753026.980765.309700@.z14g2000cwz.googlegr oups.com...
> To anyone who is wondering the survey is not very long and none of the
> questions were dollar related, which was my first suspicion.
> In my opinion the survey suffers from the flaw of allowing you to
> identify several databases are in use in your shop, but does not allow
> associating the answers/problems identified to any one database
> product.
> HTH -- Mark D Powell --

One of many flaws. Another is the same as with any of these surveys- it is
designed to support the solution under consideration.|||I did my part and participated.. Wondering what the results is...! Can
the creater update us on your statistics out of this survey???|||"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106769002.075423.231530@.c13g2000cwb.googlegr oups.com...
> I did my part and participated.. Wondering what the results is...! Can
> the creater update us on your statistics out of this survey???

Why are you asking me? Anyway, the answer was on the web site. If you left
your email address, you will get a copy of the results.

Data Warehousing question

I asked some of this question in another group so pardon my cross posting.
Im rather bored right now and really curios about this.
Do most of the BI folks do the technical stuff on they're own, or do they
have the technical people do it for them? Is it common to have someone doing
the technical but not alot of business involvement? If I were to go from
being a DBA to a DW guy tomorrow, would I be thrown much more in the mix
with the business folks? I never thought about this but I would have to
imagine it to be the case.
TIA, ChrisR
Sorry...

> Do most of the BI folks do the technical stuff on they're own, or do they
> have the technical people do it for them? Is it common to have someone
> doing the technical but not alot of business involvement?
This was all in regards to Data Warehousing.
"ChrisR" <noemail@.bla.com> wrote in message
news:e3e5izQpFHA.3568@.TK2MSFTNGP10.phx.gbl...
>I asked some of this question in another group so pardon my cross posting.
>Im rather bored right now and really curios about this.
>
> Do most of the BI folks do the technical stuff on they're own, or do they
> have the technical people do it for them? Is it common to have someone
> doing the technical but not alot of business involvement? If I were to go
> from being a DBA to a DW guy tomorrow, would I be thrown much more in the
> mix with the business folks? I never thought about this but I would have
> to imagine it to be the case.
> TIA, ChrisR
>
>

Data Warehousing question

I asked some of this question in another group so pardon my cross posting.
Im rather bored right now and really curios about this.
Do most of the BI folks do the technical stuff on they're own, or do they
have the technical people do it for them? Is it common to have someone doing
the technical but not alot of business involvement? If I were to go from
being a DBA to a DW guy tomorrow, would I be thrown much more in the mix
with the business folks? I never thought about this but I would have to
imagine it to be the case.
TIA, ChrisRSorry...
> Do most of the BI folks do the technical stuff on they're own, or do they
> have the technical people do it for them? Is it common to have someone
> doing the technical but not alot of business involvement?
This was all in regards to Data Warehousing.
"ChrisR" <noemail@.bla.com> wrote in message
news:e3e5izQpFHA.3568@.TK2MSFTNGP10.phx.gbl...
>I asked some of this question in another group so pardon my cross posting.
>Im rather bored right now and really curios about this.
>
> Do most of the BI folks do the technical stuff on they're own, or do they
> have the technical people do it for them? Is it common to have someone
> doing the technical but not alot of business involvement? If I were to go
> from being a DBA to a DW guy tomorrow, would I be thrown much more in the
> mix with the business folks? I never thought about this but I would have
> to imagine it to be the case.
> TIA, ChrisR
>
>

Data Warehousing question

I asked some of this question in another group so pardon my cross posting.
Im rather bored right now and really curios about this.
Do most of the BI folks do the technical stuff on they're own, or do they
have the technical people do it for them? Is it common to have someone doing
the technical but not alot of business involvement? If I were to go from
being a DBA to a DW guy tomorrow, would I be thrown much more in the mix
with the business folks? I never thought about this but I would have to
imagine it to be the case.
TIA, ChrisRSorry...

> Do most of the BI folks do the technical stuff on they're own, or do they
> have the technical people do it for them? Is it common to have someone
> doing the technical but not alot of business involvement?
This was all in regards to Data Warehousing.
"ChrisR" <noemail@.bla.com> wrote in message
news:e3e5izQpFHA.3568@.TK2MSFTNGP10.phx.gbl...
>I asked some of this question in another group so pardon my cross posting.
>Im rather bored right now and really curios about this.
>
> Do most of the BI folks do the technical stuff on they're own, or do they
> have the technical people do it for them? Is it common to have someone
> doing the technical but not alot of business involvement? If I were to go
> from being a DBA to a DW guy tomorrow, would I be thrown much more in the
> mix with the business folks? I never thought about this but I would have
> to imagine it to be the case.
> TIA, ChrisR
>
>

Data Types

I'm creating a windows .net form that has SQL as the back-end. One of the
controls is a group box with three radio buttons options. What data type
should this column have, so whatever option the user chooses will be saved o
n
the SQL table?
Another one, a YES/NO field, what data type should this column have?
--
TSHi TS,
You can use a numeric field and store 1 or 0.
please let me know if u have any questions.
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.SQLResource.com/
---
"TS" wrote:

> I'm creating a windows .net form that has SQL as the back-end. One of the
> controls is a group box with three radio buttons options. What data type
> should this column have, so whatever option the user chooses will be saved
on
> the SQL table?
> Another one, a YES/NO field, what data type should this column have?
> --
> TS|||With three radio buttons you either have three or four options - if you allo
w
none of the options to be selected (maybe as an initial state).
E.g.
null - none selected
0 - first selected
1 - second selected
2 - third selected
etc.
I believe TINYINT could cover that. Look it up in Books Online if you
haven't already.
However, a more humanly-readable aproach would be to use more descriptive
values - make use of enumerations in .Net and map them to a table in your
database if appropriate. After all - this is the 21st century. ;)
ML|||On Thu, 27 Oct 2005 08:26:13 -0700, TS wrote:

>I'm creating a windows .net form that has SQL as the back-end. One of the
>controls is a group box with three radio buttons options. What data type
>should this column have, so whatever option the user chooses will be saved
on
>the SQL table?
>Another one, a YES/NO field, what data type should this column have?
Hi TS,
You're approaching this from the wrong side.
You should first investigate what data is needed for the application
that you are creating. Identify the dependencies and the business rules,
then normalize the data to at least third normal form and create your
tables.
Once that is done, the next step is to create a GUI that makes it as
easy as possible for the user to enter the required data into the
system. For a column where only a few specific options are legal, a
group box with radio buttons might be fine (but so might a textbox with
dropdown). For a column with only two legal values, a yes/no button
might be appropriate (but a checkbox, a dropdown, or a set of two radio
buttons might do as well).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

Data Transformation in Transactional Replication

I already put this set of questions to another group and oly one person
replied. I would appreciate if other people can share their opinion as well.
Thanks
=====================
I have a transactional replication set up from one system to another.
Subscriber has only read mode on data (Uni-directional Replication). I need
to do lots of transformation in the data while replication from Publisher to
Subcriber Like adding the same record in the other table as well or do some
denormalization etc.
Which route should I choose?
1. Modify Replicaiton procedures to have this business rule in-built.
2. Should I create indexed views and other tables on reporting server.
3. Should I create trigger on the reporting server and have the replication
procedure only do the insert and trigger do rest of the business rules
implementaion.
4. Can reporting services be used for such a transformation.
5. Should I have DTS as a part of replication.
-Nitin
Perhaps you should call PSS and get their input.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Now available on Amazon.com
http://www.amazon.com/gp/product/off...?condition=all
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nitin" <Nitin@.discussions.microsoft.com> wrote in message
news:A2EE86E0-024D-4E1D-9051-6144C65B310F@.microsoft.com...
> I already put this set of questions to another group and oly one person
> replied. I would appreciate if other people can share their opinion as
well.
> Thanks
> =====================
> I have a transactional replication set up from one system to another.
> Subscriber has only read mode on data (Uni-directional Replication). I
need
> to do lots of transformation in the data while replication from Publisher
to
> Subcriber Like adding the same record in the other table as well or do
some
> denormalization etc.
> Which route should I choose?
> 1. Modify Replicaiton procedures to have this business rule in-built.
> 2. Should I create indexed views and other tables on reporting server.
> 3. Should I create trigger on the reporting server and have the
replication
> procedure only do the insert and trigger do rest of the business rules
> implementaion.
> 4. Can reporting services be used for such a transformation.
> 5. Should I have DTS as a part of replication.
> -Nitin