Every post tagged sql server on the DbSchema blog.
Create a stored procedure in SQL Server: the CREATE PROCEDURE syntax, parameters with defaults, OUTPUT parameters and return codes, ALTER and DROP, run from sqlcmd and from DbSchema.
Learn how to create SQL Server user-defined functions in sqlcmd and DbSchema, including function types, permissions, syntax, and examples.
Learn how SQL Server distributed transactions work, including permissions, transaction types, and practical execution in sqlcmd and DbSchema.
Learn how to use SQL Server spatial data types (geometry and geography) with examples in sqlcmd and DbSchema.
Need a SQL Server design tool for 2025? Compare features, model schemas visually, document changes, and sync safely with DbSchema.
Learn SQL Server CREATE TRIGGER with AFTER, INSTEAD OF, audit logging, inserted/deleted tables, and DDL examples. Build and review triggers in DbSchema.
Learn how to create indexes in SQL Server using sqlcmd and DbSchema, with index types, permissions, examples, and verification steps.
Learn how to manage SQL Server concurrency, locks, blocking, and deadlocks in sqlcmd and DbSchema.
Visualize and document your SQL Server schema with ER diagrams, clickable HTML docs, and change tracking. Perfect for teams, audits, and onboarding.
Learn how to perform SQL Server transactions in sqlcmd and DbSchema using COMMIT, ROLLBACK, and SAVEPOINT.
Learn how to create SQL Server views in sqlcmd and DbSchema, including syntax, permissions, examples, and practical usage tips.
Learn how to create a SQL Server database using sqlcmd and DbSchema, with prerequisites, practical steps, and verification queries.
Learn how to set up SQL Server failover clustering and connect from DbSchema for high-availability environments.
Learn SQL Server database sharding with shard keys, routing, cross-shard design, and trade-offs. Plan scalable SQL Server architectures in DbSchema.
Learn SQL Server CREATE TABLE syntax, data types, constraints, temp tables, and SELECT INTO patterns. Design and deploy tables faster with DbSchema.
Learn SQL Server MERGE for UPSERT and sync jobs, compare WHEN MATCHED options, OUTPUT logging, and safer alternatives. Test the logic in DbSchema.
Learn SQL Server table partitioning with partition functions, schemes, RANGE LEFT/RIGHT examples, list/hash alternatives, and DbSchema design tips.
Insert multiple rows in one SQL Server statement: the multi-row VALUES syntax, the documented 1,000-row limit and error 10738, and INSERT ... SELECT.
Compare SQL Server ROW, PAGE, and COLUMNSTORE compression, estimate savings, and pick the right option for OLTP or analytics in DbSchema.
Deploy SQL Server schema changes safely. Learn how to manage Sch-M locks, set XACT_ABORT, and generate migration scripts without blocking your application.
Learn SQL Server window functions with practical examples in sqlcmd and DbSchema, including ranking, aggregates, value functions, and common limitations.
Compare SQL Server schema comparison tools: DbSchema, Redgate SQL Compare, dbForge and xSQL, with the price each vendor lists today and what each compares.
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.
Design and organize your SQL Server database visually using diagrams that clearly show tables, relationships, and help you understand the structure.
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.
Learn how to set up SQL Server replication with sqlcmd, understand replication roles and types, and validate replicated data in 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.
Learn how to implement SQL Server Common Table Expressions (CTEs) in sqlcmd and DbSchema with practical examples.
