SQL Server 2012

SQL Server 2012 It provides a cloud computing information platform. sql2012 can help enterprises have a breakthrough in-depth understanding of the entire organization, and can quickly redeploy solutions and extend data in internal and public clouds. Zol provides the Chinese version of SQL Server 2012 for download.

Software benefits

Microsoft SQL Server 2012 Main Services:
- Provide the required running time and data protection through AlwaysOn;
- Achieve breakthrough and predictable performance through column storage indexes;
- Help achieve security and compliance through new user-defined roles and default architecture for groups;
- Fast data recovery through column storage indexes to better understand the organization;
- Ensure more reliable and consistent data through SSIS improvements, Master Data Services add ins for Excel, and new Data Quality Services;
- Optimize the work efficiency of IT and developers between the server and the cloud by using parity check of data tier application component (DAC) of SQL Azure and SQL Server data tools, so as to achieve a unified development experience among database, BI and cloud functions.

Software features

1. Columnstore index - This is a unique feature of SQL Server. They are read-only indexes designed for data warehouse queries. Data is stored in the form of flat compression, greatly reducing data I/O and memory usage.

2. PowerView - This is a powerful autonomy for BI users to create tool BI reports.

3. Big data support - this is the most important point, although it has ended. PASS (Professional Association for SQL Server) Microsoft announced the cooperation with Cloudera, the provider of Hadoop. The first is to provide the SQL Server ODBC driver for Linux. The main cooperation content is Microsoft's development of Hadoop connector, that is, SQL Server has also entered the field of NoSQL.

4. SQLAzure enhancement - This is not directly related to SQLServer 2012, but Microsoft does take the critical improvement of SQLAzure as an example, ReporintService, and back it up to Windows Azure. The upper limit of Azure database is increased to 150G.

5. Customized server permissions - DBA can create database permissions, but cannot create server permissions. If the DBA wants to have read and write access to all databases on the server, it must complete the operation manually. SQL Server 2012 supports server permission settings.

6. AlwaysOn - This function promotes database mirroring to a new height. Users can perform disaster recovery for a group of databases instead of individual databases.

7. BI This function is used to replace the semantic model "AnalysisServicesUnifiedDimentionalModel" Yes. This is an experience that supports all BI mixed data models of SQL Server.

8. WindowsServerCore support - WindowsServerCore is the command line interface Windows, which uses DOS to interact with PowerShell users. It uses less resources, is more secure, and supports SQLServer2012.

9. Enhanced audit function - All SQLServer versions support audit. Users can customize audit rules and record some customized time and logs.

10. SequenceObjects - With Oracle, people always want this function. (sequence) Based on the self increment of the trigger. SQLServe has a similar function, identitycolumns, but it is implemented with objects.

11. Distributed Replay - similar to Oracle's RealApplicationTesting function. The difference is that the enterprise version of SQL Server has its own functions. If you use Oracle, you can purchase additional functions. This function allows you to record the working status of the production environment, and then reproduce these working status in another environment.

12. Enhanced PowerShell support - All Windows and SQLServer administrators should seriously learn PowderShell skills. Microsoft is vigorously developing support for its server side product PowerShell.

Installation steps

1. Open the downloaded SQL Server software installation package, right-click the compressed package and select [Extract to Current Folder].

2. Wait for the decompression of the compressed package to complete.

3. Open the unzipped [SQL Server 2012] folder.

4. Right click the [setup] program and select [Run as administrator].

5. Click Install, and then click New Install or Add Functions to Existing Installation.

6. Click [OK].