The discipline of Operational and Architectural Management of Database Systems.
2
votes
3answers
213 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
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 ...
-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 ...
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
0answers
587 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.
2
votes
2answers
569 views
Cannot login to Oracle11g with System username
I just installed Oracle 11g into my machine.
I was about to shut down a database instance, and Oracle asked me for username and password, I provided the credentials I used to login into the web ...
4
votes
1answer
464 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> ...
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 ...
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.
...
8
votes
2answers
1k views
Handling growing number of Tenants in Multi-tenant Database Architecture
Handling a modest number of customers (tenants) in a common server with separate databases for each tenant's instance of the application is relatively straightforward and is normally the correct way ...
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 ...
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 ...
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: ...
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 ...
1
vote
1answer
895 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
1answer
628 views
Solution to error NID-00135 in Oracle 10g, Solaris 10
We are trying to build a test version of a production database by restoring the production backup using RMAN and renaming the database to test.
We've successfully restored and opened the database ...
6
votes
4answers
4k views
Why using innodb_file_per_table?
There are many articles exaggerating (IMHO of course) the need for innodb_file_per_table. I understand that with innodb_file_per_table, there should be a better control over the individual tables; ...
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
..............................
...
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
254 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.
2
votes
1answer
236 views
How to recover SA account password without restoring it?
I forgot my SA password and resetting the password is out of the question because internal applications are using it and will will affect them. I also don't have an option to change the SA credentials ...
1
vote
1answer
189 views
How to get a unique highscore per user
I have the following tables: users, highscores
I would like to get the top ten best results in highscore. The scores should be unique, meaning one score per user. I tried using INNER JOIN and GROUP ...
-1
votes
1answer
340 views
Difference in between HAS MANY and BELONGS TO in Yii framework [closed]
I am new to the Yii Framework.
I discovered HAS MANY and BELONGS TO in the documentation, however I am confused about these features.
Can someone give some real life examples with a diagram that ...
0
votes
1answer
201 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 ...
8
votes
2answers
516 views
Recovering logical space from a tablespace
I have a tablespace called DATA, and it is setup with auto-extend as false. This tablespace has two datafiles and is set up so it takes up 350 GB of physical space.
A week ago I queried ...
5
votes
2answers
215 views
Running each SQL Server service under different Windows accounts
Besides the Database Engine, SQL Server has some additional Services, namely:
SQL Server Integration Services
SQL Server Analysis Services
SQL Server Reporting Services
SQL Server Agent
Should ...
7
votes
2answers
757 views
100 TeraBytes Capacity Database - Resources and Time Estimates
I am working on a 'back of the envelope' calculation for a 100TB reporting database setup. I am seeking out thoughts from the experts here. Proposed environment:
Storage Capacity ~ 100TB
Tables ~ ...
-1
votes
2answers
925 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 ...
8
votes
2answers
22k views
oracle - list users with access to certain tables
I'm sure this has been asked before but I can't seem to find the relevant details for the following.
Is there some sort of pre-built table that can do the following (I have used dba_tab_privs but it ...
10
votes
1answer
275 views
What does a SQL Server DBA need to know about Windows Server?
Analogous to my previous question What does a DBA have to know about SSAS?, which generated a really wonderful answer (thank you, @ConcernedOfTunbridgeWells!), I now ask a similiar question:
What ...
19
votes
2answers
3k views
What does a DBA have to know about SSAS?
I've seen a lot of material covering the business aspect of SSAS, but not really much about the important aspects of administration and management.
From the point of view of administering an instance ...
2
votes
1answer
102 views
MySQL switch between data directories for individual databases
I'm in the middle of designing a solution to an issue we're currently experiencing while writing to certain large MyISAM tables. The database in question basically stores information regarding two ...
1
vote
1answer
421 views
MySQL Cluster over WAN: Best Architecture Options?
My company is looking at a multi-data-centre solution for high-availability, fun, and profit.
We have businesses across the planet, with the need for MySQL database clustering solutions that can keep ...
1
vote
1answer
277 views
How to prevent high memory, CPU and time consumption by MySQL restore?
I have a local test machine with 2 GB RAM and a dual core processor.
I imported a dump on that using
mysql -uuser -psecret < script.sql
script.sql is a 700 MB file which contains a single ...
4
votes
2answers
289 views
SQL Server - DBO without Backup
Similar to my previous Question : Prevent Non Copy Only Backups, how do I create a user that can do everything to my database take backups at all. I've granted them every role except ...
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 ...
2
votes
1answer
455 views
Problem with Czech collation Czech_CI_AI in MS SQL Server 2008 R2
I have the following issue with accent insensitive search in Czech language. My database is set to Czech_CI_AI collation. For some diacritics system works correctly (ie. I), but for some does not (ie. ...
2
votes
2answers
916 views
efficient way to poll database?
I have a Linux CentOS server hosting an Oracle 11.2 database, which communicates with an application server, which communicates with a client (a Flex application). I'll try to describe the pseudo-code ...
2
votes
2answers
397 views
How to compare performances of two databases
There are two database servers and I want to compare their performances.
Both have Windows operating system and and Oracle (10.2.0.4 and 11.0.2) database.
Both are OLAP databases with 15-20 users ...
1
vote
2answers
202 views
Is it good practice to assign a system account for database owner?
I can see the owners of my databases usign this query
SELECT name ,
SUSER_SNAME(owner_sid)
FROM sys.databases
What are the things I should consider when choosing an account for database ...
6
votes
3answers
195 views
How do you protect against malicious PREPROCESSOR attacks in Oracle External Tables?
I'm a new DBA and I recently found out about the option of External Tables in Oracle using the PREPROCESSOR feature ( ...
15
votes
2answers
1k views
How to make a transition from SQL Server DBA to Oracle?
As an interest, if I would to transition from a SQL Server DBA to Oracle what will be the major learning or unlearning that I would have to do?
I would assume the concepts are the same and the ...
2
votes
1answer
873 views
How to upgrade MySQL to a New version..?
I have installed mysql using the package management system.I am using ubuntu machine.
After that i have very well configured the server for InnoDB and other server related parameters.
I am using the ...
6
votes
1answer
147 views
On-the-fly query/command modification
I'm responsible for administrating an instance of SQL Server 200x which has the misfortune of serving as a backend to a turnkey application written with a disgusting performance problem. It repeatedly ...
