Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [management]

31 questions
92
votes
15 answers

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 being a database administrator so hard?
Soner Gönül
  • 1,045
  • 2
  • 12
  • 21
37
votes
10 answers

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 for identifying database dependencies, both within…
Rowland Shaw
  • 557
  • 4
  • 12
21
votes
6 answers

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 there any good and free tools for managing a…
Jonas
  • 33,945
  • 27
  • 62
  • 64
17
votes
1 answer

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 LOGIN John WITH NAME=Peter
Hoppus Hoppard
  • 273
  • 1
  • 2
  • 5
13
votes
2 answers

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 updates (SPs, CUs). Across all versions there is…
Solomon Rutzky
  • 70,048
  • 8
  • 160
  • 306
9
votes
2 answers

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. What I'd like to know is if there is an official…
ivanmp
  • 2,323
  • 3
  • 24
  • 36
4
votes
3 answers

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 those, but this won't account for jobs that…
Nullh
  • 73
  • 7
3
votes
1 answer

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.
Mike
  • 31
  • 1
  • 2
3
votes
1 answer

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 managing databases over JDBC?
Jonas
  • 33,945
  • 27
  • 62
  • 64
2
votes
1 answer

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 locations, or profession types). During upgrade, you…
0fnt
  • 123
  • 4
2
votes
1 answer

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 SQL WebAdmin can degrade the performance of your…
OrElse
  • 121
  • 1
2
votes
1 answer

Why when I use variables on SQL the Database Engine avoid the indexes?

I'm improving our SSIS process passing the variables through a declare and I found this: Here you have the plan execution using variables brentozar.com/pastetheplan/?id=rkSxs7VPv for the following statement: select * from fact_Venta where Data_ID >=…
Nacho González Valero
  • 23
  • 2
2
votes
2 answers

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 default tablespaces like SYSTEM, SYSAUX, UNDO, and…
Michael-O
  • 510
  • 3
  • 10
  • 22
2
votes
2 answers

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 results. As the project has grown, a Masters student…
SabreWolfy
  • 949
  • 1
  • 7
  • 16
1
vote
1 answer

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 actual space occupied by the database, and can…
Plicatibu
  • 163
  • 1
  • 8
1
2 3