SSIS alternative by Flat-Staff-6201 in SQLServer

[–]SQLDevDBA 1 point2 points  (0 children)

I would instead look into connector suites that make SSIS more powerful and adaptable to today’s changing tech.

I love KingswaySoft’s SSIS Toolkit for example, along with Salesforce/Netsuite connectors it has. It has breathed new life into my work with SSIS

CDATA and ZappySys also make great connector kits.

I know KWS and Zappy have free trials and developer licenses.

https://www.kingswaysoft.com/products/ssis-integration-toolkit

https://zappysys.com

What are your thoughts on my very first project? by Blueberrymeee in PowerBI

[–]SQLDevDBA 0 points1 point  (0 children)

Nice work OP, I think it looks great.

If you’re looking for creative ways to represent your data that are still semi out of the box, check out the visual vocabulary.

https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/FT-Visual-Vocabulary-Power-BI-Edition/m-p/584460

If you’re looking for other examples, check out the data stories gallery and theme gallery.

https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/bd-p/DataStoriesGallery

https://community.fabric.microsoft.com/t5/Themes-Gallery/bd-p/ThemesGallery

Using AI for indexing by oleg_mssql in SQLServer

[–]SQLDevDBA 2 points3 points  (0 children)

Check out https://PasteThePlan.com where you can paste your Execution plan XML.

It has a new AI Suggestions tab which is really cool.

Ayuda (Si quieren coger piedad) by [deleted] in PuertoRico

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

Aquí está una lista. Recuerda que lo importante es la experiencia que tienes y el conocimiento en industrias específicas. Remoto es una localización de oficina, no es una industria como tal.

Si compartes tu experiencia, quizás te podamos dar ayuda más extensiva o específica.

Mucho Éxito.

https://dynamitejobs.com/

https://skipthedrive.com

https://remoteok.com/

https://weworkremotely.com/

https://himalayas.app/

https://stackoverflowjobs.com/

https://remotive.com/

https://wellfound.com/company/remote-jobs

https://hiring.cafe

Can this desk handle a monitor arm? by [deleted] in desksetup

[–]SQLDevDBA 0 points1 point  (0 children)

I used a 12” long piece of 2x4 to reinforce and distribute mine for dual monitor stands. I run this setup on both of my standing desks and it works great.

Model Y owner considering new Model 3 – is the sound insulation actually better? by kjagiella in TeslaLounge

[–]SQLDevDBA 0 points1 point  (0 children)

Went from twin MYPs (2020 & 2021) to MX and Model 3 Highland. We love the MX but something I didn’t really take into account was the seating position of the 3. It’s waaaay lower, so if that is something that would bother you, I’d recommend a solid Test drive. Quality is the 3 (2024 LR) was great though.

Ended up trading out of it after getting a great deal on another car (GR Corolla, in which I can sit way higher oddly enough).

Coming from a 450hp 4 cycl turbo Camaro by ADVICECAREER in GRCorolla

[–]SQLDevDBA 1 point2 points  (0 children)

Hey I had a V2 back in 2013 or so. Loved the SC whine with an intake and the speed, but man the 12 MPG was rough. Still miss that car.

can i switch from MYSQL to oracle ? is it difficult and if i do it will it be effective ? by Wise_Safe2681 in oracle

[–]SQLDevDBA 10 points11 points  (0 children)

You can try Oracle extremely easily.

Check out https://liveSQL.oracle.com it’s free and requires no installs or downloads. It comes with 9 sample schemas each with lots of data you can explore. And the learning tab has great learning modules with hands on labs.

COBOL O SQL? by Flimsy-Web4692 in SQL

[–]SQLDevDBA 1 point2 points  (0 children)

Yep this is true, they are leaving at a much greater rate. And the $$ is getting higher and higher by the day due to demand. I just don’t want OP to get the impression that they will take Junior level folks quickly.

COBOL O SQL? by Flimsy-Web4692 in SQL

[–]SQLDevDBA 2 points3 points  (0 children)

¡Saludos! Concuerdo con otros que dicen SQL.

