TransWikia.com
  1. All Categories
  2. Database Administrators

Database Administrators : Recent Questions and Answers (Page 12)

Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.

How can I model a database structure to retain student information?

I am completely new to databases and SQL. I have generated a database in myphpAdmin consisting of a table with the columns (name, student number, grade). Basically this database will...

Asked on 12/02/2021 by Kitchen

2 answer

No output when use pymongo watch()

I try to access real-time data changes with pymongo.mongo_client.MongoClient.watch(), code example (Python 3.5.3, pymongo==3.7.2): from pymongo import MongoClient DB_CON_STR = "mongodb://10.10.10.1:27017/?replicaset=rslogs" mongo_rs = MongoClient(MDB_CON_STR) MDB_SCHEMA...

Asked on 12/02/2021 by Red Black

1 answer

SQL Server 2019 UPDATE Statement SET to function does not execute the function again for each row

Here is the scenario. I have a local SQL Server to which I have restored the live SQL Server databases. In order to be GDPR/CCPA compliant, I must anonymize the...

Asked on 12/02/2021 by CB_Ron

1 answer

SSRS2016 external parameters for mobile report

How can external parameters be passed to a SSRS 2016 mobile report in order to pre-select values / settings for the report? The same scenario is possible for paginated reports...

Asked on 11/30/2021 by Magier

1 answer

changing the connection string in SQL Server

we deployed the packages from old server to new server .how to change the connection string i.e initial catalog or server name parameter from Agent job > configuration ...

Asked on 11/30/2021 by Teja

1 answer

SSIS Excel Import - First row getting skipped

I am using VS 2017(SSDT) with SSIS(2012). I'm trying to import an Excel file, but the issue is that the first row is getting skipped. I've unchecked First row has...

Asked on 11/30/2021 by Mithun John Jacob

1 answer

Logical Replication/Foreign Data Wrapper Connectivity between Two Aurora Serverless Databases (PostgreSQL 10.7)

I have two Aurora PostgreSQL Serverless databases running in the same region and have PostgreSQL version 10.7. I'm wondering if logical replication is available? The official docs...

Asked on 11/30/2021 by gogofan

0 answer

Get if field has max value and display value

I need to display Y or N when displaying rows in a report based on the max value for them on their version. If they have multiple versions all of...

Asked on 11/30/2021 by Carlos Alberto Martinez Martin

2 answer

How to remove database from explorer after deleting .MDF and .ldf files

I wanted to know if I can delete or remove the database shown in the object explorer after someone has manually deleted the MDF and ldf files from the...

Asked on 11/30/2021

3 answer

Mongodb index keeps growing in size eventhough the collection has a TTL index

I work on a mongodb sharded cluster (3.0.2 i know it's very outdated, not my call), on which i have a sharded db and a sharded collection on which i...

Asked on 11/30/2021

1 answer

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP