IT/Software career thread: Invert binary trees for dollars.

TJT

TJT

Mr. Poopybutthole
<Gold Donor>
40,921
102,685
Aaron said:
Thanks. I wouldn't want to work at some woke big tech firm. Give me a comfy job at the refrigerator company. I think I'll at least try out Codeacademy or similar to see how good or shit I am.
Click to expand...
My advice would be to start with SQL. SQL is straightforward and beneficial to know in any tech environment. All databases use it.

SQLZOO

This is a good site to get your feet wet about it. It really isn't that complicated but it can be. Sometimes. Site is lightweight and just gives you example data and queries to construct. You'll find that SQL is underlying in most technologies. It's ancient (70s or something) and linear. Start with Python or Javascript (gag) if you'd like. Both are used commonly enough.

I kinda see it like everyone should know SQL, and if you're working in tech you should know at least one scripting language and one full language, in addition to SQL and basic terminal shit you can learn on the job.

SQL -> Python -> Java... smth like this.
 
Last edited:
Aaron

Aaron

Goonsquad Officer
<Bronze Donator>
8,089
17,856
Thanks, I've wondered about SQL for a while. Thanks for all the advice. :)
 
Neranja

Neranja

<Bronze Donator>
2,605
4,143
Quineloe said:
you need to start paying [...] but come to think of it, all of them have university degrees.
Click to expand...
The IHK membership is automatic because of the Meisterzwang, not the other way around.

Quineloe said:
I don't have one of those, I work IT and I don't have her problem.
Click to expand...
I have good news and bad news for you.

The good news is that IT was a booming sector, especially with the spread of the Internet to the normies, so salaries went up because the market demand. During the dotcom bubble I knew of a nurse and a goldsmith that went into the sector (as Adobe Flash programmer and Web designer, respectively), because it paid a lot more than their original jobs. The IT industry was one of the few industries where career changes like that without certificates paid good money.

Now for the bad news: This will change, and employers in Germany (and worldwide) are pushing to make it happen. On one hand they try to clamor there is a shortage of skilled labor to flood the market with young and inexperienced workers, on the other hand there are lots of projects for nearshoring or outright offshoring IT departments. If you can do your work from your home office, then so can a guy from India who bought his diploma.
 
Quineloe

Quineloe

Ahn'Qiraj Raider
6,978
4,463
You have IHK membership even if you start a business in one of the trades that do not have Meisterzwang.

If you can do your work from your home office, then so can a guy from India who bought his diploma.
Click to expand...

I actually can't (onsite contracting for Government and Military installations so they legally can't outsource this to foreigners) so I'm good. The unskilled labor that they can flood our market here with can't compete with me. We've actually had a refugee at my last job who allegedly had real IT training at the Kabul university and the guy knew next to nothing. However the few things he did know did prove his story wasn't made up.
 
TJT

TJT

Mr. Poopybutthole
<Gold Donor>
40,921
102,685
Aaron said:
Thanks, I've wondered about SQL for a while. Thanks for all the advice. :)
Click to expand...
At your service, ask any questions you'd like and remember. There are only dumb people. Not dumb questions.

Move to the discord if you want any in depth questions it'd be more efficient.
 
  • 1Like
Reactions: 1 user
AVTB

AVTB

Vyemm Raider
172
2,050
Odd IT question, IT in the past has bored me, but now I'm at a top hospital as a biomed. As medical devices become more connected the lines between IT and biomedical engineering converge, but IT currently still pays more. I've got an AS in both, 5-years+ xp in IT, 2-years now in biomed which I love, but pays less, what do?

IT has bored me at my past job and now I'm a NICU/mother-baby/woman-child & ESU equipment specialist already at 2-years. Money isn't everything, but it is a factor. I'm not at a ton of money as a freshly minted bmet2, but with OT and on-call pay I'm at like 60k for central FL, so not horrible, not great, but more than I made before Obama sunk my last industry.
 
Ao-

Ao-

¯\_(ツ)_/¯
<WoW Guild Officer>
7,879
507
AVTB said:
Odd IT question, IT in the past has bored me, but now I'm at a top hospital as a biomed. As medical devices become more connected the lines between IT and biomedical engineering converge, but IT currently still pays more. I've got an AS in both, 5-years+ xp in IT, 2-years now in biomed which I love, but pays less, what do?

IT has bored me at my past job and now I'm a NICU/mother-baby/woman-child & ESU equipment specialist already at 2-years. Money isn't everything, but it is a factor. I'm not at a ton of money as a freshly minted bmet2, but with OT and on-call pay I'm at like 60k for central FL, so not horrible, not great, but more than I made before Obama sunk my last industry.
Click to expand...
Go get a job for Medtronic or Boston Scientific making the medical devices.
 
Aychamo BanBan

Aychamo BanBan

<Banned>
6,338
7,144
TJT said:
At your service, ask any questions you'd like and remember. There are only dumb people. Not dumb questions.