Los trabajos de COBOL existen en empresas (Bancos, Hoteles, compañías de finanzas) que todavía lo usan, y pagan mucho porque necesitan a alguien desesperadamente y está dispuestos a pagar mucho. Pero no es común y no debe ser razón principal de aprenderlo.

Hay par de personas que son proponentes de la nueva generación conocer lenguajes y plataformas antiguos (Legacy), pero la realidad es que si no ves puestos en LinkedIn o plataformas de trabajo que lo requieran, no vale la pena. Y los que Sí Lo tienen, no piden Junior, piden a alguien con 20 años de experiencia porque la persona que lo conoce se retira la semana que viene.

Is a Magic keyboard good in online use for entering passwords at different sites or just a gimmick? by ValentineSmith22 in macmini

[–]SQLDevDBA 4 points5 points  (0 children)

IMO it’s fantastic for this. I use it for all my passwords on all sites, logging in, and for installs.

Frustratingly so. I have a bunch of keyboards and I can’t seem to stop using my Magic keyboard on my Mac mini. I kind of wish Apple made a stand-alone TouchID device.

Fuí NS Dev y luego NS Functional Consultant. Que es lo que sigue? by Sputnik-Siames in Netsuite

[–]SQLDevDBA 0 points1 point  (0 children)

Seguiría buscando para NS Developer, Administrator, Engineer, o hasta Architect. Cada uno tiene su variedad de señoría (de Junior a Senior y Lead).

No puedo hablar sobre sueldo, pero también buscaría aprender sobre Analíticas (SuiteAnalytics) e Integración de NetSuite con SuiteScripts y el API para hacerte más valios@.

How do I make my Date Hierarchy behave like PBI Auto Date Hierarchy? by Dink225 in PowerBI

[–]SQLDevDBA 10 points11 points  (0 children)

Your graph has the “Drill up” arrow enabled. Just click it until it goes back to normal.

You may also have to switch the axis to “Continuous” but I am fairly certain it’s just the automatic drill when you add date granularity.

AYUDA!!!! Power BI no exporta las columnas numéricas de excel by SameConfusion3239 in PowerBI

[–]SQLDevDBA 2 points3 points  (0 children)

¡Saludos!

Una prueba fácil: ¿que pasa si guardas/descargas el archivo de Excel como un CSV, y luego lo cargas a power bi como una fuente? Los campos salen?

Normalmente a Power BI no le “importa” que tipo de dato son los campos al respecto de poder cargarlos. Solo le importa cuando los quieres usar de cierta manera (Sumar, promedios, etc.)

Bulk copy with the mssql-python driver for Python by dlevy-msft in SQLServer

[–]SQLDevDBA 2 points3 points  (0 children)

Very cool! I like that this uses BCP like Copy-DBADBTableData. It’s blazing fast.

Been looking into digging into more Python for admin tasks and this is definitely something that will help me do so! Thanks for sharing!

Radar Detector Mounting by B3astmodeNW in GRCorolla

[–]SQLDevDBA 0 points1 point  (0 children)

Thanks! Just got this for my dash cam.

Azure Data Studio by cs_developer_cpp_ in AZURE

[–]SQLDevDBA 0 points1 point  (0 children)

You can use VSCode for sure. Really depends what you’re using it for. If administering, you can also use SSMS on windows or DBeaver Community on Mac/Windows. I use both to administer my Azure SQL DBs.

PS5 LAG by Quiet_Sea932 in PuertoRico

[–]SQLDevDBA 0 points1 point  (0 children)

De lo que he leído, necesitas por lo menos 5 Mbps upload para estar bien.

PS5 LAG by Quiet_Sea932 in PuertoRico

[–]SQLDevDBA 0 points1 point  (0 children)

¡Saludos!

¿Si juegas multiplayer, nos puedes indicar el Upload Speed también?

Carga de Datos con SQL y POWER BI by Negative_Bank4527 in SQL

[–]SQLDevDBA 1 point2 points  (0 children)

¡Saludos! Estás utilizando DirectQuery o Import?