#RedditSql

Hi there, I have been using SQL Server since 1998 - Version 6.0 I think it was and also a SQL Server MVP for 6 years. I have started publishing the articles I have written over these years but never published. I have quite a varied mix.…

Let me know if reposting this violates the "no solicitation for others to do your homework" rule, I'm just genuinely asking if there is a better way to do this than what my beginner mind has imagined lol submitted by /u/publicherstorian [link] [comments]

Hello I am learning data analysis from scratch. Can anyone help me understand these two MySQL installers and make me decide weither I should download one or both of them? Thank you. submitted by /u/SkepAlert [link] [comments]

Hi everyone, i want to access the oracle database on my guest machine (on VirtualBox) using my host machine (both machines are on windows 11) , i have already set up oracle client on my host machine but i couldn’t figure out how to connect it to the…

Been at this 10 years, this is still a gap in my knowledge. What is the BEST video or blog post or whatever you have found that cemented query plan knowledge in you? submitted by /u/you_are_wrong_tho [link] [comments]

How fellow data junkies! I created a FREE tool (no signup needed) that can perform a variety of file services including perform SQL against it all in your browser. CSV, JSON, and more. Go to inkwelltools.com and select Inkwell Data.…

Hey Hive mind, been stewing on a problem for a long time and getting stuck, so I thought I would reach out and see if anybody can spark some ideas.…

I just realize that SQL was only the language. Idk which IDE for sql to use. Suggestions pls submitted by /u/jdkapaoskd [link] [comments]

I'm a Solutions Architect at Databricks, and I've been spending a lot of time on the Lakebase sink. It lets a Structured Streaming query write directly into a Lakebase (Postgres) table with batching, automatic retries, and workspace-managed auth.…

Subject: The quantum leap we skipped: a SQL Server database that refuses UPDATE and DELETE - live, try to break it Here is a heresy: two of the four letters in CRUD are bugs. Every business system I have worked on lets someone rewrite history.…

Hello. I'm the maker, so take this as a self-promo post, and tell me if it doesn't fit here. Most SQL practice I found is "write a query from scratch". On the job, a lot of the work is reading someone else's query and noticing it's wrong.…

hi, I thought I would get some insights from professionals on this. I'm currently an intern, and I'm tasked with building a database for a church's religious education program, potentially handling a few thousand families.…

Is it the norm to have a program that is coded in SAS and then need SQL to store the the data? The need SQL tools to pull information about out the tables then swap back to SAS to pull lots of data out quickly?…

Hi! I’m currently an undergrad college student, Finance, looking to get into a data analytics/science, relative field post-grad. I’m looking into getting certified in SQL and Python and get a better grasp of the whole thing before I jump the gun and can’t…

Long story short I went through a divorce, had a scary health issue and generally was just burned out. I sold everything and travelled for 3 years. Now that I am back it seems the Datbase Developer position is not a thing.…

I'm a software developer at heart and at work. Sometimes when a project ends I get asked "Do you know SQL?" or "Do you do SQL?". I'm puzzled at what exactly are they aiming at. What knowledge or skills would they expect?…