Microsoft Gold-Certified Consultants
Microsoft SQL Server 2012 Expertise:
Planning, Deployment, Application Development, DBA Services
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). SQL Server 2012, called "Denali" during its development, introduces a broad range of features that offer significant improvements in vital areas such as availability, security, performance, manageability, analytics, cloud readiness, scalability, collaboration, data discovery, and streamlined application development. With SQL Server 2012, Microsoft has consolidated the major editions of SQL Server from five to three, making it easier for organizations to select the appropriate version.
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 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 from earlier versions of SQL Server or from other RDBMS platforms, and design an efficient and secure IT infrastructure that helps you maximize the business benefit of SQL Server 2012.
Microsoft's AlwaysOn High-Availability Solution 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 by scheduled maintenance or by network failures. Microsoft designed AlwaysOn technology to achieve or exceed the famous "five nines" availability, or 99.9999% uptime, which translates into just a few minutes of downtime per year. Microsoft's AlwaysOn technology utilizes 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). To provide a more effective and affordable HA/DR solution, SQL Server 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 feature also improves failure detection and provides more flexibility for configuring an optimal failover policy. In addition, SQL Server 2012 introduces an option for indirect checkpoints as an alternative to automatic checkpoints. This new feature allows you to specify the maximum permissible downtime for a database so you can more safely guarantee the recovery time of critical databases following a failover event.
The AlwaysOn Availability Groups feature in SQL Server 2012 offers a significant enhancement to the database mirroring capability of 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 availability as well as resource utilization by allowing you to 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 up to four secondary replicas and feature listeners for fast application failover over, automatic page repair to protect against page corruption, and the ability to force a Windows Server Failover Clustering (WSFC) quorum. To improve hardware utilization and productivity, secondary replicas can be used actively for read-intent applications and backup.
Other New and Enhanced Features of SQL Server 2012
Additional improvements to SQL Server 2012 cover self-service data analysis and business intelligence, collaboration, performance and capacity, manageability, and security. Important new features include:
- PowerPivot
Microsoft SQL Server 2012 PowerPivot allows organizations to create a managed self-service business intelligence (BI) collaboration environment that uses the familiar Excel interface to perform advanced data analysis on high volumes of data from almost any source including relational databases, SSRS reports, Excel files, text files, and web data. PowerPivot also integrates with SharePoint to enable users to share sophisticated reports and analytical applications while supporting standard SharePoint features such as role-based security, compliance policies, workflows, scheduled refreshes, and user-defined alerts. New features of PowerPivot for Excel include Key Performance Indicators (KPIs), Top N, Rank, Perspectives, plus a variety of financial and statistical calculations. - Power View
Power View is a new self-service data analysis and presentation feature of the SQL Server 2012 Reporting Services (SSRS) Add-in for the Enterprise Edition of SharePoint Server 2010. With Power View, users at any level (not just developers or power users) can quickly and interactively create rich reports from data models based on PowerPivot workbooks published in a PowerPivot Gallery, or derived from tabular models deployed to SQL Server 2012 Analysis Services (SSAS) instances. - Improved Performance and Capacity
SQL Server 2012's new xVelocity in-memory columnStore index is reported to deliver a 10x performance boost for typical data-warehouse and decision-support queries and provides the environment necessary to support Relational Online Analytical Processing (ROLAP). SQL Server 2012 also supports 15,000 partitions by default (compared to 1,000 in SQL Server 2008), parallel data warehouses can scale beyond 600 TB, and up to 256 logical cores are supported. In addition, indexes containing important data types can now be created, rebuilt, or dropped online to keep mission-critical database applications available at all times. - Contained Databases and Other Manageability Improvements
SQL Server 2012's support for contained databases removes database dependencies such as user logins and other information on a single instance of the SQL Server Database Engine and makes it easier for administrators to move databases between SQL Server instances. Other manageability enhancements include improvements to SQL Server Management Studio, SQL Server Configuration Manager, and the Database Engine Tuning Advisor. - Security and Compliance
Security enhancements for SQL Server 2012 include provisioning during setup for Managed Service Accounts and Virtual Accounts for Windows 7 or Window Server 2008 R2, 19 new permissions in the Database Engine, new user-defined server roles, the ability to define a default schema for a Windows group, extensive audit enhancements, support for additional hashing algorithms, and use of the newer AES encryption algorithm to replace 3DES for protecting the service master key (SMK). - SQL Server Analysis Services
SQL Server 2012 includes new features and enhancements in Analysis Services covering server instance and server monitoring, tabular and multidimensional modeling, PowerPivot for Excel and SharePoint, programmability improvements for spatial features and DAX functions, and the ability of SQL Server Data Tools to run in the Visual Studio 2010 shell. - Monitoring with Operations Manager
Microsoft System Center Operations Manager now supports health monitoring for SQL Server 2012 and incorporates new features for discovering and monitoring AlwaysOn availability groups, availability replicas, and availability databases for hundreds of computers plus health roll-up from availability database to availability replicas.
Progent can provide affordable online or onsite expertise to help you with any aspect of SQL Server 2012 integration and support so you can minimize your total cost of ownership, maximize your return on investment, and optimize the business value of your information system. Services available from Progent for SQL Server 2012 include:
- Develop a Business Case for SQL Server 2012: Progent offers the services of seasoned IT executives who have extensive backgrounds as Chief Information Officers for large public and private sector organizations. Progent's senior CIO consultants can help you develop a realistic analysis of the risks and benefits of moving to SQL Server 2012.
- Project Management Services: You can outsource or co-source Progent's project management services for any and all phases of creating your SQL Server 2012 solution including requirements definition, system design and architecture, setting up pilots at your datacenter or at Progent's lab, design tuning, deployment and configuration, and training.
- Data and Application Migration: Progent can provide the services of expert database consultants experienced in database development for all versions of Microsoft SQL Server and can also provide Oracle consulting, MySQL expertise, and Microsoft Access support, allowing you to move your data and applications efficiently to a SQL Server 2012 environment.
- Integration with Other Microsoft Applications and Technology: Progent offers the support of Microsoft-certified engineers who can help you plan and implement the integration of SQL Server 2012 with key Microsoft applications and technologies by providing services such as SharePoint consulting, Office Excel and Office 365 Excel application programming, Exchange Server help, Microsoft Dynamics GP (Great Plains) support, and Active Directory expertise.
- Business Intelligence Reporting Expertise: Progent's BI reporting experts can help you use tools such as SQL Server Reporting Services (SSRS), Report Designer, and Report Builder for SQL Server 2012 to design business intelligence (BI) reports that consolidate data from multiple sources and present compelling presentations with deep insights and actionable information. (Find out about Progent's Power BI consulting and training services for using SQL Server SSRS and SSAS data to create visualizations for Power BI analytical reports and dashboards.)
- DBA Services: Progent's database administration consultants allow you to outsource or co-source DBA services for SQL Server 2012 which can include performance tuning, backup/recovery strategies, database security and compliance, managing database storage structures, client configuration and user account management, consolidating databases, plus upgrade and patch management.
- Application Development: Progent's database application developers can help design, implement, and maintain line-of-business SQL Server-based applications and support every phase of an application's life cycle by providing services such as requirements analysis, specification of features/scope, conceptual, logical, and physical modeling, ETL development, T-SQL programming, partitioning strategies, plus replication and synchronization solutions.
- Network Infrastructure Design: Progent's Cisco-certified CCIE network engineers can help you design, configure, and troubleshoot an efficient, secure, and resilient network infrastructure that supports local, remote and mobile users as well as geographically dispersed multiple datacenters.
- Security and Compliance Consulting: Progent's network security engineers hold world-class security credentials including CISA, CISM, CISSP-ISSAP, CRISC, and GIAC, and Progent offers a wide range of services to help protect your SQL Server 2012 environment and achieve compliance with industry and government requirements.
- Disaster Recovery/Business Continuity Planning: Progent's disaster recovery consultants can help you design, implement and validate a transparent mutli-site backup and restore solution for your SQL Server 2012 environment that takes advantage of AlwaysOn technology to eliminate scheduled downtime and accelerate no-loss recovery in case of a network failure due to human error, software bugs, or a catastrophic event. Progent's business continuity planning experts can help you create and document a DR/BC plan that covers all aspects of business recovery including both IT issues and business logistics.
- Proactive Server Monitoring: Progent's System Center Operations Manager (SCOM) consultants can help you configure Microsoft's Monitoring Pack for SQL Server 2012 on Operations Manager 2007 R2 or Operations Manager 2012 so you can automatically monitor the performance, availability, and configuration of SQL Server 2012, collect performance data for analysis, and utilize new default thresholds to alert IT administrators of looming problems before these issues can seriously impact productivity.
- Virtualization Expertise: Progent's Hyper-V experts can help you design cost-effective ways to host SQL Server 2012 instances on virtual machines using Windows Server 2008 R2 Hyper-V and to take advantage of Hyper-V's Live Migration feature. Live Migration can significantly improve database availability by supporting zero-downtime migrations of virtual machines between physical hosts, allowing IT managers to perform maintenance on a SQL Server host without disrupting database applications.
- Upgrading to SQL Server 2014: Progent's SQL Server 2014 consultants can help you assess the business advantage and technical challenges associated with upgrading from SQL Server 2012 to SQL Server 2014 and can help you follow leading practices in migrating your databases and applications to SQL Server 2014. Progent can also help you evaluate the benefits and limitations of moving some or all of your new SQL Server infrastructure to the cloud so that you can create a SQL Server solution that is the best fit for your current needs and for your plans for future growth.
- Migrating to SQL Server 2016: Progent's SQL Server 2016 consultants can help you evaluate the business case for moving to SQL Server 2016 from SQL Server 2012, migrate your applications and data, optimize your network infrastructure to support a cloud or on-premises or hybrid deployment strategy, provide software development and DBA support services, and deliver online or onsite training customized for individuals or groups within your organization.
- Upgrading to SQL Server 2017 or SQL Server 2019: Progent's SQL Server 2017 experts and SQL Server 2019 experts can assist you to plan and implement a cost-effective migration from SQL Server 2012 to a modern version of SQL Server to improve the speed. cybersecurity, availability, and scale of your key data-driven applications. Progent can also help you assess the advantages of various options for on-site, cloud-based, or hybrid-cloud deployment models for SQL Server 2017 or SQL Server 2019.
Progent's Consulting and Support Services for Microsoft .NET Servers
For organizations of all sizes anywhere in the U.S., Progent's Microsoft-certified consultants offer network help and professional consulting support for the whole family of Microsoft .NET servers, Microsoft Windows Server 2008, and Windows 2003 Server. Progent's planning, installation, optimization, and consulting capabilities cover system architecture, deployment, and management outsourcing for
project management and documentation, local and off-site
IT support and network repair,
Help Desk Services, comprehensive
security consulting,
IT outsourcing and co-sourcing, and
network and application server hosting services.
If you need immediate online help from a Microsoft certified consultant, go to Progent's Emergency Online Computer Help.
Find out more about Progent's Consulting Services for Microsoft Server Products.
An index of content::
NetApp MetroCluster Design Engineer
Professional NetApp SAN Fabric
NetApp MetroCluster is a disaster recovery platform that combines array-based storage clustering along with replication to deliver fast, zero RPO disaster recovery between sites located as far as 300km apart. Progent's team of seasoned network experts can assist you to plan, configure, manage, upgrade, test and troubleshoot a disaster recovery solution based on NetApp MetroCluster. Progent can assist you to select an architecture for your MetroCluster environment that aligns with your functional needs and IT budget. Progent can make sure you follow best practices for installing your MetroCluster environment by delivering guidance with tasks such as assigning disk pools and shelf IDs, determining aggregate layout, setting up FlexVol volumes, setting up NetApp Snapshot, provisioning switches, implementing a tiebreaker mechanism, setting up a TCP/IP configuration replication network between your storage clusters, and verifying your MetroCluster DR system to verify adherence with industry standards and regulatory mandates.
ProSight Active Security Monitoring Engineers
ProSight Endpoint Protection Services Information Technology Consulting
Progent's ProSight Active Security Monitoring is an endpoint protection (EPP) service that incorporates cutting edge behavior analysis tools from SentinelOne to defend endpoints and servers and VMs against new malware assaults like ransomware and email phishing, which easily evade legacy signature-matching AV tools. ProSight Active Security Monitoring protects local and cloud-based resources and provides a unified platform to manage the complete malware attack lifecycle including blocking, infiltration detection, mitigation, remediation, and post-attack forensics. Key capabilities include one-click rollback with Windows Volume Shadow Copy Service and automatic network-wide immunization against new attacks.
Les Kent has a 35-year track record of successful technology integration, executive administration, sales, and operations. He has shown a knack for developing sophisticated IT solutions during his time as as a network architect, software developer, project manager, implementation consultant, and problem solver for small businesses, start-ups, and major enterprises.
Google GCP Cloud hybrid cloud solutions Specialist
Google Cloud Anthos Consulting
Progent can provide cost-effective remote and on-premises consulting to help organizations of any size to move any portion of their critical network infrastructure to Google Cloud Platform (GCP). This can save management hassle and equipment expense and enable access to Google's state-of-the-art machine learning tools. Progent can assist you with every phase of Google Cloud Platform migration and troubleshooting including requirements analysis, readiness evaluation, architectural design and review, pilot testing, configuration, administration, performance optimization, licensing management, disaster recovery solutions, and security strategies.
Technology Professional VMware VMotion
Services VMware VCDX certified
Progent can provide the assistance of a certified VMware VCDX consultant to help your organization plan, configure, administer and repair VMware vSphere-powered virtualization solution for on-premises networks, cloud environments, or hybrid deployments. Progent can provide world-class expertise for deploying and configuring VMware Site Recovery Manager (SRM) and VMware's NSX virtual network platform for disaster recovery and application continuity. Progent offers in-depth understanding of VMware vCloud Director, VMware vRealize Automation (vRA), vRealize Orchestrator and vCloud used for managing private and public cloud and hybrid cloud environments that deliver high availability, fault tolerance, and disaster recovery.
IT Consultants Flex Series Wireless Controller
9800-L wireless controller Configuration
Cisco's Catalyst wireless controllers streamline the administration of wireless networks by unifying the provisioning and control of Wi-Fi access points, tuning wireless throughput by reducing the impact of RF congestion, enhancing wireless availability with rapid failover, and strengthening data security by identifying threats and analyzing traffic content based on user class and locale. Progent's Wi-Fi consultants can assist you to deploy Cisco wireless LAN controllers to manage Wi-Fi LANs of all sizes. Progent can help you to maintain and debug your current Cisco Wi-Fi environment or implement a smooth transition to Cisco's modern wireless controller solutions.
Intune Certification Management Technology Consulting
24-7 Mobile Application Management Online Technical Support
Progent's Microsoft-certified Intune consultants can help your company to understand the business value of utilizing Microsoft Intune for managing your web-facing mobile devices including notebooks, smartphones, and tablets based on Windows, iOS, and Google Android. Progent can help your company to define policies, set up pilot environments to evaluate the appropriateness of Microsoft Intune for your environment, deploy Intune throughout your IT ecosystem, integrate Intune with System Center Configuration Manager for single-console change management, and provide ongoing support for your Microsoft Intune solution.
Consulting ProSight Virtual Hosting
ProSight Virtual Machine Hosting Consultants
Progent's ProSight Virtual Hosting and Management outsourcing provides comprehensive hosting of a small or mid-size company's production servers in an environment that gives the highest degree of availability and expandability and is also simple to move to another host. ProSight Virtual Hosting services are built upon mature virtualization technologies that enable small and midsize companies with multi- platform IT systems to economize significantly on the expense of capital equipment, infrastructure maintenance, and IT administration while benefiting from enterprise-class reliability and an unmatched level of vendor flexibility.
Windows Server 2012 R2 Configuration Manager Support Outsourcing
Technical Consultant Windows Server 2012R2 Clustering
Progent's certified professionals can help you to evaluate the benefits of Microsoft Windows Server 2012 R2 for your organization, develop pilot systems and rollout plans, tune your network for local, multi-location, cloud-based, and hybrid datacenters, educate your IT management, team, develop an enterprise-wide security plan, streamline IT administration, help with creating applications, and build and validate a disaster recovery/business continuity plan.
Microsoft 365 and iOS Integration
24x7x365 Microsoft 365 AD FS Consultants
Microsoft allows you to create transparent hybrid networks that integrate Microsoft 365 Exchange Online and local Exchange deployments. This allows you to have certain mailboxes located at your corporate datacenter or private cloud and other mailboxes resident on Microsoft 365. Progent's certified Exchange consulting team can assist your organization with any facet of planning, implementing and debugging your hybrid Microsoft 365 Exchange Online deployment. Progent's Exchange specialists can deliver occasional expertise to help you through challenging technical issues and also offer comprehensive project management outsourcing or co-sourcing to ensure your hybrid Exchange initiative is completed on schedule and on budget.
Small Offices Information Technology Outsourcing Company
Small Offices Computer Consultant
Progent provides the services of Microsoft and Cisco-Premier IT support professionals to offer customers economical alternatives to help businesses optimize the benefits of Microsoft and Cisco products. For networks that span from small offices to large enterprises, Progent's network engineers can show you how to enhance your information system's e-mail infrastructure, protection, reliability, throughput, and system management.
School Wireless Case Study
Wireless Case Studies
Progent delivered a wireless networking environment that allowed a school to improve efficiency and eliminate the ongoing costs of a dedicated data connection. Progent proposed a Proxim Tsunami high-speed wireless bridge. The economical building-to-building Proxim wireless bridge is intended for connecting separate sites up to 2.5 miles apart and can extend to even greater ranges. This wireless solution offered better performance and dependability than recourse to amplifying the 802.11b wireless network, and because it utilizes the 5.8Ghz spectrum it offered immunity to local interference.
Outsourcing Fortinet Firewall Migration
On-site Technical Support Fortinet FortiOps
Fortinet FortiGate next-generation firewalls (NGFWs) are industry leaders in delivering top performance for encrypted data inspection. Progent's Fortinet FortiGate firewall consultants can assist you to integrate your Fortinet FortiGate security appliances to safeguard your IT resources at the network edge, within the data center, at branch locations, and at the cloud edge.
24x7 Microsoft Certified Visual Basic for Applications Contract Development
Custom .NET Design
For custom program development, Progent can provide programming experts to write business applications in areas such as commercial transaction webs, web site design, Microsoft Business Solutions packages such as Great Plains Software accounting system, and specialized management reports based on Crystal Reports, Access Report, or FRx Reports. Progent’s experts can use Microsoft IIS to create company-specific eCommerce solutions based on Microsoft ASP.NET. Also, Progent offers expertise in a broad range of custom program development environments including SQL Server and Delphi. For custom e-Commerce software, Progent also can provide specialists in custom Microsoft Access, custom Visual Basic, custom Excel, and any other specialized development powered by any Microsoft development platform.
Juniper Junos BGT Firewall Configure
Juniper Junos BGT Cybersecurity Consultancies
Progent's Juniper-certified network engineers can help you utilize Junos OS and the Junos platform of network management applications to configure, administer, and monitor Junos-powered devices; migrate to the Junos OS operating system from other Juniper software platforms such as ScreenOS; and upgrade your Juniper routers, switches, and gateways to the latest version of Junos OS.
SQL Server Capacity Planning Design
SQL Contract Programmer
Microsoft SQL Server 2000 is a complete, web-aware database and data analysis package that opens the door to the fast development of a new generation of high-end applications that can give your business a significant competitive advantage. SQL Server provides built-in support for XML and the ability to communicate across the Internet and beyond the firewall. The knowledge and experience of Progent's certified SQL Server 2000 consultants, averaging more than over 10 years of work supporting Microsoft integration, ensures you success in planning, deploying and administering Microsoft SQL Server solutions that are seamlessly integrated with other applications based on Microsoft's .NET platform.
Remote Microsoft and Cisco Certified Expert Amazon AWS migration Contract Programming Firm
24/7 MS Certified Amazon AWS instances Contract Programming Firm
Progent offers affordable remote support to assist companies of any size to integrate Amazon Web Services (AWS) cloud services including Amazon EC2 for virtual machine hosting, Amazon S3 for scalable high-performance storage, and Glacier for value-priced archival storage. Progent can assist you with every aspect of Amazon AWS integration including needs analysis, readiness evaluation, architectural design and review, testing, configuration, centralized administration, performance optimization, software license management, backup/restore mechanisms, and security. Progent can provide advanced expertise with firewall configuration and VPN access and can help you deploy cloud-centric or hybrid cloud networking models that efficiently integrate Amazon AWS cloud services. Progent offers as-needed support to assist you to overcome complex technical issues or Progent can deliver project management outsourcing to help you migrate to the Amazon AWS platform on time and on budget.
ASP Development Company
Microsoft Access application development Services
Progent’s expert programmers, relational database architects, and program managers can assist large businesses to carry out development programs for Microsoft Windows, Linux, or Web applications. Progent's enterprise co-sourcing services include fast access to seasoned project managers for high-level planning and project co-ordination or Progent can assist customers plug expertise gaps by providing database designers and programmers skilled in building RDBMS applications powered by Microsoft SQL Server, Oracle, or MySQL. Progent's SharePoint Server consultants can help clients to incorporate SharePoint with additional applications like Microsoft SQL and Excel to create data-driven intranets and portal sites. Progent also offers expertise with multiple web development technologies and can help businesses to build, enhance, troubleshoot, or port web-based applications to take advantage of the most current web technology.
Select Topic: