startCCH SQL Database Analysis Consultancy
How To

CCH SQL Database Analysis Consultancy

Training and Consultancy
Last update: Reading time 1 minutes
ConfigurationSQL ServerTechnical Services

    CCH Central optimal operation is key to the business function CCH Central suite key underlying technology is Microsoft SQL Server. Whilst the database function is viable to operate within its parameters 'out of the  box', it is a highly flexible product and benefits from careful optimisation in order to achieve best performance.​

    Database analysis services ensure the CCH suite can function at optimal level  with analysis focusing on performance , data quality, quantity including data history. ​

    Rigorous consistency checks ensure your data remains accurate and trustworthy on the platform and validation processes prevent aims to prevent future errors. ​

    Data quality reports gives exposure to that quality and the clear summary information  allow the decisions on data cleanse , retention to be made and actioned as additional projects in a quicker and easier manner. Resulting in clean, structured database.

    Agenda

    • Data Quality ​

    • Client Records , volume and history​

    • Data size and history of data​

    • Obsolete data ​

    • GDPR Impact of stored data​

    • Report on database content, and impact of data governance and health to facilitate future data cleansing.​

    • Follow on action planning.

    Related documents

    CCH Compliance Pack Implementation
    This document outlines an implementation session aimed at assisting users with the effective set up of CCH Tax and Accounting software. The session will cover best practices, compliance options, pre-configuration checks, data migration discussions, and training opportunities. Key objectives include reviewing current processes and confirming tasks and responsibilities. Target participants are decision-makers and managers. The session lasts up to three hours and includes an agenda focused on operations, data security, compliance training, and useful resources such as eLearning and webinars.
    Azure Information
    This document provides guidance on selecting Azure architecture and hardware provisioning specifically for SQL Server. It recommends the Ebdsv5/Ebsv5 series for those seeking optimal performance and cost-effectiveness. Key advice includes prioritizing P core processors, focusing on clock speed over core count for SQL performance, and utilizing Proximity Placement Groups. Relevant Microsoft resources for best practices and pricing strategies are linked, as well as additional support materials for products and training from Wolters Kluwer.
    CCH Accounts Production Corporate: Refresher (10134647/10134661)
    A streamlined service for existing users who require a quick update or refresher on key processes within CCH Accounts Production. This service is ideal for those returning to CCH Accounts Production after a break or seeking to refresh their skills in line with current standards and software updates. 
    CCH Accounts Production Corporate: Professional online (10134646)
    An advanced programme for experienced users of CCH Accounts Production who wish to develop their expertise or update their knowledge. This service covers the latest updates, advanced functionalities, and troubleshooting techniques, helping users to stay current and maximise efficiency in their accounts production work. 
    CCH Accounts Production Corporate: Practitioner (10134645/10134660)
    A comprehensive onboarding programme for new users with little or no prior experience of accounts production software. This service covers accounts production for corporate entities, guiding users through CCH Central and CCH Accounts Production software.