r/SQLServer • • Jun 25 '25

Update without the WHERE clause

Post image
319 Upvotes

Brent Ozar posted this and I thought it was funny because it reminded me of when I made the same mistake, hahaha. I can laugh now but at that time I was terrified.

Has anyone else made this mistake or had to fix it because some other DBA did?


r/SQLServer • • Sep 12 '20

meme Rookie mistake.

Post image
271 Upvotes

r/SQLServer • • Jul 02 '26

Community Share Interview with a DBA [Humor]

219 Upvotes

I hope it's allowed to post as an exception.

This this seems more like a Oracle/2008 mysql dba but somewhat relatable.
Where is the role of DBA's going in the age of serverless?

Source: https://www.youtube.com/watch?v=5KyfW79Ld4g


r/SQLServer • • Jun 20 '25

Those requirements are getting out of hand

Post image
214 Upvotes

r/SQLServer • • 10d ago

Community Share Hugo Kornelis, long time #sqlfamily member, MVP, creator of SQL Server Execution Plan Reference, speaker, friend, and community member, passed away today after a prolonged fight with cancer.

Thumbnail
bsky.app
196 Upvotes

r/SQLServer • • Mar 01 '19

Eventual consistency

Post image
167 Upvotes

r/SQLServer • • Sep 20 '22

Blog [Bitesized] So, why Indexes?

Post image
149 Upvotes

r/SQLServer • • Mar 13 '21

Blog Brent Ozar celebrates 20 years of showing us how to work with SQL Server

Thumbnail
brentozar.com
145 Upvotes

r/SQLServer • • Feb 06 '25

Azure Data Studio to be Retired Feb 25

144 Upvotes

r/SQLServer • • Apr 22 '15

One for all you DBAs out there...

Thumbnail
imgur.com
135 Upvotes

r/SQLServer • • Aug 05 '19

Found the datafile

Post image
131 Upvotes

r/SQLServer • • Jan 10 '22

Notepad++ plug-in to convert CSV files to SQL insert script

130 Upvotes

Just wanted to mention that I've created a CSV Lint plug-in for Notepad++ and I though it might be useful to anyone working with SQL Server.

The plug-in can convert csv files to SQL insert scripts, which imho is a bit easier to work with compared to BULK INSERT. It automatically detects the datatypes, and it includes a CREATE TABLE part with the correct data types for each column.

It can also validate the csv data beforehand, meaning check for bad data like missing quotes, incorrect decimal separator, datetime formatting errors etc. It will create a SQL script that contains INSERT statements for each line in the csv, in batches of 1000 records.

Personally I find it's easy to use for small one-off files, but it can also process larger csv files like 10MB ~ 50MB maybe even larger I haven't tried.


r/SQLServer • • Apr 17 '25

Hardware/VM Config Old Employer got hit with Ransomware

124 Upvotes

Had one of my prior employers get hit with Ransomware this past Saturday. When I was there I did their erp implementation, managed the erp and DB and did the in house development so they called and asked me to come in and help get things back up in going.

