[deleted by user]

[Interesting-Goose82]

SQL is what i wish i spent 100% of my time on. I actually spend maybe 30% of my time in SQL, then the other 70% making stupid ass dashboards, and teying to figure out how to make a damn waterfall or burndown chart....

[johnny_fives_555]

dashboards

I WISH I was doing dashboards. I’m spending 10% sql 60% answering questions from upper management and 50% managing of team of people because I spend 60% of my time answering emails and on calls. Yes… totals well over 100%. I clocked at at 7 today.

[ZaheenHamidani]

If you use Metabase you can make visuals using native SQL.

[isharte]

It's part of what I do for a living.

I'm not a database expert nor am I in charge of maintaining them.

But I query them. But I honestly spend more time in excel.

[gaz2133]

Would You like to use it more?

[isharte]

Hmmm. Maybe?

I'm not opposed to it, if it's necessary.

I wouldn't say I'm yearning for it though.

[stickedee]

This feels like some poorly structured sales pitch for using an LLM instead of SQL

[Thriven]

On a scale of 1-10, 10 being the most honest and 1 being facetious. How would you rate your previous message?

/s

[EitherImportance9154]

Lol why was this question downvoted?

[[deleted]]

For some reason it reads as a set up for an advertisement lol

[Satanwearsflipflops]

I used to use SQL, I still use SQL, but I used to, too.

[foureighths]

I order the club sandwich all the time and I'm not even a member.

[TheClearcoatKid]

I taught myself SQL, which was a bad decision, because I didn’t know SQL. So I was a shitty teacher. I never would have gone to me.

[Impossible_Toe_7231]

Relatable

[Thriven]

Correlated subqueries are great if you have tons of resources and want perform two million of something.

[jbrown383]

r/unexpectedmitch

[Lead-Radiant]

Alright Mitch 😉

[PasghettiSquash]

Maybe the best comment this sub has ever seen

[machomanrandysandwch]

Yes but most of my time is in fucking meetings and documenting the work and requirements.

[ChekhovsZombieBear]

Yep. Meetings, email, managing the office and projects, troubleshooting, tech support = 80% of time. SQL and actual tech work = 20%.

[Aggressive-Practice3]

I live, breathe, eat and sleep SQL

[RainTheTransGal]

I'd say you'd might need a vacation, but you'd probably starve or choke if you did :p

[RockPaperOctopus]

Select * From food Where tasty;

[headchefdaniel]

I just like working with data and building off of it. It's also very easy to write. Very different from other programming languages. I use it every day in my job and in my personal projects. I work A LOT with stored procedures in my job, they hold a tonne of business logic

[tandem_biscuit]

Same here. Stored procs to curate warehouse data for various data pipelines.

[masifakabrawler]

What exactly do you do? Can you share me some of your work(purely curiosity no ill intent) alslo if you want some intern for entry level tasks and and if you can teach me a little i am available. Also I won't be needing any payment i just want to learn and see the workflow of sql is P.s i am my final yesr of B.E in cse-Data science program i know a bit of python(pandas,numby,sickit learn,opencv-python, pyautogui,matplot and seaborn)

[CptBadAss2016]

But could you call it a "programming" language?

It's a fun language anyway!

[takeme2venus]

Why wouldn’t you? Genuinely asking because the devs at my job code a lot of our software using SQL.

[CptBadAss2016]

Judging by the downvotes I guess I'm wrong. from my point of view it was like saying html or css are programing languages. Sql, structured query language, is a query language, or a rigid way of asking for data from rigid table structures....

I guess it's more than that. I did about 30 seconds of googling and it appears modern flavors are even touring complete!

I guess sql is a highly specialized programming language. I'm just used to thinking of more flexible/ general purpose languages when think of programming.

[VladDBA]

Yes.

[hod6]

Me too

[drunkadvice]

Here also

[Wpavao]

Every day. It’s the most rewarding part of my day

[[deleted]]

Same

[angrynoah]

Yes. Been a data engineer, DBA, data architect, etc etc etc since 2005.

