DbSchema Blog

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

Learn SQL tables with practical examples: what a table is, how to CREATE, ALTER, and DROP tables, and how primary keys and constraints work.

Tutorials • 11-Jul-2023

Learn how to create SQL Server user-defined functions in sqlcmd and DbSchema, including function types, permissions, syntax, and examples.

Sql server • 11-Jul-2023

Learn how to perform SQL Server transactions in sqlcmd and DbSchema using COMMIT, ROLLBACK, and SAVEPOINT.

Sql server • 11-Jul-2023

Cookie preferences