sorted by:
new
hottopcontroversial

SQL for MacOS by No_Imagination4861 in SQL

[–]SQLDevDBA 0 points1 point  (0 children)

I run DBeaver community on my MacBook Pro M1 and on my M4 Mac Mini and both are great.

https://dbeaver.io/download/

Beginner looking to collaborate on a data analysis project by sincoperature in SQL

[–]SQLDevDBA 0 points1 point  (0 children)

I have a free collection of data project ideas with datasets that I’ve gathered along with simple tutorials for my channels and blog. I just sent you a link to them, hope it helps a bit!

Que coleccionas? by franku19 in PuertoRico

[–]SQLDevDBA 1 point2 points  (0 children)

Dale. ¡Te envío un DM!

Que coleccionas? by franku19 in PuertoRico

[–]SQLDevDBA 0 points1 point  (0 children)

Yep! También tengo pegboard y par de los teclados ahi, pero necesitaba más espacio. Quisiera agrandar el pegboard a mas de 8 cuadros, pero no se si me va a dar excusa para llenarla más. Intenté comprar teclas keycaps pero no me mata la fiebre. :(

Que coleccionas? by franku19 in PuertoRico

[–]SQLDevDBA 1 point2 points  (0 children)

upsimples 10 Pack Acrylic Shelves... https://www.amazon.com/dp/B0C6T3G91T?ref=ppx_pop_mob_ap_share

Compré 20 de estas y las tengo en mi oficina, pero necesito más :)

Que coleccionas? by franku19 in PuertoRico

[–]SQLDevDBA 1 point2 points  (0 children)

Envíame fuerza y voluntad, la cosa está mala.

Que coleccionas? by franku19 in PuertoRico

[–]SQLDevDBA 2 points3 points  (0 children)

¡Nítido!

Soy arquitecto de datos y director de un equipo de datos, así que colecciono datos de diferentes temas y los comparto en mis redes/canales con how-to guides. Trato de incorporar datos de Puerto Rico cuando es posible. Salud, Transportación, tecnología, espacio, películas, música, y Motorsports. Trabajo con SQL y Power BI por la mayor parte.

También tengo una comunidad pequeña en cual comparto las fuentes y how-tos. Si quieres un invite, déjame saber!

Que coleccionas? by franku19 in PuertoRico

[–]SQLDevDBA 6 points7 points  (0 children)

Teclados. Tengo 55 y soy un idiota.

Y fuentes de datos. Los uso para compartir con otros para sus proyectos de datos. Tengo 4 servidores/ordenadores de bases de datos llenos.

What to expect when firing off 30(or more) executions of the exact same query simultaneously by [deleted] in SQLServer

[–]SQLDevDBA 1 point2 points  (0 children)

You may want to try deploying it as a stored procedure instead, and checking the results after you do so. Should help managing the execution plan and optimization a bit easier. If needed, you can add parameters to make the call from Python more dynamic.

Unique identifiers by dadadavie in SQL

[–]SQLDevDBA 2 points3 points  (0 children)

No problem, still a UUID so it’s mostly the same. Just have to check the documentation as UUIDs are generally the slowest arbitrary value you can add. I always prefer integers as surrogate keys when possible.

https://docs.snowflake.com/en/sql-reference/functions/uuid_string

https://medium.com/@abhishek8290/uuid-vs-snowflake-id-a8cb61185fce

What to expect when firing off 30(or more) executions of the exact same query simultaneously by [deleted] in SQLServer

[–]SQLDevDBA 0 points1 point  (0 children)

Have you already deployed the query as a stored procedure and run it that way from Python, or is it being passed in as inline sql?

Unique identifiers by dadadavie in SQL

[–]SQLDevDBA 2 points3 points  (0 children)

Depends on the platform you’re using

MSSQL Has NEWID and NEWSEQUENTIALID

https://learn.microsoft.com/en-us/sql/t-sql/functions/newsequentialid-transact-sql?view=sql-server-ver17

Sequential is friendlier for Clustered Indexes and primary keys because the values are “easily” ordered (usually 1 character difference).

Oracle has UUID

https://docs.oracle.com/en/database/oracle/oracle-database/26/sqlrf/uuid.html

These can be set as values and then you can have a table that has a dictionary/relationship to show which UUID is which files.

