Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 1 to 10 of 12 « Previous | Next »
Displaying posts with tag: SQL Server Tools (reset)
Database governance in the AI era: Framework, risks and best practices

AI database governance can get overlooked when teams rush to connect AI tools to production data. IBM’s 2025 research found that 97% of organizations that reported a breach involving an AI model or application lacked proper AI access controls. The risk is easy to see. Give an AI agent too much access and it can […]

The post Database governance in the AI era: Framework, risks and best practices appeared first on Devart Blog.

Database branching explained: How it works and when to use it 

Your application code branches in seconds. Your database still gets copied, shared, and fought over. Here is how database branching closes that gap, where it breaks down, and what has to sit around it before it makes releases safer.

The post Database branching explained: How it works and when to use it  appeared first on Devart Blog.

Will AI agents replace database IDEs? The future of database development 

AI agents can already write SQL, inspect schemas, and work through multi-step database tasks. But what happens when they start acting inside the database itself. Read the full article to see where that shift leads, what still needs human control, and how database IDEs fit into the picture.

The post Will AI agents replace database IDEs? The future of database development  appeared first on Devart Blog.

13 best practices for database development in Visual Studio 2026 

Visual Studio 2026 ships SQL projects through SSDT, and only the original project format. Here is how to configure, validate, version, deploy, and drift-check a database project without discovering the gaps during a release.

The post 13 best practices for database development in Visual Studio 2026  appeared first on Devart Blog.

Data Integrity in a Database: How to Ensure Accuracy and Security

Learn what data integrity in DBMS means, why it’s vital for database accuracy, and how to maintain it effectively. Read on to protect your data now.

The post Data Integrity in a Database: How to Ensure Accuracy and Security appeared first on Devart Blog.

What Is ANSI SQL and Why You Should Use It 

This article examines ANSI SQL, the universal SQL standard that ensures compatibility across databases such as PostgreSQL, Oracle, MySQL, and SQL Server. Learn its history, key features, components, and benefits, and understand how it compares to vendor-specific SQL dialects in building scalable, maintainable, and cross-platform database systems.

The post What Is ANSI SQL and Why You Should Use It  appeared first on Devart Blog.

Best Database Diagram Tools–Free and Paid 

Scalable systems live or die by schema clarity. That’s why most engineers now use database diagram tools to map, manage, and document their structures. But not all tools are built for modern, fast-moving teams. Here’s a look at the top database diagram tools making a difference in 2025.

The post Best Database Diagram Tools–Free and Paid  appeared first on Devart Blog.

How to Migrate From SQL Server to MySQL

One of the standout features of dbForge Studio is its ability to import data from various sources, including ODBC data. This significantly expands your capabilities, both for direct conversion of data stored on different platforms and for the convenient development of database-related objects such as ETL procedures, reports, and more.

The post How to Migrate From SQL Server to MySQL appeared first on Devart Blog.

Find Invalid Objects in Your Databases

Read on to learn basics about invalid objects and how to identify them in SQL Server, MySQL, and Oracle databases using dbForge Edge or from the command line.

The post Find Invalid Objects in Your Databases appeared first on Devart Blog.

Champs Recap: Devart’s Award-Winning Products in Q1 2024

Last season was quite fruitful in terms of awards scored by our products on independent review platforms. And today, we've got a lot more of those to share. Without further ado, let's get started!

The post Champs Recap: Devart’s Award-Winning Products in Q1 2024 appeared first on Devart Blog.

« Previous | Next »