r/SQLServer • • Jul 16 '26

Discussion Is SQL server considered as legacy technology?

0 Upvotes

My current organization couple of years ago migrated from SQL server to snowflake and I noticed in some of the documentation, they have mentioned SQL Server as legacy technology.

I started working in SQL server some 20 years ago and some of the developers in our team are cloud first developers and they find it so difficult to navigate SQL server management studio and they ask me questions like is there timetravel feature in SQL server and can we see what data was there 10 mins back. I was totally dumbfounded when I heard that question, because I had never come across such a feature. Apparently snowflake has this. So I am curious is SQL server now really considered as legacy technology?


r/SQLServer • • Dec 27 '24

Question my select function doesn't give me any data back. The table seems to be empty while having data in other's ssms. Can anyone help ?

Post image
0 Upvotes

r/SQLServer • • Nov 03 '15

Why is Azure SQL Server so broken/crippled?

0 Upvotes

Edit, V12 supports change tracking and alot more features. Upgrade your azure instance

I'm fairly new to using MS SQL(usually use others). A client had a requirement for a project that I must use his existing Azure SQL database for two way real time updates.

I'm a developer and jumped right in....

so far every single normal SQL Server 2014 feature I've tried is purposely disabled without a replacement.

Change tracking on rows? No soup for you. SQL service broker so I can enable push notifications? GTFO! Some GUI substitute option for push notifications? Hell no! Bulk insert so I can import some CSV files? Bulk wha??! alerts? Not in for your SQL server....greyed out for you! subscriptions ? Yes we have....wait... you meant an feed? No No....I meant how much $$$ would you prefer to give to MS. Syncing? Yes we have... for glorious MS servers only....the only TRUE server.

So I check MS forums and find out over the past 5 years MS has been slowly adding "features" to azure that have been available for well over 10+! Even worse...some are still in beta so recommended not for production usage.

Why da fuq would anybody use Azure SQL server over another cloud platform...is it in alpha? Is there anything I can do more advanced than Microsoft Excel?


r/SQLServer • • Feb 18 '26

Question Difference between SIMPLE and FULL recovery model in SQL Server

0 Upvotes

Hi everyone, I’m a beginner MS SQL DBA and trying to understand recovery models in SQL Server. Can someone explain in simple terms: What is SIMPLE recovery model What is FULL recovery model How each one affects transaction log growth When a DBA should choose SIMPLE vs FULL in real projects A basic real-time example would really help. Thanks in advance 🙏


r/SQLServer • • Nov 25 '24

Question SSMS Vent\Rant

0 Upvotes

Is Microsoft ever going to release a version of SSMS that doesn't freeze and/or crash and restart?!?!?!? I get my hopes up with every new release for the problem continues. It's quite ridiculous. We should be able to leave a few windows open with connections.


r/SQLServer • • Jun 18 '25

review my resume : 12+ years as mssql dba

Thumbnail
gallery
1 Upvotes

Hi

I know there is r/resume where i can upload my resume but there i didnot got any response and so i am posting here as its dedicated to sql server so folks here could provide better advice ....

So kindly review and help me how is my resume and what more points i could add in resume


r/SQLServer • • 13d ago

Community Share Open Source AI-enabled Index Tuning Stored Proc

Thumbnail
gallery
0 Upvotes

Disclosure: I’m the founder of AI SQL Tuner LLC.

Azure SQL Database has had automatic indexing for years. If you run SQL Server on-premises, on a VM in another cloud, or on Azure SQL Managed Instance, you’ve been managing indexes by hand. I built aisqltuner-index-tuner to fill that gap, and it’s free and MIT-licensed. It was inspired by Brent Ozar's post on Microsoft’s 2006 AutoIndex.sql prototype: I'm Probably Not Supposed To Show You Microsoft's Auto-Indexing Tool. - Brent Ozar Unlimited®.

It’s a stored procedure that collects index diagnostics from your database, sends them to your own Azure OpenAI deployment, and stores the recommendations in a table. It can also create the new indexes it is able to verify.

sql

EXEC dbo.sp_AIIndexTuner;                    -- recommend only (the default)
EXEC dbo.sp_AIIndexTuner  = 'CREATE';   -- also create verified new indexes

What it looks at

  • Missing indexes and index usage

  • Duplicate and overlapping indexes

  • Plan cache and Query Store

  • Statistics, heaps, and skewed columns

  • Non-SARGable predicates

