Work safe with session restoration

Last modified: October 28, 2024

Keeping the user’s work safe has never been easier with the session restoration features of SQL Complete. They help minimize or completely avoid loss of code or data, recover sessions, and quickly take action in case of emergency.

• Restoration of document sessions: This is useful when SSMS crashes or the power has been suddenly shut down.
• Restoration of the last closed document: This is helpful if a document has been accidentally closed without saving.
• Execution warnings: Execution warnings prevent accidental drop of objects or loss of data by producing a blocking message whenever the DELETE, DROP, TRUNCATE, and/or UPDATE statements are used in certain environments. The environments can be configured in options and color-coded using the tab coloring feature.
• Tab coloring: Tab coloring helps you quickly identify the database connection or server you are currently working with by assigning individual color labels to them. You will also be able to clearly see where the query will be executed: in Production, Development, or Testing.
• SQL Query History: With the help of this handy tool, the user can view, edit, and search for queries that have been previously executed.
• Transaction reminders: This feature notifies the user about uncommitted transactions.

Video tutorial

Watch the following video to get acquainted with session restoration in SQL Complete.