SQL Server 2017 ConsultantsMicrosoft SQL Server 2017 significantly expands support for Microsoft's core data platform beyond Windows while delivering best-in-class performance, security, availability, and scale. You can run SQL Server 2017 natively on major Linux distributions including Red Hat, Ubuntu, and SUSE. SQL Server 2017 also supports Linux-based Docker containers. With SQL Server 2017, you can even use Always On availability groups to migrate or fail over your SQL Server 2017 data between Windows and Linux environments with minimal downtime. Another new feature, SQL Graph, makes it easier to model and analyze complex many-to-many relationships and patterns within existing databases by using a graph structure instead of querying data from a traditional relational schema.

The improvements available in SQL Server 2017 are especially timely in view of the end-of-support (EOS) status of SQL Server 2008 and SQL Server 2008 R2. EOS means there will be no more access to critical security updates for these legacy products, compliance could become difficult if not impossible, and maintenance may become prohibitively expensive. Migrating from SQL Server 2008 or 2008 R2 to SQL Server 2017 brings a decade's worth of innovations including in-memory performance, enterprise-class high availability, mobile business intelligence (BI), in-database advanced analytics, and modern cybersecurity that facilitates GDPR compliance.

SQL Server 2017 Mobile BI Consulting

SQL Server 2017 Reporting Services can host data for advanced BI reporting on almost any device

Progent has more than two decades of experience deploying, tuning, managing, and troubleshooting SQL Server solutions for businesses of all sizes and has provided software development and project management services for a broad range of SQL Server applications. Progent's Microsoft-certified SQL Server experts can help you assess the business benefit of upgrading to SQL Server 2017 and can help you plan and carry out an efficient migration of your databases and applications to any network model including on-premises, cloud-based, or hybrid. (See SQL Server 2017 Deployment Options.) If you currently run SQL Server 2017 and are considering an upgrade to SQL Server 2019, Progent can provide end-to-end SQL Server 2019 migration consulting services.

Progent's consultants can provide online or onsite expertise and offer services ranging from as-needed design review or troubleshooting to comprehensive project management and co-management to make sure your SQL Server 2017 initiative is successfully completed on time and within budget. Progent also offers the expertise of certified cybersecurity consultants, disaster recovery planners, and DBA professionals to make sure your SQL Server 2017 ecosystem is secure, compliant, protected, and efficient.

Progent's Microsoft-certified consultants can also help you integrate SQL Server 2017 with other core platforms from Microsoft by providing services that include Windows Server consulting, Hyper-V virtualization expertise, Exchange Server support services, SharePoint consulting, Skype for Business integration, Microsoft Dynamics GP customization and training, and System Center Operations Manager (SCOM) expertise.

Progent's experienced application developers can help you design, build, test, deploy, and debug applications powered by SQL Server 2017 and offer expertise in data modeling, OLTP, Data Warehousing, Data Mining, ETL, performance tuning, backup and disaster recovery, business analytics 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.

Progent also offers Wi-Fi network consulting and smartphone integration services and can assist you to design and deploy a protected BYOD environment for SQL Server 2017 by providing services that include Apple iPhone and iPad integration and Android mobile device management.

SQL Server 2017 Editions
SQL Server 2017 is available in five primary editions that differ in feature sets, scalability, pricing, and/or licensing rules. Progent can help you determine which editions are right for your requirements and can help you track and manage licensing.

SQL Server 2017 Express is free and is designed for creating data-driven applications for desktops and light servers. This is the best edition for ISVs and developers creating client applications. The SQL Server 2017 Express with Advanced Services includes Basic R and SQL Graph integration and can be used to host a SQL Server Reporting Services (SSRS) database. SQL Server Express LocalDB is the only version of SQL Server 2017 that runs in user mode, requiring no configuration and few prerequisites to install. SQL Server Express LocalDB is bare bones even for Express. For example, it is the only edition of SQL Server 2017 that does not support in-memory OLTP. All versions of Express are limited to the lesser of 1 socket or 4 cores, and all support 352 MB of memory per database in SQL Server Database Engine. Upgrading to more advanced editions of SQL Server 2017 is seamless.

