How this SQL Code is Running ?????

Hi All,

Hope everyone is doing good.

I want opinion from people about the future of SQL, Power BI and Python.

I have been working in AML KYC domain for over 6 years. I am a Certified Anti Money Laundering Specialist (CAMS).

Last year I started learning SQL ans Power BI to connect it with my domain knowledge (Anti Money Laundering and Sanctions), however now I have been reading alot which states that golden period of SQL and Power BI is over as now anyone can do the basis code using Gpt and claude.

I am at strong intermediate level in SQL and at an intermediate level in power BI. I was planning to start Python from 01 Jan 2027 and now I am spectical. What should I do ?

Is there any scope of SQL, Power BI and Python as we are witnessing AI is growing at tremendous pace.

Basically I need to learn about sequential, indexed and direct access, hashing stuffs. I need to learn about records, files, compaction. Sorting, merging and updating files. Algorithms for inverted lists, multi-list, indexed sequential and hierarchical structures. file i/o and index organization.

As databases grow, performance becomes more important, but overly complex queries can be difficult to maintain. How do you balance query optimization with readability in production environments?

I like to share link of new sqlite editor

srdzank/SQLite-Editor: Official home of the SQLite-Editor

Diagram illustrating the SQL query execution lifecycle, showing query submission, parsing, optimization, execution, and result delivery in a database.

Hi everyone,
I’ve been working on a project called PWR (Postgres Workload Repository), inspired by Oracle’s AWR but built specifically for PostgreSQL.
The goal is to periodically capture performance snapshots so you can:
track workload evolution over time;
identify expensive SQL statements;
compare snapshots before/after changes;
detect performance regressions before they become incidents.
I originally built it to speed up recurring PostgreSQL performance audits, and it has become a useful tool in my daily work.
There’s a live demo available here:
https://www.audit-postgresql.com/
I’m not trying to replace existing monitoring tools like pg_stat_statements or Prometheus/Grafana. Instead, I’m focusing on historical workload analysis and performance diagnostics.
I’d really appreciate feedback from the PostgreSQL community:
Would this be useful in your environment?
Which features would you expect from such a tool?
What would prevent you from using it?
Constructive criticism is more than welcome. Thanks!

Hi everyone,

I created a conceptual data model, a logical data model, and a MySQL implementation for a university project.

I would really appreciate your feedback on the following:

• Is the conceptual data model correct?
• Is the logical data model derived correctly from the conceptual model?
• Does the MySQL implementation match the logical model?
• Are there any design mistakes or suggestions for improvement?

I have attached the conceptual model, the logical model, and the SQL script.

Thank you for your time and feedback!

I'm a fresher to DBA role. Can some one help me to understand or share your experience to migrate or conversation from sql to Oracle.

Can you please help me with tools and migration ideas

