Manage Your Sensitive Data With SQL Data Discovery and Classification in SSMS

The 17.5 version of SQL Server Management Studio (SSMS) brought with it a new built-in security tool. Since then, the Data Discovery and Classification feature has become a difference-maker in the protection of sensitive information.

Read the rest of this entry »

ADD SENSITIVITY CLASSIFICATION Command in SQL Server 2019

For a database administrator, the common everyday practice involves running multiple operations targeted at ensuring database security and integrity. Thus, we shouldn’t overlook the importance of sensitive data stored in the database under any circumstances. In light of this, we are excited to demonstrate the new ADD SENSITIVITY CLASSIFICATION command introduced in SQL Server 2019, which allows adding the sensitivity classification metadata to database columns.

Read the rest of this entry »

Meet dbForge Schema Compare for PostgreSQL, v1.0!

We are proud to announce the release of a new product from the dbForge Tools for PostgreSQL line – dbForge Schema Compare for PostgreSQL, v1.0.

The tool is best suited when you need to compare Redshift databases quickly and efficiently, as well as to generate synchronization SQL scripts to update target database schemas.

Read the rest of this entry »

Continuous Delivery of Database Changes to SQL Server When Working Remotely

In the process of software product development that involves a database, one of the key points is the possibility of continuous delivery of changes from the development environment to the production environment.

Read the rest of this entry »

Working With Multiple Branches in Source Control

With the help of dbForge Source Control tool that comes as an add-in for Microsoft SQL Server Management Studio and is included in dbForge Studio for SQL Server, you can quickly connect databases you’re working on to your version control system of choice and easily switch between different branches.

Read the rest of this entry »

Version-controlling Static Data: Conflicts

Version-controlling static data is vital to maintaining a normalized database structure. The article presents a simple and comprehensive guide through the process of resolving static data conflicts with the help of the dbForge Source Control plugin.

Read the rest of this entry »

Embrace Data Protection and Regulatory Requirements With SQL Complete Suggestions

We are pleased to present the latest version of our superior solution for SQL Server database development, management, and administration – SQL Complete v6.6. The update is packed with improvements and the major one is the support for the ADD SENSITIVITY CLASSIFICATION command introduced in SQL Server 2019.

Read the rest of this entry »

dbForge Data Compare for PostgreSQL v.3.3 Released!

We are glad to announce that a new version of dbForge Data Compare for PostgreSQL v.3.3 is available for download.

In this release, we have extended connectivity options to provide the possibility to work with the latest PostgreSQL database engine. Also, we adjusted the Pre & Post Script execution functionality that helps you perform additional operations before and/or after data synchronization.

Read the rest of this entry »

SQL Unit Testing Stored Procedure with dbForge Unit Test for SQL Server

Unit testing is an essential component of the database DevOps process. Its primary goal is to test the constituent parts of the database objects in order to identify any malfunctions or flaws early in the project. This approach allows database developers to ensure the changes they have made are verified, and the project will work properly. In our article, we will mainly focus on unit testing a stored procedure in a SQL Server database and exemplify how simple it is to conduct unit tests with the dbForge Unit Test tool.

Read the rest of this entry »

New in Delphi DAC: Support for the Latest Versions of Lazarus and FPC

Secure Connections in ODAC

We are excited to announce that new versions of Delphi data access components are now generally available. All DAC products received support for the latest versions of Lazarus (2.0.10) and Free Pascal Compiler (3.2.0).

Read the rest of this entry »