How many Database Administrator need to support 100+ production databases ?

Sun Dec 05, 2010 5:50 pm

by jesi (Posted Sun Dec 05, 2010 5:50 pm)
Impressive this help me alot thanks for sharing such a great information

----------------
kitchen units

Read Main Topic

Forgot SA password

Wed Dec 30, 2009 9:12 pm

by happykaka (Posted Wed Dec 30, 2009 9:12 pm)
You can reset the SQL log in password in two ways. If you are skilled SQL command, you can reset sa password with some simple codes like [osql -U sa -P ”" -Q ”sp_password NULL,,sa”] . If you have no ideal about SQL command, I would like to recommend you to free download MS SQL Server Password Unlocker, which helps to instantly change SQL password without data loss.

Personally, I would like to use SQL password changing tool, like MS SQL Server Password Unlocker. I have no ideal about the sql commands and other setting but I forgot sql password. My friend recommended me MS SQL Server Password Unlocker, and I used it. Just one click, I reset the SA password

Read Main Topic

Feedback

Sun Apr 26, 2009 3:29 am

by wadeln (Posted Sun Apr 26, 2009 3:29 am)
This is one cool Site and only to grow with members. I bookmarking this baby. Nice work guys!
WirelessUnlimitedShop

Read Main Topic

which one is better-> IBM db2 or oracle???

Mon Dec 15, 2008 5:07 am

by KACH (Posted Mon Dec 15, 2008 5:07 am)
IBM is the best

Read Main Topic

Can someone please recommend a specific brand name Enterprise DBMS??

Fri Dec 12, 2008 2:43 pm

by Em (Posted Fri Dec 12, 2008 2:43 pm)
MySQL -- free, scalable, easy to use, lots of support out there

SQL Server -- Microsoft's product, not all that great in terms of extensibility but highly programmable.

Read Main Topic

Query to find the count of sum() in db2 (preferably executable in ibm iseries navigator) ?

Thu Dec 11, 2008 7:31 am

by warsql (Posted Thu Dec 11, 2008 7:31 am)
select count(*)
from (select account_id,carrier_id,employer , sum(salary)
from
group by account_id,carrier_id,employer ) a

but I don't see what this will give you over and above

select count(distinct account_id,carrier_id,employer )
from

Read Main Topic

Does anyone have ne material for IBM DB2 731 exam apart from IBM material?

Wed Dec 10, 2008 12:19 am

by wunti (Posted Wed Dec 10, 2008 12:19 am)
hi...i am also planning to take up this exam.It would helpful if you could share the e-book by roger sanders. And also if you have any sample questions or practise questions please do post them.Thanks.

Read Main Topic

what is the process to be followed to get IBM DB2 certification.?

Sat Dec 06, 2008 2:43 am

by Networking (Posted Sat Dec 06, 2008 2:43 am)
000-701 ibm db2 udb v8.1 database admin for linux unix&windows
000-702 db2 udb v8.1 for z/os database administration
000-704 db2 udb v8.1 advanced db admin for linux,unix+windwos
000-706 db2 v8.1 for linux,unix and windows db admin upgrade
000-355 iseries system administration v5r2
000-442 ibm content manager version 8
000-513 db2 udb v7.1 database administration for unix windows % os/2
000-516 db2 udb database administration for os/390
000-700 ibm db2 udb v8.1 family fundametals
000-730 DB2 9 Fundamentals
000-731 DB2 9 DBA for Linux,UNIX and Windows
000-703 db2 udb v8.1 familu application development
000-732 DB2 9 for z/OS Database Administrator
000-355 iseries system administration v5r2
000-442 ibm content manager version 8
000-513 db2 udb v7.1 database administration for unix windows % os/2
000-516 db2 udb database administration for os/390
000-700 ibm db2 udb v8.1 family fundametals
000-701 ibm db2 udb v8.1 database admin for linux unix&windows
000-702 db2 udb v8.1 for z/os database administration
000-704 db2 udb v8.1 advanced db admin for linux,unix+windwos
000-706 db2 v8.1 for linux,unix and windows db admin upgrade
000-730 DB2 9 Fundamentals
000-731 DB2 9 DBA for Linux,UNIX and Windows
000-703 db2 udb v8.1 familu application development
000-732 DB2 9 for z/OS Database Administrator

Read Main Topic

how to install db2 on vista?

Wed Dec 03, 2008 12:19 pm

by jeo8324 (Posted Wed Dec 03, 2008 12:19 pm)
you don't....

Read Main Topic

Please Help! Difference between Database, Schema & Instance?

Sat Dec 13, 2008 9:52 pm

by RichardK (Posted Sat Dec 13, 2008 9:52 pm)
for simplicity, Instance is the name of the Database. Schema is the owner of your objects(tables, indexes, views, synonyms,etc).

In you example, you have a Database Instance named CONTRACT.

In your Contract database, you have 2 Schemas named LEGAL & RI.

Now, this is where I also get confused. Because, you said "LEGAL has got 2 instances, ie QADB15 & QACNTR2". Meaning they are inside the LEGAL schema...

If they are inside the LEGAL schema, QADB15 & QACNTR2 are OBJECTS and not instances inside the LEGAL schema. Most probably, they are tables...

Hope that clear things abit

Read Main Topic

Help with executing queries on Oracle 9i sql plus?

Thu Dec 11, 2008 7:28 am

by TarA (Posted Thu Dec 11, 2008 7:28 am)
the username is
scott
and password is tiger
for oracle 9i

Read Main Topic

how to design a database?

Mon Dec 08, 2008 5:04 pm

by JeffreyB (Posted Mon Dec 08, 2008 5:04 pm)
since the question states the database must be written by students, your best answer would be to do a search for oracle tutorials

heres one to start you off http://infolab.stanford.edu/~ullman/fcdb/oracle.html

Read Main Topic

how to design a database using Oracle DBMS?

Sun Dec 07, 2008 9:52 am

by nick2price2003 (Posted Sun Dec 07, 2008 9:52 am)
Dear Rachel,

I suppose it is also a matter of getting the order of things right ;-)

1(Design): What do you want to show(data model)? You obviously have freedom here in the assignment. You should at this stage put some thought into the queries at the end (by the complex view).

2: CREATE TABLE (1..4) (defining the columns you thought of)
3: INSERT data by means of a tool or INSERT INTO (manually)
(have a look at your example so far, are you happy?)

4: CREATE VIEW AS (SELECT...
Show them how to join in most tables in the WHERE clause in the most interesting way.
(maybe ask a friend, this is the hard part...)
5: Make interesting example SELECTs on the complex view.
(normal SELECTs, like on an ordinary table)

All the best !

Read Main Topic

create database in oracle ?

Thu Dec 04, 2008 7:28 pm

by bostonianinmo (Posted Thu Dec 04, 2008 7:28 pm)
http://www.oracle.com/technology/products/database/application_express/index.html

Read Main Topic

question realted to oracle?

Wed Dec 03, 2008 12:16 pm

by thunder2sys (Posted Wed Dec 03, 2008 12:16 pm)
Hey there are many on internet

try this
http://www.tutorialized.com/tutorial/Oracle-DBA-FAQ---Introduction-to-Oracle-Database-10g-Express-Edition/12800

or just type your query on google will get many links

Hope this helps
Cheers:)

Read Main Topic

Does my pc have SQL server installed?

Mon Dec 15, 2008 5:00 am

by TonyB (Posted Mon Dec 15, 2008 5:00 am)
SQL Server is a database management system. It is not required for day to day computing. It can be used if you want to do some database related programming. You can check which programs you have installed on your computer by looking into Control Panel.

Start-->Control Panel-->Add/Remove Programs

You can read more about SQL Server here:
http://en.wikipedia.org/wiki/Microsoft_SQL_Server

Read Main Topic

ASP.net + SQL Server 08 + IIS 7 = need a free message board that all users can write on?

Fri Dec 12, 2008 2:36 pm

by Bharat (Posted Fri Dec 12, 2008 2:36 pm)
What's your base system? If you have users, are they anon or registered? You may want to look at a CMS like dotnetnuke. This gives you a portal and many modules to add on to it. There are plenty of msg boards for it.

Read Main Topic

How do I get SQL Server 2005 GUI?

Mon Dec 08, 2008 5:00 pm

by dbadmin (Posted Mon Dec 08, 2008 5:00 pm)
It's called SQL Server Management Studio and is installed when you install SQL Server. The name of the exe is SqlWb.exe

Update:
I just noticed that your screenshot is for the SQL Express version so the exe name may be different.

Read Main Topic

how to connect sql database to visual basic 2005 express edition?

Sun Dec 07, 2008 9:48 am

by jeo (Posted Sun Dec 07, 2008 9:48 am)
If the database is stored locally in your computer, you can just add that to your project and a wizard automatically shows up which will guide you into setting up the database. If not, you will need to use a connection string to connect to the database.

Read Main Topic

MSDE using 2 CPU's - how?

Sat Dec 06, 2008 2:36 am

by Networking (Posted Sat Dec 06, 2008 2:36 am)
is one of the limitations the use of only 1 CPU? in Unix, programmes are charged per processor (or processor cores).

Read Main Topic

What language is appropriate for my interactive webpage?

Mon Oct 27, 2008 8:35 am

by ReasonableGuy (Posted Mon Oct 27, 2008 8:35 am)
You can consider using Microsoft asp.net. you can do a lot with relatively very little code. Besides these are plenty of forums and sites where you can find plenty of examples and ideas.

Here are a dew sites where you can find a lot of sample code

http://www.4guysfromrolla.com/
http://www.codeproject.com/
http://www.asp.net/
http://msdn.microsoft.com/en-us/asp.net/default.aspx

