Skip to content

WebCheatSheet

The easy way to know

  • PHP
  • HTML
  • JavaScript
  • SQL
  • ASP
  • MS Access Functions
  • SaaS
  • Email

Category: SQL

SQL

Use Contained Database Users in SQL Server

adminAugust 28, 2026August 29, 2026

Create database-scoped users that reduce login-mapping work when databases move between compatible instances.

SQL

Restore a SQL Server Backup to Another Server

adminAugust 28, 2026August 29, 2026

Inspect logical file names, restore with new paths, and complete post-restore security and integrity checks.

SQL

Move SQL Server Agent Jobs to Another Server

adminAugust 28, 2026August 29, 2026

Script SQL Server Agent jobs and verify owners, proxies, schedules, and dependencies on the destination.

SQL

Transfer SQL Server Logins while Preserving SIDs

adminAugust 28, 2026August 29, 2026

Move SQL logins with their SIDs so restored database users remain mapped on the destination server.

SQL

Find and Fix Orphaned Users in SQL Server

adminAugust 28, 2026August 29, 2026

Identify database users whose login SID no longer matches and remap them safely after a restore or migration.

SQL

Get the Size of Every MySQL Database and Table

adminOctober 16, 2023August 29, 2026

Last updated: August 29, 2026. MySQL reports table data and index allocation through INFORMATION_SCHEMA.TABLES. The following queries convert the byte…

SQL

Fix SQL Server ‘Insufficient Access Rights’ During Backup

adminJuly 28, 2023August 26, 2026

Last updated: August 26, 2026. A SQL Server backup can fail because the login lacks database backup permission or because…

SQL

Transfer SQL Server Logins and Passwords Between Instances

adminJuly 28, 2023August 29, 2026

Last updated: August 29, 2026. Database users and server logins are separate SQL Server objects. When a database moves to…

SQL

SQL Data Types

adminJune 21, 2023September 8, 2026

Last updated: August 26, 2026. A column’s data type defines the values it can store and the operations a database…

SQL

SQL Aggregate Functions: COUNT, SUM, AVG, MIN, and MAX

adminMay 12, 2023September 8, 2026

Last updated: August 27, 2026. Aggregate functions calculate one result from multiple rows. The most common are COUNT, SUM, AVG,…

Posts navigation

Older posts
Newer posts

Recent Posts

  • Handle PHP 8.5 SNMP ValueError Separately from Network Failure
  • Explain Why PolarDB Storage Exceeds MySQL Table Size
  • Fix Gutenberg Blob Worker and iframe CSP Errors in Nginx
  • Install SQLSRV for PHP 8.1 with a Compatible Driver Version
  • Remove UNSIGNED When Changing a MySQL Integer Column to VARCHAR

Recent Comments

  1. Explain Why PolarDB Storage Exceeds MySQL Table Size - WebCheatSheet on Get the Size of Every MySQL Database and Table
  2. Install SQLSRV for PHP 8.1 with a Compatible Driver Version - WebCheatSheet on Install and Configure PHP on Windows
  3. Build Accessible Tabs with JavaScript - WebCheatSheet on JavaScript Functions
  4. Remove SQL Server STX Characters before FOR XML – WebCheatSheet on Export a MySQL Database Schema as XML with PHP
  5. Parse Untrusted XML Safely with PHP XMLReader – WebCheatSheet on Export a MySQL Database Schema as XML with PHP

Archives

  • November 2026
  • October 2026
  • September 2026
  • August 2026
  • October 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022

Categories

  • ASP
  • Email
  • HTML
  • JavaScript
  • MS Access Functions
  • PHP
  • SaaS Architecture
  • SQL
  • Uncategorized
Copyright © 2026 WebCheatSheetFresh News by Ascendoor | Powered by WordPress.