Questions tagged [management]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
20 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
1answer
29 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 ...
0
votes
1answer
37 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 ...
0
votes
0answers
30 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 ...
12
votes
2answers
7k 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
81 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
31 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
479 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
100 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 ...
2
votes
1answer
51 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 ...
12
votes
1answer
11k 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 LOGIN ...
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
1k 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
115 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
597 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
75 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
261 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
174 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
4k 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. ...
-1
votes
1answer
127 views

Model of database management systems [closed]

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
67k 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 ...
20
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
94 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 ...