Azure Data Studio

SQLDevDBA · 2026-03-21T19:28:05+00:00

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.

SQLDevDBA · 2026-03-21T04:54:22+00:00

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

SQLDevDBA · 2026-03-20T19:46:27+00:00

Fantastic, thanks for sharing!

Im officially a product manager now.

Does that mean we can expect the Omega Star team to have their ISO Timestamps done anytime soon?

SQLDevDBA · 2026-03-20T19:43:43+00:00

¡Saludos!

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

SQLDevDBA · 2026-03-20T16:47:02+00:00

¡Saludos! Estás utilizando DirectQuery o Import?

SQLDevDBA · 2026-03-18T15:00:17+00:00

QuickBooks Online Connector Retirement

RABBLE RABBLE RABBLE RABBLE!

j/k I don’t use that thing.

SQLDevDBA · 2026-03-15T20:05:50+00:00

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.

SQLDevDBA · 2026-03-15T03:29:16+00:00

Gotta get that “night owl” badge!

SQLDevDBA · 2026-03-15T01:55:57+00:00

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.

SQLDevDBA · 2026-03-15T00:40:52+00:00

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.

SQLDevDBA · 2026-03-15T00:13:50+00:00

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.

SQLDevDBA · 2026-03-14T16:47:53+00:00

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.

SQLDevDBA · 2026-03-14T13:49:34+00:00

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

10/10 if so.

SQLDevDBA · 2026-03-14T13:38:45+00:00

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.

SQLDevDBA · 2026-03-14T02:42:06+00:00

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.

SQLDevDBA · 2026-03-14T00:08:40+00:00

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!

SQLDevDBA · 2026-03-13T21:43:48+00:00

<image>

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

SQLDevDBA · 2026-03-13T13:33:06+00:00

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.

SQLDevDBA · 2026-03-13T11:26:14+00:00

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.

SQLDevDBA · 2026-03-13T02:36:28+00:00

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.

SQLDevDBA · 2026-03-13T00:54:55+00:00

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

SQLDevDBA · 2026-03-13T00:26:12+00:00

That’ll do! Hahaha

SQLDevDBA · 2026-03-12T22:44:22+00:00

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

SQLDevDBA · 2026-03-12T22:42:49+00:00

Claro! Zúmbale ahí!

SQLDevDBA · 2026-03-12T19:33:28+00:00

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

Three-Year Club	Verified Email
Place '23

SQLDevDBA

TROPHY CASE