MSSQL logo

MSSQL

It is an enterprise-level database system that is very popular for Windows web servers
616
393
+ 1
3

What is MSSQL?

It is capable of storing any type of data that you want. It will let you quickly store and retrieve information and multiple web site visitors can use it at one time.
MSSQL is a tool in the Databases category of a tech stack.

Who uses MSSQL?

Companies
85 companies reportedly use MSSQL in their tech stacks, including Walmart, Alibaba Travels, and Groww.

Developers
450 developers on StackShare have stated that they use MSSQL.

MSSQL Integrations

MySQL, PostgreSQL, SQLite, Oracle, and Gitea are some of the popular tools that integrate with MSSQL. Here's a list of all 25 tools that integrate with MSSQL.
Pros of MSSQL
3
Easy of use
Decisions about MSSQL

Here are some stack decisions, common use cases and reviews by companies and developers who chose MSSQL in their tech stack.

Needs advice
on
AngularAngularDjangoDjango
and
ViteVite

I work for a firm that gave me the task to select a software stack that suits our needs, I already have some idea of what it is going to be but I am the only technical person in the firm so I need advice. I just got out of school so it's kinda overwhelming.

What we need - One MPA (so SSR and SEO) - Two SPA on the same domain as the MPA - A backend that works with MSSQL and the frontend

Because it is a pretty big enterprise project and my devs are familiar with Angular I want to use Angular with PrimeNg on top. For the backend, I think Django will be my choice because it works with our database and the built-in functionalities seem very nice.

I would also like to use Vite for faster development time but I am not sure if it will suit my needs.

The main question is can I use Angular for the MPA so SSR and Angular for the SPA's on the same domain, it opens a new tab when a link is clicked to the SPA. I need to hydrate some parts of the pages of the MPA too I was thinking to use Analogjs but vite ssr also seems similar.

Please help I'm confused.

See more
Craig Heath
Owner at Bluefield Identity · | 5 upvotes · 15.7K views

Does anyone have any advice or guidance on how to create a Lucee instance in the Amazon Web Service cloud? I'm a many years CF dev but I have zero experience working with cloud services and I'm trying to roll my own on this one. I have a traditional ACF hosting arrangement I desperately need to migrate from (their support has recently evaporated and it's causing my application performance nightmares) and my app will need to be in the cloud for scalability considerations so I'm figuring now is the best time to make the move. My current setup is ACF with a MSSQL backend and I think I'd like to migrate that to a Lucee/MySQL or Amazon Aurora setup.

Any pointers would be most welcome. Thanks in advance!

See more
Needs advice
on
FirebaseFirebasePusherPusher
and
SignalRSignalR

I'm working on a project where I need to both send real-time updates for specific data sets, along with providing notifications to the users after long-running processes have been completed (SSE).

The project is using .NET Framework, AngularJS, & MSSQL. I understand that SignalR is nice as a polyfill for .NET and you can scale with a backplane, but I was wondering if there was a more efficient/effective technology for this?

See more
Needs advice
on
Amazon DynamoDBAmazon DynamoDB
and
PostgreSQLPostgreSQL

Hi All,

I have an application form employment details, and mostly the data is text & animations. Earlier it was with the MSSQL database. Now I have to migrate it to either PostgreSQL/DynamoD or MongoDB. Could you please help me to choose the correct DB to get the best fit and also can the possibility to migrate from MSSQL the Old records?

Data Types: Text, Animations Source Database: MSSQL Destination Database::? ( DynamoDB/MongoDB/PostgreSQL)

Thanks

See more
Yeongju Park
SW Web Engineer at Sense Korea · | 4 upvotes · 74.6K views
Needs advice
on
CometChatCometChat
and
SendBirdSendBird

I am considering which chat solution to choose between CometChat and SendBird, for our new app. The condition is, the app is going to run in a private network and has to connect with MSSQL. Any advice on other things I have to consider before choosing one, or is there another chat service you would recommend? Thank you!

See more

Which tools should be use to migrate MSSQL database to PostgreSQL database ?

See more

MSSQL's Features

  • Resumable online index rebuild
  • SQL Server machine learning services
  • Query processing improvements
  • Automatic database tuning
  • TempDB file size improvements
  • Smart differential backup
  • Smart transaction log backup.

MSSQL Alternatives & Comparisons

What are some alternatives to MSSQL?
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
PostgreSQL
PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
Oracle
Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.
IBM DB2
DB2 for Linux, UNIX, and Windows is optimized to deliver industry-leading performance across multiple workloads, while lowering administration, storage, development, and server costs.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
See all alternatives

MSSQL's Followers
393 developers follow MSSQL to keep up with related blogs and decisions.