All Questions
0
votes
0answers
6 views
What are concepts need to Learn for MSSQL DBA?
I am MSSQL DBA. I have gone through basic concepts ,now i am decided to lead my career in MSSQL DBA. Please let me know what are the concepts i should learn for successful SQL DBA.
Please help me on ...
0
votes
1answer
10 views
MySQL possibility to create global routines (stored procedures and/or functions)
Is it possible to somehow define globally available routines? It seems like every routine must be created in a scope of the database.
When I tried to create a routine from console (without prior ...
0
votes
0answers
3 views
Multiple system.replset collections in local
I have a replicaset that's showing multiple system.replset collection in the local db.
replset1:PRIMARY> show collections;
me
oplog.rs
replset.minvalid
slaves
system.indexes
system.profile
...
1
vote
1answer
21 views
MySQL query optimization with aggregate ORDER BY
I have an analytics table that stores metrics aggregated the day level. I need to ask questions such as "For a given date range and client, what are the most popular items."
The schema is as follows:
...
0
votes
0answers
7 views
Connecting to remote oracle db
I am very new to system and db admin stuffs. Infact, I need to have my skills more improved in those areas. Anyways, I was trying to connect to a remote oracle database and use php oci8 library to ...
1
vote
1answer
19 views
Best practices for backing up a MySQL DB
I've recently discovered that our production web servers that run off MySQL are not being backed up regularly (or at all). I'm used to backing up SQL Server DB's but don't have a ton of experience ...
0
votes
0answers
18 views
How do I write this script
I have a very large database and I want to select certain records and then set a column value such as
Select name, email
from table
where zipcode = 12345 into outfile /tmp/file.csv;
Then I want ...
1
vote
1answer
19 views
Simple table normalisation
In raw form, I have data with 2 columns: skills in welsh and stats for that skill. For storing these information in a database, would it be best to combine the stats with the categories, or split ...
0
votes
1answer
13 views
How can I verify that MySQL's slave_compressed_protocol is working
I've set slave_compressed_protocol=1 on both my master and slave.
Using SHOW VARIABLES, I can see that it's set.
How can I check that it's actually working?
0
votes
0answers
11 views
SSIS FTP ZIP file only contains .bak when run from SQL agent
I have a SSIS package that downloads a ZIP file from remote FTP site. When I run the package from my PC it works correctly. By "correctly" I mean it downloads the zip file and when I open the zip ...
0
votes
2answers
54 views
Production (20GB+) Database running slowly and timing out
I know the title thread is a bit ambiguous (and my first post here!) but I am having a very severe production database problem. I am not a DBA, though I know how to work with queries and SQL Manager. ...
3
votes
5answers
82 views
Sharing a single primary key sequence across a database?
Is it an acceptable practice to use a single sequence as a primary key across all tables (instead of a primary key being unique for a given table, it is unique for all tables)? If so, is it ...
0
votes
1answer
19 views
Warn about table recreation on table change
By default, if you try to change a table using the designer making any of the following changes, you get an error message:
You change the Allow Nulls setting for a column.
You reorder columns in the ...
0
votes
1answer
19 views
Trigger - Add to a date using a subquery
(postgresql 9.2)
I'v 2 tables
Table 1 (extinguisher)
extinguisher_id (serial)
type_designation_extinguisher_type(text)
manufacturing_date (date)
life_date(date)
Table 2 (extinguisher_designation)
...
0
votes
1answer
15 views
how to downgrade an unknown (2005) interface name from SSIS 12 to 05
The namespace Microsoft.SqlServer.Dts.Runtime.Wrapper was research, but a suitable SSIS 2005 counterpart to a SSIS 2012 interface named IDTSConnectionManager100 was not found.
Any help for the ...
