So...Today I found an SQLI (sql injection , google if you're not aware) in one of our products , I start exploring it , I get my trusty Kali on me workstation . sqlmap etc. Tell my manager it's a true positive... I start exploring the db , half the devs at my manager's place start staring at his screen as I proper fuck a QA db server... I hear a qa guy mention triangulation as sqlmap dumps a uid table in his face . I hear my manager's manager saying 'this has been in our app for so long and we found it just now ? Who found it ?' *manager proudly saying me name* 'He's still working this late ?' ...apparently now my trip to england is getting covered for both me and me gf by the company...

My school.

We have free WiFi access, but you need to login into your personal student account to use it.

Turns out, SQL Injection works.
It gets worse.
Table name "schueler".
SELECT *
Well.
Got all data on all students.
Name, address, phone number, passwords in plain.

I reported it using an anonymous email. Partially fixed. Standard quotes now get eacaped. Still, passwords are now MD5.

Looks like my manager got the deluxe hardcover edition

*Cries in unsanitized SQL*

My boss typed up a GitLab ticket that looked like it took at least an hour to make. Screenshots, diagrams, how to reproduce the bug, dreams, hopes, desires, dinner recipes, marriage advice, how to diversify a portfolio. Honestly, the whole 9 yards.

The bug fix was changing a SQL Inner Join to a Left Join. 10 seconds.

I had just started my new job and deleted 3 years of data that the client had spent over £450,000 collecting 😱

another developer used my PC to quickly access the clients database while I was out the room as I had sql management studio open. I went back to my PC thinking I was connected to my local database, did a few truncate tables to test my software and :0 minutes later I get a call asking why there was no data on the server!

Thank god for backups 😓

What my experience was like learning SQL and server side stuff at my University

Developer: Can you upgrade my machine to Windows 10? I need it for SQL server 2019.

IT Guy: Sure.

Some time later...

IT Guy: Good news, Windows 10 is loaded. Bad news, I need to update TPM to enable Bitlocker but the firewall is blocking me from downloading the update. I will need to download it from home tonight.

Developer: But you're the IT administrator...

IT Guy: Yes...

Developer: ...

It's 2017, I've got a bird on my shoulder and a stressball on my desk, everything is alright.

( I should be working on that SQL statements I generated instead of writing them out right now)
Just one more thing
I ♥️ DevRant

Had to do a course on database design a couple of years ago. One exercise was about SQL queries and a bit of theory of databases.
On the night of the submission I got so drunk that I had to use both hands to control the mouse and instead of my solution I uploaded the exercise description.

Being a student this was how my colleagues felt about my code and SQL procedures. They didn’t even let me create a change ticket to present to CAB 😂

Every hour or so someone shows up at my desk requesting a query to be executed.

I feel like I'm just a human-sql interface.

Our website once had it’s config file (“old” .cgi app) open and available if you knew the file name. It was ‘obfuscated’ with the file name “Name of the cgi executable”.txt. So browsing, browsing.cgi, config file was browsing.txt.
After discovering the sql server admin password in plain text and reporting it to the VP, he called a meeting.
VP: “I have a report that you are storing the server admin password in plain text.”
WebMgr: “No, that is not correct.”
Me: “Um, yes it is, or we wouldn’t be here.”
WebMgr: “It’s not a network server administrator, it’s SQL Server’s SA account. Completely secure since that login has no access to the network.”
<VP looks over at me>
VP: “Oh..I was not told *that* detail.”
Me: “Um, that doesn’t matter, we shouldn’t have any login password in plain text, anywhere. Besides, the SA account has full access to the entire database. Someone could drop tables, get customer data, even access credit card data.”
WebMgr: “You are blowing all this out of proportion. There is no way anyone could do that.”
Me: “Uh, two weeks ago I discovered the catalog page was sending raw SQL from javascript. All anyone had to do was inject a semicolon and add whatever they wanted.”
WebMgr: “Who would do that? They would have to know a lot about our systems in order to do any real damage.”
VP: “Yes, it would have to be someone in our department looking to do some damage.”
<both the VP and WebMgr look at me>
Me: “Open your browser and search on SQL Injection.”
<VP searches on SQL Injection..few seconds pass>
VP: “Oh my, this is disturbing. I did not know SQL injection was such a problem. I want all SQL removed from javascript and passwords removed from the text files.”
WebMgr: “Our team is already removing the SQL, but our apps need to read the SQL server login and password from a config file. I don’t know why this is such a big deal. The file is read-only and protected by IIS. You can’t even read it from a browser.”
VP: “Well, if it’s secured, I suppose it is OK.”
Me: “Open your browser and navigate to … browse.txt”
VP: “Oh my, there it is.”
WebMgr: “You can only see it because your laptop had administrative privileges. Anyone outside our network cannot access the file.”
VP: “OK, that makes sense. As long as IIS is securing the file …”
Me: “No..no..no.. I can’t believe this. The screen shot I sent yesterday was from my home laptop showing the file is publicly available.”
WebMgr: “But you are probably an admin on the laptop.”
<couple of awkward seconds of silence…then the light comes on>
VP: “OK, I’m stopping this meeting. I want all admin users and passwords removed from the site by the end of the day.”

Took a little longer than a day, but after reviewing what the web team changed:
- They did remove the SQL Server SA account, but replaced it with another account with full admin privileges.
- Replaced the “App Name”.txt with centrally located config file at C:\Inetpub\wwwroot\config.txt (hard-coded in the app)
When I brought this up again with my manager..
Mgr: “Yea, I know, it sucks. WebMgr showed the VP the config file was not accessible by the web site and it wasn’t using the SA password. He was satisfied by that. Web site is looking to beat projections again by 15%, so WebMgr told the other VPs that another disruption from a developer could jeopardize the quarterly numbers. I’d keep my head down for a while.”

When I get home, my wife will probably tell me about all the fun things she did with the kids today. She'll tell me about all the frustrating things they did too and stories about how they made her almost pull her own hair out.

Then 20 minutes later she'll ask me how my day was and I'll say, "Oh, I dunno. I worked on a really hard SQL query today..."

Lol this guy literally asked me to use My OWN sql

You know you've had to deal with a tough database problem at work when you start seeing SQL in your own kitchen... (It says SOL meaning salt)

P.s. I sure hope this is how these memes work, because I want my avatar

Being one of the top devs (and a good student admired by most lecturers) at college, my most humbling experience was when I joined my first job. I thought I knew SQL, I thought I knew C#. I realized in the first week, the thing I didn't know was "I don't know jack".
Thanks to a couple of great mentors (it took a few of them to bring me up to speed :P), I learned that the more I learn something, the more I will realize how much more there is to learn. I used tools to create storyboard animations in WPF, and my mentor would write it all in XAML! I'd write messy SQL and the other mentor just reduces it to a couple of elegant lines. They were like tech gods to my college self, all while being humble and friendly.
They also imbibed in me a sense of responsibility to carry on the culture of mentoring my juniors, which taught me much more than just the technical side of our profession.

My wife. She's also my best friend.

Back then, when we were just flirting, I helped her and her friends(they were all medicine students) with their programming courses which included sql and html. I guess that help led us the way we're here now.

Generating SQL scripts using Excel. That's the practice at my company.

Hi everyone, I'm new here but I liked the posts so I thought I'd chip in. Here's a picture of my home office.

I'm currently brushing up on SQL and Java in my internship while I await graduation at the end of the year. Java>C# IMO. C++ is my first love but nobody wants to hire for it anymore.

To everyone who's worked in Java, Eclipse or Intellij IDEA and why? (I mostly use Eclipse because the internship requires it).

I hope to have fun here, so please give me a warm welcome or a rant.

Intelligence and ability cannot be measured by education.

I have a client who asked a Master in Computer Science to develop a small system, for querying product title and their code. The guy used python, vanilla js, and... Txt file for the "database". Then my client asked me to integrated this in... WordPress.

This was in 2016. And idiot as I'm, I agreed and adapted his code to use php and a database.

April this year, my client said they are still using the python system to add new products all this time, in parallel. And wanted to update the WordPress with the data.

- No problem! - I said. Just send me the SQL file.

So the Master in CS sent me a SQL coded in ANSI. I asked for the SQL again, but with a more appropriate encoding. He took 1 month to reply back, and said it would be better if I get rid of the database and just use the txt file for querying.

This is outrageous.

I really hate people who are educated but completely useless.

So today my gf wanted to know if I, a software developer, know anything about SQL.

Adorable. 😍

Not that i mean any disrespect but fuck you. Fuck you and all that you stand for. No seriously, just go hit a train and die.
You are a DBMS teacher in an Engineering college and teaching to the Computer Science students in the year 2017, where computers are fully capable of playing sports and simulating human brain.
And you want your students to write down all the sql queries along with their monolithic tabular output on paper..... With pen?
And you wont accept my printed out output?
Fuck you from the depths of my heart.
Go ahead and dont accept my project.
I dont need your fucking credits.

Probably a little OCD on my part, but when colleagues write SQL keywords in lowercase

Front end + back end = Project finished.

This is my first full stack application that I spent a month working on. It's a basic database that holds car information and saves it to a SQL db. I built this using Java Spring/Hibernate for my backend and Node.JS/REACT for my front end. Mariadb handles SQL requests. REACT handles token requests for secure login, that was the hardest part of this whole thing.

I was going to comment on how frequently I feel like garbage and an inadequate excuse of a human being, but today is my birthday and this is the best gift I could get, a finished project from scratch.

I'm 29 today devRant. And I work over the weekend before going back to school, but at least I fucking finished something that I started.

...thanks, for everything. 😄

Guy I work with: Hey can I borrow you for a minute

Me: sure. What do you need?

Him: so this is a project me an the other dev worked on

Me thinking: Well I know he did it all and sent you the project so don't tell me you worked on it

Him: so we use it to do this and this and send an email to this new account I made because (2 minute explanation)

Me thinking: I don't care. Just tell me what your issue is! I already know what it is and does from what you told me the last time when you showed me. Which took an hour of my time.

Him: so he sent me this code which is called <Descriptive name> and in the method we have variables call <descriptive name> and it returns a <variable name>

Me thinking: You mother fucker! I don't give a shit what your method is named, what it the variable names are, and you don't need to read through every line of code to me! Just from the descriptive name you just said I know what it does! What the fuck is your issue!?

Him: we also have these other methods. This one is called <Descriptive name> which does...

Me: are you fucking seriously going to read me your code line by line and tell me what you named your variables AGAIN!?

Him: and we named this one <descriptive name>

Me: you mother fucker...

Him: and it calls this stored procedure. (Literally opens the stored procedure and shows me) and it is called...which has parameters called... And it is a select query that inserts

45 minutes later after he finishes explaining all 3 pages of his code and his 5 stored procedures that the other dev wrote...

Him: So anyway, back to this method. I need to know where to put this method. The other dev said to put it in this file, but where do you think I should put it in here? Should I place it after this last one or before it?

Me thinking: You fucking wasted my fucking time just to ask where to place your mother fucking method that the other dev sent to you in a project with only 3 files, all less than 500 lines of code with comments and regions that actually tell you what you should put there and 5 small stored procedures that were not even relevant to your issue! Why the fuck did you need to treat me as a rubber ducky which would fly away if you did have one because you didn't have an issue, you just didn't know where to put your fucking code! FUCK YOUR METHOD!

Me: Where ever you want

Him: Well I think it won't work if I placed it before this method.

I walked away after that. What a waste of time and an insult to my skills and really unchallenging. He's been coding for years and still can't understand anything code related. I'm tired if helping him. Every time he needs something he always has to read through and explain his shit just to ask me things like this. One time he asked me what to name his variable and another his project. More recently he asked why he couldn't get his project he found online to work. The error clearly stated he needed to use c# 7. His initial solution was to change his sql connection string. 😑

He should just go back to setting up computers and fixing printers. At least then he would never be in the office to bug me or the other dev with things like this.

So DevRant asked me to put my skills on my profile, I'm like:

you wanna know my languages, well, I'm a human Android sipping on Java, got C++ grade phy-SQL education. but some idiot bashed me on my </head> so swift, that I objectively-c angular stars, everywhere. Recoved by a js injection. ASCII too in snowy Cs

I recalled a seemingly simple task I took on.

We were building a booking system, and I had to figure out how to retrieve bookings by a certain date range.

Upfront, the tasked seemed simple until I realised I had to both figure out the logic and the SQL statements needed to retrieve all bookings within a certain date range in one query.

I ended up drawing a model to help me visualise the various date-range criteria to be satisfied. And used unit tests to help me think through each date range criterion and make sure they were accurate. Some were obviously from paranoia, but better to be safe than sorry...

After that, I had wrote down raw SQL directly into Sequel Pro first to make sure my query logic was accurate too, before translating into something the ORM equivalent. This was when I learned how to define and use variables in SQL. The variables were throw-away code; I just didn't want to have to hard-code the test date-ranges over and over again; minimise chances of spelling errors.

Needless to say, felt my problem-solving skills went up one level after this task. Saw my coding style and unit tests improve. And also the thought processes that go into how to maintain code quality...

At work for a bank, I changed the target SQL Server in my SSIS project and arbitrarily, all my custom-coded scripts were erased!!

I didn't take backups and I spent a week coding them! Fuuuuuuuuuckkkkk 😠

Ended up rewriting them.

I learned my lesson... 😥

So my marketing dept request us to perform a SQL injection to someone's bank account. I refuse to do it.

1. Most bank no longer use Relational Database , they use something like NoSQL Database.

2. Even if the bank Use Relational Database system, I assume their security must be high, validating my session maybe...

3. I am not going to do shit like this for illegal purposes, well this task sounds super illegal to me

4. Hacking is not a part of my job description. I was hired to be a Senior Fullstack Mobile App Developer.

This is screwed up !

Today my boss told me that i missed the '*' in the delete from x SQL query..

!rant

We just did a massive update to our prod db environment that would implicate damn near all system in our servers....on a friday.

Luckily for us, our DB is a badass rockstar mfking hero that was planning this shit for a little over a year with the assistance of yours truly as backup following the man's lead...and even then I didn't do SHIT

My boy did great, tested everything and the switch was effortless, fast (considering that it went on during working hours) and painless.

I salute my mfking dude, if i make my own company I am stealing this mfker. Homie speaks in SQL, homie was prolly there when SQL was invented and was already speaking in sql before shit was even set in spec, homie can take a glance at a huge db and already cast his opinion before looking at the design and architecture, homie was Data Science before data science was a thing.

Homie is my man crush on the number one spot putting mfking henry cavill on second place.

Homie wakes up and pisses greatness.

Homie is the man. Hope yall have the same mfking homie as I do

Unaware that this had been occurring for while, DBA manager walks into our cube area:

DBAMgr-Scott: "DBA-Kelly told me you still having problems connecting to the new staging servers?"
Dev-Carl: "Yea, still getting access denied. Same problem we've been having for a couple of weeks"
DBAMgr-Scott: "Damn it, I hate you. I got to have Kelly working with data warehouse project. I guess I've got to start working on fixing this problem."
Dev-Carl: "Ha ha..sorry. I've checked everything. Its definitely something on the sql server side."
DBAMgr-Scott: "I guess my day is shot. I've got to talk to the network admin, when I get back, lets put our heads together and figure this out."
<Scott leaves>
Me: "A permissions issue on staging? All my stuff is working fine and been working fine for a long while."
Dev-Carl: "Yea, there is nothing different about any of the other environments."
Me: "That doesn't sound right. What's the error?"
Dev-Carl: "Permissions"
Me: "No, the actual exception, never mind, I'll look it up in Splunk."
<in about 30 seconds, I find the actual exception, Win32Exception: Access is denied in OpenSqlFileStream, a little google-fu and .. >
Me: "Is the service using Windows authentication or SQL authentication?"
Dev-Carl: "SQL authentication."
Me: "Switch it to windows authentication"
<Dev-Carl changes authentication...service works like a charm>
Dev-Carl: "OMG, it worked! We've been working on this problem for almost two weeks and it only took you 30 seconds."
Me: "Now that it works, and the service had been working, what changed?"
Dev-Carl: "Oh..look at that, Dev-Jake changed the connection string two weeks ago. Weird. Thanks for your help."
<My brain is screaming "YOU NEVER THOUGHT TO LOOK FOR WHAT CHANGED!!!"
Me: "I'm happy I could help."

Jason Bourne movie:
"Use SQL to corrupt their database!"

In my head: "Seriously? That's like saying 'Use a computer to hack them!', 5 bucks says someone is going to say "ENHANCE" on a blurry photo."

3 Min later. 'ENHANCE!'"

Why are all my classmates building their web applications in PHP for our thesis? I know it's used a lot but for smaller projects there's tons of better ways to build a web application. Besides myself and another guy in this class (I'm using Java and mongoDB, he's working in ASP.NET and Microsoft SQL), nobody else wants to use something different. We only did PHP in one class so this seriously can't be the only language 2/3rd's the class knows.

Oh God it probably is.

Business User [1 PM]: So I know every month you’ve been using your dark magic SQL skills to transform my monthly data into better monthly data.

Well I know it’s the middle of the month, and this is totally random... but... I have some other data formatted totally differently, almost totally different data! You can just run this through your magic SQL Proc right?? Easy! Also, I need this by end of day... thank you for your support.

Me [1:01 PM]: K.

So my boss copied a code from stackoverflow and thought "foo" was a function or something... It was just an alias to a SQL select...

My Database Teacher writes the SQL commands in lowercase. It really grinds my gears.

!rant
In my Software Engineering II class, our teacher begins a overview of NoSQL DBs. A buddy of mine leans over and asks me "A SQL DB walks into a NoSQL bar, do you know why he left?"
I said, "No idea".
He said, "Because there were no tables".
Our teacher heard me laugh, so my buddy had to explain the joke to the entire class. Needless to say, the whole class got a kick out of it!

Got hired as an SSRS engineer. Walked into work day 1 thinking I was a bad ass with my SQL joes2pros knowledge and quickly (and i mean quickly) got smacked down with what real SQL procs look like........should've renamed my title to SSRS reverse-engineer. Good times.

I was curious what's the current demand ranking of programming languages and found this. Calling SQL a programming language and putting iOS instead of Swift makes the ranking not credible in my opinion.

MY OWN SQL !

TLDR: Skills and background or dedication for becoming a good programmer?

So I almost finished the bootcamp on my company, there is only 2 people. Me and another guy who is from math major. He wanted to learn programming so he applied for the job. He doen’t know sql, any backend language, and not even html or css when he joined. The only thing he knew is for looping and if condition logic. He survived 1 months or so by learning a lot here. C#, .net mvc, sql, decent css and html. I believe he worked hard by learning it by himself. But the company he can’t continue anymore. I doesn’t know the reason but probably because he is seen as not good enough. Sure he is kinda slow when adding some feature to our small project but we need to find how to do it by ourself mostly. Now I’m alone with another few weeks to continue

My worst dev sin was leaving out the 'WHERE' in a SQL update statement on a production database

Set every booking to be owned by the same sales consultant 👀

!rant

Went to see my brother today. Before I could say hi, I saw the following:

- Desktop, Windows playing video
- Thinkpad, Linux mint, Arduino IDE
- Arduino board with some sensors
- Coffee
- Complaining about light theme

I've only thought him a bit of C# and SQL. They grow up so fast :')

(Before today, I only knew he was gonna learn Python)

My CS teacher uses html 4 spec that has shit like <strong> and <font size=5> and all sorts of inline garbage. She writes the tags in ALL CAPS and it honestly looks like SQL had a baby with brainfuck. I can't handle this shit anymore. She feels like she's apparently very good at programming and has just been promoted to the School's CS HOD (Head of Department). I have no idea what to do I go to school everyday having to face her mutilating my interest in programming. My peers are all incompetent and don't care at all. Don't get me started on how she writes Python. What the fk man.

According to my predecessor, nothing showcases your SQL skills quite like generating the entire page (markup, JavaScript and all) from a single 2500 line query.

My resolution for this year:

- learn PHP
- advance at JavaScript and figure out what's so cool about react.js
- be a pro with SQL and learn PostgreSQL
- build couple cool hardware projects with Raspberry Pi and Arduino based on C.

So, apparently the legacy code I'm told to maintain at work requires me to add a windows user via control panel to my PC for SQL database to work.

Hah!
I just broke my record and generated (not exported or imported) the biggest SQL file!
A massive 15.7GB SQL file monster.

I hope the import will go well.

Currently, I am going through a legacy application built in microsoft access back in 90s.

* No Comments
* No Relationships between tables
* Random code that does nothing
* Weird form layouts
* Weird naming conventions

I need to copy this functionality into modern version using SQL Server Management studio and asp.net core, I also need to kill myself because none of this fucking shit fucking fuck makes sense.

I do my best to write clean and concise code along with comments but after this ordeal I am going to up my game because nobody should need to suffer through spaghetti code and stupid logic that is uncommented.

😶

**Me, while working on sql based project**

Manager: Does anyone knows java! Want a sample login screen written in java.

**I'm the only one in my team to know java, thus raised my hand**

Me: It's done. Mailed you the .java file.

Manager: I can see my password

Me: I fuckn hate myself. ***Forgot to set password field as password type***

Manager: you are no different than others.

Me: Yeah..😶 **f@#& you**

Today I looked at some code from our CTO. He used plain SQL Statements with huge selects and no prepared statements.

I asked him:
1. why dont you build some helpers or even use some frameworks?
2. why are there no prepared statements?

His answer (to both questions)
We do not need that. That just uses too much ressources and time. It's more cleaner and simpler this way.

My Face: 😵

My first time working with Java and SQL queries(SQL with little/no knowledge): created separate db for each entities and hoped it to work together after the coding was finished.

what a noob!

I was supporting a legacy CRM app which front end used Visual Basic 6 and almost the entire business logic was written on SQL store procedures.

A "feature" of the product was the open code, anyone with admin access could modify forms, code and store procedures.

We also sold "official" (and expensive) consulting services to modify the code.

A long time customer owned this thing and it was heavily customized. They had hired us to change something, hired a third party to make other changes and decided to modify some stuff themselves because, why not?

Suddenly they came to product support asking to fix a bug. The problem happened on a non customized form.

After reviewing, I realized the form used several of the modified store procedures in the business layer. I tried saying we don't support custom code but my boss was being pushed and said "look into it"

All 3 parties denied responsibility and said their changes were NOT the problem (of course). Neither of them commented or documented their changes.

The customer started to threaten to sue us.

I spent 5 full days following every field on the form through the nested and recurrent SQL store procedures and turns out it was a very simple error. A failed insert statement.

I was puzzled of why the thing didn't throw any error even while debugging. Turns out in SQL 2003 (this was a while ago) someone used a print line statement and SQL stopped throwing errors to the console. I can only assume "printing" in SQL empties the buffered error which would be shown in the console.

I removed the print statement and the error showed up, we fixed it and didn't get sued
:)

I thought most developers were aware of the dangers of interpolating variables into strings in the context of SQL queries, but apparently some people are oblivious.

`SELECT * FROM USERS WHERE USERNAME = ${username}`

My username is ' ' OR 1=1;

I got a ASP.NET and SQL test today from my bootcamp

Wish me luck devranters

My first rant/story

> 3 years ago company x decides to pay for my software dev degree

> fast forward to today.. x has no idea what I've learned as they never asked..(basically java,php,sql,android)

> x gives me a contract 1 week before my final exams and expects me to work everyday except exam days..

>next day, a dev contacts me - 'oh please brush up on your Vue, Node, angular as well as laravel php framework'

>I've never touched any of those xD fml.. what to do!?

At a Magic: the Gathering prerelease tournament (yeah, yeah, stereotypes), on my phone, with a pen and paper copy of the SQL query, as the phone screen was too small to read it properly in full. Managed to fix the bug in the query about 30 seconds before the next game started.

