Microsoft SQL Server logo

Microsoft SQL Server

A relational database management system developed by Microsoft
17.8K
13.1K
+ 1
539

What is Microsoft SQL Server?

Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.
Microsoft SQL Server is a tool in the Databases category of a tech stack.

Who uses Microsoft SQL Server?

Companies
1217 companies reportedly use Microsoft SQL Server in their tech stacks, including Accenture, Hepsiburada, and Stack Overflow.

Developers
15398 developers on StackShare have stated that they use Microsoft SQL Server.

Microsoft SQL Server Integrations

Datadog, Slick, PowerShell, Sequelize, and Metabase are some of the popular tools that integrate with Microsoft SQL Server. Here's a list of all 120 tools that integrate with Microsoft SQL Server.
Pros of Microsoft SQL Server
139
Reliable and easy to use
102
High performance
95
Great with .net
65
Works well with .net
56
Easy to maintain
21
Azure support
17
Always on
17
Full Index Support
10
Enterprise manager is fantastic
9
In-Memory OLTP Engine
2
Security is forefront
1
Columnstore indexes
1
Great documentation
1
Faster Than Oracle
1
Decent management tools
1
Easy to setup and configure
1
Docker Delivery
Decisions about Microsoft SQL Server

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

Hi Friends, I am planning to create a web and mobile app for eCommerce purposes, which is very similar to Swiggy.com/Zomato. Started this app and created API using .NET Core, Entity Framework, and Microsoft SQL Server as DB. Consuming this API in Flutter for mobile and web UI. Just want some help and suggestions about this selection. Worrying about the application's scalability and performance, please suggest me a good architecture to create this application, which may be used by more people over a period of time.

See more

Which option do you prefer to go with (considering scalability, and a limited budget):

Technologies in use: Angular / .NET Core 6

What do we want to achieve?

We want to create simple near-time web notifications, those notifications can be categorized into 2 sections:

  • User notification: which represents user activities and engagements.

  • System notification e.g release notes and maintenance time. The notification object is too simple just a title, body, userId, notificationStatus, and readAt. notification status is an enum with 3 values: unread, menuOpened, Read.

Options:

  1. use Firebase Realtime Database for user notifications and Microsoft SQL Server for system notifications (maybe using long poling or so to frequently call the getSystemNotification API ).

  2. use SignalR to push new notifications along with the SqlServer database and store both user and system into one table (as they almost have the same attributes)

See more
Shared insights
on
Microsoft SQL ServerMicrosoft SQL ServerJSONJSON

I have a project (in production) that a part of it is generating HTML from JSON object normally we use Microsoft SQL Server only as our main database. but when it comes to this part some team members suggest working with a NoSQL database as we are going to handle JSON data for both retrieval and querying. others replied that will add complexity and we will lose SQL Servers' Unit Of Work which will break the Atomic behavior, and they suggest to continue working with SQL Server since it supports working with JSON. If you have practical experience using JSON with SQL Server, kindly share your feedback.

See more

Looking for the best analytics software for a medium-large-sized firm. We currently use a Microsoft SQL Server database that is analyzed in Tableau desktop/published to Tableau online for users to access dashboards. Is it worth the cost savings/time to switch over to using SSRS or Power BI? Does anyone have experience migrating from Tableau to SSRS /or Power BI? Our other option is to consider using Tableau on-premises instead of online. Using custom SQL with over 3 million rows really decreases performances and results in processing times that greatly exceed our typical experience. Thanks.

See more
Ramadan Mohamed
Shared insights
on
Microsoft SQL ServerMicrosoft SQL ServerC#C#

Want to link my sys login by fingerprint to access login my sys by same login user How I can do that's. I'm using C# and Microsoft SQL Server

See more
Kelsey Doolittle

We have a 138 row, 1700 column database likely to grow at least a row and a column every week. We are mostly concerned with how user-friendly the graphical management tools are. I understand MySQL has MySQL WorkBench, and Microsoft SQL Server has Microsoft SQL Server Management Studio. We have about 6 months to migrate our Excel database to one of these DBMS, and continue (hopefully manually) importing excel files from then on. Any tips appreciated!

See more

Microsoft SQL Server Alternatives & Comparisons

What are some alternatives to Microsoft SQL Server?
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.
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.
Apache Aurora
Apache Aurora is a service scheduler that runs on top of Mesos, enabling you to run long-running services that take advantage of Mesos' scalability, fault-tolerance, and resource isolation.
Microsoft Access
It is an easy-to-use tool for creating business applications, from templates or from scratch. With its rich and intuitive design tools, it can help you create appealing and highly functional applications in a minimal amount of time.
MariaDB
Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry. MariaDB is designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance.
See all alternatives

Microsoft SQL Server's Followers
13144 developers follow Microsoft SQL Server to keep up with related blogs and decisions.