Ease of integration with Microsoft power automate flows. I have created views and have run the scripts on data too.

The design part of the view sometimes return errors while the query works successfully.

I have 2 sources of data for the punch details of the employees here. One from the ERP system and One from the payment software. MS SQL has made it easy to connect these 2 sets of data together and do comparisons on it.

ADVANCED FUNCTIONALITY WITH LESS COMPLEXITY

SOME TIMES THERE IS A MEMORY BASED ERROR

INTEGRATION, IMPLEMENTATION AND AUTOMATION ISSUES

QUERY PERFORMANCE ,ALWAYS ON, IT IS GOOD SOFTWARE FOR MEDIUM SIZE INDUSTRIES

CURRENTLY ALWAYS ON REQUIRE DOMAIN CONTROLLER , REQUIRE NEW WAYS WITHOUT DOMAIN CONTROLLER

WHILE WORKING PROBLEM IS COMING BUT RESOLVE BY THE HELP OF ONLINE ...IT IS GOOD

Microsoft SQL Server is a database management system. It is widely used in many companies. It is very stable and can handle large volumes of data at a time. It is secure enough and roles can be assigned to users for access to the database. You can also use the SQL Server Reporting Services for analysing data. It is easy to get help from the Microsoft support team for any issues. Replication of a database is easy to do.

It utilizes a lot of resources on the system that it is installed on. This can slow down the system thus making it difficult to use. Regular maintenance and monitoring is required.

It helps store large volumes of data and is easily compatible with automation tools like RPA Automation Anywhere and Microsoft Power Automate. Procedures/Functions can be written for specific data requirements.

The best thing about Microsost SQL Server is that it is user friendly. It is easy to integrate other tools like PowerBI, Excel with it which indeeds helps in streamlining workflows with ease.It provides advanced security feature which includes encryption and authetication making it a reliable tool. Microsoft offer many support channel. it includes 24/7 assistance and a diverse knowledge base. It is also useful for daily usage whether it's querying data from a database or generating reports. The installation and setup process of SQL server is straighforward.

Although SQL Server is user-friendly, yet some features of it might seem challenging to beginners. For larger systems,setting up SQL server could take up ample amount of time which is a downside. Customer support is good but sometimes the response time could be high for things which has higher urgency.

1. It helps save large amount of data in an organized way (normalisation). A proper schema (star, snowflake) can be created in Microsoft SQL Server which helps in arranging data in a structure way making it easy for data analysis. With the help of SSRS (built-in tool), it is easy to create reports in no time. Because of it's advanced security features, the data is now entirely secured and trusted. Various tasks like alerts, updates etc could be automated which indeed reduced the manual work.

We can actually interact with sevaral data server and Which can exports in excel.

Slightly lags a bit while opening application.

Gather that data that provides by customer and we can combine to solve our problems.

It provides a fastic integration with other Microsoft products.

In my view, it is not as powerful as postgresql.

It helped me to store and retrieve data for company reports.

I really like MS SQL, I'm using this tool for more then 10 years

Need to grab some cool feature from tood.

It's easy to connect to multiple servers and perform any administrative or developer tasks.

Microsoft SQL Server has robust Database Management System which supports and stored operational data

None, it has a rich UI and very simple navigations

Storing your business day to day operational and transactional details

Easy to learn syntax and well documented learning material. it also follow the statandard SQL syntax.

Lack of protection against deleting the entire table since it does not make provision of where clause mandatory. When you have sub-query on your query it allows the use of main query fields in the sub-query without explicitly referencing the main query table name or aliase, if this was done in error it will not raise any syntax error, it will just use the field of the main query if it's not found in the sub-query resulting with unexpected (and often unnoticed) results.

Management of large data that need to be accessed on demand. Most of the application I develop are data-driven and are access my multi users which are not technical, so it helps storing and retrieving the data that I present to my end users.