Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [management]

The tag has no usage guidance.

0
votes
0answers
34 views

After switchover OIM app to standby, getting ORA-01033: ORACLE initialization or shutdown in progress

I have the exact same issue as described here JDBC Connection on Current Primary Database After Switchover: ORA-01033 encountered We have OIM 11gr2PS3 app and 2 node rac DB cluster. When I switchover ...
9
votes
1answer
3k views

If no plans to uninstall, can Log and Update Cache folders in Setup Bootstrap folder be removed?

I have several versions of SQL Server, used for testing, installed on my laptop (2012, 2014, 2016, and 2017). I noticed the other day that there was a folder containing prior versions of files across ...
0
votes
1answer
67 views

Invoke-PolicyEvaluation fails with xml files on network location

I am just starting to explore using Policy Based Management in SQL 2016. I created a policy that runs in SSMS just fine. I exported the policy to a folder on the local machine (VMSk1) that is shared ...
1
vote
1answer
29 views

How can I get the host_name who creates a DB (proactive mode) in SQL Server 2008?

First, I want to clarify that I am not looking for a SELECT HOST_NAME(). I am managing a database environment and have given the developers permission to create the databases they need in the ...
4
votes
3answers
365 views

Checking Job Statuses As A Daily Task

I've been thinking about this a lot recently: Is there a consensus as to how to check SQL Server Agent jobs have run correctly? Some advice seems to be alerting the operator on failure and addressing ...
0
votes
2answers
97 views

Managing tables in database

I am new to web development field and particularly very poor at database management. I am developing a web application which resembles Project Management System where new companies can add their ...
1
vote
1answer
46 views

Best practises for DB management

What are the prevalent best practices for managing database of an application? One option is to have an sql script to create the empty tables, and also to start with hardcoded options. (Say all ...
10
votes
1answer
9k views

How to change name for administrator login on azure sql server

I have myserver.database.windows.net with administrator login John. I'd like to change it to Peter. It is possible, if so, how ? Alter which works with local sql server, doesn't work here ALTER ...
3
votes
1answer
2k views

want to find out which databases are used in last 30 days or not

I have about 120 databases in my SQL. I want to migrate so I want to know which databases are not used in last 30 days.
0
votes
0answers
22 views

Usermanagement and a database pr user

Is there any easy way to manage users? Let's say, I need another user called user2. This user needs a database called user2 aswell - With only privileges to THIS database. It's easy to do, just by ...
1
vote
1answer
993 views

How to predict the growth of a PostgreSQL database

I'm looking for a way to predict growth of the database given its fields, indexes, constraints (as foreign key), number of lines, and so. I searched on Google, but I found only means to determine the ...
0
votes
1answer
114 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
587 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
73 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
258 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
172 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 ...
2
votes
2answers
3k 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 ...
9
votes
2answers
4k 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. ...
0
votes
1answer
104 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 ...
92
votes
15answers
63k 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 ...
19
votes
6answers
19k views

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

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
89 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 ...
3
votes
1answer
1k 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 ...
37
votes
10answers
8k 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 ...