Microsoft Gold-Certified Consultants
SQL Server 2019 Consulting:
Planning, Deployment, Application Development, DBA Services
SQL Server 2019 is an advanced, on-premises version of Microsoft's flagship database platform. The headline feature of SQL Server 2019 is the introduction of the Big Data Cluster, a pattern of Linux containers orchestrated by Kubernetes. The Big Data Cluster feature enables massively scaled AI and machine learning tasks on the data stored in HDFS and SQL Server storage pools. SQL Server 2019 also includes additional improvements in the core SQL Server database engine such as feature parity on Linux hosts. Other important enhancements impact SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
With SQL Server 2008 and SQL Server 2008 R2 having reached end of support (EOS) status, migrating to a modern version of SQL Server makes sense for organizations concerned about compliance, compatibility, cybersecurity, and competitiveness. Progent has twenty years of experience planning, deploying, tuning, managing, and troubleshooting SQL Server solutions and can help companies of any size to prepare and execute an efficient migration to SQL Server 2019. Progent's Microsoft-certified SQL Server experts can help you evaluate the business case for upgrading to SQL Server 2019 and supply fast online or onsite access to experts in system design, application programming, database administration, and cybersecurity. Progent can help you deploy SQL Server 2019 on premises, in a private or public cloud, or in a hybrid network architecture.
You can engage Progent's consultants on an as-needed basis for tasks like design review or troubleshooting or you can receive comprehensive project management and co-management services to ensure your SQL Server 2019 initiative is completed on time and on budget. Progent offers the help of certified network security consultants, disaster recovery and business continuity planners, and database application developers to make sure your SQL Server 2019 deployment consistently delivers maximum business value.
Progent's Microsoft-certified consultants can also assist you to integrate SQL Server 2019 with other Microsoft products and services by providing expertise that includes Windows Server 2022 integration services, Windows Server 2019 consulting, Hyper-V virtualization planning, Exchange Server 2019 integration consulting, SharePoint 2019 consulting, hybrid integration with Azure cloud services, Skype for Business integration, Dynamics GP custom reporting help, and System Center Operations Manager (SCOM) consulting.
Progent's seasoned software developers can assist you to plan, create, pilot test, install, and troubleshoot applications that utilize SQL Server 2019 databases and Progent can provide expertise in data modeling, OLTP, Data Warehousing, Data Mining, ETL, tuning, availability, backup/recovery, analytics and reporting, and integration with Amazon Marketplace Web Service. To find out more about Progent's SQL Server development and debugging services, visit SQL Server application development services.
SQL Server 2019 Editions
SQL Server 2019 is available in five basic editions distinguished by price, performance, scale and licensing rules. Progent can help you decide which editions make sense for your needs, and Progent can also help you simplify license management.
SQL Server 2019 Enterprise is the high-end edition of SQL Server 2019 and is intended for critical business applications requiring the most advanced levels of scale, availability, and performance. Compute power and memory supported per database match the operating system maximum, virtualization is unlimited, and relational database size can be up to 524 PB. High availability features unique to the Enterprise edition include Always On availability groups, online page and file restore, online index create and rebuild, resumable online index rebuilds, online schema change, fast recovery, mirrored backups, and hot add memory and CPU. Scalability and performance features for the Enterprise edition include in-memory database, resource governance, partitioned table parallelism, read ahead, automatic tuning, batch mode adaptive joins, plus row mode and memory grant feedback. The Enterprise edition of SQL Server 2019 also supports a richer set of Master Data Services, Data Warehousing, Analysis Services, Reporting Services, and Advanced Integration Services than other editions.
SQL Server 2019 Developer edition is essentially identical to the Enterprise edition, but its license restricts its use to development and testing. The Developer edition is not licensed for use as a production server. SQL Server 2019 Developer supports only a single client for SQL Server Distributed Replay.
SQL Server 2019 Standard edition is designed for departments and small organizations who require a basic, low-overhead platform for data management and BI. SQL Server 2019 Standard edition supports all the security features of SQL Server 2019 Enterprise, but compute capacity is limited to the smaller of 4 sockets or 24 cores. For each instance of SQL Server Database Engine, maximum memory for buffer pool is 128 GB and maximum memory-optimized data size is 32 GB. Unlike the Enterprise edition, the Standard edition of SQL Server 2019 does not support advanced R and Python integration and does not include Machine Learning Services, but supports the other programmability features as well as the management tools available with the Enterprise edition. Advanced features like transparent data encryption, accelerated database recovery, and Big Data Clusters are now included with the Standard edition.
SQL Server 2019 Web edition is an inexpensive option intended for web hosting companies. Compute capacity is limited to the lesser of 4 sockets or 16 cores, max buffer pool memory is 64 MB, and memory-optimized data size is 16 GB. Unlike the Standard edition of SQL Server 2019, SQL Server 2019 Web edition does not support Always On failover cluster instances, basic availability groups, hybrid backup or transactional replication to Windows Azure, or accelerated database recovery. The Web edition also does not support transparent database or backup encryption. You can profile SQL Server Web by using SQL Server Enterprise or SQL Server Standard editions, and SQL Server Web includes the other management tools included with the Standard edition. Data warehousing, Analysis Services, tabular and multidimensional models, BI Services, and some Reporting Services are not included.
SQL Server 2019 Express, available in several variants, is a free entry-level version of SQL Server designed for training or for creating desktop, small-server, and client applications that do not require an industrial-strength database. Compute capacity is limited to the lesser of 1 socket or 4 cores, max buffer pool memory is 1.41 MB, and memory-optimized data size is 352 MB. If applications created with SQL Server 2019 Express grow to require more capacity or additional features, you can upgrade seamlessly to more powerful editions of SQL Server. SQL Server 2019 Express with Advanced Services adds Basic R and SQL Graph integration, the distributed replay management tool, and SQL Server Data Tools (SSDT). SQL Server 2019 Express with Advanced Services can also host a SQL Server Reporting Services (SSRS) database. SQL Server Express LocalDB is a trimmed down version of Express that runs in user mode and can be installed without configuration and with virtually no prerequisites. SQL Server Express LocalDB shares all the programmability features of other Express variants but does not support in-memory OLTP.
Components of SQL Server 2019
The SQL Server 2019 Installation Wizard allows you to select which of the SQL Server components you want to include in your deployment. These components include:
SQL Server Database Engine
The Database Engine is the heart of SQL Server's services for processing, storing, and protecting data. The Database Engine is responsible for replication, full-text search, utilities for managing relational and XML data, integrating in-database analytics, integrating PolyBase for accessing external data sources like Hadoop, and Machine Learning Services for processing SQL Server's relational data with Python and R scripts.
Analysis Services
SQL Server Analysis Services (SSAS) is an OLAP and data mining resource for extracting useful information from data scattered across multiple databases or in various files or tables.
Reporting Services
SQL Server Reporting Services (SSRS) offers a collection of on-premises utilities and services that allow you to build, share, and manage tabular, matrix, graphical, and free-form reports, both mobile and paginated. You can create responsive-design mobile reports with the Mobile Report Publisher app and use native Power BI apps for mobile devices to access the data you have in SQL Server Reporting Services.
Integration Services
Integration Services is a collection of programmable objects and zero-code graphical tools for migrating data. ETL operations can be performed on XML data files, flat files, and relational data sources. These services can be used for copying or downloading files, populating data warehouses, cleansing and mining data, and managing SQL Server objects and data.
Master Data Services
Master Data Services (MDS) is SQL Server's Master Data Management (MDM) platform that allows you to build a single, centralized view of enterprise data, synchronizing data sources to eliminate redundancies and versioning models to maintain consistency. An Excel add-in makes it easy to share the master data set throughout an organization.
In-Database Machine Learning Services
Machine Learning Services allows you to execute Python and R scripts with relational data sources without moving data outside SQL Server or across the network. The Microsoft Python and R packages can be used for predictive analytics and machine learning.
Standalone Machine Learning Server
The Standalone Machine Learning Server allows you to build distributed, scalable machine learning solutions on multiple platforms and use multiple enterprise data sources, including Linux and Hadoop. Because the Standalone Machine Learning Server is independent of SQL Server, you configure, protect, and access the R and Python environment via the OS and tools available on your standalone server. To use SQL Server data, you can create data source objects and connections.
New and Enhanced Features of SQL Server 2019
The headline new feature for SQL Server 2019 is Big Data Clusters, which allows you to work with very large sets of data and includes machine learning and AI support. Other new or enhanced features impact important areas including the SQL Server Database Engine, SQL Server on Linux feature parity with SQL Server on Windows, SQL Server Analysis Services, and SQL Server 2019 Reporting Services.
Introducing Big Data Clusters
SQL Server 2019 introduces Big Data Clusters, a feature that enables you to configure and run scalable clusters in interrelated SQL Server, Spark, and HDFS containers managed by Kubernetes. Because these components can run in parallel, Big Data Clusters technology allows you to process big data from Transact-SQL or Spark and makes it easy to combine and analyze your internal SQL Server relational data with big data. Deployment scenarios include data virtualization, data lakes, and scale-out data marts.
With SQL Server PolyBase, you can query data from virtualized external SQL Server, Oracle, Teradata, MongoDB, and ODBC data sources without having to move or copy the data. You can create a scalable HDFS storage pool to store big data that can be ingested from multiple external sources. Once the data lake is stored in HDFS in the Big Data Cluster, you can analyze and query the data and combine it with your relational data. You can increase data analysis performance by creating a data mart with scale-out compute and storage resources.
You can also distribute data from a wide range of sources across data pool nodes as a cache for ongoing analysis. You can use Spark or integrated R, Python, Scala, and Java tools in SQL Server 2019 for AI and machine learning tasks on the data stored in HDFS storage pools and data pools.
Additional Enhancements to the SQL Server 2019 Database Engine
Other enhancements to the SQL Server 2019 Database Engine cover intelligent databases, the developer experience, security, high-availability, and feature parity between Linux and Windows hosts. Improvements to the SQL Server 2019 Database Engine include:
- Intelligent Query Processing increases the performance of your existing workloads and is activated by default on the latest database compatibility level setting. Improvements include row mode memory grant feedback, batch mode execution without requiring columnstore indexes, scalar UDF Inlining, table variable deferred compilation, and approximate query processing.
- Enhanced In-Memory Database technologies improve performance and scale with new features such as hybrid buffer pool, memory-optimized TempDB metadata, and support for creating Database Snapshots of databases that include memory-optimized filegroups for In-Memory OLTP.
- Intelligent performance improvements in SQL Server 2019 address common resource bottlenecks and offer database configuration options to ensure more predictable performance across all your workloads. Improvements include optimization for indexes subject to last-page insert contention, Query Store plan forcing support for fast forward and static cursors, more granular control of memory limits for resource governance, reduced incidents of unnecessary recompilations, improved scalability for indirect checkpoint, concurrent Page Free Space (PFS) updates, and Scheduler worker migration for more balanced CPU utilization.
- Improvements to the developer experience include support for table and index partitioning for graph tables, support for UTF-8 import and export character encoding, a new Java language software development kit (SDK), new spatial reference identifiers more closely aligned with global positioning systems (GPS), and more informative and actionable error messages for failed ETL processes.
- Security improvements include the Always Encrypted with secure enclaves feature, which allows computations on plaintext data within a secure server-side enclave. This avoids moving data in and out of the database, thereby improving cryptographic performance and reliability. In addition, certificate management is integrated into the SQL Server Configuration Manager, making it easier to view and validate certificates, manage certificates approaching expiration, and deploy certificates across machines in Availability Groups and Failover Clusters. Also, a new integrated Data Discovery and Classification feature helps you classify, label, and protect sensitive data in your databases and meet regulatory and compliance standards for information security.
- For improved availability, SQL Server 2019 increases the maximum number of synchronous replicas in an Availability Group from 3 to 5. In addition, secondary to primary replica read/write connection redirection for Always On Availability Groups allows client application connections to be directed to the primary replica no matter what target server is specified in the connections string. This feature adds replica connection redirection for deployments that do not include an Availability Group listener. In addition, you can configure high availability for SQL Server 2019 Machine Learning Services on a Windows Server Failover Cluster.
- The SQL Server Database Engine recovery process has been redesigned in SQL Server 2019 to support Accelerated Database Recovery. This significantly reduces the time required to complete the recovery process after a failover or other abrupt shut down. Accelerated Database Recovery also cuts the time it takes to complete rollback of canceled long-running transactions.
- SQL Server on Linux has come close to reaching feature parity with SQL Server on Windows through the addition of new SQL Server on Linux features that include support for replication, the Microsoft Distributed Transaction Coordinator (MSDTC), OpenLDAP for third-party AD providers, Machine Learning Services, PolyBase, Change Data Capture (CDC), plus improvements in TempDB.
SQL Server 2019 includes new and improved features for Analysis Services that enhance performance, resource governance, and client support. These features include calculation groups in tabular models, query interleaving, many-to-many relationships in tabular models, new property settings for resource governance, online attach, and governance setting for Power BI cache refreshes.
Enhancements to SQL Server 2019 Reporting Services (SSRS)
Enhancements to SSRS 2019 include:
- Support for Azure SQL Managed Instances allows you to host a database catalog for SSRS in an Azure SQL Managed Instance hosted in a virtual machine or in your data center. You are required to use database credentials for the connection to SQL Managed Instance.
- Support for Power BI Premium datasets allows you to connect to Power BI datasets via Microsoft Report Builder or SQL Server Data Tools (SSDT). You can publish those reports to SSRS 2019 using SQL Server Analysis Services connectivity.
- The Azure Entra (formerly Azure Active Directory) application proxy eliminates the need to manage your own web application proxy for secure access via the web or mobile apps.
- Transparent Database Encryption is supported for the SSRS catalog database for the Enterprise and Standard editions of SQL Server 2019.
Progent's Microsoft-certified consultants can provide online and onsite help to assist you to plan, configure, manage, tune, and debug your SQL Server 2019 deployment. Progent can help you assess the benefits of migrating to SQL Server 2019 and can help you design an appropriate architecture for an on-premises or hybrid network model.
Progent can assist you to migrate your data and applications, set up pilot systems to verify SQL Server 2019's ability to run your business-critical applications, streamline management, design and implement a company-wide cybersecurity strategy that meets government and industry requirements, integrate mobile devices, and create a disaster recovery or business continuity plan that takes advantage of the advanced high-availability technology integrated into SQL Server 2019.
Consulting services available from Progent for SQL Server 2019 include:
- Project Management: Progent offers project management services to help you adhere to leading practices to make sure your SQL Server 2019 initiative is carried out on schedule and within budget. Project can provide fast access to experts to help with any phase of project management including requirements analysis, preparedness assessment, system design, migration planning, configuring test environments, deployment, optimization, documentation, training, administration, and as-needed online or onsite consulting and debugging.
- Database Migration: Progent's seasoned DBA consultants offer consulting expertise for all releases of SQL Server, including end-of-support (EOS) versions such as SQL Server 2008 R2. Progent can also provide Oracle expertise, MySQL software design and programming, and Microsoft Access consulting. Progent has 20 years of experience delivering database solutions and can help you move your databases and applications to SQL Server 2019 quickly and affordably.
- Integration with Other Microsoft Products: Microsoft's extensive catalog of enterprise applications, operating systems, development platforms, management tools, and technologies rely on SQL Server as their core database engine. Progent's Microsoft-certified consultants can help you integrate SQL Server 2019 efficiently with other Microsoft products by offering services that include Windows Server 2022 configuration support, Windows Server 2019 migration expertise, SharePoint Server 2019 application design, Power BI reporting expertise, Exchange Server 2019 consulting and Microsoft 365 Exchange Online integration, and Active Directory and Azure Entra planning and troubleshooting.
- Reporting and Business Intelligence: Progent's Business Intelligence (BI) reporting consultants can help you use Microsoft's BI stack to build and share BI reports that can be accessed securely from any authorized endpoint. Progent can help you create PowerPivot models and use SQL Server 2019 Analysis Services to manage tabular databases. Progent's Power BI experts can help you connect to Power BI datasets using Microsoft Report Builder or SQL Server Data Tools and publish reports to SQL Server Reporting Services by using SQL Server Analysis Services connections. Progent can also help you integrate third-party BI reporting platforms like Crystal Reports with SQL Server 2019 or migrate from legacy reporting tools like FRx.
- Network Infrastructure: Progent's Cisco-certified CCIE network architecture consultants can help you plan, configure, manage, and protect a high-availability and high-performance network infrastructure for your SQL Server 2019 environment. Progent can help you design and deploy an optimal solution for any network model including on-premises, local or public cloud, or hybrid.
- Security and Compliance: Progent's cybersecurity and compliance experts have earned prestigious security certifications including CISA, CISM, CISSP, ISSAP, CRISC, and GIAC. Progent offers organizations of any size a variety of cybersecurity assessment, enhancement, response, and remote monitoring services to protect against known and zero-day cyber attacks such as ransomware and to validate compliance with regulatory and industry requirements.
- Virtualization Expertise: Progent can assist you to plan and configure a cost-effective and manageable virtualization solution for SQL Server 2019 and offers the expertise of certified Windows Hyper-V consultants, VMware vSphere and vCloud experts, VMware NSX-certified virtualization consultants, and Citrix XenServer consultants to assist your organization to deploy and manage a virtualized ecosystem.
- ProSight Remote Monitoring and Management Services: Progent's ProSight family of remote monitoring and management (RMM) services offer an affordable way for small and mid-size businesses (SMBs) to benefit from modern tools and technologies for network management. ProSight services offer comprehensive remote monitoring at a low monthly cost and include management of key areas including network and device security, backup/restore, VM hosting, and documentation management. To find out more about how Progent's ProSight ProSight services can help you monitor and manage your SQL Server deployment, visit ProSight remote network management services.
- Disaster Recovery/Business Continuity Planning: Progent's disaster recovery planning consultants can help you create, test, and document a disaster recovery plan that incorporates SQL Server 2019's high-availability technology to maximize uptime and minimize recovery time for business-critical applications and services. Progent's business continuity planning consultants can help you develop and validate a comprehensive plan to keep your core business processes operating in case of a catastrophic event. The business continuity plan deals with IT infrastructure but also addresses the logistics associated with issues like emergency notification systems and procedures, temporary office space and transportation, and regulatory mandates for reporting. For enterprises, Progent offers the expertise of a VMware VCDX-certified VMware Site Recovery Manager expert and VMware NSX network virtualization consultant to help you plan, implement, and manage an advanced disaster-recovery/application-mobility solution for private cloud and hybrid-cloud environments.
- Online Consulting and Troubleshooting: Progent has twenty years of background providing advanced consulting, application development, and debugging services remotely. Access to online expertise allows you to minimize the costs and duration of network downtime. Progent has successfully delivered remote IT support to organizations of all sizes in every state in the U.S. (See Progent's customer testimonials.) Progent can also provide on-premises support in most metropolitan areas throughout the United States and Canada.
To find out more about how Progent can help you with SQL Server 2019 planning, integration, management, troubleshooting, or software 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::
InDesign Train
Adobe After Effects Training Professional
Progent's Mac consultants can promote the creative aspect of Mac computing by offering help services and training in imaging, sound, and video. Progent's support professionals can provide help in a range of Mac programs such as Photoshop, Illustrator, InDesign, QuarkXPress, Apple Logic, MOTU Digital Performer, Digidesign Pro Tools, Final Cut Pro, Apple Motion, and Adobe After Effects. Progent can also help you with special jobs such as capturing or digitizing audio or video or setting up an audio/video production facility.
Programming MS SQL Server
Coder Microsoft T-SQL
Microsoft SQL Server 2005 delivers indispensable, familiar tools to IT experts and information workers, lessening the complexity of creating, integrating, managing, and using company data and analytical applications on platforms ranging from mobile devices to enterprise data systems. The complexity and integration demands of Microsoft SQL Server 2005 require an IT consultant with real-world expertise and wide knowledge in planning and building information-based, comprehensive business IT solutions. The expertise of Progent's Microsoft-certified engineering staff, with an average of more than 10 years of background supporting Microsoft integration, ensures you success in planning, deploying and managing Microsoft SQL Server 2005 solutions that are seamlessly integrated with the Microsoft .NET environment.
Professional Office Move
Colo Technical Support Services
For corporations with branch offices in California or any area covered by Progent's consultants, Progent's Microsoft-Certified IT consulting experts and certified Cisco network specialists can provide a range of IT consulting services such as project planning, Sarbanes Oxley compliance, site moves, enterprise security, system architecture, local or remote branch office support, and troubleshooting for data center hosting environments. A Progent network consultant can help you design a multi-site network that makes smart use of co-location facilities and Internet hosting sites. Progent's Microsoft Premier consultants can help large corporations plan, integrate and support massive rollouts of updated releases of Microsoft technology including Enterprise Active Directory, Exchange Server, SharePoint, SQL Server, and Enterprise Windows. Progent's CCIE and Cisco Certified Network Professional consultants can assist you to deploy Cisco technology for connection solutions that combine basic, high-speed, integrated, and wireless networking.
Hybrid cloud integration Professional
Hybrid cloud integration Engineer
Progent offers expert remote consulting support to help businesses integrate their IT infrastructure with leading public clouds including Azure and Amazon Web Services (AWS). Progent can assist you to design and administer hybrid ecosystems that can include Windows and Linux systems and applications in either cloud-based solutions or in hybrid architectures that utilize on-premises IT assets along with cloud services. To assist you to integrate cloud services with physical datacenters, Progent can provide a variety of public cloud integration support services that include Microsoft Azure hybrid cloud planning and integration consulting, Amazon Web Services (AWS) cloud integration, and Amazon Web Marketing Service (WMS) development and debugging. Progent has over two decades of background delivering advanced consulting support remotely, and Progent can help you complete your cloud migration initiatives quickly and within your budget.
After Hours SCCM 2007 Migration Onsite Technical Support
SCCM 2007 Asset Inventory Integration Support
Progent can assist you to support Microsoft System Center 2007 Configuration Manager (SCCM 2007) to simplify administration, improve compliance, and increase worker output by ensuring that operating systems and applications are always current, managing licensing, and reporting resource usage patterns so you can make informed buying choices. Once your organization is ready to upgrade your SCCM 2007 device management ecosystem, Progent can assist you to prepare for and implement a smooth migration to System Center 2012 Configuration Manager.
Specialists County Government Cisco
City Government Cisco Technology Professional
Progent has extensive experience providing a broad range of online network consulting and emergency troubleshooting services to local governments and schools throughout the United States. Progent is one of the pioneers in delivering advanced online IT support and has delivered IT support to organizations in every state. Online support eliminates travel costs and resolves problems more quickly than onsite service calls.
MCSE Expert Certified Troubleshooting Great Plains
Dynamics GP Professional
Progent's Microsoft certified experts provide a range of consulting services for Microsoft Dynamics GP/Great Plains. Microsoft Dynamics GP is a Microsoft accounting package and corporate management tool based, like all Microsoft accounting tools, on the expandable and familiar foundation of Microsoft Windows technology. Microsoft Dynamics GP 2010, the most recent version of Microsoft financial products in the Dynamics GP/Great Plains family, provides a cost-effective solution for managing and integrating accounting, e-commerce, supply chain, manufacturing, project accounting, on-site support, customer relationships, and human resources. Microsoft Dynamics GP is easy to install and configure, and with its modular approach you can purchase only the functions you currently need, with the ability to add clients and enlarge functionality when necessary. Progent's Microsoft Dynamics GP Software consulting engineers can help you install, configure and administer Microsoft Dynamics GP/Great Plains 2010 as well as older editions of Microsoft Dynamics GP.
Forefront Threat Management Gateway Remote Troubleshooting
Threat Management Gateway Integration Services
Microsoft Forefront Threat Management Gateway 2010 builds on the proven security capabilities of ISA Server 2006 and offers a easily administered Internet gateway that acts as a single-server platform for an array of security functions including an application layer and network layer firewall, URL filtering, antimalware, IPS, application proxy, Virtual Private Network control, plus HTTP and HTTPS inspection. Microsoft Forefront Threat Management Gateway provides comprehensive web security logging and reporting features, permits customized reporting generated by Microsoft SQL Server, integrates with Active Directory to streamline authentication and policy enforcement, and can be installed as a virtual machine to cut expenses and improve recoverability. Progent's Microsoft-certified engineers can help your company to plan and carry out pilot and production implementations; integrate Microsoft Forefront TMG 2010 with Windows 2008 R2, AD, SQL Server, Exchange Server, and SharePoint; install Microsoft Forefront Threat Management Gateway to operate on a virtual machine with Windows Hyper-V; and deliver ongoing support and troubleshooting. Progent's consultants can also help you to migrate smoothly to Forefront Threat Management Gateway from ISA Server.
Microsoft Operations Manager Case Study
MOM Case Study
Before Progent's Microsoft Operations Manager solution, network problems were handled reactively, once users complained about them. With the help of proactive, automated warnings and trend analyses sent by Microsoft Operations Manager, Progent can now anticipate system troubles before they grow to be serious enough to disrupt network availability. Thanks to Microsoft Operations Manager, Progent can deal with incipient problems before customers are aware that the problems exist. Progent has expertise with Microsoft Operations Manager 2005 and MOM 2000 to offer small business networks enterprise-class reliability, security and performance.
SQL Server Integration Support
Microsoft T-SQL Developer Firms
Microsoft SQL Server 2000 is a complete, Web-enabled database and data analysis package that opens the door to the fast creation of a new generation of high-end programs that can give your business a critical competitive advantage. SQL Server provides built-in support for XML and the capability to query across the Internet and outside the firewall. The experience of Progent's certified SQL Server 2000 engineers, with an average of more than over 10 years of background helping with Microsoft technology, assures you success in planning, installing and supporting Microsoft SQL Server solutions that are seamlessly integrated with other applications based on Microsoft's .NET environment.
24-7 Dynamics GP Power BI Computer Engineer
Microsoft Dynamics GP ERP Network Consulting
Microsoft Dynamics GP/Great Plains allows you to expand and manage your business more efficiently by delivering easy access to decision-driving data and a fast ROI. Dynamics GP offers important business benefits including its ability to extend the reach of your organization, handle your financials, computerize financial operations, unify processes across your company, improve inventory control, increase order accuracy, expand revenue and minimize lead-time, and increase free cash flow. Progent can help you set up and manage a robust, secure server and communications foundation to support Great Plains, and can offer experienced Microsoft Dynamics GP/Great Plains consultants to help you derive the full benefits of your Dynamics GP business management system.
Online Consulting Windows Server 2022 with Linux
Windows Server 2022 Kubernetes Containers Support and Setup
Progent's certified Windows Server 2022 experts can help your company to design and carry out an efficient upgrade to Windows Server 2022 that features high availability and that is based on a self-hosted deployment model or a hybrid model that combines cloud-based Windows Server on Azure with a datacenter-based installation of Windows Server 2022.
At Home Workforce Endpoint Security Professionals
Remote Workforce Security Online Consulting
Progent can assist small and mid-size companies to set up endpoint security protection solutions and deliver mitigation expertise needed to support telecommuters.
Emergency Engineer Google Cloud Compute Engine solutions
Google Cloud Windows Consulting
Progent offers affordable online and onsite support to assist companies to move any part of their critical network infrastructure to Google Cloud Platform (GCP). This can save management hassle and equipment costs and allow access to Google's cutting edge machine learning tools. Progent can help you with every aspect of Google Cloud Platform migration and troubleshooting including needs analysis, readiness evaluation, architectural design, pilot testing, deployment, centralized administration, performance tuning, licensing management, backup/restore mechanisms, and security and compliance.
Microsoft Exchange Professionals
Exchange 2016 Collaboration Onsite Technical Support
Progent can help your business in all phases of your upgrade to Microsoft Exchange 2016 such as designing HA infrastructure for a local, Microsoft cloud connected or hybrid deployment; licensing compliance for Exchange and Windows Server 2012 R2+; migrating mailboxes; Hyper-V design; determining mass storage capacity required for your virtual machines (VMs), databases and logs; setting up hardware load balancing (HLB) for high-availability CAS services; planning, setting up and testing Exchange Servers and Windows Servers and Database Availability Groups (DAGs); integration with SharePoint Server or SharePoint Online; updating the firewall; resolving SSL issues; performing client integration with Office 2010 or greater or Microsoft 365; and configuring Outlook on the web (formerly Outlook Web App).
24/7 Consulting macOS Remote
macOS Small Business Computer Consulting Company
Progent provides national online technical support and consulting services for businesses that operate macOS and OS X networks or whose information systems include a combination of Mac and Microsoft products. Progent's consultants offer Mac clients a range of IT services including desktop support, migration to the most recent version of macOS from legacy editions of Apple macOS or OS X, plus expertise with Mac application software. Progent can also assist your business with iPhone and Apple iPad synchronization and troubleshooting, or migrating to iCloud. Online technical support offers optimum return for your IT budget by preserving user productivity and shortening the time charged for computer repair services. Advanced remote support utilities and skilled service specialists and consultants allow Progent to handle most IT problems without squandering time and expense by traveling to your site. In most of cases your IT issues can be dealt with by telephone or via a mix of telephone help and online connectivity. Progent can offer the services of Cisco certified CCIE network experts and CISA premier security specialists to help with the most difficult network issues.
Security Assessment Professionals
Engineer Cybersecurity Vulnerability Assessment
Progent has created several security service bundles intended to deliver larger corporations an independent and comprehensive security evaluation from a team of certified security engineers. All Progent's security assessment packages feature a suite of services like network scans from within and from outside your corporate firewall, professional analysis of results by certified security engineers, production of a report documenting the findings, plus a live concise executive outbrief and an in-depth interactive outbrief for internal network administrators.
macOS Computer Support Companies
Mac Design Consultants
Progent offers national online technical support and consulting services for businesses who run macOS and OS X networks or whose information systems include a mix of Apple Mac and Microsoft products. Progent's engineers offer Apple macOS and OS X clients a range of IT services including desktop support, upgrading to the latest edition of macOS from legacy editions of macOS or OS X, plus expertise with Mac applications. Progent's specialists in Apple technology can also assist your business with Apple iPhone and Apple iPad support, or moving to Apple's iCloud services. Online technical support offers maximum leverage for your IT dollar by preserving client productivity and shortening the hours charged for computer repair services. Sophisticated online access utilities and skilled technicians and engineers allow Progent to handle most IT problems without wasting time and money by going to your site. In the vast majority of situations your IT issues can be remediated over the phone or via a mix of telephone support and online access. Progent can put you in touch with Cisco certified CCIE network experts and CISA and CISM certified security specialists to help you with the most challenging system problems.
CRISC Certified Testing
After Hours CRISC Certified Risk and Information Systems Control Systems Engineer Consultant
Progent offers the guidance of a CRISC-certified risk management expert to help your company to design and deploy an enterprise risk management strategy following leading practices promoted by CRISC and crafted to match your organization's risk tolerance, business objectives, and IT budget.
ransomware virus recovery Professional
LockBit ransomware recovery Consultants
Progent's proven ransomware recovery experts can assist you to rebuild an IT network breached by a ransomware attack such as Ryuk, Maze, Sodinokibi, DopplePaymer, Snatch or Nephilim.
Cybersecurity Consultancy NodeZero Cybersecurity Penetration Testing
NodeZero Certified Threat Assessment Cybersecurity Contractors
Progent's certified cybersecurity experts can perform NodeZero-based PEN tests to verify your security monitoring and protection tools and policies are properly configured and effective.
Select Topic: