Shulou(Shulou.com)05/31 Report--

How to use the correct attitude to examine SQL Server database, I believe that many inexperienced people are helpless about this, this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Many friends who use SQL Server databases may start using MSSQL2000 and upgrade all the way. The current version is 2019, but only a preview version is available. The official version of SQL Server is version 2017, which is also the version I am currently using.

SQL Server 2019 is really amazing, she has a major breakthrough in big data clustering, database engine and other aspects, but also provides a new tool Azure Data Studio, if you are interested, you may wish to download a preview version to try it out.

The following is a history of SQL Server versions. If you have been using SQL Server, you can see which versions you have used:

The most popular database is MySQL, not SQL Server. Many people are disgusted with SQL Server, because MySQL is open source, there is no copyright dispute, and SQL Server is a commercial database, you need to buy; or because MySQL resources on the Internet are very rich, the cost of use is relatively low; or because everyone simply does not like Microsoft's monopoly software company.

There's no way, it's really cool to use open source free databases, not worry about copyright issues, not spend money, and have a lot of resources available online. Not only do you like it, but I also like it very much. If you use open source free databases, you may feel like the air you breathe is sweet, and those who still use SQL Server are like uncivilized old hats.

SQL Server and Oracle, DB2, Informix, Sybase and other commercial databases were born in the same era, there are decades of development history, in terms of functionality and performance, SQL Server is not bad. We all have this consensus, Microsoft's advantage is stupid things, but performance is very general, SQL Server is no exception.

I have used many databases, SQL Server, MySQL, PostgreSQL, Access, SQLite, etc. Since MySQL was acquired by Oracle, I feel that MySQL has been sentenced to death, but MySQL has occupied a large number of markets. According to Oracle's rogue character towards Java, I feel that MySQL's future is doomed.

Happily, MariaDB appeared, a fork from MySQL promising to continue the open-source free route. To put it bluntly, I just don't like big hooligans like Oracle. There is also a group of people of insight in China who have developed a very powerful NewSQL database TiDB, which is also along the path of transcending and replacing MySQL.

For large applications, we generally do not choose SQLite and Access, which are more suitable for local storage, just like you use a fruit knife to kill cattle, feel that the knife is handy, but do not produce good results.

As far as personal preference is concerned, large applications still choose PostgreSQL or TiDB, if you really can't give up MySQL, you can also try MariaDB, the two are like twin brothers. PostgreSQL claims to be the world's most powerful open source database, and this name is not covered;TiDB is an open source database contributed by China, and its support for OLAP and OLTP is excellent.

With the rapid development of NoSQL, some friends are full of passion for MongoDB, Redis, etc. MongoDB originally had a good future, but it was distorted by their own selfish desires. In general, NoSQL database applications have not been widely spread, but NewSQL has emerged, NewSQL is inclusive, absorbing all the advantages of traditional databases and NoSQL, and will definitely take away many traditional databases and NoSQL databases in the future.

For friends who use the database, liking it is one thing, and using it to earn money to support their families is another. A lot of friends are not scolding the tools they are using, praising the tools they want to use but can't use frequently, but they still have to use the tools they scold to make a living. My favorite database is PostgreSQL, but I don't use it much.

The author's customers are mainly factory ERP applications, I also weigh repeatedly, in terms of various costs, the cost of using SQL Server is still low, maintenance will be a lot more convenient. There are very few professional database administrators in the factory. In addition to SQL Server, it is difficult for ordinary network managers of other databases to play.

Some of the more "smart" friends, they only use tables, views in the database these basic elements, and do not touch stored procedures, custom functions these. These friends want to replace the database is really quite simple, the table created script export, a little modification can be used in other databases.

But there are also some "stupid" friends like me who like to use stored procedures and custom functions. I love stored procedures to the extent of obsession. The client basically does not pass queries and update statements to the database. All operations are encapsulated in stored procedures.

As you can imagine, database migration is harder than ever. Fortunately, when I was developing a new system, all SQL scripts were in duplicate, one for SQL Server and one for PostgreSQL. Both databases were supported, which would consume more energy and time, but I could always find a psychological balance between preferences and applications.

Although many friends hate SQL Server, we have to admit that SQL Server is powerful and has good performance. You can hate her, but she won't die, and she may live well. If you hate her but can't live without her, try doubling everything, as I did.

NoSQL Database with High Throughput and Low Latency--Scylla 3.0 Released

RedHat Satellite abandons MongoDB for PostgreSQL

March database ranking: MySQL index continues to rise, PostgreSQL fell

MySQL database optimization

"Working overtime until your head is bald"? GitHub database blocked by Tencent Xiaomi and others

After reading the above, do you know how to look at SQL Server databases in the right way? If you still want to learn more skills or want to know more related content, welcome to pay attention to the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.