Software Applications Programming Errors and solutions.

  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 ;

  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

 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

Today is my last working day at xyz compay . It’s always hard to say good bye. I would like to take this opportunity to thank each and every person I have worked with in past 5 Years of my stint with xyz compay .  I would start by thanking a,b,c,d etc for all the opportunities. I would also like to thanks E for his Mentoring and help provided whenever I needed the same.  Thanks to my technical team (Name list). We always got each other’s back. I would also like to thanks functional and pre-sales team whom I have closely worked (Name list) to name but a few.  Thanks to HR team (Name List).   I may have chosen to walk different path but xyz compay  , the time spent here and memories will always stay close to my heart   Needless to say, please stay in touch. I am reachable at my personal email test@xyc.com

Dear All,  After almost 10 year of exciting and memorable stint with xyz company.I am bidding adieu to pursue other career opportunities.   I want to take a moment to say goodbye to you all, today is my last working day in xyz compay and it has been a journey filled with wonderful memories. I appreciate having had the opportunity to be associated with xyz compay and YOU all !   With all this, it has been a hard decision for me to go ahead with the change. But there come times in everyone's life when a change is for the better, and this is one of those times.   It is rare to find great working experience as good as that is in xyz compay . I take this opportunity to personally thank each one of you, who have always helped and supported, directly or indirectly.   My journey at xyz compay  will always hold a very special place in my professional life. I have huge respect and emotions towards this organization.   Once again thanks to all and good bye. ...

 Dear All, I wish to take a moment to let you know that today is my last working day at Xyz company.  It has been almost three years since I got an opportunity to work in this great organization and today, I am finding it quite difficult to say Goodbye to the wonderful people like you. I thank God that I got an opportunity to get associated with xyz and people like you. The time spent here has been a learning experience. It was really a privilege to know and spend time with everyone. This has been a memorable period of my life so far and I will never forget this association. I would like to extend my sincere gratitude to all those who helped and supported me in this journey. I thank each of you for every experiences shared, friendships made, opportunities offered and good times during this tenure. I am reachable at my personal email abc .

 Dear All,   Today is my last working day at XYZ Company and I wanted to let you know how much I've enjoyed my time here. It's been a pleasure working with everyone, and I appreciate everything I've learned here. I would like to take this moment to thank each and every one that has helped me grow as a professional individual.   Your guidance and support has helped me a lot, and I will look back on this time with extreme gratitude.   I wish you all the very best in life and wish more success for XYZ company.   Needless to say, stay in touch. I am reachable at my personal email abc .