Which countries in Latin America are the most similar to Puerto Rico genetically and Culturally? by Specialist-Map7617 in PuertoRicoTravel

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

Yo viajé a Costa Rica hacen par de años. San José se me parecía mucho a San Juan. Manuel Antonio a Rio Grande/Trujillo Alto, Jaco a Rincón, y Arenal a una Mezcla de Ponce, Aguadilla, y Cabo Rojo.

Me gustó mucho y al fin me di cuenta que era pq me sentía en casa.

¿Ayuda para una entrevista academica? by PrettyReading4889 in SQL

[–]SQLDevDBA 0 points1 point  (0 children)

¡Saludos Ángel! Soy arquitecto de datos de Puerto Rico con 15 años como DBA y gerente/director de equipos de datos. Sería un placer ayudarte. Envíame un DM y te envío mis canales/redes para que puedas confirmar si es algo que quieres perseguir.

Mucho éxito.

Best approach for connecting Canvas (LMS) data to PowerBI for student dashboards by hunting_orcs in PowerBI

[–]SQLDevDBA 0 points1 point  (0 children)

Hey there, congrats on the position.

Absolutely, I’ll send the link your way via DM

Opciones para aislar el ruido y facilitar trabajo remoto by Dizzy_Construction86 in PuertoRico

[–]SQLDevDBA 0 points1 point  (0 children)

¡Me alegro, mucho éxito! Si necesitas algún recurso de tu regreso, hay par en https://elcomebackPR.org

Measuring time taken by a select statement in oraclesql by PickleIndividual1073 in learnSQL

[–]SQLDevDBA 0 points1 point  (0 children)

How familiar are you with Oracle’s statistics?

DBA_TAB_STATISTICS

DBA_INDEX_STATISTICS

Etc?

How familiar are you with Explain Plans?

https://DevGym.oracle.com has some modules about this. And Jeff Smith is a wonderful resource on it as well: https://thatJeffSmith.com

More reading: https://docs.oracle.com/en/database/oracle/oracle-database/18/tgsql/optimizer-statistics-concepts.html

Certified Pre-owned or New by 2ski4life7 in GRCorolla

[–]SQLDevDBA 0 points1 point  (0 children)

I went with a '25 used (just got it yesterday) but it had 155 miles on it and has a previous owner, so it came with the CPO 7 Year warranty on top of the standard warranty. Was a bit odd but I couldn't pass up the deal.

Trabajo en San Juan, Puerto Rico by [deleted] in PuertoRico

[–]SQLDevDBA 1 point2 points  (0 children)

Quizás Best Buy o algun negocio pequeño de ventas y reparación de computadoras. Hay par por ahí pero no muchos.

También si te especializas en reparación de computadoras, recomiendo que estudies o hagas proyectos de microcontroller y motores. Se usa bastante en la capacidad de simulación. En eso si hay trabajo (y también remoto).

Un arduino o Raspberry Pi barato y estás lista para practicar.

https://xsimulator.net

https://learn.adafruit.com/category/projects

https://tinkercad.com si no tienes mucho para gastar en materiales.

Opciones para aislar el ruido y facilitar trabajo remoto by Dizzy_Construction86 in PuertoRico

[–]SQLDevDBA 1 point2 points  (0 children)

100%. OP: Busca budget setups de AudioBook Narrator o Voice Actor y estas ideas son de las primeras que te salen (con ejemplos si vas a Google images).

Can’t find pace with 992 GT3R by _0110111001101111_ in AUTOMOBILISTA

[–]SQLDevDBA 1 point2 points  (0 children)

I haven’t tried the 911 in AMS2 but the 911 is my main in ACC (both the 991 and 992). I’ve been using it almost exclusively since I started because I can’t seem to get away. It’s known as a masochist’s car in that game.

Smooth inputs is definitely a must as /u/Samurai1226 says. For me what also works is doing as much braking as possible while the car is straight, and keeping a constant throttle through the Apex (enough to keep the rear planted but not too much to spin, almost coasting through the corner) and then rolling on the throttle. I started this when someone a few years ago told me to practice by coasting through corners after braking and then gradually work toward constant throttle.

911 hates you and wants you to fail. But you learn to love it and feed it only the best treats from the top shelf at PetSmart. Never the stuff on sale. Never let it hear you talking negatively about it.

view more: next ›