All Questions

Filter by
Sorted by
Tagged with
2 votes
0 answers
63 views

MySQL 8.0 fails to store 5.7-allowed symbols (Incorrect string value, Error 1366)

I'm upgrading MySQL 5.7 server to 8.0 with a bunch of user-input data that sometimes contain "malformed" unicode characters like x'eda0bdedb98f'. The latter seems to be 2 UTF-16 characters ...
1 vote
2 answers
1k views

MySQL: Merge Same Database on Several Location into Single Location

I have a registration form, which is exactly the same for several locations. Each of them has a REG column, which is unique for each inserted row. Basically, each data input has a different REG number ...
7 votes
2 answers
1k views

Foreign key to multiple tables via forwarding table

Problem statement I have a table with a column whose values are foreign keys, but the target table of the foreign key differs from row to row. The relevant table can be determined from the key value ...
2 votes
1 answer
364 views

SQLite Internals - Records

Hey I'm trying to wrap my head around SQLite data storage, specifically how it is storing Records. I've found a book The Definitive guide to SQLlite, where the author explains internal record format (...
2 votes
1 answer
2k views

PG_DUMP on Replica DB server Error

I have a master - slave configuration with 9.4 version, but there is no WAL streaming replication configured. Customer simply copy xlog files on network share and replica applies it. I need to run ...
4 votes
1 answer
2k views

How do I identify the remote db agent name to use in create_database_destination on Oracle 11gR2?

I am trying to setup DBMS_SCHEDULER in Oracle 11g to run a remote database job. I have a remote Oracle 11g R2 database on unix and a local one on Windows. I read that you can install the oracle ...
0 votes
1 answer
2k views

Excel VBA Connection String for ODBC System DSN

I am trying to create an Oracle connection string in Excel VBA. After lots of research, I have a working connection string: Set Oracle_conn = New ADODB.Connection Oracle_conn.Open "ODBC; Driver='...
1 vote
1 answer
1k views

Querying AD from SQL Server

I've read tons of questions and answers about my error but none of them helped me ( from PINAL website, microsoft links and everything ). questions from 9 years ago to today. I created a Linked server ...
0 votes
1 answer
3k views

Why do I have to set MySQL user password with mysql_native_password to connect with Workbench?

I've noticed if I set the mysql user's password like below, I cannot connect with MySQL Workbench. ALTER USER 'root'@'localhost' IDENTIFIED BY 'myPassword' If I use this below I can connect to it: ...
0 votes
1 answer
38 views

SQL 2017 log reuse issue

I have a SQL 2017 Enterprise server where more and more VLFs are being consumed and none are being released. Log backups are running every 15 minutes. It is in an AG but this is working correctly (...
0 votes
1 answer
28 views

sp_whoisactive is showing a Blocking Session ID of -5

We're in the process of upgrading to SQL Server 2022. While comparing performance between our old QA server (SQL 2014) and our new QA server, we're using sp_whoisactive to help identify bottlenecks. ...
1 vote
1 answer
979 views

How to release SSAS memory without forcing restart

We have a production server with two SSAS instances, 1 for user querying and 1 with empty templates where we do new releases and (full) processing of the cubes (and then backup and restore processed ...
1 vote
2 answers
330 views

Automatic Failover for Basic Availability Group

This will be my first project with Basic availability group so I thought would check before implementing . As per Microsoft documentation below it says we will need to have Software assurance for ...
0 votes
1 answer
820 views

How to Get the First in and Last out in night shift?

I already have the Query for Getting the Day shift but I'm Having a problem in the night shift, Which is this query. SELECT user_id, Min(verify_date) as First_IN, Max(verify_date) as Last_Out from ...
1 vote
2 answers
2k views

how to run mongo export on macbook?

I am using mongodb Atlas (M0), which does not provide db backup feature. I am creating a nodejs script that will export all the collections automatically periodically. So far I have done the following:...
0 votes
0 answers
8 views

How can you handle internationalized queries with Elastic Search?

What functionality in elastic search would help query for a word spelled "Serialised" (-ised as spelled in the UK) with the Americanized version "Serialized" (-ized as spelled in ...
8 votes
4 answers
9k views

Using SQL Server with BitLocker

I have an application that is running on a device that has two partitions: C and D. The application runs off of C while D contains the SQL Server database (mdf file). In addition, D is also encrypted ...
0 votes
2 answers
30 views

Should I create a separate table for non null user_id values in my MySQL database schema for performance?

I have a MySQL database schema for storing uploads, where each configuration can be associated with a user account (user_id) or uploaded as a guest without an associated user account (null user_id). ...
0 votes
2 answers
17k views

ORA-01506: missing or illegal database name

I connected as sysdba and tried below: SQL> startup; ORA-01506: missing or illegal database name SQL> I tried multiple scenarios changing the Oracle_home and path variables but no luck. ...
1 vote
2 answers
1k views

Wich solutions is better for translate some data?

I've a little mobile app who need some translation. Currently, I just want to translate my app in one language, I don't think I'll need more. So I'm facing a problem, should I translate stuff in ...
1 vote
0 answers
44 views

Monitoring data exflitration

I've been tasked with coming up with some mechanism that would allow me to detect when a database user queries a certain table in our system and a large result set is returned (say over 1000 rows). ...
0 votes
1 answer
773 views

MySQL Stored Procedure Compiles Without Error (I want the error to occur)

I have a MySQL stored procedure that runs fine and does its job quite well. Yesterday, I edited it in MySQL Workbench and introduced a spelling mistake on purpose. For example: - Valid statement: ...
6 votes
1 answer
368 views

What does SQL Server's Error Log actually log?

If you have ever played around with the error_reported Extended Event, then it becomes very obvious that the SQL Server Error Log only logs a tiny fraction of the errors that are thrown by code ...
2 votes
1 answer
4k views

When trying to configure data guard broker I'm getting Error: ORA - 12154 : TNS: could not resolve the connect identifier specified

I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to data broker configuration and ...
0 votes
2 answers
4k views

Query for Transactions per second?

For performance mornitoring, i would like to have a mysql query which gives the calculated output of TPS. I think tps= Com_commit + Com_rollback / second , but I don't know the query to calculate ...
1 vote
1 answer
811 views

Changing default permanent USERS tablespace to bigfile

I'm trying to build an oracle database server but it's setting up the users tablespace as a smallfile. How can I either install brand new database with users being bigfile or changing the existing ...
0 votes
2 answers
59 views

How to simplify this intersect query?

SELECT * from M left JOIN K on M.id = k.id left JOIN W on K.str = W.str where str = N'أخبار' INTERSECT SELECT * from M left JOIN K on m.id = k.id left JOIN W on K.str = W.str where str = N'فلسطين' ...
2 votes
1 answer
103 views

Efficient Pagination In Postgresql (Keyset Pagination)

I'm working on implementing pagination for a PostgreSQL database in which I have a table that stores users for my application. I have a query that is intended to fetch the next page of users based on ...
0 votes
0 answers
7 views

how to use Amazon SCT to connection to an Amazon RDS database?

Apparently, Amazon SCT can be used to compare two schemas for differences. We have several RDS Postgres databases, using Native postres authentication. SCT has the option to connect to an RDS database ...
2 votes
2 answers
3k views

Why Sql Server management studio use English regional settings instead my local Windows settings?

Scenario: I have a Sql Server instance on English Windows Server. But I also have my own ITALIAN client with Sql Server Management Studio and SSMS regional settings set to Italian. So when I extract ...
52 votes
7 answers
143k views

How to get all roles that a user is a member of (including inherited roles)?

Let's say I have two Postgresql database groups, "authors" and "editors", and two users, "maxwell" and "ernest". create role authors; create role editors; create user maxwell; create user ernest; ...
0 votes
1 answer
980 views

Identifying processes that open MySQL connections

I need to identify which application process issues a large number of MySQL connections on a Linux system. The show processlist sql command or tools like innotop do not really help, as they only show ...
1 vote
1 answer
6k views

Top CPU consuming MySQL processes

I am trying to find out the Query which is consuming high CPU, but can't do it so. This command top -H gives me the high CPU consuming thread PID, but i cannot match them with my processlist output. ...
9 votes
9 answers
58k views

Error Authenticating Proxy Account when Executing SSIS job

I have a SQL Server instance that runs 5 scheduled tasks each night, each of which run SSIS packages. These packages have been running for years and the associated steps run via a Proxy Account (...
0 votes
1 answer
303 views

SQL: Merge rows when value doesnt change in continuous time

I am new to SQL and I need to summarize a table that has this information: Serial Number, StartDate, EndDate, StatusID and TimeInState, what I need is to merge rows that keep the same StatusId during ...
0 votes
1 answer
801 views

Optimizing big sorted join (nested loop) based on value frequency

I have a query involving two tables, let's call them timeline and events, defined as follows: create table timeline ( event_id int, ts timestamptz ); create table events ( id int primary key,...
0 votes
0 answers
7 views

Why pgAdmin run my job every 2 minutes when there is no job schedule end date?

I have a testing job that I create using pgAgent interface, and then I insert the schedule using this query: INSERT INTO pgagent.pga_schedule (jscjobid, jscname, jscdesc, jscenabled) ...
0 votes
1 answer
544 views

Explicitly revoke privileges from a user who is a member of a role that is granted those privileges in PostgreSQL

Let's say I have a user on my PostgreSQL instance called "myuser", and I add it to a new group called "update_all" like this: CREATE ROLE update_all WITH NOLOGIN ROLE myuser; I ...
3 votes
1 answer
905 views

How to list backups when not connected to target DB in Oracle RMAN

I'm trying to list backups in RMAN completed within a certain date range. This works fine when I can connect to the target database and recovery catalog. However, I'm assuming a situation where I am ...
0 votes
2 answers
79 views

Processes stuck in WAITFOR without an explanation or WAITFOR command anywhere in the code

We have 8 processes that each process a separate set of data from a table via cursor, so that multiple CPUs can be used to iterate through the data. This is used for data migration so at this point ...
0 votes
1 answer
950 views

MySQL Workbench Model sync sql_mode

Using MySQL Work Bench, When I look at the system variables of a server I am connected to, it shows the SQL_MODE as "no engine substitution" When I open a Workbench Model, and use the "sync with any ...
0 votes
1 answer
8k views

MySQL DNS issue: skip-name-resolve connection fast but cannot log into email

MySql is used here with remote network connections, and after a reboot of the server these connections started taking 20-30 seconds to connect causing timeouts. Connections used to be nearly instant. ...
0 votes
0 answers
19 views

Connect to a Private SQL Always On Availability group listener with Azure App

We have a fairly standard Azure Webapp - connecting via public IP to a database server which is a VM hosted in Azure. NSG rules etc limit the traffic between the two. The VM hosting the database is ...
0 votes
1 answer
2k views

ProgressBar error and very slow import in MySQL

I'm trying to import a CSV file into MySQL, but the progress bar doesn't advance. When I cancel the import, a ProgressBar error appears, but I see that the file was partially imported. The same error ...
0 votes
1 answer
364 views

Does SSRS report user needs database level permission?

I have a separate reporting server and a separate database server. Now on the Reporting server site settings I could see there are some roles and users. Suppose a User BOB has ‘POWER USER’ role ...
1 vote
1 answer
1k views

Mongo 3.2.20 Invalid access at address

My mongodb local instance just crashed on its own with the following in its log: Invalid access at address: 0x18 Got signal: 11 (Segmentation fault). Environment: Ubuntu 16.04 MongoDB v3.2....
0 votes
1 answer
3k views

Error when running job using SSIS package

I have SQL Server 2008R2 installed on my Windows server 2008. I created a package using the Import and Export Wizard from file system. After that I created a job (SQL Agent Job ) that used the SSIS ...
1 vote
0 answers
16 views

Ubuntu How to change the username PGAdmin tries to use to login

I uninstalled Postgresql and PGAdmin4 from ubuntu and installed them back but, now, when I open PGAdmin and click on servers/local, it requests for the password of a user no longer exists and there's ...
2 votes
1 answer
286 views

What dump file options or MariaDB setting is slowing down the load of data?

Context: Loading a copy of a legacy DB for a CRUD app at build by Spring Boot. Primary use case is developers testing the CRUD functionality as it is developed. Problem: The loading operation is ...
0 votes
1 answer
482 views

Monitor existing cluster using Galera Manager throwing: deployment status error: DB IP address must be provided

I am trying to monitor my existing galera cluster using galera manager. I installed galera manager and chose Monitor existing cluster. I added the ssh keys provided in the manager in the respective ...

15 30 50 per page
1
4 5
6
7 8
2072