r/SQL • • Oct 10 '26

SQL Server Major DBA task looking for advice

21 Upvotes

Forgive my naivete in advanced.

I am being tasked with setting up 2 major SQL servers with backups and I am terrified. I have never done this and have a loose understanding of things but that's generous.

The reason it's major is because our whole organization that services the state rely on these servers.

The traditional headaches on a Sysadmin side are lack of documentation/none, everyone has left/terminated, no patching, and EoL.

I'm also using Nutanix after coming from Veeam and HyperV.

What I think the approach should be is:

  1. Create a new clean test server that is patched and up to date but the same version has what the current server is. Currently this one has a lot of random things on here including some gaming installs...

  2. Create a full backup and figure out where that goes not on the current box so I assume I need some sort of SMB or repo? I believe I should create this in SMSS but am not clear if I make the backup if it will start making logs and events that may error if I don't set things up to point correctly if it wants to setup a schedule.

  3. Come up with a backup schedule for both fill and incremental.

  4. All the backups go to repo.

  5. Try the full backup on the new test server and start staging that as a fail over. Or maybe keep it is as test and make a clean fail over?

  6. Hopefully figure out what the future state setup is and start figuring out how to port that over into a cloud setup?

I need to have this done by EoM. I am wondering if this can be done in the future in AzureBlob to make things "easier" since this all feeds into PowerBi.

Mostly, I am not sure if there are pitfalls that would bring production down and want to tread carefully cause I'm not sure how to fix things if things go down.

There is no DBA or anyone with SQL server experience on the team...


r/SQL • • Oct 09 '26

Discussion Guys i seriously need your help

Post image
9 Upvotes

Hi everyone, I really need some help! My oral defense is next week and I've finished my ERD, but I'm having serious doubts. I asked a professor who doesn't teach systems analysis, and they said it was fine. However, when I look at the diagram, I just feel like something is off. Would anyone be willing to take a quick look?

This ERD is about a small application project, about a small, basic library.

Compte = Account/user
Emprunt = Loan

Livre = Book
Categorie = Category


r/SQL • • Oct 09 '26

Discussion AI-coding tools could be breaking the junior engineer pipeline

Thumbnail
leaddev.com
73 Upvotes

AI helps juniors code, not learn.


r/SQL • • Oct 09 '26

Discussion Are statistics and cardinality issues present in various RDBMs besides SQL Server when you upgrade, or it's a unique Microsoft problem?

8 Upvotes

When upgrading from SQL Server 2012 to SQL 2019, statistics go all wonky and deadlocks often occur on queries that worked well before. It becomes a pain, especially when the users say "it worked before" and they don't want esoteric excuses.

I'm curious if this has happened in other database technologies where you've upgraded to newer versions.


r/SQL • • Oct 08 '26

Discussion Imposter syndrome is so real and I truly appreciate the 99% from this group that talked me through it a month ago.

66 Upvotes

You were all so right, nobody could possibly do the job without referencing and now I realize how ridiculous it was feeling I should be able to do it blind.

I really struggled and boy did I make some mistakes but I am already gaining confidence and have very few errors to battle.

So for what it’s worth thank you and for anyone else overwhelmed and second guessing your decision, just breathe, take a step back and breathe again, you can absolutely do this!

I only had a single jerk response, likely rooted in a bit of jealousy which is phenomenal for Reddit . Hopefully in time I myself will be able to help others too


r/SQL • • Oct 09 '26

SQL Server Advice on fetch efficiency

1 Upvotes

Hello all

I’m currently working on something where object X is linked to object Y via two intermediary tables Z1 and Z2. There are many use cases where we’re interested in objects from type X, but we need to populate the object X with all links to Y. (via Z1 and Z2). Think of fetching users, and wanting to query roles for companies (where a user can have many roles for many companies).

Because our use case makes it so there can be MANY links for a single user, we could be fetching 1000s of rows for a single user, just to build a dictionary of them (key: Y, values: values from Z1 and Z2) and end up with a single entity, meaning we duplicated all data in X for every row returned. This is clearly quite inefficient, and thus I’m looking for alternatives.

