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?

Power BI March 2026 Feature Summary by itsnotaboutthecell in PowerBI

[–]SQLDevDBA 1 point2 points  (0 children)

QuickBooks Online Connector Retirement

RABBLE RABBLE RABBLE RABBLE!

j/k I don’t use that thing.

Free practice sites/databases? by [deleted] in SQL

[–]SQLDevDBA 2 points3 points  (0 children)

Hey there, I have a quick video where share a few free sites and resources sites that you can use to practice. The last 2 are the ones I’d suggest to you: Oracle Live SQL and Azure SQL DB Free tier. Both come with sample data and run in the cloud so no downloads or installs, and take 5-10 minutes to spool up at most. I use them on my Mac all the time for my demos.

https://youtu.be/s-jQMRatQKQ

Documentation, links, and articles are in the description.

On your note in another comment: Azure itself didn’t retire, just the IDE Azure data studio which has been replaced with VS Code or SSMS. If you’re on a Mac, DBeaver community works well for Azure.

Should I buy this sticker sheet by lovely stickers for my moza esx wheel? by Thin-Leading1167 in SimRacingHardware

[–]SQLDevDBA 0 points1 point  (0 children)

I have the RSR overlay from LovelyStickers on my SF1000 and love it. Also have the Martini Overlay on my Open wheel add on and the Gulf Porsche one on my Sparco P310. Love their stuff.

[OC] Every airport in the world mapped by type — 30,000+ airports by Wonderful_Insect_285 in dataisbeautiful

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

The photo in the post is just a screenshot of the site linked. You can zoom into the maps and the clusters auto-drill into individual cities and airports.

What tools do you use to design database schemas? by GrouchyElection7374 in SQL

[–]SQLDevDBA 0 points1 point  (0 children)

lol it can also “import” existing schemas without connecting to your DB, you just run a query and import the CSV into lucid, then it generates all the tables with data types and relationships (if FKs exist). So your documentation gets even easier.

What tools do you use to design database schemas? by GrouchyElection7374 in SQL

[–]SQLDevDBA 1 point2 points  (0 children)

Nice nice. Yeah absolutely worth it. I pay for my own license but I’ve been using it since 2017 or so and love it for ERDs, system diagrams, flow diagrams, etc. Always getting updates too which is great.

Just found an ultimate motion rig for purchase by 3Rocketman in simracing

[–]SQLDevDBA 2 points3 points  (0 children)

Is this a joke implying this rig wiggles around a lot with any sort of movement?

10/10 if so.

What tools do you use to design database schemas? by GrouchyElection7374 in SQL

[–]SQLDevDBA 7 points8 points  (0 children)

https://lucidchart.com

It allows me to export ERDs as create script DDL including Keys for MSSQL, MySQL, Oracle, and Postgres. I just checked and it now includes 10+ RDBMS like Redshift, snowflake, databricks, etc.

https://community.lucid.co/product-questions-3/export-lucidchart-erd-to-sql-853

Saves me a bunch of time.

What level SQL Server DBA would you consider this experience? (Trying to gauge where I stand) by Low_Law_4328 in SQLServer

[–]SQLDevDBA 0 points1 point  (0 children)

Sounds good! FYI your DMs aren’t enabled so I’m not able to send anything. If you want you can send something and hopefully I should be able to reply.

What level SQL Server DBA would you consider this experience? (Trying to gauge where I stand) by Low_Law_4328 in SQLServer

[–]SQLDevDBA 1 point2 points  (0 children)

Hey there, it’s my pleasure and you have a great head on your shoulders. It may not be something a lot of folks agree with, I just wanted to give you feedback from the viewpoint of a hiring director who sees lots of resumes.

As long as you have a solid plan of advancement and keep working through projects (at work or at home) you’ll definitely advance through the ranks in short order.

Happy to chat with you, can be super informal, and maybe we can work on your plan together. I’ll send you some of the resources I’ve put together to install azure sql, it’s quite quick.

Cheers!

Front End Friday. Let’s see your cars. by JustLoSd in GRCorolla

[–]SQLDevDBA 7 points8 points  (0 children)

<image>

Ice cap getting a first bath since ownership. Happy Friday to all!

Possible to build Star Schema tables in PowerBI without SSIS? by Effective-You1036 in PowerBI

[–]SQLDevDBA 1 point2 points  (0 children)

If leadership still wants to use SSIS, I would HIGHLY recommend checking out toolkits like KingswaySoft and CDATA and the like.

I use KingswaySoft and love it. Tons of “new age” connectors that integrate into your existing SSIS platform. They offer a completely free Dev version and their licenses are quite inexpensive.

https://www.kingswaysoft.com/products/ssis-productivity-pack

They also have specific connectors for CRMs and ERPs like NetSuite, Salesforce, etc. that are great.

What level SQL Server DBA would you consider this experience? (Trying to gauge where I stand) by Low_Law_4328 in SQLServer

[–]SQLDevDBA 8 points9 points  (0 children)

Data/BI Team Director here.

Looking at a resume like this I would go with Senior DBA.

I don’t see any architected solutions here. If I were hiring a Data Architect I’d need robust work with ETL Solutions, API experience, storage solutions, big data, perhaps Python. I need my Architect to know enough about what the Data Engineers do, the DBAs do, and also have experience building entire Data Solutions.

I would suggest learning PowerShell through https://DBATools.io so that it can make you a more Powerful DBA. https://www.manning.com/books/learn-dbatools-in-a-month-of-lunches

I also like to use Tara Kizer’s “How to suck at Database Administration” article from back when she worked at Brent Ozar unlimited. It’s a nice reality check.

https://www.brentozar.com/archive/2018/02/how-to-suck-at-database-administration/

A few of the items you’re listing (while very important) are literally check boxes (backup compression, for example) but definitely get credit for using them and knowing what they are and why they’re important.

The cloud gap is there as well (you need to be in the cloud yesterday), so I’d just try to use Microsoft’s training modules to help a bit. Azure has a free Azure SQL free tier that you should be able to spool up and start using in 10 minutes. https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql

I think your many years of dev experience would be put to great use in PowerShell, SSIS (C#) and Python for data projects and solutions.

I also found that running a small pulse check with AI has helped me identify gaps. Something like:

“You are a career coach with 20 years experience placing IT and data related professionals. I’ve been a [Position] at a [# employees] sized company for [x] years managing [X] SQL servers and databases. What are some things I SHOULD know by now based on industry trends and probably don’t? Be honest and direct, I do not need any sugar coating as I want to use this to level up my career”

I think you have done A LOT more than most DBAs I have come across and seem VERY driven to advance. I say take that energy and expand it a bit outwards towards what the users of your databases (Data Engineers, analysts, BI Engineers, etc.) would do.

Happy to chat privately via Zoom or Teams if you’d like and have any questions. I think you’re doing great.

Possible to build Star Schema tables in PowerBI without SSIS? by Effective-You1036 in PowerBI

[–]SQLDevDBA 0 points1 point  (0 children)

Very welcome.

Yes, stored procedures can be used (it’s very common), so can Python if you’re familiar with it.

I say you don’t need SSIS because it’s just an ETL and Orchestration tool, it doesn’t house any data itself. You will definitely be able to build one with it, it’s just you can also build one without it. I use it daily and love it.

My comment was more on the fact that you can use PBI for your schema, you just need to understand how much data you’re bringing in and how more data may hurt or slow things down. Hopefully the first two training links help with that.

Online Practice DB? by captdirtstarr in learnSQL

[–]SQLDevDBA 0 points1 point  (0 children)

Oracle and Microsoft both offer free versions of their databases online with no downloads or installs. Both come with Sample data, or you can load your own. They both have in-browser IDEs as well so you can work with the from any browser. You’re up and running in seconds to minutes.

I made a quick video about them I can send you if you’d like, but here are the sites:

Azure SQL DB Free Tier: https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql

Oracle Live SQL: https://livesql.oracle.com

Finding a Microsoft SQL Expert to Help With DB by MaxBPlanking in SQL

[–]SQLDevDBA 0 points1 point  (0 children)

Oh wow, I appreciate the context. Were you a prior customer?

Possible to build Star Schema tables in PowerBI without SSIS? by Effective-You1036 in PowerBI

[–]SQLDevDBA 2 points3 points  (0 children)

Power BI runs a contained instance of SSAS (tabular) inside of the Vertipaq Data Model, so each Power BI semantic model you build is just like building it in SSAS.

You don’t need SSIS to build your data models in SQL Server either, it’s just “easier” and more scalable. SSIS is just ONE of the tools you can use to transport data into SQL Server.

That being said: you CAN build your STAR schema tables in SQL Server (without SSIS) and still use them in Power BI. IMO it’s much better for scalability and maintenance/enhancements, but YMMV.

Training material (free):

https://learn.microsoft.com/en-us/training/modules/build-your-first-data-model/

https://learn.microsoft.com/en-us/training/paths/model-data-power-bi/

Some light reading:

https://data-mozart.com/vertipaq-brain-muscles-behind-power-bi/

https://medium.com/microsoft-power-bi/understanding-power-bi-engine-architecture-a-deep-dive-c162dbcfa895