The debugging went well, but the tournament did not; I think I was a bit distracted!!

I hate SQL Server so much, don't matter how Microsoft say they improve themselves at SQL Server.

There's a lot of fucking bloat, messes your system and your services, adds tons of crap in your system registry, while more advanced SQL engines such MariaDB/PostgreSQL are more contained, and its very small.

Why SQL Server has to mess with Windows' ACL and his own privilege systems?.

Uninstall it and a lot of components remain hidden and tons of registry entries, not even TotalUninstaller or CCleaner can help.

I hate it since my technical high school and my goddamn college is forcing us to use SQL Sever for EVERYTHING, instead of good alternatives, messed my computer entirely requiring to format.

I try always to convince my freelance clients to use open-source alternatives, and say how SQL Server is so crap, (i had variant degrees of success).

Since the past 7 months I was working on a project coded in C++ and shell script.

Today I was shifted to a project where I'm required to code in JavaScript and SQL.

I can't differentiate between my head and a scrambled egg.

Nothing like a SQL Script failing and fucking up an important Database right before my christmas vacation...

I find a poor tester copy/pasting data from the test environment to the live one, as he accidentally broke it. I ask the DBA, " why isn't syncing SQL records part of the deployment pipeline?"

"You're front end. This is my job. Go do your job."

"... but it's an easy query, and you're exposing us to human error."

"You need to go sit down."

Taking a database class, prof insists on using Microsoft Sql server 2014. "Okay cool" said the Microsoft surface fan boy inside me as I installed it. "Holy shit this is using 6 fucking GBs?? Eh it's okay I trust" again said my Microsoft fanboy self. Finished installing, makes queries and it works. Cool.

Go to run Sql server again next day and get an error (nothing displayed, just a box pop up and then a crash) I use some Google skills. Change a bunch of shit and still it persists. "Just uninstall it and reinstall again" says my prof. I do so except random errors during installation saying Sql already exists even though I just uninstalled it. "Maybe it's some registry keys messing with it!" do some digging, remove unneeded registry keys and try again. Installation finished but a whack of features say failed to install.

I sit and try to work this shit out for the next four hours (not paying attention to my class) and still can't get Sql to completely uninstall itself. I try iobit uninstaller, command line uninstalling, fucking everything but still not working. Slowly my fanboy side is wishing that the windows symbol on the back of my machine was an apple.

I ended up having to backup all my files and reinstalling windows to get it working properly. Holy sweet fuck. The worst part is when this class is done ill probably need to reinstall yet again to save the 6gb it's sucking up. So if you're not sure whether you need something as heavy as Microsoft Sql server or not for your application, don't use it! It's a fucking virus that is super difficult to remove.

Tldr: life long Microsoft fanboy becomes apple convert in a day of using Microsoft Sql server.

I try and try and try to teach my coworker critical thinking skills, proper programming techniques, and standard git etiquette. Then I add 4 booleans to solve one problem, use strings instead of ints to find unique SQL Server entities, and push right to the development branch.

I am a real asshole, but at least I am not fake.

Do simple Windows apps need space this much? The bulky stuff that Visual Studio and SQL Management Studio put on my machine are already pissing me off and now this? Fuck.

a quote of todays daily standup:

"<other guy>, did you had time to investigate that disastrous SQL query. I had no time, one of my horses was giving birth"

SQL Rule 1. Always assume there are external processes that might affect your data. (for instance, triggers).
SQL Rule 2. In Denormalised data, never execute logic on dependant table values, always copy from the parent.
SQL Rule 3. When Denormalised data schemas are created the DBA knows what they are doing.
SQL Rule 3.1. If DBA knows what they is doing then according to Rule 1 there is no problem with adding in some triggers to maintain data clones as they are created.
SQL Rule 4. If you don't like or agree with triggers, deal with it. They are a first class tool in a first class RDBMS. In a multi-app or service environment there may be many other external processes massaging your data
SQL Rule 5. If all previous rules are not broken and the system has been running efficiently for many years DO NOT complain that there are triggers in the database that are doing and have been doing the same process that you just butchered (by violating Rule 1 and 2) in your makeshift "hello world, look what I can do from my phone" angular BS when the rest of the users are still relying on the existing runtime app.
SQL Rule 6. If you turn my triggers off, you sure as hell better turn them back on!

Hired a new BI developer. She tested reasonably ok in SQL, and certainly showed good strengths in visualising data, plus had a good attitude in the interview. We hired her. She broke her laptop the first day. We got her another then she complained the camera didn't work but didn't realise the lever in front of the camera was to move the privacy shutter off and on.

Assigned her some work of taking queries that are used in a BI tool that targets the transactional database directly, and re-jigging them for Snowflake which we're using as a data warehouse now, aggregating all our data into one place. Yet, she's struggling to understand why the SQL query she's pasted in doesn't work as-is.

I go over it again; the source schemas and tables are this, but in Snowflake we've named them this. She then bemoans how much work that is to change them all - I say use find and replace. She then struggles with Snowflake syntax errors and asks for a guide on T-SQL to Snowflake. I show her Google and say "this is what I did when I hit these problems - search for 'Snowflake equivalent to T-SQL getdate()' or 'how to get current date in Snowflake' but she still doesn't understand. I ask if she's every had to work between T-SQL and MySQL or MySQL and PostgreSQL or Oracle and so on and she says yes. I say the syntax isn't the same, is it? And she goes oh, now I understand.

She scored reasonably in her SQL test but I'm now concerned there's something fundamental missing in her grasp of SQL. I gave her a detailed demo of the tools, I explained in the interview and on her start about our move to a data warehouse for all our apps, and put her through some training plus gave her time to work through our Confluence pages - not expecting she'll remember everything, but more to ensure she recalls they exist and what the general contents are.

Anyhow, that's my rant.

When you go at your first IT internship and you realize that a SQL database could be way bigger that anything you could had imagined.