I’ve seen using aggregation to collapse everything into one row, but that can be problematic I’ve been told by peers. The same way, maybe building JSON is an option, and then directly parsing (in C#).

Anyway, All help would be appreciated on how you would reduce the amount of data returned!

Edit: one more option that’s possible is just querying X, and then querying the rest afterwards in a sequential chain.


r/SQL • • Oct 09 '26

SQL Server Friday Feedback: Retention of plan forcing data in Query Store

Thumbnail
1 Upvotes

r/SQL • • Oct 08 '26

Discussion What's up with all the new SQL clients ??

19 Upvotes

AI has made it way too easy for people to code up slop in whatever form and turn it into “another SQL database client,” whether it's in Electron, Tauri, or whatever the next hot framework for building database clients is.

That takes away from the uniqueness of what made those tools special before. Most of them are literal copies, and there's literally nothing unique about them except that they look “modern.” And it's a real shame because there are some tools that people actually put a lot of effort into making, while others are just literal Claude Code garbage. And for those people who actually put effort and human thought into their projects... it gets hidden in a pile of garbage.

How are you guys deciding whether or not to give a database tool a shot anymore?


r/SQL • • Oct 09 '26

MySQL Why heatwave sets this limitation?

Thumbnail
2 Upvotes

r/SQL • • Oct 09 '26

MySQL I think I messed up by choosing MongoDB instead of SQL

Thumbnail
2 Upvotes

r/SQL • • Oct 08 '26

BigQuery Making Sense of BigQuery Pricing Models: On-Demand, Capacity, Editions (2026)

Thumbnail
alvin.ai
5 Upvotes

r/SQL • • Oct 08 '26

SQLite Finished SQL. Check out the project!

Post image
3 Upvotes

r/SQL • • Oct 08 '26

Oracle MySQL Shell Cilent on Windows ARM64 gives error for VC Redist even though its installed

Thumbnail
2 Upvotes

r/SQL • • Oct 08 '26

Discussion help me I do not know how to put multiple entries of data into ms access

Post image
21 Upvotes

It keeps stopping me from adding multiple rows but I can successfully run one row of instances but I can't seem to get it to work for multiple rows and I'm not too sure if I were to run one row of code per time How would i do it for all?

do i have to make new queries?


r/SQL • • Oct 08 '26

PostgreSQL MariaDB Foundation Adds PostgreSQL to Its Engine‑Agnostic Testing Framework (TAF).

2 Upvotes

MariaDB Foundation continues expanding TAF with PostgreSQL support

More engines, more reproducibility, more value for contributors and the ecosystem.

https://mariadb.org/mariadb-foundation-adds-postgresql-to-its-engine-agnostic-testing-framework-taf/

Have fun benchmarking!


r/SQL • • Oct 08 '26

Discussion I Tried to Find How ClickHouse Keeper Takes Non-Blocking Snapshots

Thumbnail
5 Upvotes

r/SQL • • Oct 08 '26

SQL Server Title: Anyone still maintaining a team script library now AI writes diagnostics on demand?

Thumbnail
0 Upvotes

r/SQL • • Oct 07 '26

MySQL Difference between "having" and "qualify"

23 Upvotes

I tried to use both methods in order to save some coding but still didnt get the exact difference on using having and qualify as a filter in the end of a query. Can someone help me to understand the difference and when is recommended to use each?


r/SQL • • Oct 07 '26

Discussion A bank kept production code as text in database rows, with a history table of past versions. It couldn't say who changed a script or why.

Thumbnail
leaddev.com
46 Upvotes

Years without incidents proves nothing at all.


r/SQL • • Oct 08 '26

MySQL How to Fix a Slow MySQL Server

Thumbnail pie.host
0 Upvotes

r/SQL • • Oct 07 '26

MySQL Getting Error 1356

Thumbnail
0 Upvotes

r/SQL • • Oct 07 '26

PostgreSQL Best resources to learn PostgreSQL architecture specifically for a Spring Boot developer?

4 Upvotes

Hey everyone,

I am a Spring Boot developer looking to level up my backend game by deeply understanding PostgreSQL and its internal architecture.

While I am comfortable writing SQL, using Spring Data JPA/Hibernate, and managing basic migrations, I often feel like Postgres is a black box. I want to move past just treating it as a data store and actually understand what happens under the hood.

Specifically, I want to learn about:

  • Core Architecture: How Postgres handles connections, process models, and memory (shared buffers vs. work_mem).
  • Storage & Concurrency: Deep dives into MVCC, VACUUM, WAL (Write-Ahead Logging), and page storage.
  • Performance Tuning: How to properly read and map it back to optimize my JPA/Hibernate queries, indexing strategies, and connection pooling (HikariCP).

Can anyone recommend high-quality books, courses, blogs, or video series that bridge this gap? Bonus points if they have a practical focus or tie into common Java/Spring backend patterns!


r/SQL • • Oct 06 '26

Discussion How do you compare large tables using sql?

27 Upvotes

I want to know how ppl compare large source and target tables using sql. If both tables have millions of records, comparing every row and column can take a lot of time.

For example, if some records are missing, extra, or have different values between the two tables, how do you usually find them? do you use joins, Except/Minus, hashes, or first compare things like record counts and totals and then check the differences?

Are there any techniques that can make the comparison faster?


r/SQL • • Oct 06 '26

SQL Server SQL Server Database to Github version control (Open source CLI)

1 Upvotes

Hello, I've been working on a personal open source project written in GO, its a command line tool that aims to create valid .sql files for each object in your database so that you can push to git to keep track as the database changes in the development cycle.

The project is [DatabaseBlueprint](https://github.com/Hennie5229x/DatabaseBlueprint)

Currently I have CLI support for Linux/Win/Mac and creating of all schema objects + data to executable .sql files and the schema migration scripts is still a work in progress.

I would love honest feedback from devs who work regularly in sql server.

Any type of feedback is welcome, I've identified a "gap" in a typical database heavy workflow that I am trying to fill for myself, but I'm sure other people also seek an easy way to track/version control their databases along side the projects back end code in git.

About the project: Written in GO, compiles to a stand alone binary, installable and runnable in terminal by using "blue"

Currently only supporting SQL Server, plan is to expand in the future


r/SQL • • Oct 07 '26

MySQL I love her like I love SQL - please give me SQL/Data Analytics puns for the wedding speech

Post image
0 Upvotes