Database administrator

learn more… | top users | synonyms

11
votes
1answer
222 views

Metrics to prove or disprove the need for additional DBA's?

We currently have 2 DBA’s, me and one other guy and we both feel the need for an additional resource (or two). I have had the conversation with my direct manager on this topic a couple different ...
8
votes
5answers
2k views

Are there any professional fulltime PostgreSQL DBA's?

For my job I work on a JavaEE application with PostgreSQL as the database. Although we have a sysadmin for our productions servers, who also manages our database servers, we have no full-time DBA ...
4
votes
2answers
183 views

BI and DBA dev , where to start [closed]

I've read a lot about business intelligence development and database development, too. I have tried to work my way around a couple of courses on SQL Server 2008 however I feel kind of lost and I have ...
4
votes
1answer
644 views

SQL Server Restore from one database to another

One of our devs backed up a dev database, and then restored it in production. It's a new database for a new app that was deployed last night intentionally to prod. Now in the backupset table ...
4
votes
1answer
293 views

The future of DBAs with ORM [closed]

I am an aspiring DBA (I'd say in ~3 years I would be ready to apply for a job) and I currently am a programmer. I relayed my future goals to a friend of mine who is part of an Agile SCRUM team in a ...
4
votes
1answer
238 views

Managing Access for DBA and IT Support

We are currently in the process of moving our development, test and live databases on to separate servers and instances and I am looking at how best to manage access for DBA tasks and also IT Support ...
3
votes
2answers
271 views

Who is using a SQL Server database user credential?

I have a database user -- let's say "x" -- and I want to know how many Windows (desktop) users are using this database user (who2 or who is only give the current result, I want to know the entire ...
2
votes
3answers
196 views

Transaction log back up

Another accidental DBA question. We have a DB instance that host 10 databases. This DB server doesn't have any maintenance plan set up. I want to set up a decent maintenance plan that will do a full ...
2
votes
2answers
144 views

What is the recommended method to move databases?

I want to know the recommended method to move a database and data from dev to pre-prod to production in SQL Server. The databases are originally created in MS Access so some upsizing to SQL Server ...
2
votes
2answers
12k views

Reclaiming data file free space after deleting a large amount of data

I am an accidental DBA. We have a sql cluster that hosts 10 databases. Suddenly the size of one of the database increased drastically from 100GB to 250GB. When we checked the datafile, the size had ...
2
votes
1answer
4k views

Migrate / Copy Huge data from Oracle to SQL Server

I have huge tables in oracle database, appx 1 crore+ (10 million+) rows and want to migrate / copy those table and data in sql server. Currently I am using Import functionality of SQL Server for this ...
2
votes
2answers
865 views

Multiple Instance with different service packs in SQL Server

I would like to install a Default instance with SQL Server 2008 R2 RTM and I want to install another named instance with SQL Server 2008 R2 SP2. Is this possible?
2
votes
2answers
4k views

Free up disk space on sql server

Assuming I have a sql database server with disk space as follows: D Drive: 10GB (For the MDF file) E Drive: 10GB (For the LDF file) And I have only one database on the server with the following ...
2
votes
1answer
79 views

Running scheduled SSIS pkg with SQL Server 2012 Web Edition

I have a client with SQL Server 2012 Web Edition. I believe it has SQL Server Agent, but I see on the following Microsoft page that many integration services are not supported: ...
2
votes
2answers
63 views

Can SQL Server Transactional Replication do this?

We have a production server and a reporting server, with transactional replication in place to move all inserts/updates/deletes from production to reporting. We're using SQL Server 2008 R2. We have ...
2
votes
0answers
72 views

Is there a recommended for the database-to-DBA ratio? [closed]

We are now in a process of justifying the hiring of more staff for our DBA team. We have about 246 database instances. Not all of them are Oracle instances, some of them are PostgreSQL databases in ...
2
votes
1answer
60 views

Ways to Reduce Database Size and possibly improve performace. Untouched enviroment.

I am new to an environment. The Databases are virtually untouched by a seasoned DBA. I am looking for ways to reduce DB size and possibly improve performance. Unfortunately, I only have WEb edition ...
2
votes
0answers
101 views

SQL Server Online Training [closed]

I recently took an intro class for MySQL from www.oreillyschool.com and it was very helpful. The next class they offer is administering MySQL but I currently work with SQL Server. The first class was ...
1
vote
2answers
72 views

Restore a newer filegroup backup

So this is my set up. In our data warehouse we have mostly tables that are filled with data from a ETL-process. We do not take backup of these tables since we have an option to do a full reset using ...
1
vote
2answers
27k views

How to Create users in sql server for accessing only one database using Management Studio [closed]

How to Create users in sql server 2008 R2 for accessing only one database using Management Studio. regards, salman
1
vote
2answers
246 views

Why do we have negative length for character maximum length for geography and varchar(max) data types?

Why do we have negative length for character maximum length for geography and varchar(max) data types? Character_Maximum_length = - 1
1
vote
1answer
52 views

Sql Server Maintenance Plan - Simple Recovery Mode - Adding Shrink Log

I inherited lot of old servers and Databases from other department and now I will be the one who needs to take back ups / do Maintenance stuff with it. I see a lot of databases in simple mode (I ...
1
vote
2answers
88 views

What are the necessary course requirements to become a DBA? [closed]

Before some of you say it is related to other posts, let me tell you that I am more interested about schooling and getting my Master's degree not necessary learn SQL and such. I just graduated with a ...
1
vote
1answer
410 views

Copy Database from Production to Development

I need to copy database from production to development instance in SQL Server 2012 as I don't want to mess up the production server database. Can someone suggest how I can do this ?
1
vote
1answer
1k views

Oracle delete technique for table's segment size (data compactness)

I would like to ask if there is any effect on the following deletion technique of a database to the tablespace size. The existing code for clearing the data has the following style of code before: ...
1
vote
1answer
51 views

MySQL creating a concat_WS delimiter function, one part not working

I have a function that looks like this: CREATE FUNCTION CONCAT_UNTIL( x LONGTEXT, delim CHAR(1), repeatEvery SMALLINT) RETURNS LONGTEXT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA BEGIN DECLARE ...
1
vote
1answer
168 views

Dealing with Difficult DBAs [closed]

At one point, test database deployments within my department were handled directly by the database developers. The typical process was that the developer would unit test their changes in the ...
1
vote
1answer
145 views

Delete back ups more than 2 weeks in sql server

I am not a DBA, I need to delete the USER_DATABASE backups older than 2 weeks. Is this below stmt work for this scenario? EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASE', @Directory = ...
1
vote
1answer
108 views

Maintenance plans

I am an accidental dba..I did post a message a while ago about Index fragmentation and some of you suggested maintenance plan and others suggested custom Olla's scripts. I have downloaded his scripts ...
1
vote
1answer
177 views

Junior DBA hopes for advice [closed]

This is the 7th month of my DBA career, and I just graduated as a master, no experience before. My daily work for now is pretty much about backup/restoring databases in different environments ...
1
vote
1answer
32 views

How to reset slave without over write of master dump in mysql

My master having position is File Position mysql-bin.000046 430674598 I lost my data dir of mysql on master after that I have backup of slave which restored in master.Now Both ...
1
vote
2answers
58 views

To what extent can we monitor jobs/suspended queries as DBO

Short Background: I work for company A, at company A we have a DBA that should not be. When we are tasked with items for troubleshooting which require quick turn around, it generally takes quite a ...
1
vote
1answer
118 views

Incorrect unit allocation size. error comes when Tuning the Database

Here I am Using the SQL IDERA tool for checking the Index and performance of the Database, then i found below error, can any one tell what is it talking about. Incorrect unit allocation size. ...
1
vote
1answer
6k views

How to grant permissions for User defined type in Oracle

This is probably easy but i can't seem to figure it out. I created my user-defined type as CO_ADMIN. However, the application using the type runs using GS_USER database account. I have granted ...
1
vote
1answer
253 views

I need advice on these queries

could you help me optimize these queries? here are queries, please note that you see something like OR 1=1 OR those are values I pass via php and may change. query#1: SELECT posts.status, ...
1
vote
1answer
1k views

InnoDB, What would cause: “db1/tableABC contains 6 indexes inside InnoDB, which is different from the number of indexes 5 defined in MySQL”

MySQL 5.5.24 . We have InnoDB tables that grew almost by double (from 50GB to 100GB - file-per-table enabled) in a few weeks due to a project we are working on. The tables were freshly dumped and ...
1
vote
0answers
47 views

A call to a package procedure fails after upgrade to PSU24

We have just upgraded an Oracle Database 11.1.0.7 from PSU6 to PSU24. We have set a AFTER SERVER ERROR trigger to track application errors a while ago and checked its history table. Summary We see ...
1
vote
0answers
33 views

Identify a blocking process in MongoDB

I have a single MongoDB instance is performing quite badly. I noticed that db.currentOP().inprog.length quite often becomes quite big, sometimes even goes up to 100. When I drill down to the actual ...
1
vote
0answers
1k views

Oracle DBA Daily/Weekly/Monthly or Quarterly Routine Checklist/Tasks [closed]

Recently I'v achieved Oracle Database 11g Administrator Certified Associate (OCA) after passing two exams (1Z0-051 & 1Z0-052), then I got a Job as an Oracle DBA in startup company. So, I would ...
1
vote
2answers
92 views

SQL Server : CRUD Editor that will track data changes [closed]

I'm looking for a tool that allows CRUD changes to SQL Server data. Our company currently utilizes a product from Pro Data called DBU (database utility) to make IBM DB2 / AS400 changes. This tool ...
1
vote
0answers
93 views

How many Maximum Number of database can be created in single instance of PostgreSQL? [closed]

How many Maximum Number of database can be created in single instance of PostgreSQL 9.x?
1
vote
1answer
540 views

How to become a sql dba [closed]

I'm working as a software consultant with about 3+ years of experience in Microsoft .NET with SQL Server 2008 and 2012. I'm having interest in SQL Server and possess basic knowledge of SQL that i can ...
1
vote
1answer
179 views

Difference between sql agent account logged in as NTLM and UPN?

Can someone please tell the difference between a sql agent account logged in as NTLM and UPN? What is the difference if the sql agent account is logged in as: domain\username and username@domain.com? ...
1
vote
1answer
395 views

cons of linked server providers not running in “allow in process” [closed]

what are the cons of having linked server providers not running in "allow in process"? SQL box crashed due to oracle provider crashing and it provider was running in "Allow in process", now have been ...
1
vote
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 ...
0
votes
3answers
532 views

index rebuild/reorganize frequency

I am a dba by accident. I am doing index rebuild/reorganize. I would love to use some scripts once I become comfortable doing these tasks. I did go through some of the forum pages regarding this ...
0
votes
2answers
39 views

is it a good practice to ip block dev/test app servers from production database server? [closed]

I would like to do this as somewhat of a last line of defense as we will be replicating production to test regularly. Is this good practice?
0
votes
3answers
199 views

How to manage constants within an Oracle Database

This question touches on a few different parts of Oracle that I'm not particularly familiar with so bear with me: I am trying to redesign some of the procedures and functions within the database I ...
0
votes
2answers
29 views

conditional/processing on the dummy data column to create new dummy column

Following is my query. Select [A],[C] ,CASE WHEN [A]>19999 and [A]<30000 THEN '12' ELSE '21' END AS 'dummy1' ,Substring(CAST(C AS varchar(9)),1,4) as YEARDummy ,Substring(CAST(C ...
0
votes
1answer
41 views

Can PostgreSQL results include the query?

I run the following command to run 2 queries in a sql file. Could be 1, could be 50 queries. Depends on the deployment. psql -U <username> -h <servername> -d <databasename> -f ...