SQL Server 2017 Developer edition is functionally identical to the Enterprise edition but is licensed exclusively for use as a development and test system for applications that run on top of SQL Server. SQL Server 2017 Developer edition may not be deployed as a production server.

SQL Server 2017 Web edition is a low-cost option intended for web hosting companies. This pared-down edition has fewer features and is less scalable than the Standard and Enterprise editions of SQL Server 2017 but can be a cost-effective database management solution for web properties. You can profile SQL Server Web edition using the SQL Profiler management tool from the Standard or Enterprise editions of SQL Server. SQL Server 2017 Web does not include some of the high-availability features included with more advanced editions such as backup compression, encrypted backup, and Always On failover cluster instances. SQL Server 2017 Web supports the lesser of 4 socket or 16 cores and up to 16 GB of memory per database in SQL Server Database Engine.

SQL Server 2017 Standard edition provides mid-range data management, high-availability, and BI database functionality to allow small organizations or departments to run typical data-driven applications. SQL Server 2017 Standard edition supports basic development tools for onsite and cloud-hosted environments while minimizing requirements for IT resources and management expertise. SQL Server 2017 Standard edition supports the lesser of 4 sockets or 24 cores for compute power and up to 32 GB of memory per database in SQL Server Database Engine.

SQL Server 2017 Enterprise is the top-of-the-line version of SQL Server 2017 and is designed for mission-critical applications where scale, performance, availability, security, and functionality are crucial. Compute power and memory available per database are limited only by the host operating system. Virtualization is unlimited. Performance features include automatic tuning, IO resource governance, and partitioned table parallelism. Unique high-availability features include online indexing and schema change, online page and file restore, mirrored backups, hot-add CPU and memory, plus Always On availability groups supporting up to eight secondary replicas with two synchronous secondary replicas. Advanced security features include transparent database encryption and extensible key management. SQL Server 2017 Enterprise edition also includes Power Pivot for SharePoint, offers extensive support for data mining, and supports mobile reports and analytics.

New and Enhanced Features of SQL Server 2017
SQL Server 2017 offers improvements over previous versions of SQL Server in key technology areas including SQL Server Database Engine, SQL Server Integration Services (SSIS), Master Data Services (MDS), SQL Server Analysis Services (SSIS), SQL Server Reporting Services (SSRS), and Machine Learning Services (formerly called SQL Server R Services).

SQL Server 2017 Database Engine
The SQL Server 2017 Database Engine is the primary service for data storage, processing, and security. The Database Engine controls access, provides fast processing for OLTP applications, and supports high availability. Enhancements to the SQL Server 2017 Database Engine include:

  • An Online Index Rebuild operation can resume from where it stopped after a failure, and you can pause and later resume an Online Index Rebuild
  • Adaptive Query Processing can modify the query execution plan selected by the Query Optimizer based on the actual conditions for a workload at runtime
  • Automatic Database Tuning uses a built-in intelligence mechanism for continuous performance monitoring. This feature identifies potential query performance issues, recommends corrective actions, and can automatically implements fixes.
  • The Database Tuning Advisor (DTA) released with SQL Server Management Studio includes more options, like columnstore index recommendations, and improves performance by leveraging rowstore and columnstore indexes
  • Clusterless support for Availability Groups and the ability to migrate and test Availability Groups between Windows and Linux environments
  • Support for computed columns in memory-optimized tables
  • Query surface area in native modules fully supports JSON functions
  • SQL Graph for graph-based modeling of multiple, complex many-to-many relationships. Graph databases can make it easier to express queries for applications like fraud detection and risk management
SQL Server 2017 Graph Consulting

New graph processing capabilities make it easy to model complex many-to-many relationships

SQL Server 2017 Integration Services (SSIS)
SQL Server 2017 Integration Services (SSIS) is a platform for creating enterprise-class data integration and workflow applications like ETL for data warehousing. SSIS 2017 incorporate a variety of enhancements that include:

  • Scale Out for running multiple SSIS package executions in parallel from SQL Server Management Studio (SSMS)
  • The ability to run SSIS packages on Linux computers
  • High availability for Scale Out Master
  • OData Source and OData Connection Manager support for connecting to the OData feeds of Dynamics AX and Dynamics CRM Online
SQL Server 2017 Master Data Services (MDS)
SQL Server 2017 Master Data Services (MDS) centralizes the storage of master data and simplifies creating, managing, deploying, securing, and auditing models, entities, attributes, attribute groups, hierarchies, business rules, and metadata. Reports and analyses depend on MDS for consistent and accurate data. SQL Server 2017 performance enhancements to MDS include:
  • Fast migration from SQL Server 2012 and later to SQL Server 2017
  • Ability to view the sorted lists of entities, collections, and hierarchies in the Explorer page of the Web application.
  • Faster staging for high volumes of records via the staging stored procedure
  • Faster expansion of the Entities folder on the Manage Groups page when setting model permissions
SQL Server 2017 Analysis Services (SSAS)
SQL Server 2017 Analysis Services (SSAS) provides a suite of online analytical processing (OLAP) and data mining tools that can be used to create and distribute business intelligence visualizations. SSAS 2017 supports traditional OLAP as well as modern tabular modeling approaches and integrates with Power Pivot, Excel, and SharePoint for self-service analytics and collaboration. Current versions of SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) are required in order to access the latest capabilities of SQL Server 2017 Analysis Services. Enhancements to SSAS 2017 for tabular models include:
  • Object-level security restricts access to table and column data and can secure sensitive table and column names
  • Date relationships to easily create relationships to date dimensions based on date fields
  • You can hide blank members in a hierarchy for easier reading on reporting clients like Excel
  • With the Detail Rows Expression, model authors can customize the columns and rows returned to the end-user
  • Data Analysis Expressions (DAX) Editor for SSDT
  • Encoding hints for optimizing processing of large in-memory tabular models
  • You can specify the new 1400 compatibility level for tabular models when creating new projects
  • Improved data transformation and data mashup capabilities for models at the 1400 compatibility level
SQL Server 2017 Reporting Services (SSRS)
SQL Server 2017 Reporting Services (SSRS) is a set of tools and services that allow you to create, distribute, administer, and access reports. SSRS reports can ingest content from a broad range of data sources including on-premises SQL Server and Analysis Services data. Collaboration can take place on virtually any desktop or mobile device through a variety of ways such as the Reporting Services Web service, WMI provider, email, or scripts. Enhancements to SSRS 2017 include:
  • Comments as well as attachments are available for reports
  • Report Builder and SQL Server Data Tools have drag-and-drop query designer support for Data Analysis Expressions (DAX)
  • Support for a fully OpenAPI compliant RESTful API

SQL Server 2017 Machine Learning Services (formerly called SQL Server R Services)
SQL Server 2017 Machine Learning Services are in-database services that allow R and Python code to be executed on SQL Servers. Machine Learning Services allows data scientists to call stored procedures to create models, retrain them, and score them.

SQL Server 2017 Machine Learning for R and Pyhton Consulting

SQL Server is the first commercial database with built-in predictive analytics

