Location>code7788 >text

Microsoft is holding back: SQL Server + Copilot = the strongest AI database on the planet!

Popularity:91 ℃/2024-11-12 08:24:51

Microsoft is holding back: SQL Server + Copilot = the strongest AI database on the planet!

Microsoft Lays Out Code for AI Supremacy

Microsoft's layout in the field of artificial intelligence is notable, especially in the field of code generation, Microsoft has shown strong competitiveness through Copilot, a large model code assistant tool based on artificial intelligence, which can help developers quickly generate code and significantly improve productivity. Microsoft, with its leading position in the field of AI technology, is constantly promoting the development of Copilot, and has long been without any rivals.

 

 

 

From the acquisition of github

Microsoft acquired GitHub, the world's largest code hosting platform, for $7.5 billion in 2018, a move that can be considered an important strategic move in Microsoft's AI layout.GitHub has more than 30 million developers on it and manages more than 96 million code repositories. These code repositories are not only a platform for developers to collaborate and share code, but also a base for huge amounts of data. For Microsoft, these data are the core resources needed to train Copilot.

Through GitHub, Microsoft is able to access the work and code practices of developers around the world, thus providing Copilot with richer and more accurate training resources. As Copilot continues to be optimized and upgraded, Microsoft has gradually transformed it into an "intelligent assistant" for every developer. In addition, Microsoft is committed to enabling developers to customize their own Copilot Agent to meet the individual needs of different development scenarios.

 

 

Common PC and cell phone local large model popularity

With the improvement of hardware technology, an ordinary PC can run models with hundreds of billions of parameters, and a cluster of several machines can even handle trillions of parameters. Microsoft's layout in the field of code AI will greatly promote the realization of this trend, and code generation tools will undergo a qualitative leap, further consolidating Microsoft's dominant position in the field of AI.

GitHub, once jokingly called "the world's largest same-sex dating site", has now been transformed into Microsoft's "data engine" in the field of code AI. In the future, perhaps every developer will have their own Copilot, which will follow them in their daily development, and Microsoft's AI ecosystem will become stronger and stronger with the support of developers around the world.

 

 

Microsoft's Ultimate Layout

It is expected that Copilot and SQL Server will be deeply integrated in the next SQL Server release, when a series of AI-based features such as Text2SQL, RAG, and vector databases will be fed to users. Microsoft Copilot assists SQL Server database administrators and developers with data manipulation, automatically generates optimized SQL statements, and predicts and handles potential problems in database operation, such as automatic database fault self-healing. With the deep combination of SQL Server and Copilot, Microsoft is creating a new ecosystem of integrated AI and database capabilities to address the AI databases introduced by Oracle Database, an old rival.Oracle23AI

Additionally, Oracle 23c (c for Cloud) was renamed Oracle 23ai on May 2, 2024, signifying Oracle's departure from thesurname Yunchange over toAI The strategy of this steering wheel is really playing a little big, so it can be said that the database AI war is now on the verge of breaking out.

The introduction of Copilot has also further lowered the threshold of using databases in enterprises, especially after PCs are integrated with large models, SQL Server running on PCs can help users interact with databases through natural language. It can even accomplish tasks such as data query and analysis without understanding SQL syntax. Combined with Copilot, the future SQL Server will not only serve data experts, but also become a data analysis tool for low-code/no-code users, empowering more enterprises and developers.

 

In fact, Microsoft has been offering Machine Learning Services (MLS) since SQL Server 2016, a machine learning service that allows you to use languages such as Python, R, Java, etc. on the databaseDirect trainingmachine learningmould! This feature of machine learning services is being refined in every major release in the future, which means that SQL Server already had this kind oflead by a wide margin(used form a nominal expression)functionalityUp!

The built-in programming languages are as follows

 

The Python implementation architecture is as follows

 

The screenshot of the installation interface is as follows

at the present timeSQL Server 2025The CTP version is delayed, so I guess Microsoft is holding back a big move and there is a possibility of jumping the gun.

 

Microsoft has now invested nearly14 billionDollars, in addition, the current domestic service of OpenAI is only provided by Azure public cloud, in addition to Azure public cloud and no other channels.

 

According to this development trend, it is possible that Microsoft will put the core technology of OpenAI in the future.GPT v5.0transplant it inSQL Server 2005, it's currently up to Microsoft to putlarge modelstuffed into SQL Server, soMicrosoft corporationwill be inFar ahead on the AI databaseWhat do you think, Yuanfang?

 

 

 

This article is copyrighted and may not be reproduced without the author's permission.