Best ChatGPT prompts for Computer Occupations, All Other

Given a database schema with 15 tables and 50 columns, and a query that joins 5 of these tables with subqueries, provide a step-by-step plan to optimize this query for better performance, including indexing strategies, join reordering, and subquery elimination, assuming the database management system is PostgreSQL and the query is executed 1000 times per hour.

Create a comprehensive incident response plan for a cloud-based software-as-a-service (SaaS) application, including procedures for notification, containment, eradication, recovery, and post-incident activities, assuming the application handles sensitive customer data and is subject to GDPR regulations, and provide a checklist of tasks to be performed by the incident response team.

Design a technical architecture for integrating a communication platform with an existing task tracker and industry-specific database, using APIs and webhooks, and provide a detailed workflow for synchronizing tasks, messages, and user data between the three systems, assuming the communication platform is Slack, the task tracker is Jira, and the database is a custom-built MySQL database.

Generate a quality audit report for a software development project, including metrics on code quality, testing coverage, and defect density, and provide recommendations for process improvements, assuming the project uses an agile methodology, and the audit is based on a review of 10000 lines of code, 500 unit tests, and 20 defect reports, and provide a template for the report that includes sections for introduction, methodology, findings, and conclusions.