Microsoft SQL Server 2012

Microsoft SQL Server 2012 – a fully ready-to-use information platform in the cloud, which provides confidence in the reliability of business-critical systems when working with data and characterized by increased availability, high performance and enhanced security features for critical workloads; advanced analysis with managed self-study and excellent capabilities for interactive data visualization; cloud technology to meet the needs of customers.

Download Microsoft SQL Server 2012

You can download Microsoft SQL Server 2012 from Service Pack 4 (SP4) by clicking here:

https://www.microsoft.com/en-us/download/details.aspx?id=56040

Microsoft SQL Server 2012 will be released in three main versions: Enterprise, Business Intelligence and Standard. Enterprise is a full-featured version of the product. Business Intelligence includes all the capabilities of Business Intelligence (BI), but lacks some of the high availability components. The Standard version provides the core capabilities of the relational model, business intelligence (BI) and availability.

The main innovations in Microsoft SQL Server 2012

• SQL Server AlwaysOn is a high availability and disaster recovery system that reduces planned and unplanned downtime.
• ColumnStore Indexing – function that increases the speed of execution of analytical and “* JOIN” queries by selected data columns up to 10 times.
• BI Semantic Model – a semantic model that helps you link business analytics, reports, scorecards and dashboards together.
• Security and encryption are new tools that help administrators share responsibilities, delegate services and functions to authorized employees, protect information and ensure compliance with data protection regulations.
• SQL Express LocalDB – a compact and free version of the database with support for all functions of SQL Server 2012, working in the space of user rights and requires virtually no configuration.
• SQL Azure Data Sync – a new service for two-way synchronization between the database in the data center and the cloud (private or public). Support for the popular hybrid IT model covering local systems and clouds has been significantly improved in SQL Server 2012.
• PowerView is a new subsystem for visualization and generation of reports PowerView (formerly Project Crescent), which is an interactive solution for visualization and modification of reports through a web-interface. PowerView uses a graphical web platform Silverlight, which supports animation and graphical effects, as well as new visual elements to display analytical data.
• Data Quality Services – service for checking data quality. It is used to properly load nomenclature data and maintain their compliance with established formats of writing, storage and output. DQS allows you to upload to the EIM system data that have different spelling formats.
• Data Quality Knowledge Base – the knowledge base containing formal description of mechanisms of loading, processing and transformation of data according to the formats defined in EIM system.

Microsoft SQL Server Business Intelligence 2012

Microsoft SQL Server Business Intelligence Edition 2012 is a full-featured business intelligence platform that enables organizations to create and deploy powerful, secure and scalable BI systems. Microsoft SQL Server Business Intelligence Edition 2012 is a new product in the line of Microsoft SQL Server. The edition provides convenient functions for displaying data in a browser, professional opportunities for combining data and advanced integration management.

Features of Microsoft SQL Server Business Intelligence Edition 2012:

Quick data search and visualization. PowerView – a new subsystem for visualization and generation of reports PowerView (formerly Project Crescent), which is an interactive solution for visualization and modification of reports through a web-interface. PowerView uses a graphical web platform Silverlight, which supports animation and graphical effects, as well as new visual elements to display analytical data.

Managed business analytics. Monitoring and management of data and analytics created by end users. IT specialists can review end-user activity and their work with data sources, collect performance indicators from servers. In addition, the 2012 edition transforms PowerPivot-created business intelligence applications into enterprise-class solutions.

Corporate reporting and analytics. Development and deployment of scalable, secure and managed corporate business intelligence solutions with advanced analysis and reporting functions, semantic table model BI Semantic Model and others:

• Improve the performance of data warehouses. xVelocity – technology to increase performance of data warehouses and business intelligence applications.
• Comprehensive data control. Data Quality Services – data quality assurance service. Used to properly load nomenclature data and keep it in compliance with established writing, storage and output formats. DQS allows you to upload to the EIM system data that have different spelling formats.
• Rapid recovery and ensure long term application availability. Windows Server kernel support has been added to the 2012 version. At the same time, Database Recovery Advisor improves the convenience of working with database recovery functions in SQL Server Management Studio. With SQL Server Management Studio, organizations can move their SQL Server logical database copy directly to SQL Azure for cost-effective and redundant data protection.
• Easily manage access rights to data using User-Defined Server Roles to support power sharing. The system allows you to increase manageability and reduce the complexity of the database structure with the new default scheme for groups of Windows user accounts. Database access control features for existing applications have been improved. Contained Database Authentication technology uses offline information for access and does not require you to log on to the server.
• Easily manage your infrastructure. The solution simplifies application testing and reduces errors with the new Distributed Replay component. Windows PowerShell 2.0 support automates management tasks across the Microsoft platform. Improvements in Sys Prep help IT professionals more effectively create virtual machines for private clouds. An updated set of controls for System Center Operations Manager gives you centralized control of your entire infrastructure.

Microsoft SQL Server Standard Edition 2012

Microsoft SQL Server Standard Edition 2012 – a reliable, efficient and intelligent data management platform, ready to work in the most responsible and demanding business applications, helping to reduce the cost of maintenance of existing systems and development of new applications and provides extensive business intelligence capabilities for all employees. The release of Microsoft SQL Server Standard Edition 2012 is a cost-effective option for small and medium-sized organizations. Microsoft SQL Server Standard Edition 2012 offers basic functions for data management, reporting generation and business intelligence in IT infrastructures with low resource loads and non-critical workflows. Microsoft SQL Server Standard Edition 2012 demonstrates best-in-class indicators of usability and manageability of applications on which the work of departments of the organization is based.

Features of Microsoft SQL Server Standard Edition 2012:

• Rapid recovery and ensuring long-term availability of applications. Windows Server kernel support has been added to version 2012. At the same time, Database Recovery Advisor improves the convenience of working with database recovery functions in SQL Server Management Studio. With SQL Server Management Studio, organizations can move their SQL Server logical database copy directly to SQL Azure for cost-effective and redundant data protection.
• Easily manage access rights to data using User-Defined Server Roles to support power sharing. The system allows you to increase manageability and reduce the complexity of the database structure with the new default scheme for groups of Windows user accounts. Database access control features for existing applications have been improved. Contained Database Authentication technology uses offline information for access and does not require you to log on to the server.
• Easily manage your infrastructure. The solution simplifies application testing and reduces errors with the new Distributed Replay component. Windows PowerShell 2.0 support automates management tasks across the Microsoft platform. Improvements in Sys Prep help IT professionals more effectively create virtual machines for private clouds. An updated set of controls for System Center Operations Manager gives you centralized control of your entire infrastructure.
• Easy data integration. Data can be used from heterogeneous sources. Integration services now include DBA and IT Implementer support for deployment and administration of ETL tasks, including improved tracking of SSIS package statuses, running SSIS packages as a server, the ability to run administration functions and others as a separate copy of the SQL server.
• Flexible analytics and reporting. Support for multidimensional models to build and scale business logic for users through reporting services. Report Builder 3.0 provides an intuitive reporting environment for business users and supports most key features of SQL Server Reporting Services. In addition, Microsoft SQL Server 2012 Data Mining Add-ins for Microsoft Office 2010 helps end users to take full advantage of SQL Forecast analytics in Office Excel 2010 and Office Visio 2010 systems.
• Professional development of innovative applications. SQL Server Data Tools is an integrated development environment for enterprise, mobile and web applications with data binding for public and private clouds. Data-tier Application Framework (DAC Fx) significantly simplifies the development, deployment and control of database application servers in the cloud.
• Extensive content support. SQL Server 2012 turns the content management process into an integrated application component. FileTable is designed to manage information in FILESTREAM BLOB Storage using standard tools and applications. Improvements in terms of full-text indexing allow you to increase search efficiency.

Microsoft SQL Server Enterprise 2012

Microsoft SQL Server Enterprise Edition 2012 is a reliable, efficient and intelligent data management platform. Server Microsoft SQL Server Enterprise Edition 2012 is ready to work in the most responsible and demanding business applications, helping to reduce costs for maintenance of existing systems and development of new applications and providing extensive business intelligence capabilities for all employees of the company. Microsoft SQL Server Enterprise Edition 2012 offers comprehensive features of a data center that combines a database and business intelligence system. Microsoft SQL Server Enterprise Edition 2012 is the optimal solution for large-scale data warehouses and large-scale enterprise applications.

Features of Microsoft SQL Server Enterprise Edition 2012:

• Providing long-term performance and effective data protection. Economical and fast delivery of servers to the cloud. SQL Server AlwaysOn is an advanced availability and disaster recovery system that reduces planned and unplanned downtime, as well as to maximize the use of existing hardware resources.
• Data search and visualization. PowerView – a new subsystem for visualization and generation of reports PowerView (formerly Project Crescent), which is an interactive solution for visualization and modification of reports through a web-interface. PowerView uses a graphical web platform Silverlight, which supports animation and graphical effects, as well as new visual elements to display analytical data.
• Business analytics. IT-specialists can monitor end user activity and their work with data sources, collect performance indicators from servers. In addition, the 2012 edition transforms PowerPivot-created business analytics applications into enterprise-class solutions.
• Improve the performance of data warehouses. xVelocity – technology to increase the performance of business analytics data warehouses and applications.
• Comprehensive data control. Data Quality Services – data quality assurance service. Used to properly load nomenclature data and keep it in compliance with established writing, storage and output formats. DQS allows you to upload to the EIM system data that have different spelling formats.
• Support for relational and non-relational data, including Big Data sources such as Hadoop. In addition, customers can extend heterogeneous environments with any standard application programming interface on a variety of platforms, including .NET, C/C++, Java, Linux and PHP.
• Professional development of innovative applications. SQL Server Data Tools is an integrated development environment for enterprise, mobile, and web-based data-linked applications for public and private clouds. Data-tier Application Framework (DAC Fx) significantly simplifies the development, deployment and control of database application servers in the cloud.
• Scaling and optimization. Flexible scalability options for server, private and public clouds, and hybrid environments. Increase IT productivity with new cloud and server management tools.

Microsoft SQL Server 2012 Developer

Microsoft SQL Server 2012 Developer is a reliable, efficient and intelligent data management platform. Server Microsoft SQL Server Developer Edition 2012 is ready to work in the most responsible and demanding business applications, helping to reduce costs for maintenance of existing systems and development of new applications and providing extensive business intelligence capabilities for all employees. The release of Microsoft SQL Server 2012 Developer allows developers to create applications of any type based on SQL Server. The edition includes all functions of Enterprise Edition (for win32, x64, IA64 platforms), but with a special license agreement for development and testing, which prohibits the use of the created software for commercial purposes.

Features of Microsoft SQL Server 2012 Developer :

• Providing long serviceability and effective data protection. Economical and fast delivery of servers to the cloud. SQL Server AlwaysOn is a high availability and disaster recovery system that allows you to reduce planned and unplanned downtime, as well as to maximize the use of existing hardware resources.
• Data search and visualization. PowerView – a new subsystem of visualization and report generation PowerView (formerly Project Crescent), which is an interactive solution for visualization and modification of reporting through a web-interface. PowerView uses a graphical web platform Silverlight, which supports animation and graphical effects, as well as new visual elements to display analytical data.
• Business analytics. IT-specialists can monitor end user activity and their work with data sources, collect performance indicators from servers. In addition, the 2012 edition transforms PowerPivot-created business analytics applications into enterprise-class solutions.
• Improve the performance of data warehouses. xVelocity – technology to increase the performance of business analytics data warehouses and applications.
• Comprehensive data control. Data Quality Services – data quality assurance service. Used to properly load nomenclature data and keep it in compliance with established writing, storage and output formats. DQS allows you to upload to the EIM system data that have different spelling formats.
• Support for relational and non-relational data, including Big Data sources such as Hadoop. In addition, customers can extend heterogeneous environments with any standard application programming interface on a variety of platforms, including .NET, C/C++, Java, Linux and PHP.
• Professional development of innovative applications. SQL Server Data Tools is an integrated development environment for enterprise, mobile, and web-based data-linked applications for public and private clouds. Data-tier Application Framework (DAC Fx) significantly simplifies the development, deployment and control of database application servers in the cloud.
• Scaling and optimization. Flexible scalability options for server, private and public clouds, and hybrid environments. Increase IT productivity with new cloud and server management tools.

Introduction to Microsoft SQL Server 2012 – SQL server Tutorial