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
Newsoftwares USB Block 1.7.3 | Size: 4.8 MBA simple USB device can steal all your hard work in a blink! USB Block helps you to overcome such risk! USB Block is a data leak prevention software to block USB drives on your PC. Prevent theft and leakage of your important files, documents and source cod...
File Size: 2.42 MBAutomatic Mouse and Keyboard is a really powerful and easy-to-use Mouse and Keyboard automation tool. It makes your mouse move and click automatically on locations that you defined. It can use a small picture to locate a point on the screen, which makes it very flexible. Regardles...
Freemake Video Converter Gold 126.96.36.199 Multilingual
Date: 03/22/18 02:30 in : Software
Freemake Video Converter Gold 188.8.131.52 Multilingual | File size: 35.7 MBFreemake Video Converter Gold - Convert video to AVI, MP4, WMV, MKV, 3GP, DVD, MP3, iPad, iPhone, PSP, Android phones. Video to MP3 with one click! Rip & burn DVD. Convert YouTube to MP4, AVI, etc. with Freemake! Guaranteed re...
File size: 3.7 MBDynaRide is an advanced gain rider plug-in with multiple detector programs and switchable pre-delay. On top of it DynaRide can enhance the output signal by limiting the riding process to specific audio signals like speech, vocal and bass. Ride Control DynaRide offers several...
Password Vault Manager Enterprise 184.108.40.206 Multilingual
Date: 03/22/18 02:30 in : Software
File size: 127.7 MBPassword Vault Manager lets you and your team centralize your organization's passwords and credentials into one secure repository. Manage user security rights and access, reduce help desk support calls and strengthen your network security by generating only strong and unique pass...
Languages: English | Microsoft Excel and PowerPoint Add-in | File Size: 90.05 MBStrategy professionals use Mekko Graphics to deliver insights and action plans. Marketers rely on Mekko Graphics when communicating results and recommendations. Financial professionals use Mekko Graphics to translate co...
Renault Reprog 164 [2018. 25.01] Size: 3.66 GB Type: Software
Languages: English | File Size: 110.9 MBdbForge Studio is a universal MySQL client for Windows that enables MySQL developers and administrators to create and execute queries, develop and debug MySQL routines, automate MySQL database object management in the convenient environment, and many others. ...
File size: 3.3 MBGainrider 2 is a (vocal-) gain riding tool which gives fully control over the gain riding process. GainRider 2 is the successor of GainRider, our very popular gain riding popular. It offers more ride algorithms and reduces plugin delay. Gainrider 2 lets you control all aspec...
Atomix VirtualDJ 8 Pro Infinity 8.2.3994 Multilingual
Date: 03/22/18 02:30 in : Software
File Size: 34.6 MBVirtualDJ is the application that DJs use when they want to use a computer to play their music. Because being a DJ is more than just pressing play, DJs cannot just use iTunes or Media Player to perform a mix. They need special controls like crossfaders, loops, effects, etc, in ord...