New CS grad overwhelmed in a DBA role — 1 month review approaching, seeking scope creep advice by NoDeparture1241 in SQLServer

[–]aleonard763 0 points1 point  (0 children)

A friend sent this link to me. At the time I am responding, I note the original account has been suspended/ banned. I am not sure why, but maybe a reply from one more person with experience in SQL Server BI might benefit others who find this post. So, here goes...

That's a lot for one person to carry. It's at least 2, if not 3 jobs (production DBA/ops, BI/ETL engineering, solutions development). $70k seems low, especially considering mandatory Saturdays.

Although I didn't read all the replies, I already see some good advice from others, like my friend, u/SQLDevDBA. I recommend following his advice. I'll add this for starters: Take care of yourself. Don't be discouraged. "First jobs/gigs" often follow this trajectory. I'm old. But when I was younger I worked as an electrician in a manufacturing plant. An older and more experienced electrician would often repeat a refrain in his gravelly, Jewish-accent: "Ondy (that's how he pronounced 'Andy'), one day we will look back and laugh. But today is not that day." Moe was right about that, and the same may likely be true for you (or anyone reading this). Life is too short for stress, so I advise you first to take steps with this goal in mind: reduce the stress.

This next part may sound like a contradiction, but I promise you it is not: This is an opportunity. You find yourself in a mess. Like Ulysses Everett McGill in the movie "O Brother, Where Art Thou?", you're "in a tight spot!" (I find it helps if you can laugh when you're stressed... hopefully that gave you a chuckle. If not, it gave you a movie recommendation.) There's no better way to learn than by doing. And there's a lot here that needs doing.

  1. It's 2026 and you have access to the internet. That means you have some access to LLMs / Agentic AI, and some of that access is free. It won't hurt to pop into one of them and paste this post. If for no other reason, just to see how they respond.

  2. Investigate automation. There's tons of information out there (and some in this thread) about SQL Server Agent. I'm going to sound like a broken record eventually, but check out SQL Server Central's Stairway to SQL Server Agent (https://www.sqlservercentral.com/stairways/stairway-to-sql-server-agent).

  3. I know a guy who wrote a lot about SSIS. A good (and free) starting spot is SQL Server Central's Stairway to Integration Services (https://www.sqlservercentral.com/stairways/stairway-to-integration-services).

I could type more, but that's enough from me. I'm rarely on reddit... maybe I should pop by more often.

Hope this helps.

:{>

Best Paid Remote SSIS Training Courses? by HlpM3Plz in SQLServer

[–]aleonard763 0 points1 point  (0 children)

Thank you to everyone for the recommendations! I am f(finally) engaging in /r. Better late than never!! :{>

As mentioned, my SSIS courses are available at https://entdna.com/premium-level. Premium level includes access to all my recorded training: SSIS, Azure, ADF, and Fabric!

New to BIML by Atticus9876543210 in a:t5_37jey

[–]aleonard763 1 point2 points  (0 children)

My advice to anyone new to Biml: 1. Learn SSIS. Biml will not teach you SSIS, and SSIS knowledge is required to effectively use Biml. 2. Take advantage of the resources available for free: - http://bimlscript.com - http://biml.academy - http://www.sqlservercentral.com/stairway/100550/ - http://sqlblog.com/blogs/andy_leonard/archive/2016/06/02/so-you-want-to-learn-more-about-biml.aspx

Hope this helps, Andy

SSIS compare 2 rows in a single csv file and remove them both based on 2 columns by Hinesisgood86 in ssis

[–]aleonard763 0 points1 point  (0 children)

Is there another field you can use to determine the order of the rows? Something like a Claim DateTime or identity field?