DbSchema Blog

Learn the SQL SELECT statement with syntax, WHERE, DISTINCT, JOINs, GROUP BY, ORDER BY, subqueries, and FAQs. Build queries visually in DbSchema.

Tutorials • 19-Jul-2023

Learn how to use SQL Server spatial data types (geometry and geography) with examples in sqlcmd and DbSchema.

Sql server • 16-Jul-2023

Learn SQL Server MERGE for UPSERT and sync jobs, compare WHEN MATCHED options, OUTPUT logging, and safer alternatives. Test the logic in DbSchema.

Sql server • 16-Jul-2023

Learn how SQL Server distributed transactions work, including permissions, transaction types, and practical execution in sqlcmd and DbSchema.

Sql server • 15-Jul-2023

Learn how to set up SQL Server replication with sqlcmd, understand replication roles and types, and validate replicated data in DbSchema.

Sql server • 15-Jul-2023

Learn SQL Server database sharding with shard keys, routing, cross-shard design, and trade-offs. Plan scalable SQL Server architectures in DbSchema.

Sql server • 14-Jul-2023

Learn how to manage SQL Server concurrency, locks, blocking, and deadlocks in sqlcmd and DbSchema.

Sql server • 14-Jul-2023

Compare SQL Server ROW, PAGE, and COLUMNSTORE compression, estimate savings, and pick the right option for OLTP or analytics in DbSchema.

Sql server • 13-Jul-2023

Learn how to apply SQL Server database normalization techniques from 1NF to 5NF using sqlcmd and DbSchema.

Sql server • 13-Jul-2023

Learn how to set up SQL Server failover clustering and connect from DbSchema for high-availability environments.

Sql server • 12-Jul-2023

Cookie preferences