DbSchema Blog

Categories

• Cassandra
• Databases
• Dbschema features
• Design
• Firebird
• Migrations
• Mongodb
• Mysql
• Oracle
• Postgresql
• Release notes
• Snowflake
• Sql server
• Sqlite
• Tool comparisons
• Tools
• Tutorials

SQL Server: Return Date Only from GETDATE | DbSchema

Return only the date from SQL Server's GETDATE with CAST or CONVERT, filter and group by date without breaking an index, and see every style code.

Sql server • 05-Sep-2026

SQL Server Common Table Expressions (CTE) in sqlcmd and DbSchema

Learn how to implement SQL Server Common Table Expressions (CTEs) in sqlcmd and DbSchema with practical examples.

Sql server • 05-Sep-2026

How to Enable Remote Connections in SQL Server | DbSchema

Step-by-step guide to enable remote SQL Server connections by configuring TCP/IP, firewall rules, and connection settings.

Design • 05-Sep-2026

SQL WHERE Clause Explained with Operators and Examples | DbSchema

Learn how to use the SQL WHERE clause with comparison, range, pattern, and list operators, plus common mistakes and FAQs.

Tutorials • 04-Sep-2026

MongoDB User Collection: Schema Design Best Practices

Learn how to design an efficient MongoDB user collection. Explore embedding versus referencing, schema validation, and visual data modeling for developers.

Mongodb • 04-Sep-2026

Rolling Back a Database Schema Change

When a database schema change goes wrong, decide quickly if it can be reversed. Learn how PostgreSQL, SQL Server, and MySQL handle DDL rollbacks.

Migrations • 04-Sep-2026

MySQL CREATE DATABASE Guide for Beginners | DbSchema

Learn how to create a MySQL database from the command line, verify it, and manage it visually in DbSchema.

Mysql • 04-Sep-2026

DataGrip Alternatives: Tools for Visual Schema Design

Looking for a DataGrip alternative? Compare top visual database schema design tools, including DbSchema, Oracle Data Modeler, and Aqua Data Studio.

Tools • 04-Sep-2026

The latest order per customer in PostgreSQL with DISTINCT ON | DbSchema

One row per group in PostgreSQL with DISTINCT ON: the ORDER BY it requires, the tie that picks a random row, and when ROW_NUMBER or LEFT JOIN LATERAL is the better tool.

Postgresql • 02-Sep-2026

Catching a table without a primary key before the schema ships | DbSchema

Write the rules your schema must follow, run them against the DbSchema model, and get a list of every table, column, index, or foreign key that breaks one, before anything reaches the database.

Dbschema features • 02-Sep-2026