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

MS SQL Server is certainly a competently relational database engine, with reporting service and now R.
Easy to install for small onpremise application.
Easy to administer, easy to backup, easy because it is a Microsoft application.
It is so easy that most of the application today I work on seem to be pulling data from SQL into Excel and or Power BI.
You can start from free version and expand as time goes by.
The management studio take the pain our of scripting, and the online support community most likely have your questions answered with T-SQL scripts for copy and pasting.
If you deciding on an option for an Relational Database system - you should look at this as your most productive option. It allows you to focus on the problem by making the technology easy.

The new the version, the more memory intensive this management studio will become.
Microsoft need to create some more easy to use tool for change control and change tracking.
Backward compatibility - if you used a higher version during development, then it become a pain to use a lower version during production environment.

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.

First and foremost, it has all the features and functionality from the basics to advanced users for relational database management. Can be integrated well with other Microsft software especially Visual Studio code for a smooth development experience. Along with data storage management, professional performance analysis can be performed through GUI server management studio tools like Database Tuning Advisor. Data Analysts will find data extraction and filtration as well as visual & interactive report generation quite beneficial in their routine tasks. Backup and restore from one SQL server to another is fairly simple. Pricing is very reasonable according to the DBMS system and tools that are provided.

One of the main issues is that licensing price packages are difficult to choose due to confing choices for common users. One other limitation is that a backup made in a newer version of MS SQL server is not compatible with an older version of SQL Server. For large volumes of data records and for complex data it becomes slower to process queries. Taking backup of a very large number of records also takes time. Sometimes difficult to debug syntax errors.

Personally, I like that the application is easy to use, obviously if you already have time using it and you are familiar with the concepts and terms used, the tools to create backups or schedule tasks to run on specific dates and times is quite good, the price is affordable not too expensive unlike oracle.

to install it is a bit time consuming, since you have to configure it on the fly, it does not bring any preconfigured default settings, this takes a little time to the user, to migrate to other operating systems other than windows, you have to make other extra configurations.

Among the most interesting features of Microsoft SQL Server we can disclose the following:
Robust & Secure System
Easy to Deploy
Performance+
Integration with Public Cloud such as Microsoft Azure

As many of Microsoft Premium products, SQL Server license is really expensive.

Microsoft has always tried over the years to improve its flagship product, achieving good stability and robustness. For administrators, the management interface is particularly useful and easy to use.
SQL Server has allowed us to manage several databases at the same time from our applications without problems giving the possibility to colleagues to have, for example, always updated sales data.

Unfortunately I must also report the defects and in this case in my opinion the interface for administrators has become too slow in terms of starting in the latest versions.
Sometimes product updates do not install correctly, even if this rarely happens it can create a general disservice almost always in time of need.

MSSQL comes jam-packed with features. It's standard library is enough to cover the needs of a small enterprise. It is also very stable and can handle large amounts of database exceedingly well. However, my favorite tool is the built-in scripting language - T-SQL. It is very powerful and flexible and lets you do anything you might need.

SQL Server takes up a lot of computing resource. We have a small data warehouse and yet it takes up over 1 TB. Views are not as useful as in Oracle. For example, partitioning a fact table by multiple columns is impossible without a workaround.

Microsoft SQL Server impressed me with its standout features that revolutionized our data management experience. The robustness and scalability of the platform allowed us to handle large volumes of data with ease. The advanced query optimization and indexing capabilities ensured optimal performance and fast retrieval of information. The comprehensive security measures instilled confidence in the protection of our data assets. The seamless integration with other Microsoft tools and technologies enhanced our overall productivity. Microsoft SQL Server has become an indispensable tool, empowering us to effectively store, manage, and analyze our data.

While Microsoft SQL Server offers powerful data management capabilities, there were a few aspects that left room for improvement. One drawback was the complexity of the platform, which required a steep learning curve and technical expertise. The licensing costs, especially for enterprise editions, might be a limiting factor for smaller organizations. Occasionally, the platform's performance could be affected when handling extremely large datasets. The documentation, while extensive, could benefit from more detailed examples and tutorials for complex scenarios. Despite these limitations, Microsoft SQL Server remains a robust and reliable choice for data management, but addressing these areas for improvement would further enhance its usability.

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.

1. It has different types of subscriptions - you can either test it with free versions, either use it to develop different projects or when you get in love with it - you can buy it with its powerful features.
2. It is a very good working engine.
3. SQL Server has stability, and the performance mechanisms are very cool.
4. You can maintain multiple instances and databases on one server.
5. There are a lot of built-in functions that developers can use, instead of writing their own.
6. Since the latest years, I think there are more and more new things to explore in newer versions - that is a point which shows that Microsoft invests a lot in their product.
7. It is reliable.

Since these years I didn't notice something which I do not like. On the contrary, I pretty like the product and all its features that I have been using through these years, and hope that in the future releases of SQL Server there won't be disappointing things, but only cool ones.

A very robust and quite reliable database engine provides a wide variety of tools and options that allow you to perform settings as daily tasks in an efficient way.
Today it is compatible with almost any operating system allowing you to configure it in the environment that best suits your needs.

Although it is a very portable and robust database engine, its refusal comes with its licensing, which can be very expensive, also its resource consumption can be high in very complex tasks, this leading to the need to invest in very high-end resources in order to meet the demand.

• 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.