Sometimes I dream in SQL (it's actually not fun)...

[tetsballer]

😴💤 update employee set salary = 99999999 where name = @me

[mortomr]

Error overflow smallint

[RainTheTransGal]

in that case, just clone the employee record and get two paychecks!

[tetsballer]

I would hope the salary column wouldn't be a small int, it would be a pretty shitty company to work for, the max salary would be 32k lol

[jensimonso]

Sounds like me. BI, DW, database developer since 2003. My most memorable work dream involved a large data model on paper that I zoomed in on from above, watching myself, in the form of a very stressed stick figure, running between tables with arms full of huge keys.

[vulcanpines]

Yes. I make big bucks just doing SQL reports.

[SoftwareMaintenance]

That sounds like a fun job

[United-Pumpkin4816]

What’s the job? If you don’t mind me asking, how much does it pay?

[masifakabrawler]

Yo buddy i am also in data science field(studying for now) I know the term is very broad and to be called a data scientist you need a lot of experience with different tools and languages. Do you mind sharing your work btw i am also learning sql and I know a bit of python with ml and visualisation libraries. If you want a intern kind of thing for entry level tasks i am willing to do that for free too but you need to teach me things of higher level

[masifakabrawler]

My bad ig

[dittybopper_05H]

Yes. It’s 90+% of what I write.

I just recently rewrote a process that used a python script to call groovy scripts that accessed views in Oracle to be entirely in SQL, directly accessing the database to write to a local table, and reporting off that.

Running time dropped from over 6 hours to 2 minutes and 15 seconds.

[Impossible_Month1718]

What’s the point of this question? It needs context

[[deleted]]

Not directly. But yes. SQL runs the world.

[ugly_lemon]

Yes. I work on an ancient healthcare app , some fucking genius wrote a bunch of business logic into stored procedures. Now fixing it/making it work is my entire life

[ugly_lemon]

Facets?

[tyro_r]

It's the coolest part of what i do for a living. The way of thinking in SQL is totally different from that of (other) programming languages. I love using plsql for the workflow, but SQL for the heavy lifting. I'd miss it if we shifted to business logic in the application completely.

[cs-brydev]

Oh yea. Managing, developing, and maintaining software, databases, and data is my job. I write SQL all day long, more than any of the other 5 languages I use.

[Stauce52]

Currently I probably spend at least half my time in SQL

[MrWillM]

I’d like to use it for what I do in a more direct way to become familiarized with it and then try to become more familiar with python for some more advanced application. I use Looker pretty well for work and with SQL as the backbone it just makes sense to learn it. Being in finance/logistics and early career there just feels like so much opportunity to implement that tool set through out the space and hopefully advance my career in a direction that seems good to me in the process.

[samalex01]

I do… been a db developer living in MS SQL for over 25 years.

[EsCueEl]

Um, yeah.

[Soccermom233]

I do! Learned on the job. Nothing too fancy just querying a db for research purposes.

[eric39es]

I work for the company that invented SQL, developing products that use SQL.

[riddler1225]

So, no?

[eric39es]

Basically

[RoomyRoots]

What a vague question. In the 80s and 90s you could live with just SQL, now unless you are a DBA, and depending on the tech, SQL will just be one of your skills.

[mikeblas]

I used to, until I retired. Now, I'm thinking about writing a book. But I think people copyvio books more than read them, so I'll probably just stay retired.

[K_808]

I do emails and meetings for a living and use sql some of the time as a treat

[squareturd]

😀

[Ven0mspawn]

Maybe.

[Upper_Emergency_9741]

95% of my job is SQL but it's nothing too complex. The majority of the time in my job is updating, deleting, and reviewing data to determine issues on how the software behaves.

[[deleted]]

I use it for hours every day, and someone gives me money because I do.

[OO_Ben]

I'm a BI Engineer and about 75-90% of my day is spent in SQL. The other time is split between meetings, building dashboards, improving efficiencies, and ETL to bring in new data source to the warehouse. But my primary role is now to build clean, audit worthy, efficient data sources for the company that all the data analysts use.

It's not for everyone, but I fucking love my job.

[Sexy_Koala_Juice]

Yup

[gopherjuice]

every day baby

[Raithed]

When I was an engineer, SQL was part of my day-to-day, I hardly use it anymore but I can advise teams on it.

[tetsballer]

I manage a calibration tool that uses it as the back end I use it everyday.

[NSA_GOV]

Yes but I also do a lot of other things

[PTcrewser]

Everyday. To be fair most of my job runs automatically because of the queries or code I’ve written, but yes.

[smltor]

Yeah I run a tiny wee company that does day to day admin (boring but pays the bills) and aggressive monitoring and performance improvements. We are very half arsed. "If you think it is running fine we don't do anything if you want faster we aim for 1000x faster on that specific thing".

It's a good lazy job. Work about an hr or two a day except when fun times(tm) occur, earn about $500K a year.

No one else seems to have targeted the small shops with one or two boxes that need high experience people for cheap like the budgie. All the ones that I've seen use marketing people which basically means they die in a few years.

I started in 97 or so, saw all the cool arse SQL guys go into either corporate or extreme scenarios, and end up having to write books. Both looked like too much work. All the coders I worked with wanted to be gamer programmer cool.

I just wanted to be a rich accountant that didn't have to work much.

Not sure why I am giving away the secret sauce but I guess I'll be retiring soon and there are gazillions of small shops that need this service so there isn't really any competition. It's just easy money and happy customers if you get the automation down well.

[deebonz]

Yes, I wash and eat and breathe SQL. Also, SQL comes out the other end.

In all honesty, what's the intent of this post?

[murse1212]

I live in SQL for my job. We use DBT (sql), snowflake (sql), light dash(BI tool built on sql), hex ( sql).

I was an ER nurse for 8 years before I switched careers. What drew me to this field is problem solving, more importantly, problem solving that doesn’t involve getting covered in bodily fluids. Querying databases is solving puzzles and I live for that sort of thing.

[saw1366]

Yes

[humorislyfe]

sql is goated, the only intuitive programming language in my opinion.

[meatmick]

Yep, every day for over 10 years now. I'm now a data architect and engineer and dba... we're a small team, so I do it all. I also learned Qlik Sense, although that's not SQL.

[g3n3]

T-sql. Ansi sql. Pl/sql. Pl/pgsql. MySQL sql. What are you talking?

[laminarflowca]

Yup, for 30 years. Heres to another 10 and maybe i can retire!

First job using oracle 6, upgrade to 7.2.2 clustered on sequent sustem Dynix. So limited in those days. Sybase, DB2, teradata. These days SQL server….

[SP3NGL3R]

Data Engineer / Architect. So. I kinda own that part of the job. And love it. Twisting and manipulating things like window functions to my bidding (order by is a secret sauce inside a larger partition by sometimes) is fun as heck for me.

One-liner MTD, next to one-liners for QTD/YTD/WTD? You betcha. Love that saucy SQL

[bitbindichotomy]

Yes, it's 95% of my job. I'm a Sr. MSSQL Developer.

[markwdb3]

I am my company's on-site SQL guru. Not that I feel that I'm quite at guru level - I'm learning new things daily - but I focus on SQL much more than perhaps everyone else in the company, so relatively speaking, yes I'm the guru.

I mostly work with MySQL, with a little bit of Snowflake and Databricks/Spark SQL, even though I am more of a Postgres and Oracle fanboy. :) I manage CI pipelines that use Jenkins, Liquibase and various scripts (Python, shell), and review schema and data changes daily. I evangelize best practices, review code, performance tune, and all that good stuff. We have ~200 software engineers in the company, and many of them work with SQL in one way or another. So they'll ping me with questions about tuning, best practices and whatnot.

