What is our primary use case?
It has all of our data. Our company sells contracts when you buy a car. We sell aftermarket insurance for the tyre, wheel, ding, dent, windshield, etc. When somebody buys a contract, we capture all of that data into a legacy database PostgreSQL, and my task is to incorporate that into our financial platform using T-SQL. So, I write queries, procedures, and views. I use SSIS, and I use SSRS. My job is to get the data into our financial system so that we can process claims, payments, cancellations, and refunds.
In terms of its version, we're up-to-date. We have version 2019.
How has it helped my organization?
This is the heart of the whole company. SQL Server is where all of our financials are. It has all of our data.
What is most valuable?
I've been using SQL Server for 20 years, and there is nothing that it can't do. It is awesome.
What needs improvement?
When we are talking about event space architecture, scalability generally comes into play. For example, I might have a hundred thousand transactions a second, and then all of a sudden, I build something that everybody in the world wants. The next thing I know is that I have a million transactions a second. So, to be able to process the throughput, I'd have to scale up, and then when the holidays are over, I'm again down to a hundred thousand transactions, and I want to scale back down. SQL Server is not going to do that. In this way, it is not very scalable. One of the reasons why they want us to use Kafka is so that if we need to, we can do that, but our base program is on SQL Server. So, this is where we would use a Kafka event stack so that if I need more servers, I can just write a command, and I can have more consumers, more brokers, and more producers, and when the holiday season is over, it scales right back down again. SQL Server is not going to do that.
Buyer's Guide
SQL Server
May 2026
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
899,283 professionals have used our research since 2012.
For how long have I used the solution?
I have been using this solution for 20 years.
What do I think about the stability of the solution?
We do clustering. If one SQL Server goes down, it automatically goes to another one.
How are customer service and support?
I don't ever need tech support. If it breaks, I can just rebuild it.
Which solution did I use previously and why did I switch?
They're now using a different database for contracting called Road Runner. I don't know what that is, and how it stores data. I don't know anything about it.
There is also Postgres. I like SQL Server more than Postgres. That's only because I know SQL Server. I don't know Postgres as well. So, I can't say which one is better because I don't have the same amount of experience in both.
How was the initial setup?
I can bring up a SQL Server in an hour or so and set it up.
In terms of maintenance, the number of people required depends on the need.
We have a team of DBAs, developers, and UA analysts. We probably have 40 people in our IT area who are maintaining our solution. I'm just the developer. I'm the guy who makes the magic happen, but without other people collecting the information that I need to make the magic happen, I'm stuck. Without the guy who is an expert in permissions, partitioning, and performance tuning, I'm stuck. So, it's definitely a team effort. You can do it all, but you don't want to do it all because then you're running your head off, and you don't really get good at anything. It would be a jack of all trades, master of none type of scenario.
What other advice do I have?
You will seldom find a database that was designed correctly. Just because you got a poor-quality database doesn't mean that you're going to get a better database anywhere else. You rarely get to build a thing on your own. Usually, you inherit somebody else's stuff. So, the challenging thing is working with what you have while trying to implement a better solution. My only advice is to be patient.
I would rate it a nine out of 10. I wouldn't give anything a 10 because I don't have that kind of knowledge, but right now, it does what I need it to do.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.