IT Connection Newsletter: Number 6
Microsoft SQL Server 2012 Consulting:
Planning, Integration, Application 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::
Virtual Machine Manager 2016 Online Support Services
SCVMM 2016 Disaster Recovery Remote Support Services
Microsoft System Center 2016 Virtual Machine Manager is a component of Microsoft's System Center 2016 family of IT infrastructure monitoring and management products and is designed to provide a unified mechanism for configuring and managing virtualized datacenters across hybrid networks that can incorporate private clouds and Microsoft Azure services. Progent's Virtual Machine Manager 2016 consultants can assist organizations of all sizes with all facets of designing, implementing, and maintaining a SCVMM 2016 ecosystem. Progent can assess your virtualization architecture, help you migrate efficiently from older releases of VMM, design processes for building and installing VMs and hosts, design fault-tolerant compute and storage clusters, connect your private cloud resources with public clouds, set up virtual switches and load balancers, develop and debug PowerShell scripts, and help you assess the potential advantages of new capabilities such as Storage Spaces Direct and Host Guardian Service. Progent's certified hypervisor professionals can provide advanced Hyper-V consulting and VMware vSphere expertise.
Top Quality 2800 ISR Router Professional
ISR G2 Routers Integration
Cisco has developed a full array of routers that includes appliances built to deliver the security, performance, and availability demanded by organizations from branch offices to global enterprises. Cisco routers include support for redundancy, automatic failover, and redundant power for improved reliability and network uptime. Progent can help you choose and configure Cisco routers to establish a reliable foundation for your IT system and to make it economical to expand as you add new users, open new offices, deploy new services, extend your network to customers and partners, and support a more mobile workforce. Progent can provide expertise in a variety of routers based on the Cisco IOS operating system, including Cisco's 800 series of small office routers, Cisco 1800 and 2800 Integrated Services Routers, Cisco 1900 and 2900 Generation 2 ISR routers, Cisco ASR 1000 and 9000 Aggregation Services Routers for wide area network edge environments, Cisco CRS Carrier Routing System for the network core, plus older 2500 and 2700 Series Routers.
Windows Server 2019 Live Migration Computer Consulting
Windows Server 2019 Cybersecurity Technical Support
Progent's Windows Server 2019 disaster recovery/business continuity planning experts can help your business to plan and deploy a DR/BC solution built around Microsoft's advanced Failover Clustering tools including Cluster Sets, Storage Replica, Storage Spaces Direct, VM Load Balancing, and Cloud Witness.
Microsoft Excel for Mac Training
Train macOS
Progent can provide onsite training customized for individuals who want to broaden their knowledge of the Apple macOS and OS X operating system, Apple Mac computers, or Mac office productivity applications including Word, Excel, and Outlook for Mac. Progent also can provide customized group or one-on-one online training for Mac applications.
Cisco Certified Expert Pennsylvania Information Technology Support
Computer Support Companies New Hampshire
Progent’s Technical Response Center (TRC) provides national extended hours remote support for information systems based on Windows and Cisco products and technologies. Progent's Microsoft and Cisco-Premier support professionals provide after-hours phone support and remote secure network access to isolate and resolve technical problems quickly and affordably. The breadth of technical experience available from Progent's staff of country-wide service professionals allows Progent to escalate even the toughest problems to appropriate specialists as needed. For critical issues, the TRC endeavors to respond to your call for service within one hour.
Consult Comcast Business Class Cable Internet
Internet Connection Engineer
Progent can provide the cost-effective services of online Internet connectivity consultants to assist your company to evaluate or enhance your Internet services so your Internet access solution matches your business requirements. Support services provided by Progent include assessment of your current bandwidth utilization, carrier and service plan analysis and selection, network provisioning, and managing a seamless switchover to a new ISP and/or service plan. Network provisioning can include optimizing existing routers and deploying additional ones, implementing firewalls, and upgrading fault-tolerant BGP configurations.
Consulting Support for IT Service Firms Remote Support Services
IT Services for Service Providers Online Troubleshooting
Progent's Support for IT Service Firms lets you use Progent's information technology engineers under your own service brand as a transparent extension of your IT consulting staff.
Network Consulting Group Cisco Planning
Cisco Access Point Network Support Consulting
Progent offers fast remote access to Cisco-certified CCIE networking consultants. Progent's CCIE engineers can link to your network using advanced remote support utilities to deliver fast and economical analysis and repair of urgent network infrastructure problems.
Select Topic: