Use Contained Database Users in SQL Server
Create database-scoped users that reduce login-mapping work when databases move between compatible instances.
Category: SQL
Restore a SQL Server Backup to Another Server
Inspect logical file names, restore with new paths, and complete post-restore security and integrity checks.
Move SQL Server Agent Jobs to Another Server
Script SQL Server Agent jobs and verify owners, proxies, schedules, and dependencies on the destination.
Transfer SQL Server Logins while Preserving SIDs
Move SQL logins with their SIDs so restored database users remain mapped on the destination server.
Find and Fix Orphaned Users in SQL Server
Identify database users whose login SID no longer matches and remap them safely after a restore or migration.
Get the Size of Every MySQL Database and Table
Last updated: August 29, 2026. MySQL reports table data and index allocation through INFORMATION_SCHEMA.TABLES. The following queries convert the byte…
Fix SQL Server ‘Insufficient Access Rights’ During Backup
Last updated: August 26, 2026. A SQL Server backup can fail because the login lacks database backup permission or because…
Transfer SQL Server Logins and Passwords Between Instances
Last updated: August 29, 2026. Database users and server logins are separate SQL Server objects. When a database moves to…
SQL Data Types
Last updated: August 26, 2026. A column’s data type defines the values it can store and the operations a database…
SQL Aggregate Functions: COUNT, SUM, AVG, MIN, and MAX
Last updated: August 27, 2026. Aggregate functions calculate one result from multiple rows. The most common are COUNT, SUM, AVG,…