0
votes
0answers
6 views

Create Procedure

CREATE PROCEDURE validateZuoraFormat ( IN client varchar(100)= ' ', IN table varchar(100)= NULL, IN type varchar(100) = NULL, IN debug bit = 0, IN clientReport bit = 0, ...
0
votes
0answers
3 views

Copy postgis layer from S3 to Heroku

I have a dump of a postgis layer (layer.dump), which I am trying to add to my heroku database (mydatabase). The postgis layer is stored on S3 (https://s3.amazonaws.com/layer.dump). I would like to add ...
0
votes
0answers
12 views

Find data size of table for several identical databases on a instance

I have several identical databases with the same schema/table structure within a instance. I need to find the size of one table that they all have. For example, I have 30 databases on a instance and ...
0
votes
0answers
4 views

MySQL: How to count non-unique rows in a multiple criteria COUNT query?

I want to calculate, in one query, the percentage of researchers (chercheurs) that have co-signed written publications (between two dates, only for a type of publications and only for researchers ...
2
votes
0answers
18 views

Identity column in columnstore index

I have an extremely large table IMO (~137 million rows) with lots of repeated data, lots of NULL columns, and such. I am considering exploring this using a table with a COLUMNSTORE INDEX and I have ...
-2
votes
1answer
32 views

Business Date and Route Sequence

+-------------------------------------------------------------------+ |Route |Sequence| Planned Time | Business Date | ...
0
votes
1answer
13 views

How do I copy a materialized view to a table?

I have a materialized view. I want to create a copy of it so I can modify some of the data to test a few theories about an issue and its possible solutions. How do I make a copy of this MV as a ...
0
votes
0answers
9 views

Creating procedure in mysql

I am trying to build a procedure that i would use to check my data format before processing it to the net stop and i need this procedure to check the format of my file. So what i need is, my database ...
-1
votes
1answer
17 views

Querying sys.master_files over a linked server

Querying sys.master_files through a linked server, I get no results. Why? How do I work around this issue?
0
votes
0answers
5 views

When does query data get aged evicted out of cache in MySQL query runs slow then fast then slow again

Running Virtual Machine - 5.6.19 MySQL Community Server on Linux When does the data / queries get aged out of the buffer pool in MySQL? I have a dev server with 1GB was using default sized buffer ...
0
votes
2answers
15 views

Create database design with requirement

I has a small database structure with an Account and Person. I want apply the following requirement: Account have one Person Person do not have necessarily one Account (can be null) When I delete ...
0
votes
1answer
29 views

Update if exist in other table

I want to update column in table A if the value of column A1 exist in one column of B table for example B2 update A set A1 = 'F' WHERE A1 in (SELECT B2 FROM B ); I tried somethig like this but no ...
1
vote
1answer
8 views

What can I use for the PowerShell notin operator in v2.0?

I developed a PowerShell script in v4.0 and then learned that the -notin operator isn't supported on v2.0 (which is the version that I need to run it in). What is the best alternative to the -notin ...
0
votes
0answers
10 views

High disk IO from MySQL database on Ubuntu

We have a MySQL database (the master in a master-slave setup) running on Ubuntu that is experiencing high disk IO as reported in newrelic and by iostat. Now, the server normally has ~150 connections ...
0
votes
0answers
8 views

Varchar array as an input to Oracle stored procedure

I'm new to dynamic SQL execution. I'm working on an application which will take a list of input from an excel and generate a report out of it. I'm preparing the input data in the format required by ...
0
votes
0answers
17 views

SQL TDE Key Format

I'm trying to find the Key Format that SQL TDE uses. Is it PKCS? If so, what #? I haven't been able to identify this based on research done on MS website. And, there is no mention of key format during ...
0
votes
0answers
5 views

OPENDJ(LDAP) and Oracle 12c - Encrypted Password

I would like to know what values ​​the user authentication using a coded password accepted . In Oracle 12c of the hashing algorithm was indeed upgraded to a PBKDF2 based on SHA512 . I have an LDAP ...
3
votes
0answers
28 views

Permissions on a database object when it does not have any permissions associated to it

I want to find out the permissions of a specific object in the database. I have found many scripts on the internet, and developed my own too. Something like this: select dp.NAME AS principal_name ...
0
votes
1answer
27 views

Alter user - is password stored in audit trails

I was asked an interesting question the other day and I have not been able to find a definitive answer. If one of my DBA's changes a password, will the password the password show up in plain text in ...
0
votes
1answer
14 views

Are mysql global variables values in bytes?

When I run the following in my mysql terminal mysql> SHOW GLOBAL VARIABLES LIKE 'tmp_table_size'; +----------------+----------+ | Variable_name | Value | +----------------+----------+ | ...
0
votes
1answer
18 views

How to Create Insert Statement from Table Data using sp_export_data without Id?

How to Create Insert Statement from Table Data using sp_export_data without the Id? I have the following statements and want to omit the Identity. How would I accomplish this? This is how I'm ...
-4
votes
0answers
12 views

SQL Server 2008 on Windows XP [on hold]

We have SQL Server 2008 installed on Windows Server 2008 Standard Edition. We have ladescape-like client connected to the front-end application with ODBC configured with SQL Server. The ODBC test is ...
1
vote
1answer
24 views

Binary log backups in MySQL

I'm running a master-master replication with read-only second master. Now since my binary logs are not getting replicated in my passive master. Should I need to enable --log-slave-updates? If I ...
0
votes
0answers
9 views

How to use MySQLTuner on Amazon RDS

I've installed MySQLTuner locally and it works on my local database. When I try to run it on my Amazon RDS db it does not, it says my login credentials are invalid. $ perl mysqltuner.pl --host ...
-4
votes
0answers
15 views

sudo /usr/local/mysqlcluster/scripts/mysql_install_db --user=mysql --datadir=/var/lib/mysql-cluster --basedir=/usr/local/mysqlcluster --no-defaults [on hold]

/usr/local/mysqlcluster/scripts/mysql_install_db: 1: /usr/local/mysqlcluster/scripts/mysql_install_db: /usr/local/mysqlcluster/bin/my_print_defaults: not found Installing MySQL system tables... ...
4
votes
1answer
14 views

Problem when add administrator for Analysis Server ( SQL 2008 R2 )

I'm trying to add a user as an administrator in Analysis Server, doing this: 1 - Connect - Analysis Server - Right click on the Instance - Properties - Security - ADD : This number was already ...
1
vote
1answer
20 views

Using REGEX_LIKE to Implement a Check Constraint

Background I am working on the database design for an application that tracks information about database development projects at my company. The project management office (PMO) assigns a ...
0
votes
0answers
5 views

Elasticsearch For Login Purpose

Is it secure to index users' credentials, such as passwords (hashed) and usernames, in ElasticSearch for login purpose? //Practical Issues
2
votes
1answer
14 views

Which is better MySQL search strategy, varchar x 2 or text column?

I have a MySQL database for an SMS application. For the sms_msg column, I initially setup varchar(255) expecting SMS to be short anyway. Now I realize that's not enough and some messages are getting ...
0
votes
0answers
7 views

SSRS Matrix Report - Count for NULL data

I have a SSRS Matrix Report for data quality in our warehouse. We use this report to display invalid values in specific fields during specific time period. For example, Missing/Invalid Postcode, My ...
3
votes
0answers
13 views

Unable to uninstall Sql Server 2012 Express (With SP1)

My Stack: . Windows 10 Enterprise . SQL Server 2012 Express (with SP1 bundled). ISSUE: . Installed SQL to test for backward compatibility. . When I tried to Un-Install the following prompt is ...
1
vote
1answer
23 views

Move PDB to a new host

We're using Oracle 12c, and have two separate servers running Oracle, with a CDB with 2 PDBs. What is the easiest way of getting the data from server A to server B, as a one-time job (not ...
-4
votes
0answers
17 views

Seconds behind the master is getting increased how to reduced that. since i haveupdated my salve and started back the replication [on hold]

MariaDB [(none)]> show slave status \G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: ...
0
votes
0answers
7 views

how to restore the copied mongodb files in a server?

I have copied mongodb database files from my local machine into a server. How can i restore these files in the server and use them? Please help.
0
votes
0answers
6 views

How do you rename the title bar on plsql developer

Am currently using the plsql developer to access my Oracle database. i want to be able to identify which database am connected to. If there a way to change text on the title bar to something more ...
2
votes
1answer
30 views

Can SQL Server Audit be used to track hostnames or IP adresses of the users performing DML on a table?

I have been reading about SQL Server Audit, and so far I have assimilated that it tracks the command that has been executed, and some other additional information(SPID, object ID and stuff). But can ...
1
vote
0answers
13 views

Can i use PGP for securing My database

I have considered TDE and cell level encryption mechanism for securing my database. but these two cannot fully satisfies my requirements.through surfing i found that PGP may help me, but it is mainly ...
0
votes
0answers
5 views

Tools to visualize adhoc multi dimentional data

With SSMS I cannot run a MDX query such as Select [Measures].[Internet Average Sales Amount] on 0, [Product].[Category].children on 1, Product.[Model Name].children on 2 From [Adventure Works]; ...
0
votes
0answers
11 views

Sql Server remote connection to 2nd instance impossible

After installation of another SQL-Server 2014 instance to a server where a default instance of Sql-Server 2008 R2 is present, I cannot remote connect remote to the new named instance. The default 2008 ...
0
votes
0answers
31 views

SSRS Migration 2008 to 2014 - InternalCatalogException secDesc != null

We're migrating side by side from SSRS 2008 Web to SSRS 2014 Enterprise. I followed the steps: backup encryption key backup databases (ReportServer and ReportServerTempDB) restored databases on 2014 ...
1
vote
1answer
19 views

Is it safe to run optimze on mutliple tables in parallel in mysql (percona)

I have a slave on which no query is coming. Lot of data has been archived and deleted from almost all tables. Size of tables vary from 80Gb to few Mbs. And there are around 130 such tables. Mysql ...
1
vote
1answer
16 views

How to drop java source from Oracle properly?

I'm a little stuck here with my Java Source. First I want completly drop it from the database, because I want to recompile it, but I can't drop is, because if I execute this command: drop java ...
1
vote
0answers
10 views

Why mongodb never end some connection

My mongod runs out of connections from time to time. But when I restart the instance, it becomes normal. I check the log and found some connections were created and never be ended. This cause the ...
1
vote
0answers
5 views

Grant read/read-write access to SSAS cubes

I have a requirement to grant read access on SSAS cubes to one windows group and read/write access to another group. I have multiple SSAS cubes on my server. The question is: What minimum rights ...
0
votes
1answer
28 views

MySQL backup practices

I have a MySQL master-master replication with second master in read-only mode. My questions reg backup are: I have 10 databases so should I take daily backup as one dump containing all the ...
1
vote
1answer
330 views

Can we use TDE as an anti-injection technique

TDE prevent unauthorized access to the data by restoring the files to another server, because it requires the original encryption certificate and master key. If i applied a table level encryption ...
0
votes
1answer
27 views

Developer privileges in a store scenario [on hold]

I have a scenario where a chain of shops are needing to migrate their data and I need to create an environment. I have a single developer and a DBA and I wasn't sure what object privileges to give to ...
2
votes
1answer
37 views

GROUP BY rewrite to subqueries with easily interchangeable AND OR conditions

Tables: content tag_map extrainfo |id|title| |id|tagid| |id|lat|lng| |--|-----| |--|-----| |--|---|---| |1 |Lorem| |1 |8 | |3 |0,4|0,1| |2 |Ipsum| |2 |9 | ...
1
vote
0answers
17 views

MATLAB® export double numbers into PostgreSQL by `datainsert` (of Database Toolbox) [on hold]

code I'm trying to pass results into postgreSQL row by row; they have been calculated in MATLAB. Here it follows the list of matlab data type: nomi 197x1 cell eps 197x1 double Re 197x2 ...
1
vote
3answers
37 views

SQL Server 2012 window function

I've the following table which holds status of jobs in a history table. JobHistory jobOrderId | dateAdded | Status -----------|-------------------------|------- 4909 | 2015-08-26 ...

15 30 50 per page