January 16, 2023 at 4:26 pm
I developed and maintain a 'DBA Dashboard' application for internal use in our organization. It allows anyone in IT to view a SPID activity report, disk space and backup history, domain group membership and permissions, etc. It's implemented using HTML and C# (Razor), SQL, and JavaScript. However, if I were ever in the job market again, I probably wouldn't apply for jobs where web development is the primary skillset required. There are way too many open jobs for straight SQL Server developers or DBAs.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 17, 2023 at 2:24 pm
below86 wrote:As someone who started out writing COBOL, and Assembler, it warms my heart that it's a skill in demand.
I mainly use SQL now for everything, using SSIS and SSRS mainly. I haven't learned Python.
I learned Java, JavaScript, HTML and the C variants many years ago. Haven't used any of those skills in years. Back when I did HTML I found the applications that built the HTML for you added so much unneeded garbage I wouldn't use them. This was back around 2000, maybe that's changed.
I know enough VB to get bye on some older jobs that still run.
Long live SQL!! And COBOL 😉
Give Python a try. It's very interesting: https://diveintopython3.net/
I'm sure it is, but I ask why? What is the benefit? What can it do that I can't do in SQL?
Another reason I'm not going to take the time right now is I don't have a project to use it on. I found that if I learn a (computer)language and I only use it a couple times or not at all in the few months of learning it I tend to forget quite a bit of it.
And I don't know of anyone else at my company that knows Python. So I would be stuck maintaining anything that is developed in it.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 17, 2023 at 3:10 pm
Good luck. I believe Blazor uses React syntax, with some C# basis, so I'm guessing as you learn more, you'll be improving your skills in a few ways. My advice is to build something you can showcase on your resume. Show how you built something and make a site that employers can examine to see your skills.
(I hope I get the editing of quotation correct.)
Very good advice, Steve, thank you. I'll have to find something to write an app on and some place to put it. In my current job we don't use npm, which is what's used with React, so I'll have to look around for someplace else.
Kindest Regards, Rod Connect with me on LinkedIn.
January 17, 2023 at 4:05 pm
Blazor doesn't (necessarily) use React or npm (though they can be used together). You can use Blazor server-side and/or client-side (WASM).
Blazor uses the Razor template engine, which allows C# in the markup, somewhat analogous to React's JSX.
January 17, 2023 at 6:33 pm
Python is better for handling data outside of the database. Moving files, cleaning, loading, and for general tasks. Interesting to work with python and Powershell for the same task and compare them. I find some things easier with one or the other.
January 18, 2023 at 8:10 pm
Python is better for handling data outside of the database. Moving files, cleaning, loading, and for general tasks. Interesting to work with python and Powershell for the same task and compare them. I find some things easier with one or the other.
Any files I deal with that are outside a database I bring into a table on the database and deal with it there. I just use SSIS to move the data from the flat file to the database table. I then do any other tasks needed against that data using SQL. So I guess I don't need it now for what I do, but it's good to know.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply