Questions tagged [management]
The management tag has no summary.
32 questions
0
votes
1
answer
82
views
What is used to manage privileges for RDBMS databases?
For context I primarily work with PostgreSQL and Snowflake but my understanding is that privileges in RDBMS servers are far more alike than different, so most will apply to this question and I'm ...
- 3
0
votes
0
answers
82
views
Is there a web interface for managing users and tablespaces in oracle 19c
I just installed Oracle 19c on Red Hat and would like a graphical way of managing users and tablespaces. I enabled EM Express but the new interface (omx) does not allow to manage users, and the old (...
- 5,142
0
votes
3
answers
233
views
Store First and Lastname (Fullname) for Oracle Users?
Is it possible to store first-/last-/fullnames and possibly additional information of/for oracle user accounts in oracle?
I look at the table dba_users but it does not contain such information.
I need ...
- 4,847
0
votes
1
answer
1k
views
Stored Procedure with two options that execute different actions depending on their values
These were my instructions:
Create a stored procedure that receives two parameters:
@i_action
in which:
'I' = inserts a value
'U' = Updates values
'D' = Delete Values
'C' = Consult
and @_option
...
- 1
0
votes
1
answer
2k
views
Drop role postgresql
I just inherited an AWS RDS PostgreSQL 12.5 instance (so, no superuser access) and I'm required to do some cleanup and delete a bunch of groups/roles/users. I'm executing the following commands with ...
2
votes
1
answer
377
views
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 ...
1
vote
0
answers
32
views
SQL Server Management Data Warehouse creates a lot of sleeping user connections
I am wondering if someone already experience this weird scenario regarding my SQL Server Management Data Warehouse; it creates a lot of user connections. Around 2500 connections which were all ...
0
votes
1
answer
158
views
Erased my database [closed]
I've just recently bought a host with a domain and as I was following a tutorial on youtube for installing wordpress I accidentally erased my primary database. So now my site doesn't even have the ...
- 1
0
votes
1
answer
246
views
How best to store multi-dimensional timeseries data in a (R)DBMS environment? [closed]
Any suggestions on how multi-dimensional time-series data should be stored and organized in an RDBMS environment? For example, we have multiple experiments from multiple customers. This translates ...
- 143
0
votes
0
answers
136
views
Need an ERD of the schema mentioned
Need the erd of the schema for doctor, patient and appointment database. scenario is given as under:
Clinic Management Entity-Relationship Model
-Doctor has a unique id, name, address, qualification ...
user203653
13
votes
2
answers
14k
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 ...
- 70.4k
0
votes
1
answer
147
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 ...
- 433
1
vote
1
answer
64
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 ...
- 119
4
votes
3
answers
1k
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 ...
- 73
0
votes
2
answers
133
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 ...