Move to the discord if you want any in depth questions it'd be more efficient.
Click to expand...

I'm trying to learn more shit, I'd love to one day be extremely well educated in cyber security / network security, etc. I have basic understanding of programming, but haven't done shit in a really long time. You think Python is a great new language to learn?
 
Ao-

Ao-

¯\_(ツ)_/¯
<WoW Guild Officer>
7,879
507
Falxy-US said:
I'm trying to learn more shit, I'd love to one day be extremely well educated in cyber security / network security, etc. I have basic understanding of programming, but haven't done shit in a really long time. You think Python is a great new language to learn?
Click to expand...
Yes
 
  • 1Like
Reactions: 1 user
TJT

TJT

Mr. Poopybutthole
<Gold Donor>
40,921
102,685
Falxy-US said:
I'm trying to learn more shit, I'd love to one day be extremely well educated in cyber security / network security, etc. I have basic understanding of programming, but haven't done shit in a really long time. You think Python is a great new language to learn?
Click to expand...
Whenever I want to do something quick and dirty. It's python.
 
Quineloe

Quineloe

Ahn'Qiraj Raider
6,978
4,463
I'm looking for official (MOC) courses for entry level Windows Server and SQL Server administration.

Essentially what I'm doing is install our Software on customer servers, it requires IIS with net 4.6 or higher frame work and some other stuff. Sometimes I run into problems with IIS and certificate settings, with other websites already run on the server.

The Software also uses SQL for its database. Problems I run into is being unable to delete the database, not getting the database to install even though the user is registered as DBCreator (or even sysadmin).

I'm looking for two beginner MOCs to cover these as we're now doing this as a team of three and all of us could use this. Anyone know the MOC codes for this off-hand? My coworkers aren't even IT so it has to be the beginnerest beginner course.
 
TJT

TJT

Mr. Poopybutthole
<Gold Donor>
40,921
102,685
Quineloe Quineloe

