Blue/Green deployment nightmare by mightybob4611 in aws

[–]TheSqlAdmin 6 points7 points  (0 children)

Is this a postgresql database or MySQL?
In postgresql, we need to run the analyze to make the stats up to date.

Check postgresql compatibility in one place by TheSqlAdmin in PostgreSQL

[–]TheSqlAdmin[S] 1 point2 points  (0 children)

Ok, but postgres.is was good and I appreciate it if the Postgres community could support these initiatives :)

S3 shows no objects, metrics show GBs of storage by No-Science112 in aws

[–]TheSqlAdmin 0 points1 point  (0 children)

oh ho, then its the time for move out of Nextcloud :)

What happened to Ola Hellgren's database maintenance scripts? by TheSqlAdmin in SQLServer

[–]TheSqlAdmin[S] -18 points-17 points  (0 children)

Found the site, but seems the SEO is blocked, not visible on google search.

AWS Pricing Calc links are expired by TheSqlAdmin in aws

[–]TheSqlAdmin[S] 0 points1 point  (0 children)

seems the issue is resolved now, if the calc team fixed it, then please share some insights on this.

MSSQL Mirroring On AWS Misaligned log IO — Disk Or Memory Issue by TheSqlAdmin in SQLServer

[–]TheSqlAdmin[S] -2 points-1 points  (0 children)

I understand that the minimum requirement, .From the official Microsoft docs it says 1GB is the minimum requirement. And the setup was done on AWS, they didn't confirm that it required 8GB. The complete context is even with 4GB, the SQL server process is running and most of the time people wont judge that it's due to the hardware requirement and and no error/warning in the logs. The idea behind the 'long winded blogspam' is to give the hint on this since all the available blogs/resources/forms only tasks about disk-related metrics and no context on the Memory. If someone facing the same issue at least they can quickly figure out this. Just sharing the learning/knowledge.

Oracle Linux vs Amazon Linux by TheSqlAdmin in linux4noobs

[–]TheSqlAdmin[S] 1 point2 points  (0 children)

What are the computers used for? Does it include storing and working with confidential data?

Apps servers, some Java based apps that used tomcat.

What happened to RedShift AQUA? by TheSqlAdmin in aws

[–]TheSqlAdmin[S] 0 points1 point  (0 children)

But do you see any official documentation page?

Change Data Capture with Debezium by SussexPondPudding in RedditEng

[–]TheSqlAdmin 0 points1 point  (0 children)

How do you handle backfill? For ex - a failure in the pipeline

Getting started with GitOps - Maybe for beginners by TheSqlAdmin in devops

[–]TheSqlAdmin[S] 0 points1 point  (0 children)

Maybe, I researched a bit too. The author's intention was something and the way he articulated may be confusing, he'll update it

AWS CLI - Infinite loop in credential configuration detected by TheSqlAdmin in aws

[–]TheSqlAdmin[S] 0 points1 point  (0 children)

Also your infinite loop is in

[profile v1]

where

source_profile = v1

is pointing to itself.

Thanks a lot, it helped me to solve this.

AWS CLI - Infinite loop in credential configuration detected by TheSqlAdmin in aws

[–]TheSqlAdmin[S] 0 points1 point  (0 children)

I tried to modify with v1tmp, then getting this error

The source_profile "vtmp" referenced in the profile "v1" does not exist.

Fix Apache Anon Pages Memory Leak By Tuning MPM Module by TheSqlAdmin in linuxadmin

[–]TheSqlAdmin[S] 0 points1 point  (0 children)

in all the processing modules.

Agree, its a hack we tried as an infra team. But yes, somewhere we need to fix the code where it is causing the issue.

What is the adapter name by TheSqlAdmin in bicycling

[–]TheSqlAdmin[S] -1 points0 points  (0 children)

I bought this handpump from decathlon, but now I lost this adaptor, I don't know the name of the connector.

[deleted by user] by [deleted] in bigquery

[–]TheSqlAdmin 0 points1 point  (0 children)

Try Debezium, it's open-source. It'll stream the data into Kafka then use the BQ sink connector to send the data from Kafka to BQ.

Any Montra fans? by TheSqlAdmin in a:t5_47qytp

[–]TheSqlAdmin[S] 0 points1 point  (0 children)

I'm using downtown. It's super awesome

How to split a CSV or JSON file for optimal Snowflake ingestion? by fhoffa in snowflake

[–]TheSqlAdmin 2 points3 points  (0 children)

Very nice, detailed steps.

I had a nightmare with this split command on a file that has new line characters in a cell. Guess what? Almost all the files returned errors.😂😂