Microsoft SQL Server logo

Microsoft SQL Server

A relational database management system developed by Microsoft
19.8K
15.2K
+ 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
1323 companies reportedly use Microsoft SQL Server in their tech stacks, including Accenture, Hepsiburada, and Stack Overflow.

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

Microsoft SQL Server Integrations

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

Chris Bleck
Site Reliability Engineer at Cooperative Bank Of Thessaly · | 5 upvotes · 20.3K views
Needs advice
on
GraylogGraylog
and
PrometheusPrometheus

We are a small bank and we have 5 VMware ESXi servers with mainly Windows Server VMs with numerous windows services installed and most of these servers have Microsoft SQL Server and Microsoft IIS installed. Also we have some applications that have application logs (mainly in a db table) and we have a few Hangfire instances and one MQ Series server.

Now the management gave me the task of site reliability (I'm fairly new to this) which means all Windows Services must run 24/7 so I have to know if a service fails to start. All databases must run properly so I have to know locks, Query performance, and any SQL Agent job failures. The same goes for IIS websites/services must be up and running all the time.

In addition to these, I must collect all the Hangfire job failures(which are a lot) as well as general server metrics like CPU, RAM, I/O Disk, Disk sizes, etc.

On top of all these, I must setup alerts via Slack/sms or mail. Now the question which tool or a stack of tools can achieve all that?

See more
Needs advice
on
.NET Core.NET CoreFlutterFlutter
and
RedisRedis

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

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
Needs advice
on
C#C#
and
sqlsql

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

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
15245 developers follow Microsoft SQL Server to keep up with related blogs and decisions.