![]() |
![]() |
![]() |
|
مواضيع عامة يشمل جميع المواضيع العامة |
![]() |
|
أدوات الموضوع |
![]() |
#1 |
دكتور رابد
تاريخ التسجيل: Aug 2016
المشاركات: 7,068
معدل تقييم المستوى: 16 ![]() |
![]() ![]() Microsoft SQL Server 2017 version 14.0.1000.169 All Editions | 6.9 Gb What's new in SQL Server 2017: SQL Server 2017 represents a major step towards making SQL Server a platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems by bringing the power of SQL Server to Linux, Linux-based Docker containers, and Windows. This topic summarizes what is new for specific feature areas and includes links to additional details. here كود:
https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2017 SQL Server on Linux uses the same code as SQL Server 2017 on Windows, with the exception of a platform abstraction layer that manages OS-specific calls. Other Major Features Arriving with SQL Server 2017 Automatic Tuning: While many database vendors have claimed to have self -tuning databases in the past, Microsoft has built intelligence into a set of self-tuning features in SQL Server 2017. Microsoft has learned a lot from supporting Azure SQL Database and identifying customer performance problems. Running a database service that services millions of databases allows for deeper insight into how customers use the product, and where their headaches are. They have taken that knowledge and combined it with the Query Store, a feature introduced in SQL Server 2016, which tracks query execution plans and runtime statistics. This allows the database engine to identify queries that have regressed in performance, and changed execution plans (the path the engine takes to get the query's data). If the engine determines that a change in plan has occurred, and the query has regressed in performance, the engine will revert to a previous plan. Graph Database: One of my favorite features is the introduction of a graph engine into SQL Server. Graph databases are commonly used to track relationships or hierarchies, a place where relational databases have struggled in terms of structure and performance. Graph databases are implemented via nodes (or vertices) and edges (or relationships). For example, you might say John is friends with Jane, and Jane is friends with Becky. While there have been a number of small graph database projects, many have not supported the SQL language, and integration with other systems. By bringing graph into SQL Server 2017, users can take advantage of native SQL, along with the new match operator to perform graph queries. Resumable Online Index Rebuild: As someone who has been a database administrator for way too long, this feature has tremendous appeal to me. Indexes get fragmented as updates and deletes happen, and need to be reorganized and rebuilt periodically. Performing these operations are very IO intensive, and are commonly run during maintenance windows. However on larger systems some operations may run beyond the window and have to be aborted, or more frequently, simply aren't run. Resumable index rebuild allows you to schedule fixed window for your maintenance operations (for example, allocating three hours a night to index maintenance); or simply pause and resume them manually. This feature will change the ways DBAs perform database maintenance. Everything Else: Some of the other features included in this release are improved performance for backups, more enhancements to the In-Memory OLTP feature and integration of the popular Power Query tool with SQL Server Analysis Services. Microsoft also released a very interesting enhancement to its advanced analytics features by adding a predict operator to the T-SQL programming area. This can be a very fast way to perform analysis on a pre-existing R or Python model. As you install SQL Server 2017, it is important to note that both SQL Server Management Studio and SQL Server Reporting Services are now separate installs from the database engine and other components. Management Studio has a different release cycle from SQL Server and is updated monthly. About Microsoft. Microsoft Corporation, leading developer of personal-computer software systems and applications. The company also publishes books and multimedia titles, offers e-mail services, and sells electronic game systems, computer peripherals (input/output devices), and portable media players. It has sales offices throughout the world. Product: Microsoft SQL Server Version: 2017 (version 14.0.1000.169) All Editions* Supported Architectures: x64 Website Home Page : كود:
www.microsoft.com System Requirements: PC Supported Operating Systems: here كود:
https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server * Microsoft SQL Server Developer 2017 Microsoft SQL Server Enterprise 2017 Microsoft SQL Server Enterprise Core 2017 Microsoft SQL Server Standard 2017 Microsoft SQL Server Web 2017 Download link: كود:
Links are Interchangeable - No Password - Single Extraction
|
![]() |
![]() |
![]() |
|
|
![]() |
||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Microsoft Office 2016 Professional Plus.16.0.4549.1000 (October 2017) | mitsumi | مواضيع عامة | 0 | 2017-10-11 01:10 PM |
Microsoft Office Select Edition 2016 Vl v16.0.4549.1000 2017 | bestsoft84 | مواضيع عامة | 0 | 2017-10-11 09:54 AM |
Microsoft Office Professional Plus 2016.v16.0.4498.1000 June 2017 | mitsumi | مواضيع عامة | 0 | 2017-06-10 11:28 AM |
Microsoft Office 2016 Professional Plus.16.0.4498.1000 (May 2017) Multilingual | mitsumi | مواضيع عامة | 0 | 2017-05-29 12:58 PM |
Microsoft Office Professional Plus 2016.v16.0.4498.1000 May 2017 | mitsumi | مواضيع عامة | 0 | 2017-05-11 06:43 AM |