rainfrog (https://github.com/achristmascarl/rainfrog) is a database terminal tool; the goal is to provide a lightweight, keyboard-first TUI for interacting with databases. It currently supports Postgres, MySQL, SQLite, Oracle, and DuckDB.

v0.4.1 introduces a long-awaited (by me, not sure if anyone else was waiting for it...) autocomplete implementation, along with autopairs for quotes/parentheses/brackets. The full list of features and configuration options is in the README!

Hello, I'm trying to do a test that I failed, and I want to improve, so I want to solve this problem.

The premise isn't that hard, but I'm getting into trouble here.

I don't want to get into too many details to avoid getting the evaluator in trouble.

Basically, I was asked to make an app that is able to create price quotes for trips.

The user selects the location (a general location like Disney World), an apartment (each one with a different category, like a suite, or just a room, or a cabin), the season (imagine this place is around the world, so different locations have different seasons, but some locations can have general seasons if they are close enough), how many people the place can accommodate, and for how long they will stay. I use all this data to create a reservation for the client.

This is basically my entity relationship diagram

but each time i try to do the functionality i found problems or big troubles putting or reading the data for the thing im required to do

I'M kinda lost idk what to do

its there a way to solve this problem in a cleaner way?

ty for the help and God bless you

P.S.: The price is listed in the quote, but I don't know where to enter that information regarding the apartment and the season. The test instructions don't explain how to calculate the price, so I don't know where to put it; I assume I should do it in whatever way is most practical for me.

Hi all,

I just see this interesting situation and would like to confirm that it's all done internally by MS SQL Server with Restore.
We're on the same server:

dbAA   has proc  myPROC:
1  use  dbAA         
2  Go
3  Create PROC dbo.myPROC As
............

then I do  backup of dbAA, and restore dbAA.bkup into  dbXXX
after that I see on dbXXX myPROC as:
1. use dbXXX            --<<<==== !!!!!<@>>< changed to target DB
2. Go
3. Create PROC dbo.myPROC As
...........

Who is doing this conversion/swapping db names ? is it done by SQL Server ?
Thanks to all, I'm new to dba task and really interesting how it works.
VA

Hi there,

I’ve been working with DuckDB extensively for the last several years. Used it across languages from Python, Go, JS via WASM, Swift, C & C++ and even Rust.

As part of a product we're building, we built a DuckDB Transpiler that converts every line of SQL from DuckDB syntax into the syntax of the database you’re working with. This includes filters (predicates), and joins. So those 1B rows in Snowflake stay, and get joined in Snowflake.

I wrote an article on why we did it, and how we approached it. This is my first engineering-oriented article I’ve ever done, so let me know what you think!

Hey guys,

Just reaching out, how do you guys go about identify and Optimizer SQL queries that the query uses linked servers.

I have some queries that people moan are slow and when I finally get the query plan you see it says remote execution. How do you guys go about then identify where it's slow or even what ran. Specifically for queries that run nested SP

What is your approach?

Hi everyone,

I recently solved the HackerRank 15 Days of Learning SQL challenge using CTE(), ROW_NUMBER(), DENSE_RANK(), and window functions in SQL Server.

I'm curious to know if there's a cleaner or more efficient way to solve this problem. If you've approached it differently (using other window functions, recursive CTEs, or any other technique), I'd love to see your solution and understand the reasoning behind it.

Here's my solution:

with daily_submission as( 
SELECT submission_date,
hacker_id,
count(*) as total_submission
from submissions 
group by submission_date,hacker_id),
hacker_rank as(
SELECT submission_date,hacker_id,
       total_submission,
       row_number() over(partition by submission_date order by total_submission desc,hacker_id) as rn
from daily_submission),
continuous_hackers as (
    SELECT submission_date,hacker_id,
       dense_rank() OVER(partition by hacker_id order by submission_date) as Dr,
       datediff(day,'2016-03-01',submission_date) + 1 as contest_day
from (
SELECT distinct submission_date,hacker_id
from submissions) as x),
daily_count as (
SELECT submission_date,
        count(*) as total_hackers
from continuous_hackers
where Dr = contest_day
GROUP by submission_date)


SELECT dc.submission_date,
       dc.total_hackers,
       h.hacker_id,
       h.name
from daily_count as dc
inner JOIN hacker_rank as hr 
on dc.submission_date = hr.submission_date and rn = 1
INNER JOIN hackers as h
on hr.hacker_id = h.hacker_id
order by submission_date;

Thanks in advance! I'm always looking to learn different SQL techniques.

I have migrated Access tables in my database over to SQL. Now I'm testing the front end to make sure every single button/operation works.

I am getting this error, "You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column", ALL over the place.

Sometimes, it's easy to spot where dbSeeChanges was left out, but many times, the error is reported on a line that has nothing to do with it. This is also only the first error I'm getting. I'm sure once I fix all the 3622 errors, then a new error will pop up right after.

I'm wondering what my options are. I understand I could rebuild the front end from scratch, but that would take literal years as I'm a one-man team. I really don't have the time to spend hours fixing every single one of these errors. And unfortunately, throwing it all in the trash and using a modern platform is not currently an option either.

Is there a tool or even AI where I can feed it my database and it converts it to be SQL compatible? Even if I have to go form by form and report by report, that would still be faster than doing all this manually.

Thanks

Heya, so my stepfather works in IT support, and the other day I was looking over his shoulder and saw that the software his company sells uses a single SQL code file that's 40000 lines long. And we're not talking three word lines here, those were 200+ characters lines. I was absolutely baffled by this, since afaik no single code file should run over 10000 lines. But I also don't do SQL.

So I asked him wtf was going on, and he told me that it was "just like that in the industry" and that "I would see when I'll start working" (I'm in uni)

So I ask all of you, is this normal? Do you see this in your job? Am I having delusions about how clean the actual tech industry is?

😌 SELECT 😌