Just thought I'd drop a few things here that I learned over the past few days.

  1. Off domain backups are a MUST

  2. Vheam back up doesn't always play nice with VMware and likes to fail on hotadd so restoration times can be slow.

  3. Bring up each server individually starting with DCs and changing all passwords on first instance brought up.

  4. Monitor traffic between each server that is restored and the DC for any abnormalities. (not my specialty so I'm not sure on details as to what they were looking for).

  5. Back up images of critical PC are a must.

  6. Make sure your developers aren't using clear text passwords in their web configs. These were specifically targeted.

  7. Every computer that was powered up and on the domain had to be wiped.

  8. Erp hides password usage in 572857 different places.....

  9. Don't forget services accounts, the accounts themselves are easy to isolate given a good structure AD setup, the usage isn't always as well documented.

  10. Macs suck and are still infected but the infected files are moved to different locations.

Just thought I'd toss this out there.


r/SQLServer • • Jan 22 '26

Discussion Death of the DBA (Again)

120 Upvotes

Posted by rebecca@sqlfingers on Jan 14, 2026

Death of the DBA (Again)

Every few years, something comes along that's definitively, no-questions-asked going to replace us.

Let's review the historical record.

A Brief History of DBA Extinction Events

1996: Larry Ellison announces Oracle 8i and "lauds its self-managing capabilities as being the death of the DBA."
— Claremont

2017: Larry Ellison unveils Oracle Autonomous Database: "a totally automated 'self-driving' system that does not require human beings to manage or tune the database."
— Claremont

2020: A DBA reports from job interviews: "The interviewer in both cases said 'we don't have a DBA, our databases are in the cloud and an upgrade is as easy as pushing a button and requires no downtime.'"
— SolarWinds

2022: Matthieu Cornillon, Database Tech Leader at ADEO: "The DBA is dead... The job we knew is dead, and there's no doubt about it. Automation and the cloud made sure of it."
— Medium

2023: Larry Ellison doubles down: "The Oracle Autonomous Database is self-driving because it has an AI module that is the DBA. We replaced the DBAs with AI."
— Cloud Wars

And yet. Here we are. Still employed. Still getting paged at 2 AM. Still explaining to developers why SELECT * in production is a bad idea.

What Actually Happened

Every one of those technologies became part of the toolkit. GUIs made administration faster. Cloud made provisioning easier. NoSQL found its niche. Serverless handles specific workloads beautifully.

None of them eliminated the need for someone who actually understands what's happening under the hood.

AI will be the same.

The Job Description Is Changing (Again)

Here's what I've noticed in the past year:

The DBAs who treat Copilot like a threat are spending their energy on resistance. The DBAs who treat it like a junior team member are getting more done.

Think about it. A junior DBA who:

  • Responds instantly

  • Doesn't complain

  • Knows every syntax variation you've forgotten

  • Still needs supervision on the big stuff

  • Will confidently give you wrong answers if you don't check the work

Sound familiar? That's every junior DBA you've ever trained. The only difference is this one doesn't take days off.

The Skills That Matter More Now

Judgment. Knowing which solution fits the actual problem. Copilot can generate five different approaches; you have to know which one won't crater production.

Context. Understanding the business, the workload patterns, the history of why things are the way they are. AI can't attend your architecture meetings.

Accountability. When the query Copilot suggested locks up the database, someone has to fix it -- and it won't be the chatbot.

Communication. Translating between business requirements and technical implementation. Being the one who explains why those warnings shouldn't wait until they become outages.

These are the skills that were always valuable. They're just more visible now that the routine work is being automated.

The Good & the Bad

AI won't replace good DBAs.

But I'm betting it will expose those who were mostly doing work that AI can now do faster.

If your value proposition was 'I know the syntax and I can write basic queries', you have a problem. That was never enough — it's just more obvious now.

If your value proposition is 'I understand the systems, I make good decisions under pressure, and I can solve problems that don't have Stack Overflow answers', you're fine. Better than fine, actually. You now have a tireless assistant for the boring parts.

My Prediction

Five years from now, we'll look back at the AI panic of 2025 the same way we now look back at the cloud panic of 2010.

Some jobs changed. Some people adapted. The ones who leaned in came out ahead.

The robots aren't taking our jobs. They're just making it more clear what our jobs actually are.

sqlfingers inc

Posted by rebecca@sqlfingers on Jan 14, 2026

https://www.sqlfingers.com/2026/01/death-of-dba-again.html


r/SQLServer • • Apr 20 '22

We've used MS SQL as our games backend for years, here's a summary of the hardware and how it's progressed since our launch over 15 years ago.

Thumbnail
eveonline.com
107 Upvotes

r/SQLServer • • Mar 07 '16

MSSQL being ported to Linux

Thumbnail
blogs.microsoft.com
102 Upvotes

r/SQLServer • • Feb 12 '22

We made it on Jeopardy y'all

Thumbnail
imgur.com
100 Upvotes

r/SQLServer • • Nov 18 '25

Community Share Announcing SQL Server 2025 General Availability

97 Upvotes

Today we are excited to announce the General Availability of SQL Server 2025. Check out all the details at Announcing the General Availability of SQL Server 2025 | LinkedIn. I also have an article you can read more on SQL Server Central at SQL Server 2025 has arrived! – SQLServerCentral.

Join us on Dec 3rd at 10AMCST for a live AMA: https://aka.ms/sqlama.


r/SQLServer • • Jul 19 '24

Question How is this even possible?

Post image
93 Upvotes

If the server id is null in the first query, how is the second query returning no rows? I am confused 🤔


r/SQLServer • • Apr 09 '21

Custom What happens when you give the intern DDL access?

Post image
92 Upvotes

r/SQLServer • • 26d ago

Community Share I added spiders to SSMS for Halloween

89 Upvotes

Hey all! I added a little Halloween interactivity to SQL Shades (my SSMS theming add-in). I know spiders aren't for everyone, but I think they turned out pretty cute.
https://www.sqlshades.com/articles/scenes/


r/SQLServer • • Sep 05 '22

Question Would there be interest in something like this (illustrations on inner-workings of stuff)?

Thumbnail
gallery
89 Upvotes

r/SQLServer • • Jan 28 '21

Community Redgate Software has acquired the assets of PASS, including SQL Saturday and reviving Summit

Thumbnail
red-gate.com
88 Upvotes

r/SQLServer • • Apr 08 '26

Community Share Introducing SQL MCP Server

Post image
87 Upvotes

SQL MCP Server gives enterprises a secure, feature-rich way to enable agents to access data. This is accomplished without exposing the schema, risking consistency, or relying on fragile natural language parsing. SQL MCP Server is a feature of Data API builder (DAB), so deployments have a proven entity abstraction system, RBAC security at the API layer with Azure Key Vault integration, custom OAuth and Microsoft Entra support, first-level and second-level caching with integration with Redis and Azure Managed Redis, and complete instrumentation and telemetry with integration with Azure Log Analytics, Application Insights, and OpenTelemetry.

It supports hybrid queries and multiple data sources across Microsoft SQL, PostgreSQL, Azure Cosmos DB, and MySQL. Data API builder (DAB) 2.0 provides a production-ready surface for REST, GraphQL, and MCP with automatic configuration, native integration with Microsoft Foundry, a first-class query builder, and developer tooling like dedicated VS Code extensions, built-in REST and GraphQL tools, and a cross-platform CLI.

SQL MCP Server is a simple MCR container that requires a JSON configuration file. It is a zero-code solution that reduces friction, dependencies, and entire blocks of repetitive, error-prone CRUD code from line-of-business applications, custom websites, tailored mobile apps, and AI agents.

Best of all, SQL MCP Server is open source and free. It runs in any cloud, including on-premises. It was built, managed, and is maintained by Microsoft as the prescriptive approach to expose enterprise databases to applications and agents in a secure, feature-rich way, with no language or framework requirements and no drivers or libraries to install.

https://devblogs.microsoft.com/azure-sql/introducing-sql-mcp-server/