Microsoft SQL Server Erfahrungen

SQL Server is a great system to develop databases with great functionalities like jobs, procedures, functions ans so one

For me the only think not so good is performance for bigger batabases, but for me between 10GiB and 15GiB works fine

I really like the functionality of the software and the number of features it has to offer

It was a little confusing at first figuring out how to get around on it but the tutorial was very helpful

Is quite secure, it guarantees the security of the databases, it is very easy to configure unlike other database management programs, the installation and configuration is easier. And it also has data recovery support.

Cost, there is a free version that can be used, however for more advanced data-driven applications and functions, you will need to make a considerable investment in higher versions of the software. Also, additional investments in Microsoft software may be necessary if your company uses some or no Microsoft infrastructure.

We had to migrate our free databases to SQL server because we reached many gigabytes in a few tables and needed a fast and reliable software to handle it and integrate with some BI products. Microsoft SQL Server had no issues and works really fine.

License costs are major issues , but any other paid database costs about the same. It is still a bit overkill for us but we are looking at using it in the cloud as a PaaS.

Can handle large databases.Excellent performance and query optimization.

Limited compatibility with non-Microsoft operating systems.

Best database service for legacy applications out there will always work.

A software I cannot fault for any reason really.

The performance is outstanding. Includes features like reporting and analytics. Easily integrates with Microsoft products like .NET framework.

Very expensive though worth it. Available only on windows.

SQL Server provides a robust and scalable platform for managing and storing data with its advanced features like high availability, disaster recovery, and real-time analytics. Its integration with Azure cloud services and Power BI makes it a complete solution for data professionals.

Licensing can be expensive, and some features require additional costs. Limited compatibility with non-Windows operating systems may also be a concern for some users.

It si used for retrieving the data from database using sql scripts. We can also update the data using sql script

While opening and connecting to this sql server it takes some time to load. It can be little bit faster.

I really enjoyed how easy it was to use. The server was self explanatory and I was able to practice effectively with minimal help.

The clicks to do certain thing or retrieve certain information could be reduced so that efficiency could be maximized.

We love SQL Server's versatility. Every single application we purchase for insurance has support for SQL Server. We have not come across any situation where SQL Server didn't meet our needs.

License models are a bit confusing. Some years Microsoft make it easy to understand. Other years Microsoft makes it even more confusing. Can we run SQL Server in our data centers? Can we run it on the cloud? Do we need to change licensing to run in the cloud? Those questions sound easy to answer but the answers we get from Microsoft or resellers confuse us more. It just seems like the confusion is intentional.

For any developer, before first they can this own what their apps are going to be developed in their should think of what server should host their database. I do believe that MS SQL Server is the best on the marketing when comes to data management and administration. The best feature that i really love the most on MS SQL Server is the ability to disable remote execution of your queries and really helps protect data integrity in case your server authentication has been compromised. You can also be rest assured that your data is consistent and accurate at all times. Yes hackers some times can try sql injection but i believe MS SQL Server its the most secure servers around.

The license key for MS SQL might cost you an arm and a leg but at the end of the day its really worth it when you think of a platform where you are able to develop enterprise apps that secure and helps with Business Intelligence.

SQL Server is the enterprise system database, and its toolset is provided as standard. Many departments in the company use it as a database when creating a small system. Its graphical user interface is easy to use even for beginners, and its data can be queried seamlessly from other Microsoft products such as Access.

The application has very few bugs and offers stable operation.
The core elements of the product's usability remain the same despite repeated changes.
Both the cost and feature set of Oracle is superior to NetSuite.

How safe this database engine can be, its integration with other technological tools, say, programming languages, infrastructure, datawarehouse and more

A bit the price, since the enterprise license is a bit expensive

Security is one of the most important aspects of database software since sensitive information can be stored in databases. SQL Servers are some one of the most secure servers out there so data is safe from hackers.

The scaling aspect of this software is great so whether your business is very small or very large that uses huge amounts of data to be stored, SQL servers can scale and use appropriate resources to handle databases therefore no lagging issues and problems querying databases etc. which makes it extremely fast and efficient.

With the large community that uses SQL Server, you have answers to almost all questions that you may have if you encounter any difficulties setting up or using the software, so troubleshooting is made really easy.

Cost could be an issue as this software could be a bit expensive however with that being said, you definitely will get quality.

Also there might be certain compatibility issues with other non Microsoft software that your company may use so in some cases you might have to switch over to Microsoft softwares in your company depending on what they are.

1. Optimized storage and querying business critical data.
2. Powerful Tsql Query language.
3. Query execution plan to predict and optimize the data.
4. Query profiler to find out anomaly and query latency.

1. We need to take care of all patching works.
2. We need to take care of all infrastructure scalability(RAM,HDD and IO etc)
3. Server maintenance and outrage time is high.

The ability to store, manage , retrieve and backup large amounts of data without so much hassle. The availability of support on the internet is just amazing. It works well for small sized to big sized companies and the security of these databases is top notch. Since it has recently been integrated with Azure, it will be easier for cloud deployment and cloud support. Can also be used be as a reporting and analyzing tool.

The cost is a bit high and it requires skill to be able to work with sql. The larger the information on the database usually makes it to slow down in terms of querying it

Is powerfull
Easy
Complete
Customer Support
Features
interoperatibity

Have some errors
You need to reset de SQL 1 time at week
Consumes a lot of ram
it needs a Windows Server

It is easy to install. There is also a free Express Edition / Localdb, which has most features of the paid Version. The developer Edition has all Features of the Enterprise Edition. It is very easy to install even several instances on any system. I can solve nearly all tasks, I feel very confident. The documentation is great and it is easy to find answers to questions. It is just my every day tool.

If there are some heavy queries then the whole instance gets down, often even other instances on the same system. I don't understand why it is not possible to limit the effect.
Many features which I would like to use are only available in the enterprise edition. But this edition cost much more than standard and I am forced to use only features of the standard edition.
Often I am forced to use quite old version, for example 2016, but the current version is 2019. Again the reason is the price. Customers would need to spent more money for the latest version, therfore they force me to develop based on old versions.

As a IT consultant, I would say that one of the things I like most about Microsoft SQL Server is its versatility and scalability. It can handle a wide range of data types and sizes, and can be scaled up as the needs of the organization grow.Additionally, the security features in Microsoft SQL Server, such as user authentication, encryption, and auditing, provide a high level of protection for the data and the system, which is critical in many organizations.I also appreciate the integration that Microsoft SQL Server has with other Microsoft products, such as SharePoint and Power BI, making it a good choice for organizations that use Microsoft technologies.Finally, Microsoft SQL Server is easy to use and manage, even for users with limited database experience. This makes it a good choice for organizations that need a database management solution that is both powerful and user-friendly.Overall, Microsoft SQL Server is a robust and reliable database management software that provides scalability, security, integration with other Microsoft products, and ease of use, making it a popular choice among organizations of all sizes.

one of the things I like least about Microsoft SQL Server is its cost, especially for larger organizations that require more advanced features and capabilities. The cost of licensing and hardware can add up quickly, which can be a challenge for organizations with limited budgets.Another criticism of Microsoft SQL Server is its complexity. While it is a powerful and versatile database management software, it can be difficult to set up and manage, especially for users with limited database experience.Finally, some users have reported performance issues with Microsoft SQL Server, particularly in highly concurrent environments. This can result in slow performance and increased hardware and licensing costs.That being said, Microsoft SQL Server is a widely-used and well-regarded database management software, and many organizations find its benefits to outweigh these drawbacks.

The most noteworthy features of Microsoft SQL Server are the many tools and wizards that allow even novice users to get started by creating tables and views without extensive knowledge of relational databases. The query wizard can even assist with creating queries with its intuitive IDE. These features lower the intimidating barrier to entry that accompanies other relational database software such as Oracle or MySQL. There is even a free version call Express that allows anyone to dabble in the software before committing to the product.

Aside from the user assisted features, the other appealing aspect of SQL Server is the integration with other Microsoft products that are probably already running in an organization. SQL Server interfaces with Active Directory allowing for easy user management so appropriate levels of database access can be allotted via group membership. This is useful because even something simple like user access management in another RDBMS may present a learning curve for anyone that is not a DBA. With SQL Server a general IT resource could manage user access with an existing knowledge of Active Directory providing more time to focus on core database design.

SQL Server carries a high cost subscription based licensing cost. The user assistance features provide a great introduction to relational databases, but there is still a significant and continuous learning curve. Databases continue to evolve with industry need. Anyone that interacts significantly with SQL Server during day to day database or application design may need to consider yearly training to keep up with all the changes.

The review is based on my experience of using SQL Server as a database with SAP.

What I like about MSSQL :
- ACID compliant like any enterprise based RDBMS (Oracle, IBM DB2, SAP HANA)
- Runs well and scales well with commodity x86 hardware
- Various editions to suit customer needs and requirements. For example Express Edition for small workloads and is free, or all the way to Enterprise Edition for state-of-the-art functionality (High-Availability, Disaster Recovery etc. to prevent Single-Points-of-Failure). Its current functionality definitely rivals the existing enterprise RDBMS's
- Straightforward learning curve as it is Windows based. Unlike other RDBMS's (e.g. Oracle or DB2), administering a MSSQL DB is very easy GUI (SQL Server Management Studio) is very easy to use especially if coming from Oracle/DB2, or if you're learning from scratch
- Supports Linux (finally!) - MSSQL is no longer limited to the Windows platform, and Microsoft has released version on Linux to compete with the likes of Oracle, DB2, etc.

Over my years of using MSSQL have encountered numerous bugs (performance issues, corrupted data, etc.) but these are normal with other RDBMS's (Oracle, DB2, SAP HANA, etc.) given the enterprise nature of the workloads. Can't really think of any other disadvantages.

SQL Server allows users to setup up a database with different features, from basic database to a complex environment that can include partitions, replication, business intelligence, reporting, etc. Is really simple to deploy on different scenarios like on-premise or cloud. Regarding SQL Language - Transact SQL - it is simpler and easier than other languages. For beginners this could be something positive because of the velocity of the learning curve. The integration with the business process is really easy when working with other Microsoft technologies. Additionally there is an interesting feature called FileTables which allows see the storage as a table. SQL Azure database is something great, an scalable database service that can me managed with Management Studio tool and created in less than a minute.

Something that could be an improvement to MS SQL is related to the performance monitor. In general all databases require to have a relative high level of expertise to create a good database design. With a simpler performance tool, junior users could create better queries, indexes, model, etc...

• Microsoft SQL Server is the best RDBMS package I have ever worked on! (Other DBs I have used are - Oracle, Teradata, MySQL, and Redshift)
• Just like other Microsoft products; SQL Server is by far the most User-friendly Database Server - best IDE
• Lots of wizard features from import, export, backup, query builder etc that anyone can easily learn and do just with few clicks!
• Intellisense (like visual studio) to complete code while typing and showing common mistakes before you even execute
• Built-in execution plan viewer which is nice enough to start with.
• Free Plugins and third-party tools available to make your life even easier like: Poorman SQL Formatter, SentryOne Plan Explorer etc
• Integrates very well with other MS products. Full MS BI stack includes SSIS ETL, SSRS BI Tool, SSAS etc.

• No considerable cons. Maybe Microsoft should consider offering built-in features/tools for which developers use third-party tools and plugins. Like builtin execution plan viewer is not as great as SentryOne Plan Explorer.
• With so many built-in features one little must have to include is One click code indentation. Until Microsoft can add this feature, we can live with Poorman SQL formatter.

Relationship database is structured database management that create with data integrity and reliability in mind.

Slow performance with big data load requirements.
Also physically need to build primary keys for each tables instance.