Microsoft Gold-Certified Consultants
SQL Server 2017 Expertise:
Planning, Deployment, Application Development, Troubleshooting
Microsoft 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.
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 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) 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) 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) 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.
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
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:
- Project Management: Progent can provide project management outsourcing and co-sourcing to help your business to follow best practices to ensure that your Server 2017 project is successfully completed on time and on budget. Project offers expertise with any aspect of project management with services like needs analysis, preparedness evaluation, solution design, deployment strategy, building pilot systems, installation, tuning, documentation, training, monitoring, and as-needed remote or on-premises consulting and troubleshooting.
- Database Migration: Progent's DBA experts can provide consulting support for all versions of SQL Server, including end-of-support releases like SQL Server 2008 and SQL Server 2008 R2. Progent also offers Oracle consulting services, MySQL application design and development, and Microsoft Access development and training. Progent's background in database solutions can save you time and money in your SQL Server 2017 migration project.
- Integration with Other Microsoft Products: Microsoft's vast portfolio of servers, applications, and technologies depend on SQL Server for data management. Progent's Microsoft-certified consulting experts can assist you with seamless integration of SQL Server 2017 and other Microsoft products by providing services like Windows Server 2022 integration expertise, Windows Server 2019 migration consulting, Windows 2016 Hyper-V virtualization solutions, Windows Server 2016 hybrid cloud integration, SharePoint 2016 hybrid integration consulting, SharePoint Server 2019 application design, Excel and Power BI reporting expertise, Exchange Server 2019 migration, Exchange Server 2016 configuration and troubleshooting, Active Directory design and management, and Microsoft Dynamics GP and CRM customization and training.
- Reporting and Business Intelligence: Progent's Business Intelligence (BI) reporting consultants can show you how to utilize Microsoft's BI stack such as SQL Server 2017 Reporting Services (SSRS) to create, distribute, and manage BI reports that can be accessed securely from any authorized desktop or mobile device. Progent can assist you to create PowerPivot models and use SQL Server 2017 Analysis Services to manage tabular databases. Progent can also help you integrate third-party reporting tools such as Crystal Reports or migrate from legacy tools like FRx.
- Network Infrastructure: Progent's Cisco-certified CCIE network infrastructure experts can assist you to design, configure, manage, and secure a robust network architecture to support your SQL Server 2017 ecosystem for any deployment model including on-premises (local cloud), public cloud, or hybrid.
- Security and Compliance: Progent's security and compliance consultants have earned internationally recognized certifications such as CISA, CISM, CISSP, CISSP-ISSAP, CRISC, and GIAC. Progent can provide organizations of all sizes a selection of security evaluation, mitigation, and information assurance monitoring services to guard against cyber attacks and verify compliance with government and industry standards.
- Virtualization Expertise: Progent can help you design and deploy an efficient virtualization strategy for SQL Server 2017 and can provide the support of certified Windows Hyper-V consultants, VMware vSphere and vCloud specialists, VMware NSX virtual network experts, and Citrix XenServer consultants to help you implement and manage your virtualization solution.
- ProSight Remote Monitoring and Management Services: Progent's ProSight suite of remote monitoring and management (RMM) services provide a cost-effective solution for small and mid-size businesses to take advantage of the latest tools and technologies to outsource network management. ProSight managed services offer end-to-end remote monitoring at a low monthly price and include management of vital areas such as cybersecurity, backup and recovery, virtual machine hosting, and IT documentation management. To learn about how Progent's ProSight managed services can help you monitor and manage your SQL Server ecosystem, see ProSight remote network management services.
- Disaster Recovery and Business Continuity Planning: Progent's disaster recovery planning consultants can assist you to develop, validate, and document a disaster recovery plan that takes advantage of SQL Server 2017's high-availability technology so you can maximize uptime and minimize recovery time for mission-critical workloads. Progent's business continuity planning experts can help you develop and document a detailed plan to keep your business running in the event of a major disruption. This plan will address IT issues but will also cover the logistics of continuing to operate core business functions. For enterprise systems, Progent can provide the expertise of a VMware VCDX-certified VMware Site Recovery Manager consultant and VMware NSX network virtualization expert to help design, deploy, and administer an advanced disaster-recovery/application-mobility solution for private cloud and hybrid-cloud environments.
- Online Consulting and Troubleshooting: Progent has two decades of experience delivering consulting, development, and troubleshooting solutions online. Remote delivery of consulting services saves time and money while minimizing expensive downtime. Progent has successfully provided online IT support to organizations of all sizes in every state in the U.S. (Visit Progent's customer testimonials.) Progent also offers onsite support in major metropolitan areas across the United States and in the Toronto area of Canada.
To learn more about how Progent can help you with SQL Server 2017 design, integration, troubleshooting, or application development, call
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::
Remote Network Monitoring Technical Support
Support Outsourcing Operations Manager
Even if your company has a minimal computer support group and a modest IT budget, your information network can still feature the same high availability and performance that once needed a substantial in-house support organization. Progent's 24x7 Network Support Services for small businesses combine the expertise of skilled Microsoft-certified and Cisco-certified IT professionals, the most recent network management software for 24x7 monitoring and alerts, and cost-effective support packages such as a help desk service to keep your mission-critical network applications and servers up and running.
Google Cloud integration Professionals
Google Cloud GKE Specialists
Progent offers cost-effective online and on-premises support to assist businesses of any size to move any portion of their critical IT infrastructure to Google Cloud Platform (GCP). This can save time and hardware costs and enable the use of Google's state-of-the-art AI and machine learning technology. Progent can assist you with every aspect of Google Cloud Platform migration and troubleshooting including needs analysis, readiness evaluation, system design, testing, deployment, centralized administration, performance tuning, software license management, backup/restore solutions, and security and compliance.
PXE evaluation Lab Consultancy
network evaluation Lab Consultancy
The Progent Test and Training Lab at the QTS Internet Data Center can be used for testing mission-critical applications, creating efficient system upgrade procedures, assessing and optimizing performance, designing or verifying disaster recovery solutions, resolving compatibility problems, and establishing training environments for new products and technologies. For Progent clients without adequate in-house resources to configure proper pilot environments, the lab cuts capital outlay and engineering risk and helps keep vital network projects on schedule.
Symantec Cybersecurity Organizations
Palo Alto Networks Compliance Audit
Progent provides businesses of any size expert consulting for Intrusion Protection products and IPsec VPN technology from leading firewall and VPN security vendors such as Palo Alto Networks, Check Point Software, Juniper, Fortinet, and Symantec. Progent can show you how to design a comprehensive security plan and select the right products from multiple suppliers to achieve your security goals while sticking within your spending limits.
Microsoft Operations Manager IT Consultant
Comprehensive Event Management Technical Consultant
Even if your business has a small network services group and a modest IT budget, your information system can still have the same high availability and performance that once needed a substantial in-house support organization. Progent's 24x7 Network Support Services for small businesses combine the expertise of world-class Microsoft-expert and Cisco-premier IT professionals, the latest system management software for 24x7 monitoring and alerts, and economical service packages such as a help desk call center to keep your vital business applications and servers up and running.
Systems Management Server Professional
Systems Management Server 2003 Online Support
Systems Management Server 2003 offers extra capability for change and configuration management of Windows-powered systems via introducing Feature Packs. Feature Packs lower the net operational expense of managing and configuring software by making it simpler to install system images, manage mobile devices, and operate management tools. In addition to alerting you about ways to cut management costs by installing SMS 2003 Feature Packs, Progent's consultants can show you how to prepare and implement IT projects that cover areas that Feature Packs are intended to streamline. Progent's adoption and update services can lower cost and reduce business disruption as you move to the latest operating systems and applications. Progent's wireless engineers can help you define efficient processes and policies to manage handheld computers and intelligent mobile phones so your mobile workforce remains productive and secure. Progent's CISSP-certified consultants and CISM-certified consulting professionals can show you how to design a security strategy that incorporates policies, procedures and technologies to keep your IT computer system safe.
24/7/365 Expert Microsoft Certified 64-bit Upgrade Technical Support Services
64-bit Computing Consulting Services
Progent's Microsoft-certified consultants can assist you to enhance your application servers and/or desktops from 32 to 64 bits. Progent can help you to understand the costs and advantages of migrating to 64-bit computing, design an affordable upgrade strategy that reduces operational interruptions, and deliver inexpensive, expert online help to assist your organization to install 64-bit software and application software on your current computers.
Router patch management Services
Patch management services Consultancy
Progent's support services for patch management provide organizations of all sizes a versatile and cost-effective solution for evaluating, validating, scheduling, implementing, and tracking software and firmware updates to your servers, endpoint devices printers, network appliances such as switches and wireless APs, and Internet-of-Things (IoT) devices such as alarms and health monitors.
Microsoft Office System Information Technology Outsourcing Companies
Microsoft Office 2003 Specialists
Progent's computer outsourcing services for small companies include planning 2003 Server, Microsoft .NET Server, and BackOffice systems, managing migrations Windows XP, Windows 2003 Server, Active Directory, and Microsoft Exchange Server 2003, Help Desk services, remote and on-premises troubleshooting, resolving stubborn integration problems, and creating a company-wide security strategy. Progent can help you enhance network availability and performance with non-stop technologies, redundant network topology, and proactive server monitoring. Progent also offers project management help for large-scale migrations and can help with needs definition, product identification, BOM production, vendor qualification, purchasing coordination, and professional documentation. Progent's computer outsourcing service also includes education for office productivity products such as Microsoft Office XP.
SQL Server 2019 Migration Online Consulting
Remote Consulting SQL Server 2019 Standard
Progent's certified SQL Server 2019 experts can assist your organization to assess the advantages for upgrading to SQL Server 2019 and can deliver fast remote or on-premises contact with consulting experts in solution design and deployment, application programming, SQL Server management, and cybersecurity.
Cisco Certified Expert Support Outsourcing wireless VoIP phone integration
Best IT Consultants wireless VoIP phone and Aironet APs
Cisco's wireless VoIP phones are industrial-grade Wi-Fi devices designed for workers who are mobile within office, warehouse, health-care or other venues where management requires portable phones that offer more control, security and durability than is possible with the BYOD style of workplace communications. Integration of Cisco's wireless IP phones usually requires that IT teams configure and fine tune numerous components of your wireless environment including APs, routers and switches, Cisco wireless LAN controllers, and network management tools. Progent's certified consultants can provide remote and onsite assistance to help your organization create and maintain a Cisco wireless VoIP phone deployment by delivering integration services that range from troubleshooting the configuration of a wireless IP phone or AP to providing comprehensive project management outsourcing or co-sourcing services for updating the wireless infrastructure of an entire campus.
Ryuk ransomware cleanup Consultancy
ransomware data restore Consultants
Progent's proven ransomware recovery experts can help you to restore a network breached by a ransomware attack like Ryuk, Maze, Sodinokibi, DopplePaymer, LockBit or Nephilim.
Microsoft Access Services
Engineers Oracle Database Resource Manage
Progent's team of expert software programmers, database designers, and project managers can assist large businesses to complete development programs for Microsoft Windows, Linux, or Web applications. Progent's enterprise co-sourcing services include access to seasoned project managers for high-level planning and program co-ordination or Progent can assist customers plug expertise gaps by providing relational database architects and programmers experienced in building RDBMS applications powered by SQL Server, Oracle, or MySQL. Progent's SharePoint Server experts can help clients to integrate SharePoint with other data sources like Microsoft SQL and Excel to create data-driven intranets and web portals. Progent also offers experience with multiple web development technologies and can help businesses to build, expand, repair, or port web applications to utilize the latest advances in web technology.
Select Topic: