- I Create Things in SQL that Shouldn't be in SQL
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...
247 points30 comments5 d ago
- What answer is expected when asked "Do you know/do SQL?"?
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...
31 points35 comments2 d ago
- I’d like to share an opportunity with the community
On Friday I will have a chance to sit and have an open discussion with Microsoft’s VP of SQL Product The ask for the session is to provide product feedback and share product pain points and...
22 points41 comments7 d ago
- How Screwed am I? 8 years of experience, 3 year gap.
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...
17 points8 comments2 d ago
- Best video/diagrams/blog for learning to read the execution plans like an expert?
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?
15 points18 comments6 d ago
- Why implement procedural programming inside an RDBMS (MariaDB) instead of handling all business logic in backend application code?
9 points7 comments2 d ago
- Is PostgreSQL the best choice for my database?
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...
8 points22 comments2 d ago
- Best website to get SQL certification?
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...
6 points12 comments2 d ago
- Refactor Pattern for Denormalized Table
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. Say you have a table with fields for X People...
6 points9 comments4 d ago
- How to connect Oracle Database 19c from host machine to VirtualBox guest machine ?
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...
5 points6 comments6 d ago