Programmability and developer tools: T-SQL, SQL CLR, Service Broker, JSON, XML, graph data supportĪdvanced OLTP: in-memory OLTP, operational analytics Unlimited virtualization, a software assurance benefit Memory: Maximum memory-optimized data per database Memory: Maximum Columnstore segment cache per instance Memory: Maximum buffer pool size per instance Now in SQL Server 2017, manage and query graph data inside your relational database. JSON support lets you parse and store JSON documents and output relational data into JSON files. Use SQL Server Reporting Services to publish reports to any mobile device-including Windows, Android, and iOS devices-and access reports online or offline.Ĭombine relational data and big data with PolyBase technology that queries Hadoop using simple T-SQL commands. Gain insights and transform your business with modern, paginated reports and rich visualizations. Reduce time to insights using direct querying against tabular and multidimensional models. SQL Server Analysis Services help you build comprehensive, enterprise-scale analytic solutions-benefiting from the lightning-fast performance of in-memory built into the tabular model. Scale your business intelligence (BI) models, enrich your data, and ensure quality and accuracy with a complete BI solution.
