Topic
SQL ServerIntermediateHow to measure SQL Server query performance with Query Store, DMVs and Extended Events, pick targets by total resource use, and check the settings that affect every query.
#configuration#db-administration#execution-plans
SQL ServerIntermediateQuery sys.dm_db_missing_index_details and its companion DMVs, read the numbers critically, find the queries behind each suggestion and merge them into the few indexes worth creating.
#db-administration#execution-plans#indexing
SQL ServerAdvancedA table-by-table workflow for tuning existing SQL Server indexes: find unused and overlapping indexes, merge them, and replace blanket rebuilds with statistics updates.
#db-administration#indexing#maintenance
PostgreSQLBeginnerA founder's guide to choosing PostgreSQL or MySQL: team experience, managed hosting, scaling paths, extensions, licensing, switching cost, and a clear "pick PostgreSQL unless" rule.
#db-administration#scalability#schema-design
GeneralBeginnerSee what a DBMS does internally, from query processor to storage engine and transaction log, compare the main types of DBMS, and learn how to choose one.
#db-administration
