Data storage is a database, which is a collection of tables with typed columns.SQL Server supports different data types, including primitive types such as Integer, Float, Decimal, Char (including character strings), Varchar (variable length character strings), binary (for unstructured blobs of data), Text (for textual data) among others.
Microsoft SQL Server Data Engine / Desktop Engine / Desktop Edition. Intended for use as an application component, it did not include GUI management tools.Later, Microsoft also made available a web admin tool.SQL Server Express Edition is a scaled down, free edition of SQL Server, which includes the core database engine.While there are no limitations on the number of databases or users supported, it is limited to using one processor, 1 GB memory and 10 GB database files (4 GB database files prior to SQL Server Express 2008 R2). Two additional editions provide a superset of features not in the original Express Edition.Included with some versions of Microsoft Access, Microsoft development tools, and other editions of SQL Server. Had workload or connection limits like MSDE, but no database size limit. Intended for use as a mobile / disconnected proxy, licensed for use with SQL Server 2000 Standard edition.
SQL Server 2008 R2 Datacenter is a full-featured edition of SQL Server and is designed for datacenters that need high levels of application support and scalability.The first is SQL Server Express with Tools, which includes SQL Server Management Studio Basic.SQL Server Express with Advanced Services adds full-text search capability and reporting services.Introduced in SQL Server 2012 and focusing on Self Service and Corporate Business Intelligence.It includes the Standard Edition capabilities and Business Intelligence tools: Power Pivot, Power View, the BI Semantic Model, Master Data Services, Data Quality Services and x Velocity in-memory analytics.Azure SQL Data Warehouse is the cloud-based version of Microsoft SQL Server in a MPP (massively parallel processing) architecture for analytics workloads, presented as a platform as a service offering on Microsoft Azure.