The discipline of Operational and Architectural Management of Database Systems.
2
votes
2answers
1k views
Difference between Row based and statement based replication in Mysql?
What is the Actual difference between Row based and Statement based replication I actually looking in terms of replication effect's on slave.
If I am using Row based replication then whats is the ...
2
votes
1answer
2k views
Is it possible to do a datapump import with a different user than did the export?
I have one db dump below is the log file for that dump
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** ...
2
votes
0answers
149 views
SQL Server SSIS issue retrieve data when i enter into login of server side?
can any one try solve my problem here i am facing a problem Failed to retrieve data when i enter into login of server side
here is the error message
TITLE: Microsoft SQL Server Management Studio
...
2
votes
2answers
240 views
Help with Vehicle Service database
I am using the Desktop Vehicle Maintenance template in access, but i am trying to cater it towards our farms needs.
We will be keeping track of the service's done on Trucks, Tractors, Equipment, etc.
...
1
vote
2answers
743 views
Unable to mount oracle instance
I am trying to shutdown the system, then I want to mount it. I have tried this:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
...
2
votes
1answer
85 views
database connection time expired issue
I have a server machine and four client machine for database connectivity.
I installed sqlexpress 2008 in server and one machine and all remaining systems, they have connected the database through ...
6
votes
3answers
163 views
Can I check the services currently running through SSMS?
I want to check which services has started and which has not by running a script/query on SSMS.
9
votes
1answer
349 views
Are there reasons why I should not set my db owner to [sa]?
Yesterday I asked this question regarding changing the dbo of multiple databases that I have. The change makes sense, but I want to be clear.
Is there any, good reason or circumstance why I should ...
3
votes
2answers
1k views
pt-table-checksum help required
I am trying to figure out pt-table-checksum, as I am using it for the first time.
It look likes the documentation is complex and not easy to understand stuff.
I have a complex replication topology ...
2
votes
1answer
177 views
Active Directory domain being shutdown— Do I have to update my DBO accounts?
I manage a SQL Server machine (with SQL Server 2000 and 2005 installed) that was first created on an Active Directory domain that we are transitioning away from and are about to shut down. All of my ...
2
votes
1answer
732 views
MySQL : “FLUSH TABLES WITH READ LOCK” started automatically
I would like to understand how this happened. I was running a query that would take a long time, but should not lock up any table. However, my dbs were practically down - it seems like it was being ...
11
votes
3answers
2k views
SQL Server 2008 R2 “Ghost Memory”?
We have a dedicated SQL Server 2008 R2 machine that is experiencing some strange memory issues.. The machine itself has plenty of resources including two quad-core processors, 16gb of RAM and 64bit ...
4
votes
1answer
1k views
Capabilities of InnoDB INSERT Performance
Hi I am running the most recent version of Percona Server.
Server version: 5.5.24-55 Percona Server (GPL), Release 26.0
I have a 10 cpu box of these characteristics.
processor : 0
vendor_id ...
3
votes
1answer
61 views
Administration of MySQL Users
What is the best practice for keeping and maintaining MySQL users? Say for example I have 5 programmers and a PHP application connecting to a database. Should I create 6 different users 1 for each ...
2
votes
2answers
96 views
which option is better for not slow down the performance of queries?
I am developing a system that records customer payments, when a customer makes a payment, the system must update the account and show the payment made and all previous payments, is here when the ...
-1
votes
1answer
188 views
What exactly is SOLR? [closed]
It seems like a magical technology that can
Do spatial search
do full text search
The problem is,
It doesn't say where does it store all the data. Does it have it's own proprietary database
If it ...
0
votes
2answers
241 views
DBA to work from home [closed]
I was wondering is it feasible or doable to work from home as a DBA or Database designer/developer or Business intelligence developer.
I have seen developers doing great working from home, but can ...
2
votes
0answers
219 views
SQL Developer Data Modeller and Data Dictionary question
I'm not a DBA but I am a (mostly!) competent SQL report writer. Can I trouble you DBAs for some pro-knowledge, please?
I can connect SQL Developer to Oracle XE's data dictionary without any problem, ...
0
votes
1answer
150 views
Do you feel like DBA/DBD Is a “secure Field” still? [closed]
I noticed recently alot of Database jobs/Development have kind been pushed onto general developers, not to mention with NoSQL Solutions (Which IMO are probably a little easier for Non-DBA's to throw ...
0
votes
1answer
157 views
What are commonly used database types? [closed]
There are a lot of database types. Can you list a list of the top classification of databases commonly found in schools and offices? Any help is appreciated. Hope to see compressed and summarized type ...
4
votes
1answer
463 views
Mongo Collection `Size` is *larger* than `storageSize`?
I recently compacted my collection using the command:
db.<collectionName>.runCommand( "compact" )
And now my collection size seems to be bigger than size on disk!
SECONDARY> ...
5
votes
1answer
3k views
What exactly is binding in DB2?
I recently crossed over from being a Java developer to an actual DBA in our company. I am learning the ropes, so to speak, about being a DBA (which is actually somewhat of a new position for our ...
3
votes
2answers
265 views
What exactly is “pinning” in relation to indexes?
When one talks about "pinning" in indexes, what exactly is this? Is there some other word/term I can search for, as google has not provided any solutions.
It is part of a test question, where ...
0
votes
0answers
382 views
How much does a Junior Oracle DBA get paid? [closed]
I have a pretty good background in programming (SQL/PL-SQL/DB Design/Modeling) and in computers in general... no actual DBA experience (yet!) wondering roughly how much jr dbas get paid ?
It seems ...
0
votes
3answers
1k views
What is the purpose of having a table NOT LOGGED INITIALLY
I came across this recently. When defining a table in DB2 LUW (at least 9.5 or higher), you can define it as NOT LOGGED INITIALLY.
Example from the book I read:
CREATE TABLE products (
productID ...
3
votes
1answer
79 views
Inconsistent information from different DMVs
I've a server with 12 GB of physical RAM. I just lowered its 'Max Server Memory (MB)' setting from 10 GB to 8 GB.
If I look at the processes' committed memory in Perfmon, I see:
select *
from ...
1
vote
1answer
66 views
Clarification on Cloud Computing Database
This question can be very generic, but I am trying to understand the concept of Cloud Databases.
Let's say I have a Web Application, a Desktop Application, and Apps for my Web Application.
All of my ...
2
votes
1answer
287 views
PostgreSQL archive_command on Windows
What is the best method for WAL log transfer on Windows?
I have two servers with Windows Server 2008, PostgreSQL 9.0 64bit.
Servers do not have any shared SAN disk, they are on different hosts, ...
1
vote
1answer
57 views
Oracle DB administrator-specific security features
Yesterday I was presenting an internet banking solution to a potential client management. My offer is based on using MS SQL Server 2008 RDBMS.
One of the client's officers mentioned, that Oracle's ...
6
votes
3answers
1k views
Database Administrator vs Database Architect?
In terms of job responsibilities and activities, what is the difference between a Database Administrator (DBA) and a Database Architect?
2
votes
3answers
211 views
MySQL - Master/Slave Replication with different server specs
I have a Master/Slave replication (using MySql 5.1 / InnoDB).
Currently both my master & slave are running on the same type of server (32 GB RAM, 2 x Intel Xeon 5520 Quad Core 2.26 GHz (8 cores)) ...
0
votes
1answer
75 views
What are the challenges of administrating an International stock trading database?
I am a student, and have a question for an assignment:
What problems and challenges do database administrators face when designing systems to trade international stocks in real time and 24 hours a ...
-2
votes
1answer
201 views
Sharing MS Excel Sheet over network? [closed]
Is it possible to have a Server PC running a MS Excel Sheet to which several Thin Clients will be connected via TCP/IP having Barcode Scanners? The scanner's should dump their Data in the MS Excel ...
2
votes
0answers
585 views
823 errors on tempdb
Have a couple Fiber channel SAN-attached cluster servers which have been intermittently reporting errors like:
2012-05-09 16:31:54.13 spid74 Error: 823, Severity: 24, State: 2.
2012-05-09 ...
2
votes
2answers
1k views
Why can the SA account no longer access the master database?
I'm somewhat stuck. We have a database server which was set up and configured by a third party. It's for a third party product so unfortunately we're stuck with the way they've configured it.
Their ...
0
votes
1answer
151 views
RAID vs Replication [closed]
I'm kind confuse about it, can some one give me a hand with this...
Differences.
Which one is better.
Which one do you use and why?
Personal Opinion and advise.
0
votes
0answers
304 views
Grouping a comma separated value on common data [closed]
I have a table with col1 id int, col2 as varchar(comma seperated value) and column 3 for assigning group to them.
Table looks like
col1 col2 group
..............................
...
0
votes
1answer
198 views
Look for software that can convert sql (mysql) to erd
I would like to have an ER Diagarm in phpmyadmin, however, its graph is not up to my expectation, the graph has no relationship indicator (1-1) (1-m) etc at all.
So i am wondering whether there is a ...
0
votes
1answer
50 views
Copy snapshot files from Publisher, Paste and Apply on subscriber in SQL Merge Replication
I read an excellent article about copying the snapshot files for Transactional replication from Publisher to Subscriber and Apply them on subscriber.
...
2
votes
4answers
157 views
MySql Database solution for specific web app problem
Well, I need to create a comment system for posts that people add to my web app. This web app is just like facebook or myspace posts. Users add posts and people can comment on them. But the problem is ...
4
votes
1answer
127 views
Is there a standard approach to rolling out database schema changes?
A developer said I should simply wrap all my database upgrade scripts in a transaction. If it fails, just roll back all changes. All my instincts tell me this is wrong, especially when it comes to ...
6
votes
2answers
140 views
Automation of backups of Large Number of Database
In a multi-tenant web application where a database is set up for each tenant, the database can be backed up and restored manually through a fairly conventional approach.
I am considering this type of ...
2
votes
2answers
62 views
Data Backup and Restoring the same if requried in SQL SERVER 2008
In Multi-tenancy , Shared Database Shared Schema.
How to take Tenant level backup and restored the tenant data when required? Can any one guide me or point me to the right direction.
Thanks!!!
NB: ...
1
vote
1answer
888 views
How can I move LOB_DATA ( varbinary/image/text) to different Filegroups
LOB_DATA : varbinary(max),varchar(max), image , text columns.
I have 4 tables with large amount of LOB_DATA in it. I would like to move LOB_DATA in these tables to different File group in a different ...
1
vote
2answers
1k views
How to deny drop permission for a table?
Is there a way to deny drop permissions for a specific table from a user or role?
0
votes
0answers
71 views
Database Design Concern [closed]
Need to design a multi-tenant web application, using single application multiple database setup.
![Image][1]
https://plus.google.com/photos/104702944930754413137/albums/5725683632435430785
2
votes
1answer
169 views
User Rights - Database Security
I am having following scenarios and i am having some issues and some questions.
We have a DB Server on which we have some databases in these 2(two databases) are for my users.
Now i have created 2 ...
2
votes
2answers
7k views
How to create Sql Server login for a domain account?
All,
I have Sql Server 2008 installed on a server (let's say Server1) in a Domain (let's say AD). I also have a domain account called AD\Sql1. This is not an Admin account on the Domain (AD), but I ...
1
vote
1answer
253 views
Difference in between MySQL affected num rows and num rows
I am just newbie to the MySQL.I want to know what is the main differences in between mysql num rows and mysql affected num rows?Any example or references will be highly appreciable.
-1
votes
2answers
920 views
Data Base Administration Oracle vs MySql? [closed]
I have worked with MSSQL for a while now, but now we want to try to move to some open source for a specific part of the company's products or explore Oracle if possible. What would you say are the ...
