Maximize your potential with Microsoft SQL Server 2017 Standard (2 Core)
SQL Server has evolved into a true enterprise information platform for a wide range of applications.
Maximize your potential with Microsoft SQL Server 2017 Standard (2 Core)
SQL Server has evolved into a true enterprise information platform for a wide range of applications.
Maximize your potential with Microsoft SQL Server 2017 Standard (2 Core)
SQL Server has evolved into a true enterprise information platform for a wide range of applications.
Maximize your potential with Microsoft SQL Server 2017 Standard (2 Core)
SQL Server has evolved into a true enterprise information platform for a wide range of applications.
Microsoft SQL Server 2017 Standard (2 Core)
Microsoft Corporation
It features a set of tools for database management and administration, programming through T-SQL (Transact-SQL)
- SQL Server includes the Database Engine, the core service for storing, processing, and securing data
- One of the main Advantages of SQL Databases is its feature of easy data retrieval.
- Data security is a top priority of SQL Server in the modern digital landscape, where cyber threats continue to evolve.
- Gain a competitive edge in your data career with our SQL courses! From query optimization to database management,
- Maintaining data integrity is crucial for any database system
- Cloud-based SQL databases offer the advantage of flexibility and cost-effectiveness.
Original price was: AED 15,999.00.AED 7,999.00Current price is: AED 7,999.00.
Subscription automatically renews. Cancel anytime to stop future charges.
Key SQL Server components and services
SQL Server is a client/server DBMS (Database Management System) whose main components and services are :
- Database engine: this component forms the core of the RDBMS (Relational Database Management System). It manages data storage, retrieval and modification operations, as well as the execution of SQL queries.
- SQL Server: this service starts, stops, interrupts and continues an instance of Microsoft SQL Server.
- SQL Server Agent: acts as a task scheduler. It schedules and automates the execution of recurring tasks in SQL Server, such as backups, data import/export or the execution of stored procedures.
- SQL Server Browser: a software solution for managing SQL Server instances. It enables users to easily connect and interact with their SQL Server databases. It simplifies administrative tasks such as database querying, security management and server performance monitoring.
| SQL Server Database Engine | SQL Server Database Engine includes the Database Engine, the core service for storing, processing, and securing data, replication, full-text search, tools for managing relational and XML data, in database analytics integration, and PolyBase integration for access to heterogeneous data sources, and Machine Learning Services to run Python and R scripts with relational data. |
| Analysis Services | Analysis Services includes the tools for creating and managing online analytical processing (OLAP) and data mining applications. |
| Reporting Services | Reporting Services includes server and client components for creating, managing, and deploying tabular, matrix, graphical, and free-form reports. Reporting Services is also an extensible platform that you can use to develop report applications. |
| Integration Services | Integration Services is a set of graphical tools and programmable objects for moving, copying, and transforming data. It also includes the Data Quality Services (DQS) component for Integration Services. |
| Master Data Services | Master Data Services (MDS) is the SQL Server solution for master data management. MDS can be configured to manage any domain (products, customers, accounts) and includes hierarchies, granular security, transactions, data versioning, and business rules, as well as an Add-in for Excel that can be used to manage data. |
| Machine Learning Services (In-Database) | Machine Learning Services (In-Database) supports distributed, scalable machine learning solutions using enterprise data sources. In SQL Server 2016, the R language was supported. SQL Server 2022 (16.x) supports R and Python. |
| Data Virtualization with PolyBase | Query different types of data on different types of data sources from SQL Server. |
| Azure connected services | SQL Server 2022 (16.x) extends Azure connected services and features including Azure Synapse Link, Microsoft Purview access policies, Azure extension for SQL Server, pay-as-you-go billing, and the link feature for SQL Managed Instance. |
| Component | Requirement |
|---|---|
| Hard Disk | SQL Server requires a minimum of 6 GB of available hard-disk space.
Disk space requirements vary with the SQL Server components you install. For more information, see Hard Disk Space Requirements later in this article. For information on supported storage types for data files, see Storage Types for Data Files. Installing SQL Server on computers with the NTFS or ReFS file formats is recommended. The FAT32 file system is supported but not recommended as it is less secure than the NTFS or ReFS file systems. Read-only, mapped, or compressed drives are blocked during installation. |
| Drive | A DVD drive, as appropriate, is required for installation from disk. |
| Monitor | SQL Server requires Super-VGA (800×600) or higher resolution monitor. |
| Internet | Internet functionality requires Internet access (fees may apply). |
| Memory * | Minimum:
Express Editions: 512 MB All other editions: 1 GB Recommended: Express Editions: 1 GB All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance. |
| Processor Speed | Minimum: x64 Processor: 1.4 GHz
Recommended: 2.0 GHz or faster |
| Processor Type | x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support |
The main SQL Server tools
Although its main function is that of an RDBMS, SQL Server has built-in intelligence through a range of business intelligence, analysis and reporting tools, of which the main ones are :
- SQL Server Management Studio (SSMS): this is the main tool for managing and administering SQL Server. It enables you to perform tasks such as creating and modifying databases, designing tables, writing and executing SQL queries, managing users and permissions, configuring servers and more.
- SQL Server Data Tools (SSDT): this is an integrated development environment (IDE) used to create, deploy and manage SQL Server database projects. It provides features for designing database schemas, creating stored procedures, functions, views, triggers and more. SSDT is integrated into Visual Studio.
- SQL Server Configuration Manager: this tool lets you manage SQL Server configuration parameters. It enables you to start, stop and configure SQL Server instances, manage network protocols, services, connection aliases and more.
- SQL Server Profiler: a monitoring and debugging tool that captures and analyzes events occurring on a SQL Server. It tracks SQL queries, server performance, errors, triggers, etc.
- SQL Server Integration Services (SSIS): a data integration tool for creating and managing extract, transform and load (ETL) workflows. It facilitates the import, export and transformation of data between different sources and destinations.
- SQL Server Analysis Services (SSAS): the online analytical processing (OLAP) tool. It provides data analysis, data mining and machine learning functionalities.
- Access Documents Anytime and Anywhere.
- Scalable Solution.
- Seamless Collaboration.
- Clear Communication.
- Secure Cloud Storage.
- Customized Email Benefits.
- Business Intelligence
Key Features
Get online protection, secure cloud storage, and innovative apps designed to fit your needs all in one plan.
Top questions
Frequently Asked Questions
Your Ultimate Destination
Why Shop at Digital Market Software ?
Related products
Microsoft Visio Plan 2
AED 624.00 – AED 2,935.00
Microsoft 365 Business Premium (35 Users)
AED 20,195.00
Microsoft 365 E5 (100 User) 1 Year Subscription
Original price was: AED 71,614.72.AED 70,000.00Current price is: AED 70,000.00.
2% Off
Microsoft 365 E5 (50 User) 1 Year Subscription
AED 44,070.65
Microsoft Office 365 E3 (100 Users) 1 Year Subscription
Original price was: AED 105,500.00.AED 58,999.00Current price is: AED 58,999.00.
44% Off