With SQL Server 2017 you can set up data in a columnstore, generate predictions with R or Python, use in-memory OLTP tables to store the data, and create visualizations with Power BI or SSRS. (Leasrn about Progent's Power BI business analytics consulting services.) This capability makes SQL Server the first commercial database with built-in predictive analytics and machine learning. Enhancements to SQL Server 2017 Machine Learning Services include:

  • Integration of the revoscalepy primary library for scalable Python with functions for data manipulation, transformation, visualization, and analysis
  • Integration of the microsoftml stack of machine learning algorithms and transforms with Python bindings
  • Pretrained models based on ResNet models for image extraction or sentiment analysis
  • Python code deployment with T-SQL using stored procedures
  • You can create Python applications within the database, eliminating the need to move data to your Python application. This simplifies security and compliance, preserves data integrity, and saves the cost, time, management hassle, and risk of transporting huge volumes of data.
  • Ability to stream data from SQL to Python processes using MPI ring parallelization for ultra-high performance
  • Python integration is available in all editions of SQL Server 2017, even the free Express edition
  • Updated versions of base R and RevScaler
  • Advanced role-based management of R packages to control access permissions
  • Standalone SQL Server Machine Learning Server, an independent data science server for R and Python, allows you to distribute and scale R or Python applications without dependencies on SQL Server
How Progent Can Help You Install, Configure, and Use SQL Server 2017
Progent's Microsoft-certified consultants offer remote and on-premises expertise to help you design, install, manage, and troubleshoot your SQL Server 2017 environment. Progent can assist you to evaluate the business advantages of migrating to SQL Server 2017 and can help you plan an optimal deployment model for a local, cloud-based, or hybrid network architecture.

Progent can help you migrate your data and applications efficiently, configure test environments to validate SQL Server 2017's support for your critical workloads, simplify and centralize management, create an enterprise-wide security strategy that complies with government regulations and industry standards, integrate mobile devices, and design a disaster recovery or business continuity plan that incorporates appropriate high-availability options built into SQL Server 2017. Progent can also help you design, develop, and test line-of-business applications powered by SQL Server 2017.

Consulting services offered by Progent for SQL Server 2017 include:

Contact Progent for SQL Server 2017 Consulting and Development Services
To learn more about how Progent can help you with SQL Server 2017 design, integration, troubleshooting, or application development, call 1-800-993-9400 or visit Contact Progent.

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::

  • 24-7 Windows SharePoint Services Support Services SharePoint Remote Consulting
  • SQL Server 2017 and Power BI On-site Technical Support
  • 24/7 SQL Server 2012 Small Business IT Support Firm Allentown Pennsylvania SQL Server 2012 Security Consulting Firms Allentown Pennsylvania

  • Home Based Computer Consultant Job Opening
    Home Based Jobs Home Based Network Engineering

    Progent is convinced that a carefully architected and implemented network is a vital piece for enabling a firm's success, and we follow this philosophy in our own network environment. We have built a zero-downtime virtual office infrastructure that allows our in-house engineers and authorized contractors to offer rapid and effective support, cooperate closely on challenging projects, and experience career and personal maturity by being part of an exciting company ethos of self motivation and freedom.

  • Administration Microsoft SQL Server 2016 Downers Grove-Bolingbrook, Illinois System Engineers SQL Server 2019 Downers Grove-DuPage County, IL
  • At Home Workforce Consulting and Support Services - Edmonton - Infrastructure Consulting Edmonton Edmonton Remote Workforce Infrastructure Guidance
  • Baton Rouge At Home Workers Infrastructure Expertise Port of Baton Rouge, U.S.A. Offsite Workforce Consulting - Baton Rouge - Integration Assistance
  • Calgary Ransomware Remediation Calgary Calgary Crypto-Ransomware Cleanup
  • Campinas, SP IT Staffing for Computer Support Teams Top Ranked IT Staff Temps for Network Support Teams Campinas, Estado do Rio de Janeiro
  • Chesapeake, VA, U.S.A. Chesapeake At Home Workers Help Desk Solutions Guidance Remote Workforce Chesapeake Expertise - Call Desk Augmentation Consulting Services Chesapeake
  • Cisco Certified Fresno, California Tech Consultant 24/7 Fresno, California Computer Consultancy Services
  • Cisco Consulting Firm Santa Rosa, CA Sebastopol CA 24x7 Cisco IT Service
  • Cisco IT Manager Manchester-Sheffield, United Kingdom Cisco Server Administration Manchester, England
  • Cisco On-site Technical Support Springfield Holyoke Agawam Springfield, MA Cisco Systems Support
  • Consultants for Toledo Computer Support Firms Toledo, U.S.A. Toledo Consultants for Computer Support Organizations
  • Contract Programming Azure migration Microsoft Experts Azure hybrid cloud integration Technology Professional
  • Dane County Wisconsin Microsoft MCTS Remote Consulting Virtual Office Job Madison Baraboo Best Computer Security Engineer Telecommuting Jobs
  • Debian Linux, Sun Solaris, UNIX Integration Services Wichita Gentoo Linux, Solaris, UNIX IT Consultant

  • ISA 2004 Server On-site Technical Support
    Technology Consulting Services ISA 2004 Server

    Progent's certified ISA Server consultants have extensive experience with Internet Security and Acceleration Server configuring ISA Server-based security solutions for information systems with multiple offices, remote users, and line-of-business web applications. Progent's Microsoft Firewall experts can help your small business in planning and deploying an installation of ISA 2000 Server or ISA 2004 Server that supports your information protection needs without overly limiting your network productivity. Progent's consultants can help you migrate from Microsoft Proxy Server from ISA 2000 Server to Microsoft ISA 2004 Enterprise Edition Server, ISA 2004 Standard Edition Server, or other later editions of Internet Security and Acceleration Server.

  • Debian Linux, Sun Solaris, UNIX Onsite Technical Support Ventura County California Ventura County California Fedora Linux, Solaris, UNIX Remote Consulting
  • Engineer Windows Server 2008 BranchCache Windows Server 2008 DirectAccess IT Consultants

  • Microsoft Certified SharePoint 2016 Authentication Support and Setup
    SharePoint 2016 Taxonomy Network Consultant

    Progent's Microsoft-certified consultants offer economical online and on-premises expertise, application development, and technical support services for organizations of all sizes who intend to migrate to SharePoint 2016 or SharePoint Online from prior releases of SharePoint.

  • Exchange Computer Support Consultant Kentucky Exchange Computer Network Consultant
  • Emergency SQL Server 2017 High Availability Online Troubleshooting
  • Exchange Configuration Services Ribeirao Preto Remote MCSE Expert Certified Exchange 2019 Integration Specialists Ribeirao Preto, SP
  • Integration Microsoft SQL Server 2017
  • Fedora Linux Computer Consultant Red Hat Linux Onsite Technical Support
  • Las Vegas Nevada Las Vegas At Home Workers Cybersecurity Solutions Expertise Las Vegas Remote Workers Endpoint Security Solutions Consulting Las Vegas Nevada
  • Microsoft SharePoint Engineer Wichita, KS SharePoint Server 2019 Technology Consulting Wichita, Sedgwick County
  • Mission Viejo-Laguna Hills, CA Mission Viejo Microsoft Dynamics GP (Great Plains) Upgrade Experts Microsoft Dynamics GP-Software Mission Viejo Partner - Installation Consultants Mission Viejo, United States
  • Offsite Workforce Eugene Consulting Services - Data Protection Systems Guidance Lane County Oregon Work at Home Employees Consulting Services near me in Eugene - Backup Solutions Consulting Eugene, OR
  • Microsoft Certified Partner Network Consultants SQL Server 2017 Management Studio
  • Open Now Outsourcing Network Help Consultant Services Consulting IT Outsourcing
  • Outsourcing Suse Linux, Sun Solaris, UNIX British Columbia 24x7 Mandrake Linux, Solaris, UNIX Online Troubleshooting Vancouver , British Columbia
  • Portsmouth Newport News Server Consultant Urgent Network Remote Help Desk Computer Expert Portsmouth Newport News
  • Progent Start-Up Companies Troubleshooters Progent Small Business Small Business IT Outsourcing Firm
  • Redhat Network Consultant Chicago, Aurora, Rockford, IL, United States Chicago Illinois Linux Configuration
  • Región Metropolitana Santiago Telecommuters Solutions Guidance Remote Workers Consulting near me in Santiago - Integration Consulting Experts Santiago, Región Metropolitana

  • Top Infor SyteLine CloudSuite Inventory Management Consultants
    Urgent Infor SyteLine CloudSuite CPQ Engineers

    Infor CloudSuite Industrial, previously branded SyteLine, is an ERP solution that embodies over a quarter century of experience assisting manufacturing and distribution companies to simplify supply chains and improve the efficiency of key business processes in order to get products to market quickly and meet customer schedules dependably. Progent offers the skills of an ERP specialist with more than two decades of experience working with the Infor CloudSuite Industrial/SyteLine product family. Progent can provide remote or onsite consulting that spans from as-needed guidance to solution design and project management. Sample consulting services offered by Progent for Infor CloudSuite Industrial include implementation, upgrades, business analysis, application development, Configure/Price/ Quote, web site integration, technical support, ETL, Excel and SQL integration, disaster recovery planning, and DBA services.

  • Remote Workforce Consulting and Support Services near Atlanta - Cloud Technology Guidance Atlanta, United States Remote Workforce Expertise - Atlanta - Cloud Technology Consultants Fulton County Georgia

  • Exchange Server 2016 Migration Planning Remote Technical Support
    Microsoft Exchange 2016 Upgrade Planning Integration Support

    Progent can help you in any and all facets of your migration to Exchange 2016 such as designing HA infrastructure for a local, cloud-based or hybrid deployment; server and CAL licensing compliance for Exchange and Windows Server 2012 R2 or later; moving mailboxes; Windows Hyper-V strategy; determining mass storage requirements for your virtual machines, mailbox databases and log files; setting up hardware load balancing (HLB) for fault-tolerant client access services; planning, setting up and validating Exchange Servers and Windows Servers and DAG groups; integration with SharePoint; preparing your firewall; resolving SSL issues; performing client integration with Office 2010 or greater or Microsoft 365; and setting up Outlook on the web (formerly Outlook Web App).

  • Sacramento CA At Home Workers Consultants near Sacramento - Backup Solutions Consultants At Home Workforce Sacramento Consulting - Data Protection Solutions Consulting Experts Sacramento
  • San Bernardino, CA San Bernardino Avaddon Ransomware Forensics 24/7 San Bernardino Spora Ransomware Forensics Analysis San Bernardino California

  • Altaro VM Backup Management IT Consultant
    Hornetsecurity Altaro VM Backup Local Professionals

    Altaro VM Backup software from Hornetsecurity provides small and mid-size organizations a reliable and budget-friendly platform for backing up and recovering Microsoft Hyper-V and VMware-based virtual machines. Altaro VM Backup can be deployed in local, remote, multi-site, and cloud environments and also supports low-cost cloud backup to Microsoft Azure storage. Altaro VM Backup protects against ransomware attacks via Immutable Cloud Storage. This creates tamper-proof backup data that cannot be erased or modified by anyone including root users. Progent is a certified Hornetsecurity/Altaro partner and offers a wide range of remote or on-premises consulting services to help you to plan, deploy, optimize and troubleshoot a modern backup/restore system powered by Altaro VM Backup. With ProSight Data Protection Services Altaro VM Backup, Progent offers a managed backup/recovery service based on Altaro VM Backup.

  • San Francisco Peninsula, United States Offsite Workforce Palo Alto Consulting Experts - Collaboration Systems Expertise Palo Alto Offsite Workforce Collaboration Technology Consulting and Support Services Atherton CA, United States
  • Southfield, MI, United States Telecommuters Southfield Expertise - Collaboration Solutions Consulting Experts Southfield-Novi At Home Workforce Assistance near me in Southfield - Collaboration Technology Guidance
  • Top Teleworkers Lincoln Consultants - Help Desk Augmentation Consulting Lincoln Work from Home Employees Lincoln Consultants - Help Desk Augmentation Consulting and Support Services Lincoln Nebraska
  • Tukwila IT Staff Temps Services Tukwila-SeaTac Tukwila Temporary IT Staffing Support Tukwila-Tacoma, WA, United States
  • Westminster Microsoft SQL Server 2016 Design Consultants SQL Server 2019 Network Installation London
  • Work at Home Employees Expertise in Austin - Connectivity Solutions Consulting Travis County Texas Work from Home Employees Austin Consultants - Support Guidance Austin, U.S.A.
  • Work from Home Employees Spartanburg Consulting - Cloud Integration Technology Assistance Spartanburg-Roebuck, South Carolina Spartanburg At Home Workforce Cloud Technology Expertise

  • © 2002-2023 Progent Corporation. All rights reserved.