The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
29 views

What table should I host data linking two objects from separate tables?

I've tried searching around, but I'm not too sure how to correctly formulate this question, and found nothing. Could be a duplicate. What is the best way (most efficient way) to host data that will ...
1
vote
1answer
63 views

Maintaining mongodb for a huge list of message “documents”?

Intro: I am working on an app right now for live messaging and it's almost complete. The database strategy is in order. So when a new message is created it is sent as an object fitting my mongoDB ...
2
votes
1answer
62 views

Can SQL Server WebAdmin degrade the performance of my site?

Once upon a time a had to use the Parallels WebAdmin interface. After contacting the support team that hosts my website and informing them that I must use the Webadmin, they informed me that: MS ...
1
vote
3answers
197 views

An admin (GUI or shell tool) for managing all kinds of databases [closed]

I needed an interface/admin (web or desktop) from which I could manage all the databases in my system. Currently I use separate admins for each (phpmyadmin for mysql, pgadmin/phppgadmin for postgres, ...
0
votes
1answer
102 views

Is it possible to drop data from OLAP database (and to keep definitions)?

[SQL Server Analysis Services from MS SQL Server 2008 R2 Standard] Our OLAP DB takes data from OLTP DB. We want to make some changes to its structure and to do this - it would be helpful if we could ...
3
votes
0answers
109 views

Tools for maintaining many dev/test environments on the cloud

The company I'm currently working with is "moving to the cloud" (isn't everyone these days?) In this case, they are moving to AWS, and they want a simple and effective way of managing multiple (SQL) ...
1
vote
1answer
1k views

Rule of thumb: AUTOALLOCATE or UNIFORM size for tablespaces

Is there a rule of thumb for creating a tablespace with extent management AUTOALLOCATE or UNIFORM? If the latter applies, how to estimate a reasonable extent size? Even more, what should apply for ...
7
votes
2answers
2k views

Is there any collection of PowerShell scripts that help the task of SQL Server maintenance?

I've been studying PowerShell and I've been (slowly) getting it into my day-to-day DBA tasks. So far I've seen a bunch of disconnected PowerShell scripts for many disparate administration activities. ...
2
votes
2answers
1k views

Good book on databases for beginners [duplicate]

Possible Duplicate: Must-read Books for DBA I'm already reading a book on Introduction to SQL (RDMS). But that only teaches SQL and commands and I feel like my knowledge lacks in database ...
1
vote
2answers
83 views

Model of database management systems

Having just installed MYSQL server and client on my laptop with Ubuntu, I was wondering, (1) do all database management systems use the server-client model, regardless of whether they are actually ...
66
votes
14answers
19k views

Why is Database Administration so hard?

I know a lot of Database Administrators and they are all over 28-29 years old. Is all database administration like that? I mean, is this about getting experience more than at least 7-8 years? Or is ...
14
votes
6answers
5k views

Are there any good and free tools for managing a PostgreSQL database?

Before, I have used phpmyadmin to manage an MySQL database, but now I would like to manage a PostgreSQL database. The PostgreSQL database is on a server, but not a webserver, so I don't use PHP. Are ...
2
votes
2answers
72 views

Research Database: Access and Ownership Policies

I'm a PhD student in an academic research laboratory. One part of my project involves collecting samples and generating data. Another part involves establishing a research database to store the ...
2
votes
1answer
626 views

Are there any good database management applications for JDBC/Java databases?

I am working with an Apache Derby/JavaDB database via JDBC. Before have I been working with MySQL and used phpMyAdmin as a good Database Management tool. Is there any good desktop application for ...
31
votes
11answers
3k views

How can I track database dependencies?

As internal applications evolve over a number of years, you occasionally find there are a number of tables that people believe are no longer relevant and want to cull. What are the practical methods ...
0
votes
2answers
205 views

Is There a Guideline for the Number of DBAs an Organization Should Have? [closed]

Is there a good guideline for the number of DBAs an organization should have relative to the number of employees or users or size/type of DB (or some other qualifier)? (not sure how to tag this)