Microsoft Gold-Certified Consultants
SQL Server 2012 Expertise:
Planning, Integration, Software Development, Troubleshooting
SQL Server 2012 is an advanced version of Microsoft's primary database management platform. This SAP-certified and cloud-ready database server delivers enterprise-class availability, performance, expandability, and security while offering native integration with Microsoft SharePoint and Office plus comprehensive support for Microsoft's popular family of application development tools. Significant enhancements over previous versions of SQL Server include the virtual elimination of planned and unplanned downtime via Microsoft's integrated AlwaysOn high-availability/disaster recovery (HA/DR) technology, ultra-fast performance with xVelocity in-memory technologies for Data Warehousing and business intelligence, and managed self-service analytics and reporting with PowerPivot and Power View.
Progent offers affordable online and on-premises consulting services for SQL Server 2012 that cover all facets of an advanced database management solution by providing services that include database administration (DBA) and project management outsourcing and co-sourcing, database application development, data and application migration services, server and client configuration and troubleshooting, multi-site network infrastructure design and implementation, security and compliance expertise, virtualization strategies, and disaster recovery/business continuity planning.
Availability Enhancements: Microsoft's AlwaysOn HA/DR Solution
Prior to the release of SQL Server 2012, Microsoft's solution for high-availability and disaster recovery (HA/DR) for SQL Server involved using a combination of separate techniques such as database mirroring, clustering, and log shipping. The AlwaysOn HA/DR solution introduced in SQL Server 2012 integrates these individual mechanisms into a cohesive environment that is easier to configure, manage, and monitor. Key components of SQL Server 2012 AlwaysOn include AlwaysOn Availability Groups, AlwaysOn Failover Cluster Instances, AlwaysOn Active Secondaries, AlwaysOn Availability Groups Listener Capabilities, and AlwaysOn AutoStat.
AlwaysOn Availability Groups (AG) is Microsoft's innovative approach to database mirroring to ensure the uptime of application databases. AG offers a variety of options that include manual and automatic failover of a specified group of databases, the ability to have as many as four Secondaries, instant application failover, and automatic page repair. An availability group is a container for a defined set of user databases, referred to as availability databases, that failover together as a single logical entity. An AlwaysOn Availability Group can have multiple failover targets, or secondary replicas, which you can set up to allow read-only access to secondary databases and as backups for secondary databases. This eliminates the need for shared SAN or NAS disk storage for creating a Failover Cluster Instance.
The AlwaysOn Failover Clustering Instances 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.
AlwaysOn Active Secondaries allow you to use secondary instances for report queries and backup. This permits more efficient use of server resources and improves overall system performance.
AlwaysOn Availability Groups Listener Capabilities include the ability of client applications to failover across up to 64 AlwaysOn subnets. Also new is read-only intent, which provides the flexibility to specify the workloads that run on high-availability servers and the ability to manage resources efficiently.
Other availability enhancements included with SQL Server 2012 include Windows Server Core Support to reduce patching and OS reboots by up to 60%, improved support for online operations such as online index build to allow database maintenance without downtime, default values for application upgrades to avoid long-term exclusive table locks, and Split File Backup for faster and more manageable backup operations.
Enhancements for Managed Self-Service Business Intelligence
SQL Server 2012 provides a managed self-service business intelligence environment that allows users at any skill level to analyze data from multiple sources, create interactive, tabular, graphical, or free-form reports, and securely share presentations and reports with colleagues. To accomplish this, SQL Server 2012 introduces Power View for interactive web-based data discovery and visualization, improves PowerPivot with enhanced analytic capabilities, and adds a powerful end-user alerting feature to SQL Server Reporting Services.
PowerPivot provides a managed self-service business intelligence solution that uses the popular Excel interface for complex data aggregation and analysis and Microsoft SharePoint to publish reports securely and collaborate with team members across the organization. PowerPivot can work with data pulled from many sources including various database platforms, SQL Server Reporting Services, Excel data, text files, and the web. PowerPivot's integration with SharePoint not only facilitates collaboration but also provides the benefits of SharePoint's support for role-based security, compliance policies, workflows, scheduled refreshes, and user-defined alerts. New features of PowerPivot include the ability to create Key Performance Indicators (KPIs), high-end sorting options, perspectives, advanced business logic, Top N, hierarchies, perspectives, plus the ability to build Excel-type analytical functions with Data Analysis Expressions (DAX).
Power View is a new feature of SQL Server 2012 that allows users to perform fast web-based data analysis to understand the business implications of massive amounts of information from multiple sources by interactively visualizing the relationships between different tables in the underlying Business Intelligence Semantic Model. Power View simplifies information sharing and allows users to preview and publish presentations instantly to SharePoint Server so stakeholders can interact with the information. To enhance performance, Power View extracts only the data currently needed for visualization. Users can launch Power View over a PowerPivot model or a tabular model running on SSAS directly from a browser.
SQL Server Reporting Services End User Alerting is a new tool to increase information worker (IW) productivity when working with Reporting Services reports published to SharePoint. The Alert runs in the background and monitors data changes, sending an Alert Message when triggered. The Alert trigger is based on a customizable data condition set by the IW, thereby increasing responsiveness to important data changes.
Increased Performance and Capacity
SQL Server 2012 offers significantly higher performance and improved scalability thanks to the addition of features such as xVelocity in-memory technologies as well support for more resource pools, higher CPU utilization, expanded table partition support, and the ability to accommodate up to 250 logical cores.
SQL Server 2012's new xVelocity technology combines an in-memory column store index with enhanced in-memory compression and a new paradigm for vector-oriented SQL query handling to deliver dramatically improved performance for typical data warehouse queries. Analysis Services has also been enhanced by xVelocity technology to improve the performance of SQL Server 2012 Business Intelligence (BI) by supporting scan rates of 10s of billions of rows per second on conventional hardware.
Resource Governance for concurrent and mixed workloads has been improved in SQL Server 2012 to allow faster, more predictable performance for critical database applications. Administrators can assign critical workloads a percentage of performance for a given resource. To provide more flexibility for managers to assure performance for specific applications, SQL Server 2012 increases maximum number of resource pools from 20 to 60 and also increases the maximum capacity setting on CPU utilization.
Full-text search performance has been dramatically enhanced in SQL Server 2012 through improved query execution and concurrent index update techniques. In addition, an improved NEAR operator and updated word-breakers enhance the functionality of full-text search in SQL Server 2012.
Table Partitioning in SQL Server 2012 has been expanded from 1,000 to 15,000, enabling large sliding windows capability. This allows snapshot-intensive applications such as SAP to hold data longer before having to push it out to clear the way for new data. The result is improved performance, simpler management of large amounts of data, and streamlined data warehouse maintenance.
Extended Events, the general event-handling infrastructure for SQL Server 2012, has enhanced event selection, logging and filtering for profiling information and a new user interface to simplify the work required for performance tuning such as analyzing query execution plans, capturing database activity, and optimizing indexes and structures.
Security and Compliance Improvements
Improvements to SQL Server 2012 that strengthen security and facilitate compliance include audit enhancements, default schema for Windows Groups, user-defined server roles, contained database authentication, alignment with SharePoint and Active Directory security models, and integration with System Center Operations Manager for security and health monitoring.
Audit Enhancements help organizations meet government and industry compliance regulations by supporting user-defined audits that allow an application to enter custom events into the audit log, audit filtering to prevent the audit log from filling up with relevant events, and the ability to recover auditing data from temporary file and network issues.
Cryptography enhancements in SQL Server 2012 include the ability to create certificates from bytes, default for Server Master Key (SMK), Database Master Key (DMK), backups key using AES256, expanded support for SHA2 (256 and 512), and the use of SHA512 for password hashes.
Default Schema for Windows Groups allows administrators to tie database schema to Windows Group instead of individual users, streamlining schema management and avoiding query errors due to the assignment of wrong schema to users who change groups.
Support for User-Defined Server Roles allows the creation of new server roles in order to delegate the responsibility for managing data access permissions to various administrators based on assigned roles. This feature reduces reliance on sysadmin for database administration and allows server roles to be nested for flexibility in mapping according to an organization's hierarchical structures.
Contained Database Authentication makes it possible to store user login information directly in user databases rather than master login. This improves compliance by permitting users to perform Data Manipulation Language (DML) operations only within the user databases rather than database instance-level operations. This also reduces orphaned or unused logins in the database instance. AlwaysOn utilizes contained database authentication to improve the portability of user databases among servers by eliminating the need to configure logins for all database servers in the cluster in case of a failover.
Alignment with SharePoint and Active Directory Security Models helps protect a user's data analytics reports published in SharePoint and provides integrated security control at row and column levels.
SQL Server 2012 Consulting and Support Services Available from Progent
Progent offers cost-effective remote and on-premises consulting and support services to help you derive maximum business value from your SQL Server 2012 environment. Consulting and support services available from Progent include:
- Evaluate the Value of SQL Server 2012 for Your Organization: Progent can provide the support of experienced IT professionals who have held executive positions with organizations ranging from Big 4 firms to dot-com startups to state government agencies. Progent's part-time chief information officers can work with you to create TCO and ROI models to help you evaluate the risks and benefits of adopting SQL Server 2012.
- Outsourced and Co-sourced Project Management Support: Progent's project management experts can help you follow industry best practices to complete major SQL Server 2012 projects on time and within budget by providing services such as preparedness analysis, requirements definition, system architecture, testing under realistic conditions at your site or at Progent's piloting lab, performance optimization, project documentation, and webinar or on-premises training.
- Migrating Data and Converting Applications for SQL Server 2012: Progent's database designers can provide database development expertise for legacy and current versions of SQL Server and also have extensive backgrounds providing Oracle database integration services, MySQL consulting expertise, and Microsoft Access application development and migration services. This real-world experience allows Progent to propose and carry out practical techniques for converting applications and migrating data to build your SQL Server 2012-based solution.
- Database Administration Expertise: Progent's database administration experts are available for you to outsource or co-source DBA responsibilities for SQL Server 2012. Skills available from Progent's seasoned DBA experts include database tuning, information security strategies, automating client configuration and account management, backup and restore solutions, managing patches and upgrades, system monitoring, and database consolidation.
- Using SQL Server 2012 Efficiently with Office, SharePoint, and Other Microsoft Technology: Progent's Microsoft-certified consultants can show you how to take full advantage of SQL Server 2012's native integration with key Microsoft technologies and can provide services that include SharePoint solution design and collaboration support, Office Excel and Office 365 Excel application development, Exchange and Outlook configuration help, Active Directory consulting, and Microsoft Dynamics GP (Great Plains) customization and reporting.
- Business Intelligence (BI) Reporting: Progent's BI reporting consultants can show you how to deploy the SQL Server BI Stack with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS) to create and securely share Business Intelligence reports. Progent can help you use new reporting utilities like PowerPivot and Power View to create ad hoc reports, or assist you to use SQL Server 2012 databases to create reports with more traditional management reporting platforms such as Crystal Reports, FRx, and Report Writer. Progent's Power BI consultants can help you use SQL Server SSRS and SSAS data to create visualizations for Power BI reports and dashboards.
- Application Development: Progent's database application developers can assist you to plan, create, test, support, enhance, or troubleshoot mission-critical database applications based on SQL Server 2012. Progent can help with every facet of your application's life cycle via services that include requirements analysis, logical and physical modeling, ETL development, programming with T-SQL and other popular development tools, partitioning design, plus synchronization and replication strategies.
- Multi-site Network Design: Progent's Cisco-certified CCIE network consultants can show you cost-effective ways to create and maintain a safe, fault-tolerant, and high-performance network architecture that accommodates multiple sites as well as local, remote, and mobile users.
- Security and Compliance Consulting: Progent's data security and compliance experts have earned major security certifications including CISA, CISSP-ISSAP, and CRISC. Progent can provide a variety of security assessment and threat mitigation services to guard sensitive data and resources and help you comply with industry security standards and regulatory requirements.
- Virtualization Strategies: Progent's Hyper-V experts can help you save money and improve database availability by deploying Windows Server 2012 R2 Hyper-V to virtualize SQL Server 2012 servers. This allows you to benefit from the Live Migration capability of Hyper-V, which can enhance the availability of SQL Server databases by allowing you to take a physical host offline for maintenance without interfering with users who are running database applications.
- SCOM-based Monitoring: Progent's System Center Operations Manager experts can help you install and configure the Monitoring Pack for SQL Server 2012, which enables System Center Operations Manager 2012 to monitor the performance, uptime, security, and configuration of SQL Server 2012, collect performance data, and take advantage of key thresholds to provide system managers with early warnings about issues that could impact SQL Server 2012 performance.
- Business Continuity Planning: Progent's senior business continuity planning consultants can assist you to develop, test, and document a comprehensive business continuity plan that addresses not only the prompt restoration of your SQL Server database applications and other IT functions but also covers issues related to business logistics such as emergency notification systems, alternate office space and transportation, and regulatory reporting. In addition, Progent's disaster recovery consultants can help you create and validate a practical plan to restore basic SQL Server operations with minimal downtime and little or no data loss after a catastrophic event.
- Upgrading to SQL Server 2017: Progent's SQL Server 2017 experts can help you plan and carry out an efficient migration from SQL Server 2012 to SQL Server 2017 to enhance the performance, security, availability, and scale of your critical data-driven applications. Progent can also help you evaluate various deployment options for on-premises, cloud-hosted, or hybrid-cloud environments for SQL Server 2017.
- Migrating to SQL Server 2019: Progent's SQL Server 2019 consultants can help you assess the business advantage and technical challenges associated with upgrading from SQL Server 2012 to SQL Server 2019 and can help you follow leading practices in migrating your databases and applications to the latest version of SQL Server. Progent can also help you evaluate the benefits 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.
Progent's Consulting and Support Services for Microsoft .NET Servers
For companies of any size throughout 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 2012 R2, and Windows 2008 R2 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 Online Computer Help.
Find out more about Progent's Consulting Services for Microsoft Server Products.
An index of content::
Network Consulting Windows Server 2012 R2 Virtual Fibre Channel
Windows Server 2012R2 upgrade Technology Professional
Progent's certified professionals can assist you to assess the benefits of Microsoft Windows Server 2012 R2 for your organization, create test systems and migration plans, tune your network for on-premises, multi-site, cloud-based, and hybrid datacenters, educate your IT support team, develop an enterprise-wide security strategy, automate IT administration, help with application development, and build and validate a DR/BC plan.
Microsoft Office XP Support Outsourcing
Microsoft Office XP Information Technology Consulting Firms
Progent’s IT outsourcing packages offer affordable computer support for small companies. Whether it includes planning system infrastructure, creating an internal Help Desk or outsourcing a one, rolling out a new e-mail platform, monitoring your network, or building an on-line eCommerce solution, outsourcing your IT engineering services can reduce expenses and eliminate risks, allowing IT service budgets to increase in a more linear and controlled manner than is possible by building up a large, knowledgeable internal IT organization. Progent’s Outsourcing White Paper and flyers explain how Progent can enable you to build a protected and robust system architecture for your critical applications powered by Microsoft Windows such as Office XP, Office 2003, and Microsoft Office 2000.
24-7 Apple OSX Tiger Remote Consulting
Macintosh OS X Remote Troubleshooting
Progent's consultants offer Mac users a range of services including desktop support, Apple macOS and OS X consulting, Mac integration with Windows environments, Entourage and Exchange Server help, security services, and custom education. Progent can help businesses to migrate to macOS from OS X or earlier editions of Apple OS X and Progent can offer expertise with Apple macOS and Mac OS X application software. Progent can also help your business with iPhone integration and Apple iPad synchronization, or migrating to Apple's iCloud. For computer networks built exclusively on macOS or OS X or for systems with a combination of Mac, Linux and Windows powered servers and desktops, Progent's Apple, Cisco, and Microsoft professionals have the background and depth to handle the complexity of planning, integrating and maintaining a network environment that is reliable, safe, fast and able to achieve your company's objectives.
Cybersecurity Consultancy Symantec Security
Symantec Firewall Technical Support
Progent's Symantec experts can assist you to support legacy Symantec firewall and Symantec VPN appliances such as the Raptor and VelociRaptor line or help you upgrade to newer firewall technology. Progent can also enable you to create and execute a comprehensive security strategy that can include firewall and VPN appliances and utilities, managed security and virus protection services, server and application monitoring products, and formal policies and enforcement procedures. Progent has the skill to be your single source for continuing network support, maintenance, training, and security expertise.
Microsoft and Cisco Certified Microsoft Azure hybrid cloud solutions Professional
Technology Professional Microsoft Azure hybrid cloud integration
Progent can assist your it team to plan and administer hybrid ecosystems that support Windows and Linux operating systems and apps in either cloud-based solutions or in hybrid network models that utilize local IT assets as well as public clouds. To help you to incorporate public cloud services with physical datacenters, Progent can provide a range of cloud migration support services such as Azure hybrid cloud planning and integration services, Amazon Web Services (AWS) cloud integration support, and Amazon Web Marketing Service programming and troubleshooting. Progent has two decades of experience providing advanced consulting services online, and Progent can make sure you successfully carry out your cloud integration projects quickly and within your budget.
Oracle RDBMS Programming Companies
24 Hour Oracle PL/SQL Coder
Progent offers affordable online access to an authorized Oracle DBA expert or an Oracle application developer. Progent can provide advanced database administration services for all versions of Oracle including 10g and 11g and can also help plan, build, enhance, or fix Oracle applications written with SQL and PL/SQL stored procedure programming language. Progent also can provide consulting for Streams replication technologies and ASM file/volume manager.
Technology Consulting Services System Center 2016 and SQL Server
System Center 2016 and Windows Server 2016 Configuration
Microsoft System Center 2016 provides major enhancements in the management of hybrid cloud networks by offering comprehensive support for Windows Server 2016 servers, Windows 10 clients; unified management of multi-OS networks that incorporate Linux, Microsoft Hyper-V and VMware vSphere; and expanded cloud support including tighter integration with Microsoft Intune for Apple iPhone and Android smartphone management plus native integration with Operations Management Suite for cloud-enhanced analytics and reporting. Progent's Microsoft-certified consulting staff can provide world-class online and on-premises support for all components of System Center 2016 including Operations Manager, Configuration Manager, Virtual Machine Manager (SCVMM), Data Protection Manager (SCDPM), Orchestrator, and Service Manager (SCSM). Progent can assist organizations of any size to design and configure a new implementation of Microsoft System Center 2016, expand or tune an existing one, upgrade smoothly from an earlier release of System Center, or debug your System Center solution.
Consulting for Service Firms Online Help
Consulting for Service Firms Support and Integration
Progent's Reseller Program for IT Service Organizations lets you use Progent's information technology experts while retaining your own service brand as a transparent arm of your IT services team.
Network Engineer OS X Architecture
After Hours OS X VoIP Troubleshooting
Progent's Apple Mac networking engineers can help you with a broad array of system foundation areas including network architecture, off-site and mobile access, internetwork communication, protection, and emerging technologies including Voice over IP and high-speed wireless networking. For business networks based solely on Apple Mac OS X or for environments that use a mix of Mac, Linux/UNIX and Windows powered servers and desktops, Progent has the experience and size to deal with the complexity of designing, configuring, and maintaining a system infrastructure that is robust, secure, productive and supportive of your business objectives. Progent can help you deploy Apple’s Xserve enterprise servers, Apple's Xserve RAID zero-downtime storage products, and Apple's Xsan storage area network solution. Progent can also provide certified experts to support Cisco routers and switches.
IT Services Wi-Fi 6 wireless controller
Wave 2 Wi-Fi controller Remote Technical Support
Cisco's Catalyst family of wireless controllers simplify the management of Wi-Fi LANs by unifying the provisioning and management of wireless access points, tuning wireless performance by limiting the effect of RF congestion, enhancing wireless uptime with rapid auto-failover, and strengthening data security by detecting cyber threats and filtering traffic content based on user class and locale. Progent can assist you to deploy Cisco Wi-Fi controller appliances to manage and monitor wireless networks of all sizes. Progent can assist you to maintain and troubleshoot your current Cisco-based Wi-Fi environment or implement an efficient upgrade to Cisco's modern wireless controller technology.
Consultant Services Private Cloud Hosting Services
24-7 Hosting for Virtual Servers Consult
Progent's Private Cloud Hosting and Management service provides comprehensive hosting of a small or mid-size company's production servers in a solution that gives the highest degree of dependability and expandability and is in addition simple to transfer to any data center. Progent's Private Cloud Hosting options are based on mature virtualization platforms that allow small companies with multi- platform IT systems to economize dramatically on the costs of capital investments, infrastructure support, and IT management while achieving enterprise-class fault tolerance and an unmatched degree of vendor independence.
SMS Server Migration Support and Setup
SMS Server 2003 Migration Remote Troubleshooting
Microsoft Systems Management Server 2003 offers added capability for change and configuration management of Windows-based networks through introducing Feature Packs. Feature Packs reduce the overall operational expense of managing and deploying software products by making it easier to install system images, manage mobile devices, and run management utilities. In addition to advising you about techniques to save management expenses by installing Microsoft SMS 2003 Feature Packs, Progent's consultants can show you how to prepare and implement IT tasks involving processes that Feature Packs are designed to streamline. Progent's adoption and upgrade services can minimize cost and reduce business disruption as you move to new operating systems and programs. Progent's wireless consulting experts can show you how to define sensible procedures and policies to manage PDAs and smart mobile phones so your field force stays productive and secure. Progent's CISSP-certified consultants and CISM-certified consulting professionals can help you develop a security strategy that incorporates policies, processes and IT products to keep your IT network safe.
64-bit Computing Consultants
64-bit Computing Professionals
Progent’s Microsoft-expert consultants can assist your organization to update your application servers or desktops from 32 bits to 64 bits. Progent can help you to understand the risks and advantages of moving to 64-bit processing, plan an affordable upgrade process that reduces operational disruptions, and offer inexpensive, professional online help to assist your organization to configure 64-bit software and application software on your current computers.
At Home Workforce Infrastructure Online Consulting
Top Offsite Employees Network Infrastructure On-site Technical Support
Progent can help small and mid-size companies to design, implement and troubleshoot the infrastructure required for at-home workers.
Desktop Technology Computer Service Companies
Microsoft and Mac Desktop Computer Network Support Firms
Progent can deliver a variety of low-cost remote and onsite consulting services to help your business to configure, manage, and troubleshoot workstations and mobile devices based on Windows, macOS/OS X, Apple iOS, Google Android, or Linux.
24/7 ProSight Virtual Server Private Cloud Hosting Services
Private Cloud Solutions Consultant Services
Progent's ProSight Virtual Hosting outsourcing offers comprehensive hosting of a small or mid-size organization's production servers in a solution that gives the highest degree of dependability and expandability and is also easy to migrate to another host. ProSight Virtual Hosting and management services are based upon mature virtualization architectures that enable small and midsize businesses with multi- platform environments to economize significantly on the costs of capital investments, system maintenance, and IT administration while benefiting from world-class fault tolerance and an unprecedented degree of vendor independence.
Select Topic: