Andrew Grant·

What’s New In dbForge For SQL Server 7.0: Key Features And Enhancements

The new dbForge for SQL Server 7.0 update is packed with great features to help you manage your databases faster and easier. With improvements to performance, code completion, data tools, and more, it’s a game-changer for both current users and newcomers.

Whether you want to boost productivity or make database tasks simpler, this update has you covered. Haven’t tried it yet? Now’s the perfect time to give it a go with a free trial!

SQL Server Tools

If you’re an SQL Server user seeking to simplify and enhance database management and configuration, dbForge for SQL Server is worth exploring. This comprehensive suite offers a variety of powerful features, including advanced T-SQL code analysis, data synchronization, and DevOps integration, all designed to boost productivity and ensure high-quality database management. Whether you’re a database developer, administrator, or DevOps engineer, this reliable and user-friendly toolkit will help simplify workflows and optimize performance.

T-SQL Code Analyzer

One of the standout features in this release is the T-SQL Code Analyzer. Available through dbForge Studio for SQL Server, this tool is essential for anyone looking to optimize their T-SQL scripts. It identifies issues such as performance bottlenecks, inefficient queries, and missing indexes — factors that can significantly impact database performance. With the T-SQL Code Analyzer, you’ll have an invaluable tool that helps you troubleshoot and improve your scripts, ensuring better overall performance.

Connectivity

The tools in the dbForge for SQL Server 7.0 release continue to evolve, consistently adapting to changes in related services.

Not only is Azure Active Directory now rebranded as Microsoft Entra ID in the interface, but the dbForge tools also include native support for ApsaraDB. Anyone working with Alibaba Cloud-hosted databases will find this integration much more accessible.

DevOps & CLI Automation

The dbForge for SQL Server 7.0 release introduces several key enhancements to DevOps workflows:

  • Bamboo Data Center Support: dbForge DevOps Automation for SQL Server now supports Bamboo Data Center, ensuring smooth compatibility for users transitioning from Bamboo Server.
  • Find Invalid Objects: Part of dbForge SQL Complete, this feature can now easily detect invalid database objects. CLI automation further improves this tool by enabling users to quickly generate scripts for identifying and managing these objects.
  • Index Manager: Routine index defragmentation is now easier than ever. With configurable defragmentation settings and reusable scripts, users can quickly generate and execute commands via the command line.
  • Comparison Reports: Data Compare and Schema Compare tools now allow you to generate comparison reports directly from the command line.

Code Completion Enhancements

Code completion has received several valuable upgrades:

  • Faster inclusion of non-aggregated columns in GROUP BY statements
  • MSDescription properties can now be viewed for better database understanding
  • Support has been added for T-SQL graph functions and constructs, such as COLUMN MASTER KEY and TERTIARY_WEIGHTS

These improvements make it easier for users to write, review, and optimize their code with a more intuitive approach.

Schema Compare Features

Schema Compare now includes several new features to enhance its functionality:

  • Show Ignored Differences: Highlight DDL differences that are typically ignored
  • Add Sensitivity Classification: Improve data security and compliance by automatically tagging columns based on their sensitivity levels
  • NULL/NOT NULL Conflict Detection: Synchronization wizards now detect potential conflicts between NULL and NOT NULL constraints
  • Enhanced Index Configuration Comparisons: Includes options like STATISTICS_INCREMENTAL and sequences for more granular comparisons

Source Control and Collaboration

The latest updates to Source Control bring several enhancements:

  • Support for XML and HASH indexes in Azure has been added
  • The PERSISTED construct for table variables further enhances functionality
  • Usability improvements include a new button in the static data diff grid for hiding empty columns

Database Diagrams

Database diagrams now feature an updated design with new skins, opacity controls, and zooming options.

Functionalities such as Select All Relations and Clear Waypoints further enhance the diagramming experience, making it more concise and efficient.

SQL Query History and Document Management

Better date range selection is now possible thanks to the revamped SQL Query History toolbar, which also includes a Clear button to free up storage.

Studio Updates also secure user-defined column layouts upon reopening. In addition, document management enhancements now allow users to employ customizable tab layouts and shortcuts for more efficient code commenting and editing.

Data Tools and Script Generation

Data management tools have been improved in several ways:

  • Data Generator: Timestamped script saving, new search capabilities, and shortcuts for faster navigation.
  • Script Generation: Named regions are now part of CRUD templates, and scripts can include DML triggers, security permissions, and authorizations according to user preferences.

Pivot Tables and Search

Pivot Tables now include an advanced Chart Designer. The Search tool also allows users to export results to CSV, assisting those who need to analyze or share search outputs externally.

Application Performance

The Studio now displays both the timestamp and actual startup duration to ensure transparency in application efficiency.

Explore dbForge Studio for SQL Server

If you require a full-featured solution rather than just standalone tools, consider dbForge Studio for SQL Server. This IDE unites various features into one platform to optimize your database management and ensure the best user experience. Take advantage of its full potential with a free 30-day trial!

You may also like to check out:

You can follow us on X, or Instagram, subscribe to our YouTube channel and even like our Facebook page to keep yourself updated on all the latest from Microsoft, Google, Apple, and the Web.