Microsoft SQL Server has developed into a market-leading data management platform in the 25 years since the first release of version 4.2 for Windows NT in 1993. In a 2018 survey of professional software developers, Stack Overflow found that SQL Server was the second most popular database platform among professional developers and only 6 percentage points behind the leader MySQL. The early versions of SQL Server, however, were slow to gain widespread adoption for mission-critical applications that needed to be highly scalable and achieve reliability of at least 99.99 percent. By 2000, however, any lingering doubts regarding full Atomicity, Consistency, Isolation, and Durability (ACID) compliance and disaster recoverability were disappearing. By 2005, the analyst community was widely reporting on the ability of SQL Server to scale to levels comparable to or higher than the more established offerings from IBM and Oracle.
The SQL Server 2017 database platform includes a broad range of technologies, features, and services, supporting mission-critical applications such as analytics, in-memory databases, business intelligence (BI), and reliable and scalable online transaction processing (OLTP). The SQL Server platform has acquired capabilities to handle data integration, data warehousing, reporting, high-speed advanced analytics, data replication and programmability features including hosting in-database common language runtimes, service broker hosting, and semi-structured datatype management. Microsoft realizes that with such a breadth of services available in the platform, not all customers or applications need all features enabled on every SQL Server instance. Therefore, Microsoft packages different combinations of features in each of the four SQL 2017 editions—Enterprise, Standard, Express, and Developer.
Because of the vast capabilities of the SQL Server platform, availability of multiple versions, and popularity among developers, customers’ varied needs require tailored solutions. Dell EMC Ready Solutions for Microsoft SQL are designed and validated for superior performance, significant cost savings, and future-ready scalability. Our solutions offer customers choices of server form factors, server virtualization versus bare metal, hypervisors including Microsoft Hyper-V and VMware ESXi, and storage flexibility including hyper-converged, storage array, and NVDIMM for high transaction throughput applications.
This Ready Solution is a pre-architected, validated, end-to-end solution for implementing a virtualized infrastructure for SQL Server 2017. Based on Microsoft, VMware, and Dell EMC best practices, the solution provides exceptional performance and scalability, delivers faster time to value, and increases return on investment.
Dell EMC’s enterprise products provide high performance, energy efficiency, and high availability. Fourteenth-generation Dell EMC PowerEdge servers, along with Dell EMC storage and networking products, help customers virtualize, consolidate, and migrate their distributed legacy environments. Dell EMC enterprise storage and servers enable the solution to deliver high performance with low latency while maintaining high availability for its components.