While the right indexes can solve a lot of performance issues, there may be other root causes. The stored proc can recommend rebuilds, constraint fixes, statistics refreshes, setting changes, and query rewrites. Each recommendation includes a priority, confidence level, and rationale.

Why it’s safe to try

  • It only recommends by default. Nothing changes until you ask.

  • The model’s script is never executed. The proc builds the DDL itself from structured fields, validates every table and column against the catalog, and quotes every name.

  • Drops, columnstore, and the maximum number of new indexes are controlled by switches. You can also set minimum priority and confidence levels for what gets applied.

  • It refuses drops of clustered, PK/unique-backed, FK-referenced, hinted, or forced-plan indexes.

  • Every applied change stores an UndoDDL.

  • Your diagnostics go only to the Azure OpenAI endpoint you configure.

Does it work?

We (Claude Opus 5.5 and I) benchmarked it on SQL Server 2025 Enterprise Developer with gpt-5.6-luna: 16 known tuning problems, 37 rubric checks, 5 trials per arm. On a 10 GB TPC-H-derived workload, CREATE mode cut logical reads by 86%, and no query returned different results. We saw gains on the other two scenarios too, and the full numbers, including where CREATE mode falls short of reviewing every recommendation by hand, are in BENCHMARK.md. We found gpt-5.6-luna with medium effort to be fast, cheap, and accurate in testing.

Known limitations

  • Answers vary between runs, so two CREATE runs can apply different sets.

  • There’s no automatic impact measurement or rollback. You get UndoDDL to reverse a change by hand.

  • Only OpenAI models are supported for now.

  • It’s not yet tested on Azure SQL Database, Fabric SQL Database on Managed Instance.

  • Please test it in a non-production database first.

Getting started

  1. Provision an Azure OpenAI deployment if you don’t have one.

  2. Run the install script in the database you want to tune.

  3. Fill in and run setup/Configure-Endpoint.sql with your endpoint and key.

  4. Run EXEC dbo.sp_AIIndexTuner; and read the results in AIIndexTuner.Recommendation.

Requirements: SQL Server 2025, Azure SQL Database, Azure SQL Managed Instance (SQL Server 2025 or Always-up-to-date update policy), or Fabric SQL Database. Since it’s a stored procedure, you can schedule it from SQL Agent or any other scheduler.

Please let me know what you think, if you have any questions or if there is anything you would change.


r/SQLServer • • Oct 03 '26

Question What’s the best way to use LLMs on top of SQL Server Data

0 Upvotes

Hi,

I always wondered, what’s the best way I can have my users be able to answer natural language questions from data stored in a SQL Server 2025 database? There’s literally no way an LLM can make sense of millions of rows in a sql table. I have heard of Fabric IQ, building Symantic graphs etc etc but anyone did something that works using SQL server data that could point me in the right direction?

I am not even talking about OLTP database, I am talking about data in a Data warehouse house on SQL Server with proper facts and dimensions.


r/SQLServer • • Feb 15 '22

Question I'm new to SQL Server. Why does this seem like such a nightmare to connect w/ a remote computer using Microsoft's tools??

0 Upvotes

The server is running on my Linux, on a server in my local network. I can connect to it fine using DBeaver. However, actually trying to connect to it via Microsoft SQL Server Management Studio seems so convoluted! Where do I find an option to just put in the server ip address and credentials? Even trying to just use SSMS only allows me to "automatically search my network", which of course turns up nothing.

I'm only using SQL Server because that's what the other developers on this project decided to go with. It seems as though to actually connect this ASP.NET core application to SQL Server just to develop on Visual Studio, I'm practically forced to use Microsoft's fucked up toolchain just to get things going...

Sorry, I'm just very fucking frustrated with this entire process. I'd so much rather just stick to Linux and the tools I know, but unfortunately I can't for this.

If anyone can offer some guidance, it would be much appreciated...


r/SQLServer • • Jun 06 '25

No recent CU for SQL Server 2019

0 Upvotes

The latest CU package for SQL Server 2019 is still CU32 which was released end of February. Now, more than 3 months later, still nothing new, not even a Security Update. Kinda strange.

Microsoft SQL Server Versions List


r/SQLServer • • Sep 10 '17

Question How do I change position of any specific row?

0 Upvotes