Unless your team has issues taking actual instruction in English your best bet (that's free) will be random youtube guides and tutorials. Most of the time they are really good. I haven't dealt with RBAC in for SQL server in a long time. Installing SQL server itself will be windows system RBAC and have nothing to do with the database. Unless you mean you have some external file that will load the database to your instance of SQL server or something like that?

Just remember you're not really alone. Master www.stackoverflow.com and wording your question carefully. 99% of the time there will be a detailed answer for what you're trying to do.

To be clear here you're trying to do the following:
  1. Install SQL Server - Windows administrator creds.
  2. Install your software on their shit.
  3. Have this software use SQL server to host its database.
  4. IIS issues - No help here I have almost no experience with it.
Are you getting a permissions error when you try to load the DB? Is the software using a user account to create the DB here or are you doing this manually?
 
Quineloe

Quineloe

Ahn'Qiraj Raider
6,978
4,463
I do want something that costs money where we end up with a valuable piece of paper. Company is paying.

The software is creating it. The last time I ran into an issue and had to forward it to our own external supplies (therefore forfeitting the money we would have made on it - which is a big reason *why* we're getting the courses paid) was this

1612343445827.png
 
TJT

TJT

Mr. Poopybutthole
<Gold Donor>
40,921
102,685
Quineloe said:
I do want something that costs money where we end up with a valuable piece of paper. Company is paying.

The software is creating it. The last time I ran into an issue and had to forward it to our own external supplies (therefore forfeitting the money we would have made on it - which is a big reason *why* we're getting the courses paid) was this

View attachment 332751
Click to expand...
So SQL Server is installed and you can open the SQL Server Manager? You can see all the databases there?

If you go into the actual SQL Server console (Not the manager) it is there that you can see if the server is active and turned on? It looks like thats where you need to look. This error seems to indicate that the connection string is wrong or it isn't what you think it is. The SQL Server Console will tell you this. This is not a RBAC error.

Someone like Phazael Phazael I believe has a lot experience with this kind of thing. Sorry if I added the wrong person.
 
Bullock

Bullock

Molten Core Raider
51
30
The IIS issue sounds like you need to either have each site on a different port or use Server Name Indication in the bindings if you have to use 443.

That last SQL error looks like either the service isnt running or firewall blocking the SQL port?
 
Quineloe

Quineloe

Ahn'Qiraj Raider
6,978
4,463
Bullock said:
The IIS issue sounds like you need to either have each site on a different port or use Server Name Indication in the bindings if you have to use 443.

That last SQL error looks like either the service isnt running or firewall blocking the SQL port?
Click to expand...

Yes some of the words for IIS sound familiar. Unlike SQL I have absolutely no experience with IIS prior to this job.
I've restarted the SQL Service (I think, I also googled how to do that during the session) and it wouldn't budge.

TJT said:
So SQL Server is installed and you can open the SQL Server Manager? You can see all the databases there?

If you go into the actual SQL Server console (Not the manager) it is there that you can see if the server is active and turned on? It looks like thats where you need to look. This error seems to indicate that the connection string is wrong or it isn't what you think it is. The SQL Server Console will tell you this. This is not a RBAC error.

Someone like Phazael Phazael I believe has a lot experience with this kind of thing. Sorry if I added the wrong person.
Click to expand...
When the customer opened the SQL manager he could only see his own user and the sa. He couldn't see all the NT Service logins and ##MS Policy etc. Usually that's a strong warning sign that the user connected to SSMS doesn't have the rights to see or change anything, and that was the case.
He was on default permissions. He didn't know the password for the SA user or any other user with admin rights. He literally had locked himself out of his own SQL server within a day of installing it.

No wait, strike all that, that was a different customer yesterday. I'll not delete it because it was so fucking hilarious to see mr google fu try to break into his own server. But also sad because if I had the inside knowledge I could have reset SA for him. And charged for that. Anyways, back to the original problem.

Yes, we saw everything, the user was sysadmin on the SQL Server. I could delete databases, I could alter permissions and everything. The SQL server was also installed locally on the application server where I was running the msi that creates the database. I've done this part of the installation like a hundred times at this point, and never did I run into a problem like that. Everything seemed in order, permissions were there, correct user was in use, it should have worked. And it did not.

Oh and since I skipped on that part the last time: we don't install SQL for them. That's their infrastructure and therefore their job. Also because we don't have the training to do that. Another reason I'm looking for a MOC we can do. I'd like to be able to install our thing all the way on a blank, new server without having "real IT" preinstall the server features for me.

one more thing: feels odd to browse FOH on company time and actually have it be relevant for the company.
 
TomServo

TomServo

<Bronze Donator>
6,367
8,350
TJT said:
My advice would be to start with SQL. SQL is straightforward and beneficial to know in any tech environment. All databases use it.

SQLZOO

This is a good site to get your feet wet about it. It really isn't that complicated but it can be. Sometimes. Site is lightweight and just gives you example data and queries to construct. You'll find that SQL is underlying in most technologies. It's ancient (70s or something) and linear. Start with Python or Javascript (gag) if you'd like. Both are used commonly enough.

I kinda see it like everyone should know SQL, and if you're working in tech you should know at least one scripting language and one full language, in addition to SQL and basic terminal shit you can learn on the job.

SQL -> Python -> Java... smth like this.
Click to expand...
But what about mongo and dynamo!?
 
  • 1Worf
Reactions: 1 user
TJT

TJT

Mr. Poopybutthole
<Gold Donor>
40,921
102,685
Quineloe said:
Yes some of the words for IIS sound familiar. Unlike SQL I have absolutely no experience with IIS prior to this job.
I've restarted the SQL Service (I think, I also googled how to do that during the session) and it wouldn't budge.


When the customer opened the SQL manager he could only see his own user and the sa. He couldn't see all the NT Service logins and ##MS Policy etc. Usually that's a strong warning sign that the user connected to SSMS doesn't have the rights to see or change anything, and that was the case.
He was on default permissions. He didn't know the password for the SA user or any other user with admin rights. He literally had locked himself out of his own SQL server within a day of installing it.

No wait, strike all that, that was a different customer yesterday. I'll not delete it because it was so fucking hilarious to see mr google fu try to break into his own server. But also sad because if I had the inside knowledge I could have reset SA for him. And charged for that. Anyways, back to the original problem.

Yes, we saw everything, the user was sysadmin on the SQL Server. I could delete databases, I could alter permissions and everything. The SQL server was also installed locally on the application server where I was running the msi that creates the database. I've done this part of the installation like a hundred times at this point, and never did I run into a problem like that. Everything seemed in order, permissions were there, correct user was in use, it should have worked. And it did not.

Oh and since I skipped on that part the last time: we don't install SQL for them. That's their infrastructure and therefore their job. Also because we don't have the training to do that. Another reason I'm looking for a MOC we can do. I'd like to be able to install our thing all the way on a blank, new server without having "real IT" preinstall the server features for me.

one more thing: feels odd to browse FOH on company time and actually have it be relevant for the company.
Click to expand...

It's really looking like this is not an auth issue. If you still think it is try remotely logging into the db with those credentials. If you can't you'll get a clear auth error.

Pretty sure this is config for the servers connection or the softwares connection to the db.
 
Quineloe

Quineloe

Ahn'Qiraj Raider
6,978
4,463
TJT said:
If you still think it is try remotely logging into the db with those credentials. If you can't you'll get a clear auth error.
Click to expand...

I don't know what that means. I know troubleshooting can be pretty interesting and I'll let you know what our experts find out, but this is really just to give a general outline what I do and which MOC we should tell our boss we need is mainly what I'm after.

in unrelated news, the other guy managed to get back into his SQL server (I overheard on the phone him talking to their actual SQL expert and I could actually hear him shake his head as he told the guy that he should just reinstall the whole thing and pay attention this time) and it was smooth sailing.
 
You must log in or register to reply here.