sql 2012（SQL 2012）.docVIP

sql 2012（SQL 2012） SQL Server 2012 download address Software profile Microsoft SQL Server 2012 (Chinese official version sql2012 download) provides a cloud computing platform, the platform can help enterprises understand the breakthrough of the organization, and can be quickly inside and heavy public cloud deployment scheme and extended data. Microsoft, SQL, Server 2012, main services, main services, main services, main services: - provide the required runtime and data protection through the AlwaysOn; - achieve breakthrough and predictable performance through column storage indexes; - help achieve security and compliance by using new user defined roles and default schema for groups; Fast data recovery through column storage indexes to better understand the organization; - through SSIS improvements, Master, Data, Services, add INS, and new Data Quality Services for Excel, to ensure more reliable, consistent data; By using SQL Azure and SQL Server data tools data layer application component (DAC) parity, IT and developers work efficiency optimization and cloud server, so as to realize the unified development experience in the database, BI and cloud function. Check out the exciting features of the new version of SQL Server 2012 1. AlwaysOn - this feature brings the database mirror to a new height. Users can do disaster recovery for a set of databases instead of a separate database. 2., Windows, Server, Core support - Windows Server COre is the command line interface Windows, using DOS and PowerShell to do user interaction. It has less resources and is more secure and supports SQL Server 2012. 3. Columnstore index - this is the unique feature of SQL Server. They are read-only indexes designed for data warehouse queries. Data is organized into compressed compressed storage, greatly reducing I/O and memory usage. 4. custom server permissions - DBA can create database permissions, but cannot create permissions for the server. For example, DBA wants a development group to h