Then I showed the schema to one of my database engineer friend and he laughed at me. :(

So, part of my job is working with SQL. Not my favorite technology to work with. But the tables have mostly non-descript fields, multiple schemas in the same table, and encoded relationships spanning multiple tables. Yes, the database from hell! On top of that, there is very little documentation on this mess. -- And my boss wants me to write queries against a combination of these tables to make sure the program is working. RIGHT...

BI dev: Hey, can you help me with my SQL query?
Me: Sure, let me see it.
BI dev: sends screenshot - not even the whole query, literally a screenshot with a segment of text in it. No errors showing either.
Me: ...

People delivering flowers to the office, guy walks in with a massive set in a huge case, delivery guy says:
Either he is setting the bar really high, or he's in trouble. Here I am, at my desk, just being the only single person in my office. Writing a SQL proc for the same report I have been working on for the last month. Happy single awareness day everyone.

To the cunts who use single character aliases for their SQL queries table joins... Suck my throbbing dick till you choke on it and die....

That's all... back to work

My first manager : "You will never be a programmer! Network guys don't know shit."

That was after working as a MCSE for 2 years (that was for NT4... fuck I'm getting old) for this asshat and maintaining their servers and fixing their crappy sql.

Worked and studied my ass off... now I manage a team of 40 developers... and I still love coding!

Me (out loud in a meeting): "we currently have a SQL Express license, but the traffic with the additional servers is causing crashes when the cache fills up. We need to upgrade to the standard version.”

Follow up email from mngr planning to retire in 6 months currently making roughly 3x my salary: "See if we can get a proposal to purchase better Sequel software and install."

Me:
(-_-;) ... ಠ︵ಠ ...

┻┻︵ヽ(`Д´)ﾉ︵┻┻

As I imagine most of you do, I have a prettier plugin installed in my IDE. It just turned a 1000 line sql script into almost 6000 lines 🙃

> Laravel lets you create migrations to manage the state of the DB
> your colleague doesn't give a flying fuck, just raw SQL on the db to perform every change
> performed initial insertions without seeders, can't reproduce his db on my local environment
> can't even run migrations anymore 'cause it would break everything

I'm starting to have suicidal thoughts though the Javascript and the whole frontend.

Is anyone looking for a Ruby Developer with 2 years of experience with Ruby, 2 years with pure SQL databases and half year with React?

I don't want to see only Javascript for 8 hours per day for the rest of my life.

My react code in production broke because one of my senior renamed a field in sql query to 'id' instead of invoiceid.

I thought SQL was supposed to be very easy? I'd like to jump off a balcony right now because of it ...
I don't know if I'm just dumb or if my sources for learning are bad or idk
maybe I'm just tired and dislike SQL

Had a job interview today as a Junior Python dev. The hardest part: they asked things, that I used to learn in some time in the past, but got rusty in my memory because I don't use em much. Like "to write func that sorts array". Last time I was writing sorting without standard library at least half a year ago. Same with the regular expressions (need em the most once in several months) or sql expressions (last time - 7 month ago). How to remember these things?

!rant
For the first time in my life I've had a use-case where I got to use UNION in SQL.

I love it when I get to use these rare bits of knowledge I picked up in school

My professor today:
"The problem with SQL Server is that it's Microsoft."

Who knew SQL Server Report Manager didn’t have a log off / sign out button when you log in via the web browser?

I didn’t until I tried to test someone’s new credentials and realised I couldn’t log out of my administrator account. MS doesn’t ship it in the box apparently. Because that’s clearly not a useful piece of functionality to have. Except, some people have developed their own hacks to get around it......

Wtf.. mind blown

I'm trying to code here and can't do find/replace in SQL Server mgmt studio because fucking "antimalware" malware uses most of my CPU. I'm sure Microsoft is mining crypto

My Favorite Senior Dev: Hmm, I don't understand this error.

Neighboring, Competent SQL Developer Coworker: What does it say?

Senior Dev: It says, "Cannot insert the value NULL into column 'person', table 'PEOPLE'; column does not allow nulls..."

*5 minute silence*

Can't believe a fellow coder, went and undid the changes I had made in the previous commit! The commit he made is totally unrelated to my changes! Admitted, that he wrote the original code. But, he was not doing a check while adding two columns whether they already existed. That means he'll get an SQL error with the latest version, and has to manually deleted the columns. Again! Why are people so territorial about their code??

This is a public service announcement with a threat at the end of it:

"Do not, I repeat, do NOT attempt to write web applications, or any particular sort of application that works with a relational database (damn near more than half of applications) without a PROPER grasp and knowledge of SQL.
I do not want to see you reaching out for an ORM either, no, you need to learn to properly design a database or to properly interact with them AT most before you even attempt using an ORM OR designing an application from the beginning, shit will only hurt you in the long term I promise, learning SQL can go a looooong fucking way and most DBA's I know make way tf more than people think they make, it might even be an interesting career choice"

If you do not follow the above advise, and I see your ass reaching for building a web application without the above knowledge I will be under your bed at night, putting oil in my hairy body before I jump into bed to you and leave you confused for the rest of your life.

Build to learn, YES, but for the love of Chamberlain and Boyce PLEASE do not neglect SQL. I have seen such neglect REACH production and I am currently wishing I had these mfkers close to me.

Anyone else having a hard time switching between languages? :/

if(this.isActive and this.isVisible):
...

Java, JS and SQL at work, Python in my own projects...

Got my program hooked up to an external sql database that’s ready to be fed into by PHP, hosted on an SSL website, fixed up all the other bugs with TONS of other stuff.

4:23 A.M. and feelin’ good.

My day so far:
"No, we can't just make that public."
"See this? That's a SQL injection..."
"We have output escaping, please use it..."

I went to uni for CompSci with knowing no prior knowledge.

In my first year of uni I created a DigitalOcean droplet to host an SQL server. I didn't change the root password or disable password login out of convenience and as I didn't think anyone would be able to find the IP address to be able to hack it.

Within 3 hours DigitalOcean had locked my account for using my droplet to send DDoS attacks. Support contacted me to ask what was going on. I knew nothing at the time so I was a bit 🤷‍♂️.

And that's when I learned the importance of changing your root password.

My boss's SQL schema has no foreign keys and he said he left them out intentionally because they should be handled in the application layer and they're a large performance impact.

This is a fresh greenfield project and he's already pre-optimizing for problems we don't have yet, on things that may or not be bottlenecks using ideas (e.g. foreign keys have huge performance costs on mariadb/auora) with no hard data or facts to back them up.

Let's start a new project with some technical debt!

Just had my first freelance job here i Korea. I was told that most(?) of my job was going to be front-end web dev, and that the 'required' skillset was html/css. I thought I'd be making some free money, and I was wrong. Ended up doing all sorts of things like sql,js,ajax,php, and EVEN design. Apparently "developers" here are people who can do pretty much everything on computers. How many other countries are like this?

phpMyAdmin

Well, it is not my favorite open source project... I almost never have to use DBs, but when I do, it just saves my life. I can create the tables, keys without worring about any SQL command.

But day to day life is GNU/Linux, Firefox, bash/zsh, git... There are lots of opensource tools that I use, and love, everyday. :)

Sent a fully constructed sql statement to someone expecting at least 4 rows however received reply "the result is empty" with a screenshot of empty result set from sql-developer. I kept cross-checking the where clause thinking I mixed something up.

After a few back and forth emails suddenly noticed the screenshot I received initially and I see all of the strings in where clause are lowercase. I reference my version and it is correct. When I asked her why are the strings in sql lowercase and that if she has tried the exact sql I sent in the email, the response "I didn't think it mattered what case the sql was in".

I am lost for words. The worse part is, this is someone who is supposed to go on site as part of their job and help clients setup, explain and train how the software works. This includes explaining how software intreacts with database tables 🤐

so here I am, at 3 in the morning on my tablet and I think, "Yes I too would like to join the pain of web development" so I download sololearn apps for html, JavaScript, CSS, SQL, and PHP.

WTF brain?!?! 😂

Never have I been so satisfied as I am right now after having implemented a login and user account system with the ability to update user preferences with databases n' shit in PHP after only knowing PHP for a day.

Speaking of all that, do you guys know of any good place to make sure all my stuff is secure? No SQL injections n' the like.

My friend is learning PHP and I told him to install xampp but that fucker went nuts and installed MySQL too which didn't allow the xampp's SQL and ended in conflict.
Oh man that's so funny when non programmers don't do what we say.

Ok so I was fetching some JSON data from a SQL database server and loading it on the front-end. Every single data is being loaded onto the table except for a single data column, which is empty.

Hmmm... So I go and check my code... everything looks fine.
Then I console.log the JSON (using .stringify() of course), all the values from the table are present in the printed out JSON.

Ok, now I am really pissed.

Long story short...
I had misplaced a single 'i' in the SQL statement, I had included the 'í' (the i-acute) character instead. And since I was using an alias in the query statement, no error was shown.

I was employed as a Researcher so for three months i basically did nothing but read, document, read, document, read, document. Then one day in a review i was doing a demo that required sql. Three months no coding. Of course I've forgotten. And now, this ass back boss of mine gets surprised because i asked for help on update syntax for sql?!?! Like, come on. I COULD GOOGLE THAT. No big deal. But it was to him. He thought i was incompetent as a software engineer. So hE DECIDED TO JUST RANDOMLY PUT ME IN A DEV TEAM and i was expected to perform as fAst AS THEM while still doing mountains of task on research. Worst part is THEY EVALUATED ME BASED ON THAT PERFORMANCE. AFTER I WORK MY ASS OFF FOR THREE MONTHS AS A RESEARCHER, I GET EVALUATED BADLY BECAUSE I DIDNT MEMORIZE THE UPDATE SYNTAX NGNGNNGGNGNNGNGGNF

So there's that project with my coworker. We splitt up the classes, 10 to be implemented by him, 10 by me.

Fast Forward to 4 weeks before deploy.
Coworker: Your stuff logs a lot of stuff. It's not very clear and a liiittle to verbouse. 5 entries per second? Too much!
Me: Okay, you're right. Let me fix that.

2 Days later I look at his logs at runtime. He logs EVRY SQL statement and their results! In a batch that processes a 10'000 of customers!
He points out: That's useful stuff and it's not that much. It's needed for debuging.

My face: 😦

I never used the SQL in my life that is why i wrote NoSQL in my cv

Whole class: makes an sql database using phpmyadmin. Simple, easy, meets the requirements
Me: fuck it. Use python with pyqt5. And Microsoft sql server Spend unnecessary hours on making repetitive functions, cause my stupid ass can't figure out how to pass more than one parameters in class methods.
All in all, it looks good. I feel like I did something, learnt something new. Took on a challenge. Its a wierdly good feeling, somewhat rewarding.

I never knew that I was a good mentor at SQL , specially at PL/SQL.

I gave a task to a new member of my team, to fill 5 tables with data from other 15 tables.

I informed him well about data table info and structure. He spended about 3 days to create 25 different queries in order to fill 5 tables.

After I saw the 25 queries, I told him, that he could do it with 1 main query and 5 insert statements.

So I spended 1 hour of training, in order to build,run and explain how to create the best sql statements for this task.

(First 5 minutes)
It was looking so simple at the beginning from starting with 1 simple join, after some steps he lost my actions.

(Rest 55 minutes)
I was explained the sql statements I 've created and how Oracle works.

Now , every time he meets me, he feels so thankful for learning him all those Oracle sql tips in 1 hour.

Now he is working only with big data and he loves the sql.

Oracle SQL Errors are an absolute fucking joke, ORA-GO-FUCK-YOUR-SELF.

Thank you for coming to my ted talk.

My university provides advanced education courses and you'll get certified if you pass them. I'm really interested but I don't have so much time, so which one should I pick?
List of courses I'm interested in:

SQL
IT-Security
Project Management
PHP

I'm curious about your suggestions ;)

I'm a .Net developer from Morocco, i'm currently working on an accounting software for this fucking company owned by an American boss. And i'm handling every single aspect of the project including the back-end (C#), Database (Sql Server), Reports (crystal reports, ABAP, VSTO), and design (UI, logos, animation...). For a salary of 300 USD/month, with no insurance, no transportation fees, and no fuck given about my health or my coworkers'. Not mentioning the shitty working hours and condition.
This is my first (job)

As a .NET dev I get questioned about using VS Code in favor of full-blown VS. My arguments are that it is faster, lightweight and overall more user-friendly.

I use it exclusively, for all types of files and projects (JSON, SQL, Angular projects, .NET Core, ...)

Do you guys like using VS Code as well? What do you use it for?

Also, if you ever want to annoy a colleague, try associating all file extensions with Visual Studio and watch him go bonkers.

When it's 20C & sunny and the only thing I have planned during my afternoon is some good 'ol SQL. #liveTheCode

been looking at my sql code all day, got headache afterwards

I’m fucking lost.

So, situation. I have a SQL table with about 3M rows (not a lot).

I have indexes. Indexes are used. BUT when I add where clause (On indexed column), it’s super slow. Around 10 seconds.

If I do select * (ALL 3M rows) and THEN I filter then on webserver side, it takes 0.5 seconds.

HOW my manual filtering is faster than DB filtering with indexes? I even tried bubble sort. Bubble sort is faster than SQL ‘where’. HOW ?!

I do not understand….

And if I add group by….. WELL, 25 seconds SQL time. 2 Seconds if I do select all and group by in code manually.

Does not make ANY sense to me.
What am I missing ?

When used properly No-SQL databases are an incredible resource but my employer keeps hammering them in problems which could better be solved by traditional SQL databases in an attempt to be more "hip" and "cool".

This causes huge PITA in making the database work properly with the ORM we're using and waste of time since we're force to emulate basic features which are already exists in almost any SQL database (i.e. relational integrity) using No-SQL storage.

Windows: restarting in 10 seconds

Me: probably just a bug or something like that *click OK button*

10 seconds later

Me: it's no a bug! IT'S NOT A BUG! let me save my stuff

(I don't now why windows did that it made some kind of update without warning except for the 10 seconds and then I had some problem s like I couldn't connect to a SQL server and the computer was super slow)

Hello devs, I need help from database devs.

The company where I'm interning is a non IT company, so they planned to migrate to a SQL Database from their older MS Access Database.

Since I'm the only IT intern, I'm up against the major devs and hot shots from where my company outsources IT solutions.
They suggested SQL Express.

I have a meeting tomorrow with them, please help me so that I can get better results for my company.
Basically I have to question them about how their decision works better for our firm and why didn't we go for MySQL Enterprise Edition or anything which is much better and cheaper and such critical questions.
Please help me.

The Database would be used to store information about the products manufactured and their parts' history so that in future if there's a problem with the product, it can be looked up in the database so that there can be further replacement or repair processes.

At work, all errors within the site are logged into our database with a subject and error column. SQL errors are logged in the subject field while the traceback is put in the error column. However, a lot of SQL errors are really large and exceed the max character width of the subject field, causing yet another SQL error, and the cycle repeats. This recursive error has been the bane of my existence, because 1) it times my local dev instance out and 2) the error doesn't end up getting logged because the server both freezes and the error can't be inserted in the database. You can't even begin to imagine how many hours I've wasted trying to find what line I changed cause total and utter failure with absolutely 0 error logging. Next thing on my todo list is to fix this fucking issue since the head dev refuses to get it done.

(I highly recommend to you to not read this, it's just something that I had been wanting to take off my head; seriously, if you want to read it, do it at your own risk, because it will be a huge waste of your time)

Oracle Academy is the worst crappy attempt from a Corporation to create a learning platform.

The directive and academic personnel of my faculty decided that it could be a good idea to teach SQL and PL/SQL during whatever online classes will last with Oracle Academy, and I truly strongly believe (including most of my friends and classmates) that it's one of the worst ideas that could be done.

At that platform you simply don't learn shit, you read page by page of shitty PPT-like PDF presentations (that most of those are from a decade ago and other from 5 years ago) that are a pain in the ass to read due to how poorly formatted they are or how it explains badly certain concepts due to how badly made some explaining examples are, and then at each section of the "Learning Course" I have to do a Quiz that asks theorical questions and tells you to make certain code reviews to see if something is wrong or not (also which they are just alike the presentations, poorly formatted, up to the point that those have many syntax errors that end up consufing anyone a lot) and the main problem with the quizes is that also the Oracle's PL/SQL Docs are so fucking badly made, that I have to check PDF by PDF and page by page the concept that I just forgot to see how to answer the goddamn question; I mean, there are Doc pages that are way better structured and obviusly external to Oracle, but not even those pages fully cover certain SQL and PL/SQL concepts.

Seriously though, who could be so fucking ill-minded to create a shittyful learning platform and not try to fucking improve nor enhance it at least every 2 fucking years, so the goddamn "learning" process isn't that stressful.

Most of the companies visiting my campus for placements are hiring people with high CGPA and less knowledge and leaving (not even allowing for taking tests) the ones with good technical knowledge with less CGPA 🙁. So I hacked the placement portal developed by a PLACED, HIGH CGPA Candidate using SQL Injection and got access to all the student accounts 😄

Eloquent is so fucking slow, my (dead) grandma queries faster. It takes the fucking double of time on a simple query with only one join for maybe ~200 rows... From now on I go fucking back to raw SQL in my Laravel projects. 😤

Yesterday, microsoft showed me once again, what it means to "obey".

I tried to install Microsoft SQL Server 2012 on a virtual machine with OS Windows7.
The installation-center asked me to choose an installation-folder for SQL-Server.
No matter what, for any folder i had chosen for the installation, the setup replied with the errormessage "The installation-folder is invalid"

So i considered asking our platform-services team, whether they gave me administrative rights for the vm.
They did. I had full access to the components of my vm.

After a few days i finally recognized, that i had picked a wrong iso for the installation of sql server.

Instead of sql server 2012 + Service Pack 3, i picked sql server 2012 ServicePack 3.

So after all, Microsoft tried to tell me by showing the message "The installation-folder is invalid", that the setup weren't able to find an installation of Microsoft SQL Server 2012.

God damned!!1!

Auto tuning for Azure SQL databases is cool but :
DON’T allow it to automatically drop indexes ! (My bad, I should’ve tested that before)
It dropped one of the most used indexes in the DB. Yep, just like that. 150+ timeout exceptions and customers going crazy

I was just wondering why the flying fuck OxyPlot was rendering an unknown node on my chart for monday when I only queued my sql db for a single Tuesday.

Noticed it was an auto generated node, which had the right time, status, everything.

I looked up my code and found out that the date somehow bugged out, and if c# isn't sure what to do with an empty date it initializes a date on 1.1.0001

And what do you know. Appearantly thats a Monday.

I broke my head way harder over this than I should have, assuming the worst possible bugs in the render engine. fml

If I have to change my domain password every 3 months for a bullshit out of date security policy (there's plenty of evidence suggesting that changing passwords is actually worse security), then maybe, just FUCKING maybe, make sure that that password change appropriately filters down to things like SQL Server so I can keep doing my goddamn work.

Well well well.
Story time.

Since we are working from home for the past 4 months, I finally decided to install a Microsoft SQL server on my home server. (Mostly was using Azure)

My server is running Windows Server 2012 R2.
Tried installing SQL 2019 : fail, 2016 : Fail, 2012 : Fail. Some obscure message about some DLLs not being at right version. (And a warning that it is no recommended to install SQL server on domain controller, but I know, it is my home setup, not roduction)

“Ok fine, I’ll install it on my PC instead”. Windows 10 PC. NOPE. “Cannot install on a compressed drive”. Welp, wtf ? (Of course you cannot select destination install folder, I could’ve put it on another drive).

So here I am. Working 100% on Windows, installed Ubuntu server 20 LTS in Hyper-V, Installed Microsoft SQL server on it (BTW, install is very easy compared to windows). And that shit is working. And new “Terminal” app does support SSH out of box, no need to add Putty !

So as a Windows user, I needed Linux to make Microsoft SQL techno work.

Nothing will ever surprise me anymore. (BTW it’s fucking fast. I like SQL server on Linux)

Gah! (Totally guilty of it too but...)

That feeling when you ask a question like "how do I make SQL less intolerable for my team?" And you get answer like "just don't use SQL lol. Use this other thing!"

I appreciate suggestions, but why would I possibly use SQL if I had the choice to use literally anything else. I play by other people's rules and on their deadlines.

Today salesmen gave me some recommendations about my "so hardly optimized" SQL queries..suggestin me to change em.. I said okay, let's execute these.. 10 hours later, their computers sql workbenches finally displayed the fucking first one.

Result: 0 row... 🤐

Progress.

It isn't much, but the MVC application now reads data from the Linux LAMP server and prints the SQL data back to the client. Biggest hurdle was the fact that my Linux host blew up three times over the week, but hey, how else are you going to learn Linux servers?

Moving into spring framework self-education in July. Hopefully it's a little less painful than Apache Tomcat.

Can't create a new SQL database on Azure on on one subscription as every region is unavailable. Everything works on my other subscription.

Fucking hell.

Captains Log:

Day 2 of trying to get SQL database to work with JDBC application.

I've built a try/catch method and it throws up the message that IntelliJ can't find the JDBC driver.

More research to be done. My first officer duck buddy has no input for me.

It's going to be a long day.

*Sitting in sql course*

Professor: "So today we are talking about normalization which will make our tables much more efficient and easier to understand."

Me: (In my head) "Sounds useful!"

Professor: "First we will start with UNF or un-normalized form"

*Professor shows example on projector*

Example:
"UNF: Student ( name, sAge, , college_name {COURSEID, cname. descCourse C# }]"

*Frustration begins to take hold as I play where's waldo*

Fucking MySQL workbench won't even tell me what's wrong with my PL/SQL script. It has no output whatsoever. I click the run button and its like "y'all say sum?"

Why are all tools for SQL development so shit. All the time.

Part of my job requires me to use SQL in SQL Server and databases and Python and utilising Javascript APIs - so I was thrown in at the deep end. But my fiancé is also an amazing help as a software engineer he helps to spot my errors and encourages me to take on new challenges.

Access is just the most bull**** thing on earth. I spent 3 hours trying to find the mistake in my sql. FYI this sucker uses some special syntax for multiple joins -_-

I fucking suck at SQL and that's hurting my performance as a supposed backend developer :D

All the cool nested queries and whatnot, it just flies over my head, I need to learn it better, any tips on study resources?

Today is SQL day.

Been some time since I had to go here, the queries are flooding back to my mind like water over a dam wall. How the heck I remembered these is what I pondered.

Oh well, back to SQL (at a client - yay).

Now you SQL me, now you don't.

Working on a project needing to integrate java, jquery, SQL, various aspects of Android unix manipulation i.e. rotation, gps, music players, etc..needs to successfully build and after getting finally getting all needed repository files, work in android studio then be converted into an apk, compressed sent to instuctor's device for seemless use...this group project included 6 individuals teamed up like avengers to complete...my team mates either dropped the class or with drew.fml with a hammer sideways.

I've alway pronounced it sequel but everyone I know swears it's SQL, so I say that now to fit in.

I feel like a spy, lying to my closest friends everyday...

Doing the deployment to production, and towards the end one of the support guys looks over at me;

"So, the website in prod is throwing some errors"

Followed by another guy:

"Yeah I'm getting the same, SQL exceptions on the page"

I stare at them panicked for a moment, when one of them goes "just kidding!". Like dude, my heart just skipped several beats!

Any one here ever had something cruel happen to them during a deployment?

My Technical lead always asks one question to new interviewing candidates. "Write a SQL query to find the second highest salary from employee salary table". It's the same question which he faced in one interview and he didn't have answered it.
Sorry for my bad English..

I made changes to an SQL view used as the source for a pretty important integration that is built and managed by an external company. The integration failed the morning after and I was immediately blamed by the company and heard "how could you be so careless" and "how long have you worked in this business". I've been a programmer for 20+ years and done integrations for 15+ years. I know I checked the output of the view and it was identical in every way to before my changes.

After finally getting access to the integration code on "the other side" I found that it didn't read from the SQL view - it read the view definition. It also uncommented anything in the view (yes, uncommented) and ran that query.
We now have a year free of charge - which we won't need because my boss is throwing the company out as soon as we have a replacement.

To do list:
- Become a better dev
- Install Archlinux and Plasma
- Finish teaching my brother C#, F#, SQL
- Learn Xamarin better
- Actually use my programming skills to create useful tools for myself (and maybe my friends and family)
- Finally add one of my personal projects to GitHub

How hard can it be to sort content stored in a relational database by a custom meta parameter and restrict the results to a certain language using a very popular content management system in 2023?

After wasting several hours trying to get my head around reference documents, 20 years of anecdotal StackExchange + WordPress.org discussion and ACF + Polylang support, and trying to debug my code, I will now either write my own SQL query or put the meta query results in a hashed object to sort it using my own PHP code.

What time is it now? 2003?

SQL collation conflicts are the worst thing that has ever been made possible in humanity... it's 1000 times worse than problems with time zones, change my mind.

Fuck off whoever decided to make hundreds of different versions of the same languages.

Is it mysequel or my sql?

Me : So cool ! My new graphQL APIs are working so good !
Also me : ‘order by <text field> take 50 skip 10000’
Me : Hmmmm.. 2.3 SEDCONDS ?! WTF. Let’s add an index !
SQL : Sorry bro, can’t add index on nvrachar(max).
Me: OK. Here you go, you are nvrachar(128) now. Add my index !
SQL : Ok
GraphQl :<same query > Here : 90 milliseconds
Me : ‘order by <text field> desc take 50 skip 10000’
GraphQL : Sorry bro : 3 seconds. (Yes, slower than without any index)
Me : Do I fu7cking need to manually add ASC and DESC indexes ? WTF IS GOING ON !
I should’ve learnt a bit more about databases. ☹. And now I don’t have time to refactor a prod database as “needed” .
/me needs to buy DB audit. Company is still a bit small to have a DBA full time.

So, this week I started working on my first mobile app with Xamarin Forms. I already have a login and register functionality. The mobile app is connected to an Laravel API and SQL database. Happy with the progress so far.

I am new to C# so I had some struggles, but after some days I began to really like it.

In an average day, how many different languages do you use?

For example my previous job was strictly C and Python.

My current job involves Python, C#, VB, PHP, SQL, HTML/CSS, JS. It's rare but quite possibly I could touch all these on a single day.

Got my “Certificate” for SQL. What do you think? I have a few other just not sure if this means jack squat despite it being a free “certification”.

Man... I hate refactoring. After I had finished up an issue this morning, I had to refactor old sql queries and the parsing to the views.

I've worked on it all day and I still haven't finished! Still loving my job, tasks like these are unavoidable but they drain the life out of me.

I am witnessing Einsteins theory of relativity first hand, I’m amazed. The closer I get to Microsoft products, the slower my velocity becomes. At 9 PM, I have tried to connect a MS SQL Server to an ERP System for 30 minutes. After this piece of shit robbed me of all my energy, I look at the clock and it’s midnight. Go die in a dumpster fire Microsoft

At my last job I was the only one who knew PHP, SQL, and Bash (for managing the linux server through SSH). I wrote PHP modules for their CMS that they still use today. I was hired as an intern and made $8 an hour.

Hey everyone. I am a freshman in college studying Cyber Security. I have been practicing various programming languages such as httml, css, java script and SQL. Does anyone have any recommendations for resources to study? My end goal is to be blue teaming for my schools Cyber Defense team in the fall.

When I think my teachers can get any worse after sending me snippets of several Java classes in a single txt, one of them sent me SQL code of a full database dump in a Word document. 8 pages of SQL in its full glory!

I guess using the proper file extension/format or a service like PasteBin or GitHub Gist is way too advanced for them.

Did some distro hopping at the weekend and ended up back in Ubuntu.

And for the most part everything is running like a dream, except MY motherfucking SQL.

Installation appears to be ok, but doesn’t let me set a root password, and throws errors like it’s cool when I try and change the root password.

Same goes for MariaDB.

All of my googling for a solution has so far failed me

My company wanted to move old desktop applications to web and use angularJS. Finally, "new" tech. Not allowed to use node and Mongo because maybe someone who joins the Web team don't know Javascript and only sql experience ... Time to dust off my CV

Gosh!! Do not want to look at my shitty face in the mirror when i get to know that there is a DESC syntax in SQL for sorting data automatically even after i manually finished sorting them in Php.. #Fuckmylife #newbie

Why is saving this form so slow? It should be doing a single SQL update...

Oh it is doing 6500 individual updates to every possible field...fuck my life...and also the previous devs.

Dear Microsoft,

I really like SQL Server, but my dbms (ssms) is like 2 years old, I installed it from a predownloaded exe we had.
Can you please let me download the update without asking me to register?
Everyday for the last years I had to see the update notification and resist the urge to click it and be prompted with a login page

Dearly, a Linux user who develops in .NET, sometimes

The test server at work was going up and down all day. Not great when I was trying to use my new dashboard.

Long story short I found out the hard way to make sure I closed my SQL connections

First exam this year, about database optimisation. I have been there just a week and I really enjoy this school

BUT. THIS. CAN'T. BE. TOLERATED.

I wouldn't wish my worst enemy to write SQL on paper goddamnit!!!!

(Yeah I didn't have any other pen that this red one, at least it was erasable)

What are people's thoughts on having a personal website/portfolio?

I've set one up on GitHub pages with my custom URL, mainly to host SQL tutorials etc that I make, but do employers look at them?

I've been infcted with writing awful, sinful, obscure code, so others can't read or change it.

Recently i got my first full time job as a programmer (yay). It's with a company with 15+ year old system and they are currently upgrading it. But it's driving me crazy with the massive mess of old and new code. However it only gets worse! Instead of making it simple and nice to read, they want it over complex, just to get something from the database i have create at least 5 fucking classes and endless SQL code, the old system didn't requier any SQL or the creation og new classes, WTF. I've become a sinner, of corse i use the old system, but i do it secretly, and i obscurify my code so others can't understand. It's shameful, but i'm afraid to confront the older programmers, they've spend too much time in the system and they've been in the business for a lot longer than me.

So an update on my last rant(s) about dependencies and wasting time...

Today I finally lost it... With deadline fast approaching, i went to the big boss and he basically got everyone on his team to get their shit together and give me what I had asked for... 2 weeks ago...

It only took them 30mins.... Just the correct SQL query really...

Learnt a lesson today:

Never try out new hotkeys in a SQL query editor window.

Or if you do, at least make sure it's not connected to anything important :)

I was trying out new hotkeys and accidentally executed a SQL deploy script to rename something in multiple stored procedures in a large system.

Thankfully - so I saw after my heart stopped - it was only our QA db so not too bad, just a couple of devs set back.

Who woulda thought ctrl-l would execute :O

Tomorrow I'm forced to attend an in person "advanced SQL training", nothing against SQL or my company's good intentions but it's naive to expect which people would retain much after a single, super intensive 8 hour session.

One of the DB guys at work writes DB packages like this:

- open package in PL/SQL developer
- copy code to notepad
- edit PL/SQL code in notepad (yes, fucking windows notepad)
- copy and paste back from notepad to PL/SQL developer
- commit

Everytime I see him edit DB packages I can feel my brain mass shrinking.

So I inherited this buggy application my company developed to process state rosters for health care. The daily process fails often and I haven’t been able to figure out why. Then I notice one little thing... it’s essentially using SQL injection as a method of updating records from a file that we receive from outside... there’s no checking for validity of the statements or making sure they’re safe to execute. Just a for in loop and calling a sp to execute the query text under elevated permissions.

My manager always tell that we're less process oriented and self sufficient.

Later on, I understand what that means
- Poorly written JIRA tickets
- JIRA tickets with only title, rest for you to fill
- Two teams did same task, client side team pushing their change directly on master, while mine still waiting on code review will eventually get rejected
- Client writing raw SQL in ORM framework instead of using any single feature of ORM.

First rant in a while, been up to my eyeballs in uni work; still am.

I have a week to finish my concurrent programming assignment, and I'm stressing a little.

On one hand, I have to figure out a way to make a resizable lock-free hashmap.
On the other, essentially implement snapshot isolation for a sql database.

It's going to take a couple of long nights I suspect.

I'm not real big on asking for help but I'm kinda nervous about applying for my first real programming gig. And I was hoping someone here would be willing to conduct a mock interview with me because I think it would help to get over my jitters and iron out where I might need to practice.

I'm applying for junior python and SQL based positions and I'd really appreciate if anyone would help me practice for an interview.

I'm available most hours Friday, Saturday, and Sunday and if you're willing you can contact me here or at email to setup a phone, screen share, or web interview.

My email is wisecrackdoesathing@protonmail.com

One day, being new in the team i was not sure of all the DB column decodes, asked my senior member to send me decode of a column.
He sent me a 300 line SQL query. Took me 30min to understand it.

PL/SQL is one of my primaries at work.

Does not have an official "multidimensional array" per-say. Instead you define anonymous tables types and point it at a different "record" type to define the structure. Then you can make a table of that table indexed by string/number/record/etc. It's all tables. Tables of tables of tables.

Reading it can be wild.

!rant

Yesterday I have to do something I never thought I'd need to. A little background: I dislike PHP and MS SQL Server; however, they pay the bills.

So yesterday in order to get work done I had to install in my Linux machine a Windows 7 VirtualBox with SQL Server on it and had to compile the php mssql modules by hand and... everything worked flawlessly. It was pretty awesome.

Kudos to VirtualBox and the team behind the open source php mssql modules.

My new employer is giving me the option to learn whatever I want. I’m doing procurement and Sharepoint and some other things, covering on the help desk, and some graphic design work. I have a bit of free time though and want to try something new!

We have the following teams: networks, development, security, and help desk. What should I ask to do next?

I’m learning SQL and have also been given the opportunity to do some of that work once I am ready.

Note: I know that it’s my preference what I do, I just don’t even know where to begin!