SQL Server User-Defined Functions (UDF) Guide with Examples | DbSchema
Learn how to create SQL Server user-defined functions in sqlcmd and DbSchema, including function types, permissions, syntax, and examples.
Sql server
Every post tagged sql server on the DbSchema blog.
SQL Server Distributed Transactions Guide with sqlcmd and DbSchema | DbSchema
Learn how SQL Server distributed transactions work, including permissions, transaction types, and practical execution in sqlcmd and DbSchema.
SQL Server Spatial Data Types Guide in sqlcmd and DbSchema
Learn how to use SQL Server spatial data types (geometry and geography) with examples in sqlcmd and DbSchema.
SQL Server Design Tool for 2025: Visual Schema Diagrams, Documentation, and Sync | DbSchema
Need a SQL Server design tool for 2025? Compare features, model schemas visually, document changes, and sync safely with DbSchema.
SQL Server CREATE TRIGGER: AFTER, INSTEAD OF, Audit, and DDL Examples | DbSchema
Learn SQL Server CREATE TRIGGER with AFTER, INSTEAD OF, audit logging, inserted/deleted tables, and DDL examples. Build and review triggers in DbSchema.
SQL Server CREATE INDEX Guide with Types and Examples | DbSchema
Learn how to create indexes in SQL Server using sqlcmd and DbSchema, with index types, permissions, examples, and verification steps.
SQL Server Concurrency and Deadlocks Guide in sqlcmd and DbSchema
Learn how to manage SQL Server concurrency, locks, blocking, and deadlocks in sqlcmd and DbSchema.
How to Document SQL Server Schemas Visually
Visualize and document your SQL Server schema with ER diagrams, clickable HTML docs, and change tracking. Perfect for teams, audits, and onboarding.
SQL Server Transactions Guide with COMMIT, ROLLBACK, and SAVEPOINT | DbSchema
Learn how to perform SQL Server transactions in sqlcmd and DbSchema using COMMIT, ROLLBACK, and SAVEPOINT.
SQL Server CREATE VIEW Guide with Examples in sqlcmd and DbSchema | DbSchema
Learn how to create SQL Server views in sqlcmd and DbSchema, including syntax, permissions, examples, and practical usage tips.
SQL Server CREATE DATABASE Guide with sqlcmd and DbSchema | DbSchema
Learn how to create a SQL Server database using sqlcmd and DbSchema, with prerequisites, practical steps, and verification queries.
SQL Server Failover Clustering Setup Guide in sqlcmd and DbSchema
Learn how to set up SQL Server failover clustering and connect from DbSchema for high-availability environments.
SQL Server Database Sharding: Strategies, Shard Keys, and Architecture | DbSchema
Learn SQL Server database sharding with shard keys, routing, cross-shard design, and trade-offs. Plan scalable SQL Server architectures in DbSchema.
SQL Server CREATE TABLE: Syntax, Constraints, Temp Tables, and Examples | DbSchema
Learn SQL Server CREATE TABLE syntax, data types, constraints, temp tables, and SELECT INTO patterns. Design and deploy tables faster with DbSchema.
SQL Server MERGE Statement: UPSERT Patterns, WHEN MATCHED, and Safer Alternatives | DbSchema
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 Table Partitioning: Partition Functions, Schemes, RANGE LEFT/RIGHT, and Best Practices | DbSchema
Learn SQL Server table partitioning with partition functions, schemes, RANGE LEFT/RIGHT examples, list/hash alternatives, and DbSchema design tips.
SQL Server Insert Multiple Rows in a Single Query | DbSchema
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.
SQL Server Data Compression: ROW vs PAGE vs COLUMNSTORE | DbSchema
Compare SQL Server ROW, PAGE, and COLUMNSTORE compression, estimate savings, and pick the right option for OLTP or analytics in DbSchema.
Deploying SQL Server Schema Changes Safely
Deploy SQL Server schema changes safely. Learn how to manage Sch-M locks, set XACT_ABORT, and generate migration scripts without blocking your application.
SQL Server Window Functions Guide with Examples | DbSchema
Learn SQL Server window functions with practical examples in sqlcmd and DbSchema, including ranking, aggregates, value functions, and common limitations.
SQL Server Schema Comparison Tools
Compare SQL Server schema comparison tools: DbSchema, Redgate SQL Compare, dbForge and xSQL, with the price each vendor lists today and what each compares.
SQL Server Stored Procedure Tutorial with sqlcmd and DbSchema | DbSchema
Learn how to create stored procedures in SQL Server using sqlcmd and DbSchema, including syntax, permissions, examples, and best practices.
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.
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 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.