How to Examine Umbraco Property Values for a Given Data Type
A practical, read-only T-SQL technique for finding published content that uses a specific data type in Umbraco 13
Umbraco
SQL Server
SQL Server
Practical database engineering covering query behavior, indexing, data design, migrations, and performance behind demanding web applications.
Debugging Slow Publishing in Umbraco 13 at 325K Nodes
After upgrading a production-scale Umbraco installation from 11.5.0 to 13.4.1, publishing and unpublishing became extremely slow and database lock errors...
Umbraco
SQL Server
Reset Identity Values in SQL Server with DBCC CHECKIDENT
How to inspect and reseed an IDENTITY column correctly, including the important difference between DELETE and TRUNCATE TABLE.
SQL Server
How to Count Rows in All SQL Server Tables
Use partition metadata for a fast database overview, or run exact counts when the precise number of rows is required.
SQL Server
Search for Text Across All SQL Server Tables
A practical read-only script for locating an unknown text value across character columns without hard-coding the database structure.
SQL Server
SQL Server Index Maintenance: Rebuild or Reorganize
A practical guide to finding rowstore index maintenance candidates, understanding what rebuild and reorganize actually change, and running maintenance...
SQL Server
Delete Millions of Rows in SQL Server Safely in Batches
Large DELETE operations can generate substantial transaction-log activity, increase blocking, and make rollback expensive. This guide shows a...
SQL Server
Architecture
How to Permanently Delete an Umbraco 8 User
Umbraco 8 normally lets administrators disable backoffice users rather than permanently remove them. When a real hard delete is required, deleting a row from...
Umbraco
SQL Server