Advantages of Microsoft SQL Server:
Increasing the efficiency of processing in memory, in which transactions are processed 30 times, and queries - 100 times faster than in disk relational databases and operational intelligence systems in real time
The new Always Encrypted technology (always encrypted) helps protect data when stored and moved, on local systems and in the cloud, using the primary keys located in the application, without making changes to the application
The Stretch Database technology (database extension) allows you to keep most of the client log data at hand by moving the OLTP data to Microsoft Azure in a safe way without having to make changes to the application
The built-in advanced analytics capabilities provide scalability and efficiency in the creation and execution of additional analytical algorithms directly in the main transactional SQL Server database
Exploring business data by rendering on mobile devices using native applications for Windows, iOS, and Android
Simplified management of relational and non-relational data using T-SQL queries using PolyBase
Quick hybrid backups, high availability and disaster recovery scenarios for backing up and restoring local databases in Microsoft Azure, and hosting the AlwaysOn SQL Server replica in Azure
SQL Server 2017 includes many new features, improvements and improvements for the database engine.
The CLR builds can now be added to the allowed list as a workaround for the clr strict security function described in CTP 2.0. To support the list of allowed trusted assemblies (RC1), the functions sp_add_trusted_assembly, sp_drop_trusted_assembly and sys.trusted_assemblies were added.
Renewable index rebalancing in connected mode: allows you to resume this operation from the moment you stop after a failure (for example, when replicating a replica or lacking disk space), or pause and resume it later. In the ALTER INDEX section and guidelines for operations with indexes on the network. (CTP 2.0)
The IDENTITY_CACHE parameter for ALTER DATABASE SCOPED CONFIGURATION allows you to avoid skipping the values ??of the identity columns when an unexpected server restart or server failover occurs on the secondary server. In the ALTER DATABASE SCOPED CONFIGURATION section. (CTP 2.0)
A new generation of query processing functions that use optimization strategies to adapt to the workload environment of your applications. In the first version of the family of functions for adaptive query processing, we included three improvements: adaptive connections in batch mode, feedback on the temporarily provided memory buffer in batch mode, and interleaved execution for multi-operator functions with tabular values. See the section Adaptive processing of queries in SQL databases.
Automatic configuration of the database provides information about possible problems with processing requests and recommended solutions. It can also automatically correct identified problems. See Automatic tuning. (CTP 2.0)
New features for graph databases for modeling many-to-many relationships include the new CREATE TABLE syntax for creating boundary tables and node tables, as well as the MATCH keyword for queries. See Graph Processing with SQL Server 2017 (Working with Graphs in SQL Server 2017). (CTP 2.0)
The sp_configure parameter, called clr strict security, is enabled by default to improve the security of the CLR assemblies. See the CLR strict security section. (CTP 2.0)
The installer now allows you to set the initial size for each tempdb file to 256 GB (262,144 MB). If the file size exceeds 1 GB and the instant initialization of the files is not enabled, a warning is issued. (CTP 2.0)
The modified_extent_page_count column in sys.dm_db_file_space_usage tracks differences in each database file, allowing you to use intelligent solutions for full or differential backups, based on the percentage of changed database pages. (CTP 2.0)
The T-SQL SELECT INTO syntax now supports loading the table into a filegroup that is different from the default user group by using the ON keyword. (CTP 2.0)
Now transactions are maintained between all databases included in the AlwaysOn availability group, including databases that are part of the same instance. See Transactions - Always On Availability Groups and Database Mirroring (CTP 2.0)
New features for Availability Groups include support for groups without clusters, a minimum number of replicas for commit, migration capabilities between Windows and Linux, and testing on both systems. (CTP 1.3)
New dynamic administrative views:
sys.dm_db_log_stats provides a summary of the attributes and information about transaction log files that help you monitor the health of transaction logs. (CTP 2.1)
sys.dm_tran_version_store_space_usage tracks the use of the version store for each database, which helps to quickly schedule tempdb sizes. (CTP 2.0)
sys.dm_db_log_info provides information about virtual log files (VLFs) for tracking possible problems with transaction logs, alerting and preventing these problems. (CTP 2.0)
sys.dm_db_stats_histogram is a new dynamic administrative view for analyzing statistics. (CTP 1.3)
sys.dm_os_host_info provides information about the operating system for Windows and Linux. (CTP 1.0)
The Database Tuning Advisor (DTA) tool has additional features and higher performance. (CTP 1.2)
Improvements in memory include support for computed columns in optimized tables, as well as full support for JSON functions and the CROSS APPLY statement for modules compiled in native code. (CTP 1.1)
New string functions: CONCAT_WS, TRANSLATE and TRIM, and for function STRING_AGG WITHIN GROUP is now supported. (CTP 1.1)
New parameters of mass access (BULK INSERT and OPENROWSET (BULK ...)) for CSV files and Azure BLOBs have appeared. (CTP 1.1)
Improvements to work with optimized objects for memory include sp_spaceused and the elimination of a limit of 8 indices for optimized tables for memory, sp_rename for these tables and for T-SQL modules compiled in native code, and CASE and TOP (N) WITH TIES for compiled in own code modules. Files in the filegroup that are optimized for memory can now be stored, backed up and restored using the Azure storage service. (CTP 1.0)
DATABASE SCOPED CREDENTIAL - A new class of protected elements that support the CONTROL, ALTER, REFERENCES, TAKE OWNERSHIP, and VIEW DEFINITION permissions. ADMINISTER DATABASE BULK OPERATIONS is now displayed in sys.fn_builtin_permissions. (CTP 1.0)
The database COMPATIBILITY_LEVEL 140 has been added (CTP 1.0).
OS: Windows 8, 8.1, 10; Windows Server 2012, 2012 R2, 2016 ( only x64 ). OS for editions of Web Edition, Enterprise Edition ( only x64 ): Windows Server 2012, 2012 R2, 2016. Versions of Windows 7 and Server 2008, 2008 R2 are not supported!
Hard disk: at least 6 GB of free disk space
RAM: Express releases 1 GB, all other editions 4 GB and above
Processor speed: 2.0 GHz and higher
Processor type: x64 AMD Opteron processor, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support
Requirements for SQL Server Management Studio: Microsoft .NET Framework 4.6.1
Microsoft SQL Server 2017 x64 Russian
Microsoft SQL Server 2017 x64 English
Lucion FileCenter Professional Plus 10.2.0.29File Size: 197 MBFileCenter, the low-cost leader in document management, combines easy scanning and file organization with powerful PDF creation and editing. It also includes OCR, Search, and a brandable Client Portal. For online file access, it even int...
SmartFTP Enterprise 9.0.2600.0 MultilingualFile Size: 55.6 MBSmartFTP is an FTP (File Transfer Protocol), FTPS, SFTP, WebDAV, Amazon S3, Backblaze B2, Google Drive, OneDrive, SSH, Terminal client. It allows you to transfer files between your local computer and a server on the Internet. With its man...
EF Commander 18.07 MultilingualFile size: 8.6 MBEF Commander is a complex and multi-featured file manager that a wide range of users, from beginners to professionals, will find easy to use. It is the result of many requests received by the author. The first version was written in 1994, under the OS...
Adobe Bridge CC 2018 v126.96.36.1993 (x64) Multilingual | 1.1 GBKeeping track of all the videos, songs and photos stored onto a computer can be a daunting task if the media files are scattered all over the hard drive, so a centralized management solution that can help organize them is welcomed. If that ...
RAM Structural System CONNECT Edition V15 Update 9
Date: 07/18/18 02:30 in : Software
RAM Structural System CONNECT Edition V15 Update 9 | 392.8 mbBentley Systems Inc., is pleased to announce the availability of RAM Structural System CONNECT Edition V15 Update 9. This software can be used to design nearly every structural component of a building structure, from the foundations to th...
Mailplane 3.8.1 Multilingual | macOS | 80 mbUnsophisticated Gmail desktop client that enables you to manage multiple email accounts and the calendars associated to them via the familiar web user interface. Mailplane is a simple Mac app that will work with your Gmail accounts, and provides the same ...
Adobe After Effects CC 2018 v188.8.131.52 (x64) Multilingual | 1.9 GBMake a big scene bigger. Create cinematic movie titles, intros, and transitions. Start a fire or make it rain. Animate a logo or a character. With After Effects CC, the industry-standard animation and creative compositing app, you ca...
Apowersoft Video Download Capture 6.3.5 (Build 07/16/2018) Multilingual
Date: 07/18/18 02:30 in : Software
Apowersoft Video Download Capture 6.3.5 (Build 07/16/2018) Multilingual | File size: 67.9 MBVideo Download Capture, the comprehensive tool with advanced technologies for online streaming media, offers a cost-effective choice to download videos from YouTube, Dailymotion, Vimeo, Yahoo Screen, and Hul...
EF Commander 18.07 Multilingual Portable | 12 MbEF Commander is a complex and multi-featured file manager that a wide range of users, from beginners to professionals, will find easy to use. It is the result of many requests received by the author. The first version was written in 1994, under the OS...
Hard Disk Sentinel Pro 5.30 Build 9417 | 24.6/25.8 MbHard Disk Sentinel (HDSentinel) is a multi-OS SSD and HDD monitoring and analysis software. Its goal is to find, test, diagnose and repair hard disk drive problems, report and display SSD and HDD health, performance degradations and failures. Ha...