How do I change position (say, to the bottom) of any specific row from a table in SQL server? Please answer it with example. Keep the remaining rows as it was before.


r/SQLServer • • Nov 05 '25

Question Can someone help me install SQL Server developer on my desktop? I keep running into errors and I can't figure it out.

1 Upvotes

Title says it all. I am willing to pay a small amount for this service.


r/SQLServer • • Aug 16 '24

Do companies are still working with SQL Server 2008?

1 Upvotes

I want to apply for a job, i have this version on my laptop, or should i install a recent version?


r/SQLServer • • Oct 17 '16

Community Share SELECT * Does Not Hurt Performance

Thumbnail
scarydba.com
0 Upvotes

r/SQLServer • • Jan 07 '26

Question Does this support 32 bit processor?

Thumbnail
gallery
1 Upvotes

r/SQLServer • • May 11 '14

Creating Indexes on a Create Table Statement (SQL Server 2014)

Thumbnail
sqlcoffee.com
0 Upvotes

r/SQLServer • • Dec 23 '25

Discussion Help!!

0 Upvotes

I need to MASTER SQL and Python in 20 days cuz I will start my internship on January 22.

Can you guys give me some guidance about the most effective resources, tools, and methods? I don’t know if it’s just me, but as I learn Python, I keep forgetting what I have learned.

Thanks.


r/SQLServer • • Dec 31 '24

ReportServer

0 Upvotes

Could not find answer via search. On our SqlServer, there is database called ReportServer. How can I find who is using it? It’s growing steadily and is 69 gigs now. We have no onpromise Sharepoint anymore. Do I just make it go offline and watch who starts to yell?


r/SQLServer • • Jun 05 '24

Alternatives to stored procedure

1 Upvotes

As the title says we are looking for alternatives of stored procedure.

We have SQL server as our database and management has been pushing us to look for alternatives of stored procedure?

Could you please suggest something and why could be the drawback of using stored procedures?


r/SQLServer • • Jul 18 '23

Question Why can’t you SIMPLY PRINT in SQL Server?! NSFW

0 Upvotes

Title says it all.

Want to print with a command named print? Nope, it’s going to be buffered until the buffer is flushed.

Want to use RAISERROR instead (why the F*** does it only have one E anyway?)? Sure that’ll work… until you have more than 500 of them… then we’re back to good old buffering.

SQLServer is great, don’t get me wrong. But the fact that something so simple has been made so annoyingly difficult is something I will never understand!

EDIT: To be clear, I am not looking for work arounds. I just want to know why printing normally is so difficult.


r/SQLServer • • Oct 13 '16

Almost all of the "tests" that I see here suck, and do nothing to improve your understanding of the mechanics of SQL Server and the importance of the record as a single object. Here is a much better test:

0 Upvotes

I am currently on my phone, but can certainly write some sample INSERT statements for people to use.

This is the test:

You are given a table with thee columns:

CREATE TABLE #Points

(PointA CHAR(1), PointB CHAR(1), Distance INT)

This table is provided to you with sets of points and the respective distance between them.

Using this table, write a single statement which will evaluate all of the possible paths between two points given as input parameters. The statement should return one record with two columns; the first containing the shortest path (in terms of distance, not steps) itself (ie: acbghefd as a path from A to D) and the second containing the total distance that path would take to travel.

If you cheat, you're only cheating yourself. Enjoy the challenge, I look forward to reading the answers.


r/SQLServer • • Jan 25 '14

Total Noob, if I already have a database on sql server how can I make that database open to querying by the public over the internet.

0 Upvotes

I already have my own website with Go Daddy as the host.

I created a table in my database of all the pics in the subreddit /r/CandidFashionPolice. My table has fields such as hair color, race, Upvotes, background setting etc.

I want to make this table/database available for the public to query.

Basically,

http://s3.amazonaws.com/rapgenius/is-such-a-thing-even-possible.jpg

and if so, how?

Edit: thanks guys, I feel dumb now. lol. But seriously thanks for the advice guys.


r/SQLServer • • May 03 '23

From Good to Great: Boosting Your Performance as a DBA with the SPIN Sales Strategy

Thumbnail
eitanblumin.com
0 Upvotes

r/SQLServer • • Jan 28 '16

SQL Joins Explained for beginners

Thumbnail
sqljoins.com
0 Upvotes