Read Main Topic

What language is appropriate for my interactive webpage?

Mon Oct 27, 2008 8:35 am

Whis is the Best Language For Web-based DataBases and Why?

Wed Oct 08, 2008 3:47 am

by chituk (Posted Wed Oct 08, 2008 3:47 am)
PHP is great with MySQL.
It is the best language, it is fast easy and flexible.

Leadhoster supports PHP and gives you a free MySQL database. http://leadhoster.com/

Read Main Topic

Whis is the Best Language For Web-based DataBases and Why?

Wed Oct 08, 2008 3:47 am

Help with creating a Makefile?

Wed Oct 01, 2008 6:11 pm

by Guru (Posted Wed Oct 01, 2008 6:11 pm)
These seem useful and comprehensive:

http://www.opussoftware.com/tutorial/TutMakefile.htm
http://makepp.sourceforge.net/1.19/makepp_tutorial.html

Apart from that, I have no experience with creating Makefiles, and I hope these sites are useful to your cause!

Read Main Topic

Help with creating a Makefile?

Wed Oct 01, 2008 6:11 pm

'Cannot connect to the database because: ' . mysql_error()); (HELP)?

Thu Sep 18, 2008 10:59 pm

by SOMASUNDARAMS (Posted Thu Sep 18, 2008 10:59 pm)
The only thing I can see is that your connection misses its PASSWORD! (that you said you set to "fakepw"):
in Php only:
-> $link = mysql_connect("localhost", "elite08_jane", "fakepw") or die ("Error: ".mysql_error());
mysql_select_db("elite08_EliteGirl") or die("Could not select database: ".mysql_error());
The error you receive refers to an incorrect link in PERL: it is trying to access elite66! (and not elite_08).
DON'T put BOTH codes! Or you call using Php, OR you call using Perl, not BOTH!
Try Php as above only.
Just one more word: I hope the users/pwd you gave are REALLY fake. If not, destroy the DB, recreate a new one and put new users and password...

Read Main Topic

After takeover announcement can I buy some stock?

Sat Aug 30, 2008 10:14 am

by drivenbywhat (Posted Sat Aug 30, 2008 10:14 am)
Three things can happen:
1. the bid goes through
2. an increased bid is announced
3. The bid falls through.

If you think 1. Work out the cost of buying the stock and the time that will elapse before you get the bid cheque.

Read Main Topic

Website uploading, serious help?!?!?

Sun Oct 19, 2008 12:32 am

by trevathantim (Posted Sun Oct 19, 2008 12:32 am)
When you get a file list in filezilla it will allow you to set the permissions. You need to have at least read permissions set, and possibly exec permissions set for directories and cgi

index.html is suppose to be the default webpage. its a file containing html only, not a directory. just put the files in your root directory and you should be able to see them using something like http://www.mydomain.com/somepic.jpg etc as long as the permissions are right.

Read Main Topic

where is config.inc.php in phpMyAadmin 3?

Mon Oct 06, 2008 2:56 pm

by prncesbuttrkup (Posted Mon Oct 06, 2008 2:56 pm)
Have you installed a web server for this, or did you just install phpMyAdmin? Download XAMPP, it has Apache, MYSQL and PHP in a bundle. Easy to install, supports mulitple OSs, easy to use, and when the installation is over, you don't need to configure anything for the phpMyAdmin to work.

http://www.apachefriends.org/en/xampp.html

Btw, the config.inc.php is located at the root installation of your phpMyAdmin folder

Read Main Topic

sqlset.com

How many Database Administrator need to support 100+ production databases ?

Forgot SA password

Feedback

which one is better-> IBM db2 or oracle???

Can someone please recommend a specific brand name Enterprise DBMS??

Query to find the count of sum() in db2 (preferably executable in ibm iseries navigator) ?

Does anyone have ne material for IBM DB2 731 exam apart from IBM material?

what is the process to be followed to get IBM DB2 certification.?

how to install db2 on vista?

Please Help! Difference between Database, Schema & Instance?

Help with executing queries on Oracle 9i sql plus?

how to design a database?

how to design a database using Oracle DBMS?

create database in oracle ?

question realted to oracle?

Does my pc have SQL server installed?

ASP.net + SQL Server 08 + IIS 7 = need a free message board that all users can write on?

How do I get SQL Server 2005 GUI?

how to connect sql database to visual basic 2005 express edition?

MSDE using 2 CPU's - how?

What language is appropriate for my interactive webpage?

What language is appropriate for my interactive webpage?

Whis is the Best Language For Web-based DataBases and Why?

Whis is the Best Language For Web-based DataBases and Why?

Help with creating a Makefile?

Help with creating a Makefile?

'Cannot connect to the database because: ' . mysql_error()); (HELP)?

After takeover announcement can I buy some stock?

Website uploading, serious help?!?!?

where is config.inc.php in phpMyAadmin 3?