SQL Server Database Normalization Techniques in sqlcmd and DbSchema
Learn SQL Server database normalization from 1NF to 6NF: what breaks each normal form, the sqlcmd fix, and how to check the result in DbSchema.
DbSchema Blog
Database design, migrations, SQL and everyday database work — explained with practical examples.
Design SQL Server Schemas Visually with DbSchema
Design and organize your SQL Server database visually using diagrams that clearly show tables, relationships, and help you understand the structure.
Schema Versioning for SQL Server
Put SQL Server schema versioning in Git: DbSchema keeps the design model as plain XML and generates the T-SQL migration script between two versions.
SQL Server MERGE to Update, Insert, and Delete Rows | DbSchema
Learn how to use SQL Server MERGE to update, insert, and delete rows by matching source and target tables.
SQL Server Replication Setup Guide with sqlcmd and DbSchema | DbSchema
Learn how to set up SQL Server replication with sqlcmd, understand replication roles and types, and validate replicated data in DbSchema.
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 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.
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.
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.
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.