Step-by-step 1: How to Profile a Procedure with ApexSQL Edit

• Find your procedure's 5 slowest SQL statements.
• Know how many times a statement was executed.
• Know how much time needed to execute each statement.
• Know all the values of your input parameters.

Step-by-step 2: How to Debug a Procedure using ApexSQL Edit

• Single-step procedures.
• Set breakpoints.
• Examine local and global variables.

Step-by-step 3: How to Map a Database to a Source Control system using ApexSQL Edit

• Selecting a Source Control system.
• Defining Source Control system parameters.
• Specifying a Working Folder and a Source Control project structures.
• Selecting database objects that are to be added to a Source Control system.

Step-by-step 1: Working with a SQL Server Transaction Log

• View and filter your database's transaction log.
• Generate and execute the Undo or Redo script of one or more transactions.
• Verify successful execution of generated script.

Step-by-step 1: Dropped or Deleted Data Recovery

• Generate a script to recover data loss from delete or drop operations.
• Specify availability of good quality data source.
• Execute a recovery script.
• Verify successful recovery.

Step-by-step 2: Recover Data Loss from Detached Databases

• Generate a script to recover data loss from a detached database.
• Execute a recovery script.
• Verify successful recovery.

Step-by-step 3: Truncated Data Recovery

• Generate a script to recover data loss from truncate table operations.
• Execute a recovery script.
• Verify successful recovery.

Step-by-step 1: Compare and Synchronize Structures with ApexSQL Diff

Compare and synchronize structures with ApexSQL Diff.

Step-by-step 2: Compare a Script Folder content with a Database using ApexSQL Diff

• Exporting a database to a script folder,
• Comparing a script folder with a database,
• Synchronizing a database structure with a script folder.

Step-by-step 3: Compare a Source Control content with a Database using ApexSQL Diff

• Exporting a database to a source control,
• Comparing a source control with a database,
• Synchronizing a database structure with a source control.

Step-by-step 1: Compare and Synchronize Data with ApexSQL Data Diff

Compare and synchronize data with ApexSQL Data Diff.

Step-by-step 2: Row Level Restore from backup file using ApexSQL Data Diff

Restoring rows from a database backup with ApexSQL Data Diff.

Step-by-step 1: Documenting your databases

• Create a documentation project
• Connect to a server
• Select objects to a document
• Specify documentation objects
• Generate documentation

Step-by-step 1: Auditing a Database

• Connect to a database server
• Create the Audit plan
• Script triggers
• Generate Standard Report
• Generate Aggregate Report

Step-by-step 1: Executing a Rulebase in ApexSQL Enforce

• Open a Rulebase
• Execute the Rulebase
• Review the Result Summary
• Generate a report

Step-by-step 1: Working with templates

• Edit template properties
• Test the template
• Run the generated code
• Review the output

Step-by-step 1: Scripting a Database in ApexSQL Script

• Database and Object selection
• Launch Script Wizard
• Select Output types
• Creating the database script.

Step-by-step 1: Create/run a new report from the newly added connection

• Open the Connection Wizard
• Add Connection
• Open the Add/Edit Report Wizard
• Report details and run report.

Step-by-step 1: How to set up your code formatting options

• Open ApexSQL Refactor's formatting dialog.
• Configure formatting and placement for spaces, indentation, wrapping, cases, expressions, and more.
• Save and share your formatting options.

Step-by-step 2: How to Format SQL Code in SQL Server Management Studio

• Load saved formatting options.
• Apply formatting to code.