(239) 908-6700 info@sengen.com

Microsoft SQL Server

Microsoft SQL Server 2014 is a feature-rich edition of SQL Server that is ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs.

SQL Server 2014 enables customers to build mission-critical applications and Big Data solutions using high-performance, in-memory technology across OLTP, data warehousing, business intelligence and analytics workloads without having to buy expensive add-ons or high-end appliances. SQL Server 2014 uses a common set of tools to deploy and manage databases both on-premises and in the cloud, which makes it easier for customers to take advantage of the cloud with existing skills.

Application Development

Microsoft SQL Server 2014 is at the heart of a comprehensive data platform that enables you to access and manipulate business-critical data from a variety of diverse devices, platforms, and data services across the enterprise.

Top New Features
  • Map data structures to business entities by using the new ADO.NET Entity Framework.
  • Use consistent syntax to query diverse data through .NET Language Integrated Query (LINQ) extensions to Microsoft Visual C# and Microsoft Visual Basic.NET.
  • Create occasionally connected solutions using SQL Server 2014 Compact Edition and Microsoft Synchronization Services.
  • Consolidate data storage through the SQL Server 2014 support for relational, XML, Filestream, and geo-location-based data.
Business Intelligence

Microsoft SQL Server 2014 provides a scalable Business Intelligence platform optimized for data integration, reporting, and analysis, enabling organizations to deliver intelligence where users want it.

Top New Features
  • Create high-performance Analysis Services solutions with optimized cube designers, subspace computation, and MOLAP-enabled writeback capabilities
  • Implement enterprise-scale Reporting Services solutions through new on-demand processing and instance-based rendering
  • Build flexible and effective reports with the new Tablix data structure and rich formatting capabilities
  • Expand reach, and empower more users through optimized integration with the 2007 Microsoft Office system
Compliance

Microsoft SQL Server 2014 is a secure and reliable platform for protecting data and for building compliance solutions. Conforming to regulatory legislation often impacts how data is stored and how it is accessed. SQL ServerĀ® 2014 provides the capabilities to address organizational needs around regulations such as HIPAA, SOX and PCI.
Whether dealing with separation of duties, key management or auditing and reporting, SQL Server 2014 provides the support needed to meet these demands.

Top New Features
  • Increased ability to protect encryption keys
  • Granular auditing capabilities
  • Define, deploy and validate configuration policies destined for your databases
Data Warehousing

Microsoft SQL Server 2014 R2 is a scalable and reliable Data Warehouse platform for Business Intelligence. Through integration with the Microsoft BI platform, it enables actionable business decisions at the lowest cost.

Top New Features
  • Data compression
  • Backup compression
  • Partitioned table parallelism
  • Star join query optimization
  • Resource management
  • Grouping sets
  • Change data capture
  • MERGE SQL statements
Hosting Solutions

Microsoft SQL Server 2014 is a cost-effective database platform for hosting solutions that provides value-add features hosters can use to increase revenue by offering new services and capabilities to their customers. A comprehensive range of SQL Server 2014 editions enables customers to pay for only the features and scalability they need, while providing a seamless upgrade path that enables customers to build on their initial investment as their data requirements grow.

Online Transaction Processing

Microsoft SQL Server 2014 is a comprehensive data platform that provides the scalability, availability, security, and manageability that you need for mission-critical OLTP applications.

Top New Features
  • Implement peer-to-peer replication quickly with the new visual designer, and add nodes without stopping system activity
  • Audit all actions across the enterprise and consolidate audit reporting
  • Help protect sensitive data with automatic, transparent data encryption
  • Use Performance Studio to troubleshoot, tune, and monitor SQL Server 2014 instances across the enterprise
  • Take control of workload resource use with Resource Governor
  • Store all kinds of business data with native support for relational data, XML, file streams, and spatial data
Server Consolidation

Microsoft SQL Server 2014 offers licensing advantages for increased savings, consolidation feature enhancements that help provide increased savings, improved high availability capabilities to meet aggregated availability needs and effective management of security needs such as strong authentication and access control, powerful encryption and key management capabilities, and enhanced auditing.

Top New Features
  • Optimize storage and increased performance with built-in data compression and backup compression
  • Control workload resource prioritization with Resource Governor
  • Use virtualization to do consolidation
  • Centralize security auditing with new comprehensive data auditing capabilities
  • Enforce policy compliance consistently across the enterprise with Policy-Based Management
Solutions for the Web

SQL Server 2014 is an important part of your Web Infrastructure providing rich features designed to support high availability, security, performance and manageability for your Web-based business applications.

Top New Features
  • Achieve higher utilization and scale
  • Enable advanced business scenarios such as PCI compliance and BI solutions
  • Competitive prices with business-class reliability
  • Delivers enterprise-class service
  • Helps enable advanced business scenarios such as PCI compliance and BI solutions
  • Achieve higher utilization and scale in a multi-tenancy environment through advanced features such as Resource Governor
  • Provides scalability and reliability at a low cost
Virtualization

A comprehensive and integrated set of virtualization tools and solutions from Microsoft will help you create a virtualized infrastructure from your desktop to datacenter including an enterprise class virtualized database infrastructure easily and quickly to lower your TCO and maximize ROI. By choosing virtualization software from Microsoft, including Windows Server with Hyper-V, System Center and SQL Server, customers benefit from a lower cost solution and an integrated end to end management solution for both physical and virtual environments.

Top New Features
  • Lower TCO and Maximize ROI with improved hardware utilization
  • Enable advanced business scenarios such as PCI compliance and BI solutions
  • Strong hardware partner eco system provides choice and flexibility
  • Licensing models that help you optimize your existing investments while taking advantage of the new SQL Server 2014 EE Licenses to increase the mobility of your deployments and realize better value