Microsoft SQL Server — система упра

Microsoft SQL Server — система управления реляционными базами данных (СУРБД), разработанная корпорацией Microsoft. Основной используемый язык запросов — Transact-SQL. Transact-SQL является реализацией стандарта ANSI/ISO по структурированному языку запросов (SQL) с расширениями. Используется для работы с базами данных размером от персональных до крупных баз данных масштаба предприятия.
SQL Server 2008 R2 включает несколько новых сервисов и компонентов, актуальных для корпоративного использования в контексте аналитических решений (Business Intelligence, BI), поскольку СУБД позиционируется Microsoft как один из главных BI-продуктов. В качестве новых функций, появившихся в СУБД, можно отметить:
Компонент PowerPivot for Excel and SharePoint, позволяющий импортировать, управлять, анализировать и экспортировать данные, а также выгружать отчеты в СУБД непосредственно из MS Excel и MS SharePoint в их стандартных интерфейсах и с использованием их возможностей;
Компонент Master Data Services, позволяющий управлять процессом структурировать и упорядочивания данных в разных источниках и приводить их к единообразному виду в конечных базах данных, обеспечивая их интероперабельность;
• интегрированную с .NET и SQL-серверами платформу StreamInsight для параллельной обработки потоков данных с поддержкой множества одновременных запросов к базе;
• компонент для среды разработки Visual Studio, позволяющий создавать многоуровневые приложения для СУБД и упаковывающий приложение и используемую им базу в единый пакет;
• средство SQL Server Utility, предоставляющее единый интерфейс управления несколькими подключенными серверами и базами.

Results (English) 1:

Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. The main query language is Transact-SQL. Transact-SQL is an ANSI/ISO standard structured query language (SQL) with extensions. Used for working with databases ranging in size from personal to large enterprise databases.SQL Server 2008 R2 includes a number of new services and components relevant to corporate use, in the context of analytical solutions (Business Intelligence, BI), because the DATABASE ENGINE Microsoft is positioned as one of the major BI-products. As the new features introduced in the database include:The PowerPivot for Excel and SharePoint, which lets you import, manage, analyse and export data, and upload reports into the database directly from MS Excel and MS SharePoint their standard interfaces and using their abilities;Master Data Services that enables you to manage the process structure and organize data from multiple sources and to bring them to a uniform view in the target database, ensuring their interoperability;• integrated .NET and SQL Server StreamInsight platform for parallel processing of data streams with support for multiple simultaneous database queries;• component for Visual Studio that allows you to create multi-tiered applications for DBMS and application packages and used them in a single package;• a SQL Server Utility that provides a single interface to control multiple connected servers and databases.

Results (English) 2:

Microsoft SQL Server - relational database management system (RDBMS) developed by Microsoft. The main query language used - Transact-SQL. Transact-SQL is an implementation of ANSI / ISO standard Structured Query Language (SQL) extensions. Used to work with databases ranging from personal to large enterprise databases.
SQL Server 2008 R2 includes a number of new services and features that are relevant for the enterprise in the context of analytical solutions (Business Intelligence, BI), as the database is positioned by Microsoft as one of the main BI-products. As a new feature introduced in the database, it may be noted:
Component PowerPivot for Excel and SharePoint, allows you to import, manage, analyze and export data, and upload the reports in the database directly from MS Excel and MS SharePoint to their standard interfaces and using them capacity;
component Master Data Services, allows you to manage the process to structure and organize data from different sources and bring them to a uniform view in the final database, ensuring their interoperability;
• integrated with .NET and SQL-server platform StreamInsight for parallel processing of data streams to support multiple simultaneous queries to the database;
• component to the development environment Visual Studio, allowing you to create multi-tier applications for database and package applications and used them in a single base package;
• means SQL Server Utility, providing a single interface management of multiple connected servers and databases.

Results (English) 3:

Microsoft SQL Server - relational data base management system (RDBMS), developed by Microsoft. The main language used requests - Transact-SQL statement.Transact-SQL is an implementation of the ANSI/ISO on structured query language (SQL) with extensions. Is used for the operation of the database size from personal to large databases enterprise-scale.
SQL Server 2008 R2 includes a number of new services and components that are relevant for corporate use in the context of the analytical solutions (Business Intelligence, BI),Since DBMS Microsoft is positioned as one of the main bi-products. As a new feature, resulting in a database, you can note:
Component powerpivot for Excel and sharepoint, that allows you to import, manage,To analyze and to export the data, as well as upload records in the database directly from the MS Excel, and MS Sharepoint in their standard interfaces and using their opportunities;
Component master data services,That allows you to manage the process structure and organize data in different sources, and lead them to the uniform mind in the end databases, ensuring their interoperability;
- integrated with the .Net and SQL server platform StreаmInsight for parallel processing data flows with support for multiple simultaneous requests to the database on;
- a component for Visual StudioThat allows you to create a multi-tiered applications for database and упаковывающии application and used them to the database in a single package;
- the SQL Server Utility,Provides a single interface to control multiple connected servers and databases.