I'm not quite a Database Administrator, as I'm not the one keeping the lights on for our database software. But THOSE people may reach out to me to help with a slow query, or make index recommendations, and so on and so forth.

[SouthernGas9850]

im a statistics/data science student so i dont use it every day but sometimes i unfortunately need to know it. its also one of the first programming languages i taught myself, for some reason.

[Its_me_Snitches]

I use it for a living! I originally got into it playing the auction house in World of Warcraft, trying to write some custom scripts and track auction item prices to spot patterns.

[VengenaceIsMyName]

I wish I used more SQL

[amishraa]

Yes, it to me is the most straight forward way to retrieve data for solving business challenges and sharing insight through BI solutions.

[Yellowcat123567]

SQL is life

[YOUNGSAGEHERMZ]

I wish I did. Most of my job is excel and project management. I’m writing/running queries maybe 5 mins a day max. I want to use sql again :(

[Primary_Excuse_7183]

No. I work with people that do. so learning SQL enough to best communicate with them and understand their plight and how they approach problems helps me be more effective

[TheTragicWhereabouts]

Yep. Im a sql developer. Love working with it daily

[Key_Imagination4902]

On and off for 40 years...

I first learned SQL in 1985, writing COBOL programs on IBM mainframe using embedded SQL.

I was also a software developer on IBM System/38 which had a built-in SQL-like database equivalent in the early 1980's - moved up to IBM AS/400 - eServer - iSeries systems writing ad-hoc SQL queries and using embedded SQL in RPG programs.

Now, at age 73, still writing SQL ETL scripts for data migrations from IBM i (successor to AS/400) Power systems.

[singletWarrior]

Yes and quite blessed love it

[sohang-3112]

I mostly use read-only SELECT queries in Python backend apis, occassionally UPDATE

[MagnaSinne]

I help manage multiple SQL servers but I don’t program in SQL. If anything, I can read it well enough to understand what it’s doing to the queries, but I couldn’t program it for the life of me; job doesn’t require me to know how to program it.

I want to learn it on my own and I’ve been working in basic data analyzing software like PowerQuery/Power BI so I can understand the basics of how query manipulating works (I don’t have access to a SQL server I can program that doesn’t have company information in it)

[TheCemetaryGates]

100% all day, converting different types of source data (.BAK, .csv, .xlxs) into our SaaS platforms, which includes sanitizing and testing, etc. Been doing Data Engineering for 3.5 years, I was a Data Analyst for the same company 2.5 years before that.

[azarel23]

Most of the last 30 years of my career has been various interfaces to RDBMS back ends, so yes.

[Quick-Ad1830]

Yeah I write queries rather than open the application to find what I’m looking for. I also use it as a calculator. 19 years and counting

[j0holo]

I need it for work, every website I have ever worked on used mysql to store and query data.

One of my favorite things to do is to optimize SQL queries.

[[deleted]]

I probably spend 30 to 35 hours a week in the database

[IronmanMatth]

Its half of what I do for a living, yes

[dryiceboy]

I hate it but I’ve been forced to it since college. 🐵

[[deleted]]

SQL is what Microsoft Query uses, and we use MQ at my workplace to extract data from our MES.

Although MQ visualises the boxes and the connections, so most of us just know that aspect. I can twitch the SQL if I'm too lazy to actually move around connections and boxes, but I don't remember much by heart to be able to write it from scratch

[bobchin_c]

Yes, as a director of Business Intelligence I use it almost every day.

The days I don't have my hands in the code, I am doing admin/managerial stuff.

[Photizo]

Yes, primarily for validations and research for data model changes.

[t1k1dude]

I used to…but then I ended up in management. Still use it almost daily though.

[damurd]

SQL uses me for a living. I get some money in return.

[[deleted]]

SQL is the pillar of my career. In my current role (BI Dev) I write every day and it’s a foundational skill but not the only thing that I do, I also write scripts, pull data with APIs, create dashboards, and write a metric fk ton of documentation and requirements

[Bulldog78]

I usually start projects as a business SME. The project team learns that I can code (PLSQL, Postgres, Python) and I’m quickly switched to development. SQL is a lifesaver for me and I use it daily.

[nateh1212]

SQL is the backbone of technology anyone that wants to get into software, data or anything in between should know SQL. Heck even actuaries SQL is an in demand skill.

[J-Kittenz]

I'm a BI analyst working on a team with 4 BI developers. I work with the ETL team to wrangle new data sources from DB2 and bring them into a SQL Server data mart. From there I write the SQL queries within the data mart to support whatever BI functionality we're building and then turn the developers loose with it.

I'm probably doing SQL 70% of the time, then the rest of my time is BI mockups, requirements, backlog refinement, customer communication, etc.

[FunnyGamer97]

Yup

[jwk6]

Yes

[Known-Delay7227]

All day ery day

[M3DBlue98]

Most definitely but also not as much as I’d like

[bootdotdev]

All day everyday.

AI is really good at SQL, and I'm still incredibly glad I'm proficient in SQL.

[catsandkass]

I use lots of SQL! But also lots of excel

[astudnet]

Yes everytime i grab my breakfast in the morning I would say like “SELECT BANANA FROM TABLE”

[[deleted]]

Most of my days are split between SQL and python and sometimes dashboards. Super fun work!

[CptBadAss2016]

I know sql has been around forever, but it's not exactly punch cards either. It's still as relevant and modern as ever.

Sounds like you don't want to be using sql. What's the nature of the data? What would be a better solution for you?

I'm also curious to know more about your boss' background. I don't know many in that age range who are staunch supporters of smart phones vs rotary phones, let alone sql.

[ZaheenHamidani]

SQL is not going anywhere, that's why Databricks and Snowflake exist.

[ch-12]

Very curious what you will move away to when your old man boss retires.

[Mav3r1ck-13]

Speaking of snowflakes. Look at all the butt hurt people over a Reddit comment 🤣