Skip to main content

Posts

lates ERP List

  NetSuite : A comprehensive cloud ERP solution suitable for businesses of all sizes, offering modules for financial management, CRM, e-commerce, and more. SAP Business ByDesign : A cloud-based ERP for mid-sized businesses, offering end-to-end business management capabilities, including finance, CRM, supply chain, and project management. Microsoft Dynamics 365 : A versatile cloud ERP solution that combines ERP and CRM capabilities in various modules tailored for different business needs. Oracle ERP Cloud : A powerful cloud ERP solution that integrates financial management, procurement, project management, risk management, and more. Infor CloudSuite : Specifically designed for specific industries (like manufacturing, healthcare, and retail), it offers industry-specific functionalities, analytics, and AI capabilities. Sage Intacct : A ...
Recent posts

Major types of software integration

1. Data Integration  Purpose: Combines data from multiple sources into a unified view. Methods: ETL (Extract, Transform, Load), real-time data integration. Use Cases: Business intelligence, reporting, data warehousing. 2. Application Integration  Purpose: Enables different applications to communicate and share data. Methods: API integration, middleware. Use Cases: Integrating CRM systems with ERP software. 3. Process Integration Purpose: Coordinates and optimizes business processes across applications. Methods: Workflow automation tools, Business Process Management (BPM). Use Cases: Streamlining order management and customer service processes. 4. Cloud Integration Purpose: Connects on-premise applications with cloud-based solutions. Methods: Hybrid integration, Integration Platform as a Service (iPaaS). Use Cases: Connecting cloud CRMs with on-premise databases. 5. User Interface Integration Purpose: Provides a seamless experience across multiple applications. Methods: Single ...

Error on SSRS Report execution query string size exceeded

 Error on SSRS Report execution Excption information: Exception type: HttpException Exception message: The length of the query string for this request exceeds the configured maxQueryStringLength value. at System.Web.HttpRequest.ValidateInputIfRequiredByConfig() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Solution Go to C:\Program Files\Microsoft SQL Server\MSRSXX.<instance_name>\Reporting Services\ReportServer\ Open the web.config Find the <httpRuntime> element. <?xml version=”1.0" encoding=”utf-8"> <configuration>     <system.web>         ...         <httpRuntime maxRequestLength="100000" executionTimeout="90000" requestValidationMode="2.0" >         ...     </sytem.web> Add or modify the maxQueryStringLength attribute (DefaultValue is 2048). <?xml version=”1.0" encoding=”utf-8"> <configuration...

SQL Server query to find long running process in database

  You can user below  Server query to find long running process in database. Please try in query editor thanks. SELECT r . session_id , r . start_time , TotalElapsedTime_ms = r . total_elapsed_time , r .[ status ] , r . command , DatabaseName = DB_Name ( r . database_id ) , r . wait_type , r . last_wait_type , r . wait_resource , r . cpu_time , r . reads , r . writes , r . logical_reads , t .[ text ] AS [ executing batch ] , SUBSTRING ( t .[ text ], r . statement_start_offset / 2 , ( CASE WHEN r . statement_end_offset = -1 THEN DATALENGTH ( t .[ text ]) ELSE r . statement_end_offset END - r . statement_start_offset ) / 2 ) AS [ executing statement ] , p . query_plan FROM sys . dm_exec_requests r CROSS APPLY sys . dm_exec_sql_text ( r . sql_handle ) AS t CROSS APPLY sys . dm_exec_query_plan ( r . plan_handle ) AS p ORDER BY r . total_elapsed_time DESC ;

Top Database management Software application list

  SolarWinds Database Performance Analyzer DbVisualizer ManageEngine Applications Manager Oracle RDBMS IBM DB2 Microsoft SQL Server SAP Sybase ASE Teradata ADABAS MySQL FileMaker Microsoft Access Informix SQLite PostgresSQL AmazonRDS MongoDB Redis CouchDB Neo4j OrientDB Couchbase Toad phpMyAdmin SQL Developer Seqel PRO Robomongo Hadoop HDFS Cloudera MariaDB Informix Dynamic Server 4D (4th Dimension) Altibase

What is good way to reply negative email communication of customer or Client

 To Handle negative email form Customer We need to follow below Instruction. This could be tricky situation so we need to take care those email more than other communication. When we receive a negative mail or communication from customer. We have to present the Facts & proper logical sequence of activities. We have to demonstrate why that situation has arises. If we have highlighted any Risk or intimated customer that we might be facing negative result.  We need to highlight that it was communicated and based on that unfortunately the Risk has occurred. The second part of the mail should contain, how do we plan to pull customer / stakeholders out of that situation. What are the ways and mediums for the same. Also please make sure that you involve your Senior Manager before sending our response to such communication