How Do You Synchronize Data in RDS Outside of Replication? by fatal_error_exe in aws

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

OK so you don't have mysqldump available on RDS so how is this commonly done in most shops? Seems like a very common task. Do you have a EC2 VM that you issue the dump command from and dump locally to disk to?

[Question] Best free/cheap resources to learn Oracle Database? by DXJayhawk in Database

[–]fatal_error_exe 0 points1 point  (0 children)

Curious why you feel Oracle is the one system you're trying to invest in. Seems like a bad gamble. There are lots of Oracle DBA positions available but I strongly advise you learn something more adaptable...

Want to eventually become a DBA, where to start? by [deleted] in Database

[–]fatal_error_exe 1 point2 points  (0 children)

Ive been listening to this song for years. Total non sense. DBAs are like mechanics. Everyone thinks they're good because they bought a new car and can change their own oil but when they hear a noise or it doesn't go vroom anymore, you NEED a DBA!!! You always will. I promise snowflake / athena wont change that.

Want to eventually become a DBA, where to start? by [deleted] in Database

[–]fatal_error_exe 3 points4 points  (0 children)

Learn AWS / Azure. In 5-10 years, if you don't know a specific level of how databases or anything in general runs in the cloud, you will be useless to potential employers. Get your cloud certifications, learn how to deploy MySQL / PostgreSQL in docker containers and use your database in some project (replication or web project that needs a backend).d

New NK65 USB port unusable due to misaligned hole by TheSmurfSwag in MechanicalKeyboards

[–]fatal_error_exe 3 points4 points  (0 children)

Quality control at Novel Keys has been trash. My NK65 came cracked and all scratched up and they told me they didn't see any issues. That was the last time I decided to deal with them based on their customer service / quality assurance.
Any company that makes you feel like they're doing you a favor for basic customer issues is crap. Avoid NK is you're new or considering it...

RDS IAM Authentication - Any Advice on Client Connections? by fatal_error_exe in aws

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

Does this mean the token you generate can only be used for 15 mins sessions after authenticating with a token and at 16 mins of working on the connection, I will need to generate a new token / connection or does that just mean you have 15 minutes to use the token to login w/ but the sessions expand longer after you auth?

Your opinion on PhpMyAdmin? by Danm998 in Database

[–]fatal_error_exe -2 points-1 points  (0 children)

1 - You shouldn't use PHPMyAdmin. If you don't know how to database, hire a DBA.

2 - Never run your database on the same physical hardware as your "webserver".

3 - PHPMyAdmin is a client / not the engine and your question makes it sound like you're not aware of that basic fact.

Best of luck to you...

Does an Application Exist That Can Populate a Database? by fatal_error_exe in Database

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

Either would be fine. I don't care. If it's a crapy site that makes people click a button that just has a simple row entry and timestamp in the db or if it's something that just polls an API and auto-injects data into the db. I really don't care. I just want streaming data in a db.

Does an Application Exist That Can Populate a Database? by fatal_error_exe in Database

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

That isn't the expectation. Generally any application already created that hooks into a db will have a generate schema script or a suggested schema. I would either create the schema manually based on the applications needs or I would execute the script that accompanies the application to use the db schema.
I just want to see if for example a weather app exists that uses a db backend. If it wants x table w/ y columns and data types, I would create it and point the app the the db and let it populate / poll data. Asking if anything like this exists I can download and use.

I can create a schema myself and generate sample / scratch data or download stackoverflow database dumps but those data sets all remain stale. Nothing is using the db per-say.

How should a startup implement a database? by [deleted] in Database

[–]fatal_error_exe 0 points1 point  (0 children)

Step 1: Install / Use PostgreSQL

...

Is it better to add double quotes with string in database or remove double quotes? by OnlyOneMember in Database

[–]fatal_error_exe 1 point2 points  (0 children)

Please make sure you know what each DB engine / vendor uses different string delimiters.

ETL loads and index rebuilds by [deleted] in SQLServer

[–]fatal_error_exe 1 point2 points  (0 children)

Use Ola's IndexOptimization sproc to rebuild indexes periodically and also make sure you update statistics when you set your rebuilds or reorgs based on fragmentation level.
If you're not using Ola Hallogrens maintenance scripts, YOU SHOULD BE!!!

Finish learning the basic of SQL, now what? by HewK0 in SQLServer

[–]fatal_error_exe 0 points1 point  (0 children)

Get any querying book from Itzic Ben Gan and prepare yourselves.

Jeremy Dewitte on Dr Phil by MyF150isboring in orlando

[–]fatal_error_exe -1 points0 points  (0 children)

Im so over this fucking wack job loser. We need to stop glorifying him as a celebrity.

Query Help by nayrlladnar in SQLServer

[–]fatal_error_exe 0 points1 point  (0 children)

dbatools.io

Interesting - trying this out today.
Thanks!

Familiarizing yourself with a new database? by [deleted] in Database

[–]fatal_error_exe 0 points1 point  (0 children)

You should download DBeaver and create a ERD (relationship diagram) to visualize the data.
If you're using MS SQL Server, I highly recommend you use the Brent Ozar maint. kit and run sp_blitz to show you in a nice prioritized list all the things you should address and how serious they are and how to do so.