IT Connection Newsletter: Number 6
SQL Server 2012 Expertise:
Planning, Integration, Software Development, Troubleshooting
SQL Server is Microsoft's flagship database management and analysis system and is tightly integrated with key Microsoft platforms such as SharePoint, Excel, Microsoft CRM, and Dynamics GP (Great Plains). Progent can provide the expertise of Microsoft-certified engineers as well as experienced application developers, database administrators, project managers, network architects, disaster recovery experts, and security specialists to help you derive the maximum business value from your deployment of SQL Server 2012.
SQL Server is Microsoft's top database management and analysis system and is tightly integrated with key Microsoft platforms such as SharePoint, Excel, CRM, and Dynamics GP (Great Plains). SQL Server 2012 has a broad range of features that offer major improvements in vital areas such as availability, security, performance, manageability, analytics, cloud readiness, scalability, collaboration, fast application development, and data discovery. SQL Server 2012 also consolidates the key editions of SQL Server from five to three, simplifying the selection of a version that fits your needs.
Progent can provide the expertise of Microsoft-certified engineers as well as experienced application developers, DBAs, DR/BC experts, network designers, and security specialists to help you evaluate the potential benefits of SQL Server 2012 for your business, set up pilot systems at your datacenter or at Progent's lab, plan and carry out a smooth migration to SQL Server 2012 either from prior releases of SQL Server or from other platforms, and design an efficient and secure environment that helps you maximize the business benefit of SQL Server 2012.
AlwaysOn High-Availability for SQL Server 2012
The headline innovation incorporated into SQL Server 2012 is Microsoft's AlwaysOn solution, which provides flexible and cost-effective system design options for insulating mission-critical application databases from downtime caused either by scheduled maintenance or network failures. Microsoft designed AlwaysOn to achieve or exceed the famous "five nines" availability, or 99.9999% uptime, which translates into just a few minutes of downtime per year.
AlwaysOn technology uses two enhancements in SQL Server 2012 to eliminate the inefficiencies of SQL Server 2008's Failover Clustering Instances (FCIs) for high availability (HA) and SQL Server 2008's database mirroring mechanism for disaster recovery (DR). For a more effective and affordable HADR solution, SQL 2012 includes AlwaysOn Failover Cluster Instances and the new AlwaysOn Availability Groups.
AlwaysOn Failover Clustering Instances support multi-subnet clustering across geographically dispersed sites, allowing you to deploy so-called Stretch Clusters. This architecture offers both a high level of availability as well as the basis for an advanced disaster recovery solution. SQL Server 2012's AlwaysOn FCI also improves failure detection and provides more flexibility for configuring an optimal failover policy. In addition, SQL Server 2012 has an option for indirect checkpoints as a viable alternative to automatic checkpoints. This new feature allows you to specify the maximum permissible downtime for a database so you can safely guarantee the recovery time of critical databases in case of a failover event.
AlwaysOn Availability Groups in SQL Server 2012 improve mirroring in SQL Server 2008 by allowing log-based data movement without shared disks and thereby enabling zero data loss in case of a fail over condition.
AlwaysOn Availability Groups improve database uptime as well as resource utilization by letting you define sets of user databases that fail over as a single logical unit and to create a set of primary and secondary availability replicas to host copies of each availability database. Availability Groups can have four secondary replicas and feature listeners for fast application failover over, automatic page repair to event page corruption, and the ability to force a Failover Clustering (WSFC) quorum. Secondary replicas can be used actively for read-intent applications and backup in order to improve hardware utilization.
For additional information about Progent's consulting support for Microsoft SQL Server 2012, see Progent's Support Services for SQL Server 2012.
Contact Progent about SQL Server 2012 Consulting Services
To find out more about Progent's consulting services for Microsoft SQL Server 2012, call Progent at
Click here to go to the table of contents of the IT Connection newsletter.
An index of content::
Technical Support SharePoint 2016 Data Loss Prevention
SharePoint 2016 Hybrid Specialists
Progent's Microsoft-certified consultants offer affordable remote and onsite consulting expertise, software development, and debugging services for organizations of all sizes who want to upgrade to SharePoint 2016 or SharePoint Online from prior releases of SharePoint.
At Home Employees Infrastructure Remote Technical Support
Urgent At Home Workforce Infrastructure Technical Consultant
Progent can assist small and medium-size businesses to plan, deploy and troubleshoot the infrastructure needed to support work-from-home employees.
Online Troubleshooting Windows 2003
Consultants Windows Server 2003
The experience of Progent's certified Windows Server consulting team, with an average of more than 11 years of support in Microsoft integration, ensures you success in identifying the edition and configuration of Windows 2003 Server that aligns best with your business goals. Progent can also help you with designing, deploying, managing and troubleshooting sophisticated IT applications powered by Microsoft Windows Server 2003, and can streamline your upgrade from Windows 2000 or Microsoft Windows NT.
Remote Support Services Microsoft Exchange 2003 Upgrade
Online Technical Support Microsoft Exchange 2003
Progent's Microsoft-certified professionals provide computer help and network consulting expertise for Exchange 2003 Server, Windows 2003 Server, and for the complete line of Microsoft server platforms. Progent's migration, configuration, administration, and troubleshooting expertise for Microsoft Exchange 2003 Server include system design, deployment, documentation, local and off-site troubleshooting, Help Desk Call Center support, expert security evaluation, and full-service network management outsourcing.
Technology Professional Outsourcing Network Help
IT Outsourcing Services Technology Professional
Progent is organized provide in-depth remote consulting for all technologies associated with today’s small business information systems and allows you to outsource an array of strategic, as-needed services such as a temporary Chief Information Officer to offer senior-level IT design and budgeting skills, a Call Center for help desk support, proactive remote monitoring, spam/virus filtering as an outside-the-firewall service, best-practices project management for major initiatives like site relocations oroperating system migrations, Cisco-certified experts for building and maintaining high-performance and robust network infrastructure, security engineers to verify information protection and regulatory compliance, disaster recovery experts to help design business continuity strategies, and software programmers to create, enhance, or troubleshoot business applications.
Top MRTG Consulting
MRTG for Linux Engineers
Nagios and MRTG are useful, Open Source monitoring utilities that operate on Linux and can be deployed to analyze UNIX/Linux environments, Microsoft Windows systems, or mixed-OS situations in which the Linux OS and MS Windows coexist. Nagios allows system support engineers to monitor system services such as POP3, HTTP, SSH, and PING. Multi Router Traffic Grapher lets you track the traffic in and out of SNMP network devices such as servers, routers, and switches. Progent's network monitoring engineers can help you use both these tools to streamline and troubleshoot your system.
Server Management Engineer
Online Technical Support Server Consolidation
Server proliferation puts pressure on IT budgets and management resources. Server consolidation via a virtual infrastructure promises lower total cost of ownership of servers and faster ROI, more efficient utilization of physical computers, streamlined operations, enhanced system uptime, and easier manageability. Typical uses for virtual servers include hardware consolidation, low-cost hosts for mission-critical legacy applications based on obsolete operating systems, and inexpensive isolation of program development or pilot testing environments from on-line systems.
Google Cloud GKE Engineer
Remote Cisco and Microsoft Certified Google Cloud VM Consultant
Progent can provide cost-effective remote and onsite support to assist businesses of any size to move any part of their critical IT resources to Google Cloud Platform (GCP). This can save management hassle and equipment expense and enable the use of Google's cutting edge machine learning tools. Progent can assist your IT team with every aspect of Google Cloud Platform integration including requirements analysis, readiness evaluation, system design and review, pilot testing, deployment, administration, performance tuning, licensing management, backup/restore solutions, and security and compliance.
Exchange 2019 Hybrid Deployment Remote Technical Support
Remote Technical Support Exchange 2019 Mailbox Migration
Progent can help your organization in any facet of your migration to Exchange 2019 such as configuring Windows Server 2019 Core for hosting Exchange; planning HA infrastructure for an on-premises, cloud-based or hybrid deployment; moving mailboxes; designing and configuring Hyper-V; setting up hardware load balancing (HLB); configuring DAG groups with MCDB solid-state caching; integrating with Skype for Business 2019 for voicemail services; integration with SharePoint Server or SharePoint Online; updating firewalls; integration with Microsoft Office 365; and configuring Outlook clients.
Exchange 2019 MCDB Cache Support
Exchange 2019 and Windows Server Core Professionals
Progent can assist your organization in any facet of your migration to Exchange Server 2019 including deploying Windows Server 2019 Core for hosting Exchange; planning HA system topology for an on-premises, Microsoft cloud connected or hybrid deployment; moving mailboxes; designing and configuring Windows Hyper-V; configuring hardware load balancing; building Database Availability Groups (DAGs) with MCDB caching; integrating with Skype for Business 2019 for cloud voicemail; setting up collaboration with SharePoint; updating firewalls; integration with O365; and configuring Outlook clients.
Windows 10 Migration Technology Consultancy Firm
Windows 10 Installation Network Consultant
Progent's Windows consultants can assist organizations of all sizes to assess Windows 10 or to upgrade to Windows 10 from an earlier release of Windows. Remote and on-premises assessment and upgrade services for Windows 10 available from Progent's experts include Return on Investment estimates, project supervision, compatibility testing, pilot systems, Hyper-V virtualization strategies, Cloud solutions, mobile device management, telecommuter connectivity, data and identity security, streamlined provisioning and administration, network design, Wi-Fi support, business continuity planning, custom training for network management personnel and end users, and post-migration technical help.
Cisco Firewall Upgrade Setup and Support
Adaptive Security Appliances Technical Support
Progent's CCIE-certified network infrastructure consultants can help your organization to maintain legacy PIX 500 or ASA 5500 firewalls or migrate to Cisco ASA 5500-X security appliances. Progent can also help you to set up, manage, update and debug Cisco ASA 5500-X firewalls with Firepower Services.
Technology Professional XenServer Virtualization
Biggest Services XenMotion
Progent's Citrix-authorized engineers can help you to understand the strategic benefits of XenServer as well as other Citrix platforms, and can help your IT organization to plan, validate, implement, troubleshoot, and maintain a Citrix XenServer installation. Progent can also analyze your existing XenServer environment and help you to optimize consolidation, responsiveness, protection, availability, and disaster recovery.
IT Consultants DoubleTake Carbonite Replication Manager
24-Hour Engineer Double-Take Replication
DoubleTake/Carbonite Software offers a family of tools intended to deliver small companies a range of affordable alternatives for replicating and recovering vital workloads including Exchange Server, Microsoft SQL Server, RIM Blackberry, and Microsoft Office SharePoint. Progent’s business continuity planning experts have in-depth backgrounds integrating DoubleTake/Carbonite technology into small business information networks to achieve a high state of availability and disaster recovery readiness at an affordable cost.
ransomware recovery planning Consultants
Services ransomware incident response
Progent's ProSight Ransomware Preparedness Report is a low-cost service based on a brief phone discussion with a Progent backup/recovery expert. The fact-finding interview is intended to evaluate your company's ability either to block ransomware or recover quickly after a ransomware incident. Progent will work with you directly to collect information concerning your current security profile and backup system, and Progent will then produce a custom Basic Security and Best Practices Report detailing how you can follow best practices to create a cost-effective security and backup/recovery environment that minimizes your exposure to ransomware and meets your company's needs.
24/7 Consultants Database DBA
Database Specialists
Progent's Microsoft-certified database application developers offer small and midsize businesses online DBA and programming services for popular database platforms such as MS SQL Server, Oracle, MySQL, and Office Access. Consulting services offered by Progent include software installation and configuration, application design and programming, administration support, synchronization solutions, storage management, performance tuning, migration, security and compliance, backup/restore options, troubleshooting, and webinar training.
Top Quality CISSP-ISSEP Security Professionals
CISSP Certified Cybersecurity Consulting Services
Progent's CISSP-certified network security experts can assist organizations of any size with any aspect of information system security. Progent can implement efficient security systems that guard a small office from modern threats or Progent can design, deploy, and manage a comprehensive security environment for hybrid enterprise networks that accommodate onsite, remote, and mobile users sharing IT resources distributed across a mix of physical datacenters and various clouds.
Select Topic: