Microsoft Gold-Certified Consultants
SQL Server 2016 Expertise:
Planning, Deployment, Application Development, Troubleshooting
SQL Server 2016 offers a wealth of new and improved features that enhance key areas including speed, scale, security, uptime, analytics, Bring-Your-Own-Device (BYOD) support, development capabilities, deployment flexibility, and more granular management. New features include PolyBase with Hardoop support for combining structured and unstructured data simultaneously from multiple locations, columnstore indexes for real-time analytics, Always Encrypted for enhanced security, integrated development support for JSON and R language, and Mobile Reports for making business intelligence (BI) insights available anywhere on any device.
Progent's Microsoft-certified SQL Server consultants have worked extensively with all versions of SQL Server since its inception and can help you assess the benefits of migrating to SQL Server 2016 from previous releases of SQL Server, including legacy versions no longer supported by Microsoft, or from other database systems. Progent offers the talents of a Microsoft Certified Solution Master: Data Platform and Microsoft Certified Trainer for SQL Server and can help you transfer data and applications to SQL Server 2016, enhance your network architecture for on-premises, cloud-based, or hybrid deployments, develop or debug application software, provide DBA services, enhance and verify security and compliance, and train individuals or teams to manage and use your SQL Server 2016 ecosystem productively.
Progent also offers Wi-Fi consulting and mobile integration services and can help you build a secure BYOD environment for SQL Server 2016 by offering services such as Apple iPhone and iPad integration, Android phone and tablet management, and RIM BlackBerry consulting.
Progent offers on-premises and online consulting and troubleshooting services to organizations of all sizes for creating a robust and secure SQL Server 2016 solution. Progent's Microsoft-certified consultants can also assist you to integrate SQL Server 2016 with all other key platforms from Microsoft such as Windows Server, Hyper-V, Exchange Server, SharePoint Server, Skype for Business or Lync, Microsoft Dynamics CRM and Dynamics GP, and System Center Operations Manager.
Progent's experienced application developers can help you design, build, test, deploy and debug applications powered by SQL Server 2016 and offer expertise in data modeling, OLTP, Data Warehousing, Data Mining, ETL, performance tuning, backup and disaster recovery, business analytics (BI) and reporting, and integration with Amazon Marketplace Web Service (Amazon MWS). To learn more about Progent's SQL Server application development and troubleshooting services, refer to SQL Server software development and DBA services.
Editions of SQL Server 2016
SQL Server 2016 is available in a range of editions that vary considerably in cost and capability. Progent can assist you to decide which versions of SQL Server makes sense for your applications and Progent can help you understand SQL Server 2016 licensing options.
SQL Server 2016 Express is free and is designed for desktop and light server applications. Versions of SQL Server Express include SQL Server 2016 Express with Tools, which includes SQL Server Management Studio (SSMS) and SQL Server 2016 Express with Advanced Services, which includes Basic R integration.
SQL Server 2016 Standard is designed to provide data management and business intelligence capabilities for small business and departmental environments and can support on-premises or cloud deployments. Added features include delayed durability, row-level security, dynamic data masking, analysis services, basic data mining support, and backup encryption. The value-priced SQL Server 2016 Web edition is designed for hosting web sites and provides less scale and fewer features than the Standard edition.
SQL Server 2016 Enterprise is intended for line-of-business applications and offers world-class scale and performance with unlimited virtualization. Availability features include online page and file restore, online indexing, and online schema change. Scalability and performance features include real-time operational analytics, In-Memory Column Store, table and index partitioning, data compression, Partition Table Parallelism, and In Memory OLTP. SQL Server 2016 Developer edition is free and has all the features of the Enterprise edition but is not licensed for production use.
For a more detailed description of the different editions of SQL Server 2016, see SQL Server 2016 editions and licensing consulting.
New and Enhanced Features of SQL Server 2016
SQL Server 2016 offers an abundance of new features and enhancements associated with the Database Engine, SQL Server 2016 Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Master Data Services (MDS).
Database Engine
The Database Engine, which is responsible for secure data storage and processing, is used to create and manage databases for OLTP or online analytical processing. New or improved features to the SQL Server 2016 Database Engine include:
- Columnstore Indexes
- Database Scoped Configurations
- In-Memory OLTP
- Query Optimizer
- Live Query Statistics
- Query Store
- Temporal Tables
- Striped Backups to Microsoft Azure Blob Storage
- File-Snapshot Backups to Microsoft Azure Blob Storage
- Managed Backup
- TempDB Database
- Built-in JSON Support
- Stretch Database
- Support for UTF-8
- New Default Database Size and Autogrow Values
- PolyBase
PolyBase is a headline enhancement in SQL Server 2016. PolyBase allows users to query non-relational data in Hardoop, Microsoft Azure Storage blobs and files and join the results with existing relational databases in SQL Server 2016. PolyBase allows users to run analytics and BI on data residing on premises or in the cloud, enabling powerful hybrid scenarios. (Learn about Progent's Microsoft Azure planning and cloud integration consulting services.)
For more information about the new and enhanced features of the SQL Server 2016 Database Engine, refer to SQL Server 2016 Database Engine consulting.
SQL Server Analysis Services (SSAS) 2016
SQL Server Analysis Services (SSAS) 2016 provides the analytical data visualization tools for business reports and client applications like Power BI, Excel and SQL Server Reporting Services (SSRS). New or improved areas of SSAS 2016 include:
- Tabular 1200 Models
- Instance Management
- Scripting
- Data Analysis Expressions (DAX)
- Developer
- DirectQuery
SQL Server Integration Services (SSIS) 2016
SQL Server Integration Services (SSIS) 2016 helps you to create enterprise-class data integration and workflow applications such as ETL (extraction, transformation, and load) packages for data warehousing. SSIS 2016 introduces new and enhanced features that simplify management, expand connectivity, and improve usability. Improved areas include:
- Always On in the SSIS Catalog
- Incremental Package Deployment
- ATOM and JSON data formats for OData V3 protocol
- Explicit support for Excel 2013 data sources
- Hadoop file system (HDFS) support
- Azure Feature Pack
- Connectors for SAP BW, Oracle and Teradata
- TMSL commands
- R language support
SQL Server Reporting Services (SSRS) 2016
SQL Server Reporting Services (SSRS) 2016 allow you to build, publish, manage and access reports. Depending on your deployment topology, administrators and users can interact with an SSRS 2016 report server via the Reporting Services Web service, WMI provider, URL access, or scripts. SSRS 2016 provides important enhancements in areas that include:
- Reporting Services web portal
- Mobile Reports and Mobile Report Publisher
- Support of SharePoint mode and SharePoint 2016 and SharePoint 2019
- Microsoft .NET Framework 4 Support
- Report improvements
- Subscription Improvements
- SQL Server Data Tools (SSDT)
- Report Builder improvements
Mobile Reports is another headline innovation in SQL Server 2016. The new Mobile Report Publisher allows you to build reports that dynamically adjust the layout of content to fit different screen sizes and that also adjust automatically to screen rotation. This makes it easy to create reports that display equally well on desktops, notebooks, smartphones and tablets.
For a fuller description of the improvements in SSRS 2016, see SQL Server 2016 Reporting Services (SSRS) consulting.
Master Data Services (MDS)
SQL Server 2016 Master Data Services (MDS) allows model administrators to create and manage models, entities, attributes and attribute groups, explicit and derived hierarchies, business rules and metadata, to deploy models, and to perform other master data management (MDM) functions to simplify data integration. Microsoft SQL Server 2016 offers a wealth of new and improved features that enhance MDS performance, scale, security and manageability. Enhanced areas include:
- Granular Security
- Microsoft Excel Add-in Performance
- Transaction Log Maintenance
- Tracing Log for Troubleshooting
- Business Rule Management
- Derived Hierarchy
- Attribute Filters
- Entity and Member Revision History
- Change Management
- Tools and Samples
How Progent Can Help You with SQL Server 2016
Progent's consultants offer online and onsite consulting services to help you plan, deploy and maintain your SQL Server 2016 ecosystem. Progent can help you assess the benefits and risks of migrating to SQL Server 2016 and can help you determine a deployment strategy for an on-premises, cloud, or hybrid solution. Progent can assist you to migrate your data and applications, configure test systems to confirm SQL Server 2016's support for your key workloads, streamline management, define and validate a comprehensive security plan that meets industry and government standards, integrate handheld devices to enable BYOD computing, and develop a disaster recovery plan that utilizes the advanced high-availability mechanisms incorporated into SQL Server 2016. Progent can also help you design, program and debug applications based on SQL Server 2016.
Consulting services available from Progent for SQL Server 2016 include:
- Project Management: Progent offers project management outsourcing and co-sourcing to assist your organization to follow leading practices to keep your Server 2016 initiative on schedule and within budget. Project can help with any facet of project management by providing services that include preparedness assessment, needs evaluation, system architecture design, rollout strategy, pilot testing, integration, performance tuning, comprehensive documentation, training, and ongoing online and/or onsite support.
- Database Migration Services: Progent's DBA consultants offer support for all current and legacy versions of SQL Server and can also provide Oracle consulting services, MySQL application development and debugging, and Microsoft Access programming and training. Progent's experience in relational database solutions can help you save time and money in your SQL Server 2016 migration project.
- Integrating SQL Server 2016 with Other Microsoft Products: Microsoft's extensive family of servers and business applications rely on SQL Server as their data engine. Progent's Microsoft-certified consultants can help you integrate SQL Server 2016 with your other Microsoft products by providing services such as Microsoft Windows 2016 Hyper-V hybrid cloud solutions, Windows Server 2012 R2 integration, SharePoint 2016 hybrid integration consulting, SharePoint Server 2019 development, Microsoft 365 Excel and Power BI reporting expertise, Exchange Server 2016 integration, Active Directory design and configuration, and Microsoft Dynamics GP and CRM development and support.
- Reporting and Business Analytics: Progent's Business Intelligence (BI) reporting consultants can help you use Microsoft's BI stack including SQL Server Reporting Services (SSRS) 2016 to build, publish, and maintain business intelligence reports that can be accessed anywhere from any device. Progent can help you develop PowerPivot models and use SQL Server Analysis Services 2016 for tabular databases. Progent can also help you work with popular reporting tools like Crystal Reports, FRx, and Report Writer and integrate them with SQL Server 2016.
- Network Infrastructure Consulting: Progent's Cisco-certified CCIE network infrastructure consultants can help you deploy, maintain, tune and secure a high-availability network architecture to support your SQL Server 2016 solution for any deployment model including onsite, cloud or hybrid.
- Security and Compliance: Progent's security consultants have been awarded advanced certifications including CISA, CISM, CISSP, and GIAC. Progent offers organizations of any size a variety of security evaluation and mitigation services to protect against threats and to validate compliance with government regulations and industry standards.
- Virtualization Expertise: Cost vs. performance issues are key in determining which SQL Server-based applications should be virtualized, just as they are major factors in determining which applications should be run on-premises rather than in the cloud. Progent can help you plan and implement a sensible virtualization strategy for SQL Server 2016 and can provide the expertise of certified Windows Hyper-V consultants, VMware vSphere and vCloud specialists, VMware NSX virtual network consultants, and Citrix XenServer experts to help you carry out your virtualization plan.
- SCOM Support: Progent's System Center 2016 Operations Manager (SCOM 2016) consulting experts can assist you to configure the SCOM Management Pack for SQL Server 2016 so you can monitor and enhance the performance of your SQL Server 2016 environment from a centralized portal that spans local and cloud deployments and proactively warns you about potential problems that could impact system availability.
- Disaster Recovery Preparedness: Progent's disaster preparedness consultants can help you create and test a disaster recovery plan that utilizes SQL Server 2016's advanced mechanisms for high-availability and recoverability in order to maximize uptime for business-critical applications. Progent's business continuity consultants can assist you to create a comprehensive strategy to keep your business functioning in case of a catastrophic event, defining operational logistics in additional to addressing IT issues. For enterprises environments, Progent offers the support of a VCDX certified VMware Site Recovery Manager consultant and VMware NSX network virtualization expert to help plan, configure and manage a secure, world-class disaster recovery/application mobility solution for private cloud and hybrid-cloud deployments.
- Upgrading to SQL Server 2017 or SQL Server 2019: Progent's SQL Server 2017 consultants and SQL Server 2019 experts can help design and execute a smooth migration from SQL Server 2016 to a more current version of SQL Server to enhance the performance. security and compliance, availability, and scale of your critical data-driven applications. Progent can also help you evaluate various alternatives for local, cloud-based, or hybrid-cloud deployment of SQL Server 2017 or SQL Server 2019.
- Online Consulting and Troubleshooting: Progent has more than 20 years of experience providing advanced consulting, development and troubleshooting support online. Remote consulting saves time, cuts costs, and improves productivity. Progent has provided online help to business of all sizes in every state in the U.S. (See Progent's customer testimonials.) Progent also offers on-premises support in major metropolitan areas throughout the U.S. and in the Toronto area of Canada.
Contact Progent for SQL Server 2016 Consulting and Development Services
To find how Progent can help your organization with SQL Server 2016 integration, troubleshooting or development, phone
If you need immediate online help from a Microsoft-certified consultant, see Progent's Online Network Support.
Learn more about Progent's Consulting Services for Microsoft .NET Server Platforms.
An index of content::
ProSight Virtual Hosting Consulting Services
Consulting Services ProSight Virtual Hosting
Progent's ProSight Virtual Hosting service offers complete hosting of a small or mid-size company's servers in a solution that gives the highest degree of availability and expandability and is also easy to transfer to any data center. ProSight Virtual Hosting options are based upon mature virtualization platforms that allow small and midsize businesses with mixed- platform IT systems to economize dramatically on the expense of capital investments, infrastructure support, and network management while benefiting from enterprise-class reliability and an unprecedented level of vendor independence.
Duo Two-factor Authentication (2FA) Technology Consulting
Duo Two-factor Authentication Support Services
Progent's Duo services incorporate Cisco's Duo cloud technology to protect against compromised passwords through the use of two-factor authentication. Duo supports one-tap identity verification with iOS, Android, and other personal devices.
Peppercon eRIC Engineers
Aten IP9001 Consultants
Remote management cards give IT managers complete control over a server without the need for an on-site presence. Through remote server management cards, all console screen information plus keyboard and mouse operations are exported to a remote session to an IT expert who can be located anywhere in the world. Progent's Microsoft and Cisco certified engineers can assist you to design, deploy, and manage a fault-tolerant company network that incorporates remote management cards and Progent can use these remote management cards to provide efficient remote technical help. Progent is familiar with a number of remote server management cards including Aten IP9001 remote server management cards, American Megatrends MegaRAC remote management cards, Dell remote server management cards, HP Lights-Out remote management cards, and Peppercon eRIC remote management cards.
Aironet 3700 Access Point Computer Consulting
Aironet Wave 2 AP Outsourcing
Progent's Cisco CCIE-certified wireless network consultants can provide remote or on-premises configuration and debugging support to assist your organization to design, implement, update, optimize, administer and debug Aironet wireless access point deployments of any scale or architecture. Progent's Cisco Wi-Fi controller experts can also help you to combine your Wi-Fi ecosystem with your wired network and cloud-hosted resources to create a seamless enterprise-wide connectivity solution that is easy to administer and scale. Progent also can provide affordable wireless site surveys to help you to determine the most efficient selection, placement and setup of Aironet wireless APs to accommodate your specific office layout, building structure, and expected workloads.
Juniper SSG Series Router Cybersecurity Consultancy
Juniper SSG20 Router Security Auditing
Progent's Juniper-certified consultants can help your business plan the deployment of Juniper SSG integrated firewall/VPN products, configure security policies to match your operational requirements, set up network OS software to streamline management processes, migrate from legacy Juniper products, and troubleshoot infrastructure issues.
24-7 ProSight Remote Infrastructure Monitoring On-site Technical Support
24-7 ProSight Remote Network Infrastructure Management On-site Support
Progent's ProSight WAN Watch is an infrastructure monitoring and management service that makes it simple and affordable for small and mid-sized organizations to diagram, monitor, optimize and debug their connectivity hardware such as routers, firewalls, and wireless controllers as well as servers, printers, endpoints and other networked devices. Using cutting-edge Remote Monitoring and Management (RMM) technology, WAN Watch makes sure that infrastructure topology maps are kept updated, copies and displays the configuration of almost all devices connected to your network, monitors performance, and generates notices when potential issues are detected. By automating time-consuming network management activities, WAN Watch can knock hours off ordinary tasks like making network diagrams, expanding your network, finding devices that require critical updates, or isolating performance issues.
Setup and Support At Home Employees Network Infrastructure
Work at Home Infrastructure Remote Troubleshooting
Progent can assist small and medium-size companies to design, deploy and debug the network infrastructure required for telecommuters.
SharePoint InfoPath Forms Services Outsourcing
SharePoint Designer 2010 IT Consulting
Progent's Microsoft-certified engineers offer cost-effective online technical support and development services to help you to plan, deploy, administer, and troubleshoot SharePoint 2010 environments that can include web pages able to function as intranets, extranets, document management tools, blogs, data marts, business analytics, enterprise search, workflows, and other utilities to support and enhance collaboration. Progent can show you how to integrate SharePoint 2010 with MS SQL Server and with third-party databases as well as with Microsoft's popular office productivity applications including Excel, Word, PowerPoint, and Project. Progent can assist you to migrate from earlier versions of SharePoint or move a mix of web applications into a consolidated and easy-to-manage SharePoint 2010 environment.
Duo Two-factor Authentication Online Support Services
Setup and Support ProSight Duo MFA
Progent's Duo services utilize Cisco's Duo technology to protect against stolen passwords by using two-factor authentication (2FA). Duo enables single-tap identity confirmation on Apple iOS, Android, and other out-of-band devices.
SCCM 2016 Patch Management Technology Consulting
Help and Support SCCM 2016 MDM
Configuration Manager 2016 automates application and device deployment and updating, centralizes compliance settings management, keeps track of network assets, protects against company data leakage, provides health monitoring, enables secure end-user self service, and delivers a single point of control for managing multi-OS ecosystems based on on-prem, cloud, or hybrid deployment architectures. Progent's Microsoft-certified SCCM 2016 consulting team and Microsoft Azure cloud integration specialists can assist your organization with any aspect of designing, installing, using and repairing a SCCM 2016 deployment for on-premises, cloud, or hybrid networks.
Antispam Technical Support
Technical Support Services Anti-Spam
E-Mail Guard is a comprehensive service for defending against spam and viruses. E-Mail Guard handles the protection and management of corporate email by providing continually updated spam and virus blocking, policy administration, content filtering, and protection against email-borne DHA and Distributed Denial of Service attacks. E-Mail Guard also features monitoring, management and analysis utilities as well as outbound email filtering to let you fix your email system and specify and enforce company email policy.
Computer Network Service Company Cisco Planning
Cisco Router Network Design
Progent can help your organization to deploy Cisco's networking technology to create a robust foundation for your local, private cloud, or hybrid-cloud data center and streamline operations in key areas including compute and storage consolidation, security and compliance, manageability, reliability, and disaster recovery.
Shared Network Support Help Desk Costs Outsourcing
Co-managed Service Desk Costs Remote Consulting
Progent's Helpdesk management and co-management services help companies to save money and enhance productivity.
SCOPIA Video Conferencing Consultant
LifeSize Video Conferencing Consultants
Progent can provide the support of a veteran consultant with extensive hands-on experience installing, maintaining, and enhancing video conferencing platforms from leading suppliers including Cisco, TANDBERG, Polycom, and LifeSize. Progent can work with your internal network management team, your ISP, and your video conferencing platform supplier to help your organization maximize the business value of your telepresence ecosystem.
SIP Trunks Support Outsourcing
CCIE Certified CUCM and SIP Integration Technical Support
Progent's Cisco CCIE-certified SIP integration consultants can help organizations of any size to plan, integrate, manage, troubleshoot and enhance Cisco's SIP connectivity solutions and Cisco's CUBE (Cisco Unified Border Element)-connected SIP trunks and offer affordable remote or on-premises support to assist you to migrate smoothly to a modern communications environment that offers accelerated return on investment. Progent's certified Microsoft unified communications experts can assist you to set up interfaces between Cisco's CUBE SBC and Microsoft's VoIP and IP video platforms like Skype for Business or Lync for connectivity to a SIP PSTN trunk.
ProSight Remote Network Troubleshooting Online Consulting
ProSight Remote Network Infrastructure Management Online Troubleshooting
Progent's ProSight WAN Watch is an infrastructure monitoring and management service that makes it easy and affordable for smaller organizations to diagram, monitor, enhance and troubleshoot their connectivity appliances like routers and switches, firewalls, and wireless controllers plus servers, endpoints and other devices. Incorporating state-of-the-art RMM technology, ProSight WAN Watch makes sure that infrastructure topology diagrams are kept updated, copies and manages the configuration of virtually all devices on your network, tracks performance, and generates alerts when potential issues are discovered. By automating time-consuming management processes, ProSight WAN Watch can knock hours off common chores such as network mapping, reconfiguring your network, locating appliances that require critical software patches, or identifying the cause of performance bottlenecks.
Windows Server 2016 Disaster Recovery Planning Technology Consulting
Windows Server 2016 Information Assurance Technical Consultant
Progent's Microsoft-certified information technology consultants can provide Windows Server 2016 integration consulting services to assist organizations of all sizes to plan and carry out an efficient upgrade to Windows Server 2016 and Windows Hyper-V 2016 using a local, cloud-centric, or hybrid deployment model. Progent can assist you to assess the value of Windows Server 2016 for your enterprise and can help you with any aspect of designing, deploying, managing or debugging your Windows Server 2016 and Windows Hyper-V 2016 solution. Progent can assist your organization to take advantage of the many new disaster recovery and security features of Windows Server 2016 and Hyper-V 2016 such as Windows Containers for isolating applications, Shielded Virtual Machines to protect against compromised administrators, Credential Guard, Just In Time Privileged Access Management, VM software load, Storage Replica, plus multi-domain failover clusters.
Windows Server 2019 Storage Spaces Direct Computer Engineer
Windows Server 2019 USB Drive Witness Online Support
Progent's certified Windows Server 2019 consultants can help your organization to plan and carry out a cost-effective migration to Windows Server 2019 using your current deployment architecture or a cloud-hosted or hybrid deployment model. Windows Server 2019 delivers major improvements in capacity, speed, manageability, Hyper-V virtualization, security and compliance, hybrid on-prem plus cloud deployments, resilience, and Linux support.
Top Ranked Microsoft and Cisco Call Desk Sharing Costs Support Services
Virtual Help Desk Costs Specialists
Progent's Help Desk outsourcing and co-sourcing service programs help businesses to reduce costs and improve productivity.
24 Hour Maze ransomware recovery Consultant
24-Hour Maze ransomware recovery Engineer
Progent's proven ransomware recovery consultants can assist your business to restore an IT network damaged by a ransomware cryptoworm such as Ryuk, Dharma, NotPetya, or Locky.
Immediate Services MySQL DBA
Top CISA Certified Security Expert Consult Oracle database administration
Progent can provide cost-effective remote access to an Oracle-certified MySQL DBA or software programmer and can help organizations of any size to integrate and support MySQL within a robust IT infrastructure that provides advanced performance, expandability, and security. Progent also has experience assisting businesses migrate applications from an Oracle environment to MySQL.
.NET Blazor Development Companies
.NET Blazor Design
Progent's software developers have worked for 20 years with .NET technologies and the Visual Studio development system and can build or modernize .NET apps quickly and affordably.
Online Technical Support Citrix Desktop Studio
Specialists virtual desktop delivery
Citrix offers a powerful family of products that provide enterprise-grade manageability, expandability, and responsiveness for server virtualization and for centralized delivery of virtual Windows desktops and Windows applications. For managing virtualized Windows desktops and applications, Citrix has developed XenDesktop and XenApp. For creating and managing virtual servers, Citrix has developed XenServer and Citrix Essentials for Microsoft Hyper-V. Progent's Citrix-certified engineers can help you to assess the business benefits of Citrix virtualization products and help you plan, test, implement, troubleshoot, and support Citrix virtualization platforms.
Select Topic: