Topic Hub

SQL & Data

SQL Server, PostgreSQL, database maintenance, connectivity, migration, and data repair.

Use this hub as a cross-surface map: start with insights for this topic, then branch into supporting tools, drills, and implementation work as needed.

Related Items39

Best First StopInsights

How To Use This Hub

22 Insights14 Toolchest3 Labs

Start Here

Insights

Concepts, decision points, troubleshooting patterns, and operator-facing field notes.

Browse insights

Support Surface

Toolchest

Checklists, scripts, templates, and evidence packs you can use once the path is clear.

Browse toolchest

Support Surface

Labs

Hands-on build guides and validation environments for testing ideas end to end.

Browse labs

Insights

Insights that frame SQL & Data

Insightsread-only

Comparing Robocopy, PowerShell, rsync, and Storage-Native Replication for File Migrations

Use this when you need to choose the right file-migration path instead of defaulting blindly to Robocopy, PowerShell, rsync, or storage replication.

Insightschanges-system-state

Guide to Disable Hypervisor in Windows for Improved VMware Workstation Performance

Use this when VMware Workstation performance or compatibility problems trace back to the active Windows hypervisor stack.

Insightsreview-before-running

Planning Data Migrations and File Moves Without Creating Validation Gaps

Use this Insight to plan file-share and data migrations around scope, tool choice, validation, rollback, and evidence before running the copy path.

Insightschanges-system-state

Troubleshooting Artifactory JCR 7.125.8 Login Stuck on Pending in Ubuntu 22.04 VM

04, focused on service health, JFrog logs, database reachability, reverse proxy behavior, and restart safety.

Insightsreview-before-running

Troubleshooting AWS Amplify GitHub Repository Reconnection After Ownership Transfer

Use this when AWS Amplify cannot reconnect to a GitHub repository after an ownership transfer or redirect change.

Insightssecurity-sensitive

Troubleshooting Azure Blob Upload Failures Due to CSP in ASP.NET WebForms

Use this when browser uploads to Azure Blob Storage fail with CSP Failed to fetch errors. config.

Insightssecurity-sensitive

Troubleshooting Azure OpenAI Realtime API Server Errors During Response Processing

Use this when Azure OpenAI Realtime API calls fail during session creation, streaming, or response processing.

Insightschanges-system-state

Troubleshooting Boot Issues in VMware Workstation Pro 17: Encrypted VM with Corrupted Snapshot Disk

A VMware Workstation Pro 17 recovery checklist for encrypted VMs with suspected snapshot-disk corruption, emphasizing evidence collection, disk-chain safety, repair limits, and backup fallback.

Insightsreview-before-running

Troubleshooting CORS Error: Permission Denied for Requests in Chrome on Office Network

Use this when a browser reports a CORS failure only on a corporate or filtered network.

Insightsreview-before-running

Troubleshooting Dataloader Errors in Ansible Windows with PowerShell

Dataloader errors in Ansible when using PowerShell can often be resolved by validating compatibility, checking permissions, and reviewing script syntax.

Insightschanges-system-state

Troubleshooting File Copy Failures in Windows Task Scheduler

Use this when a Windows Task Scheduler file-copy job fails with access denied, missing paths, or no visible run.

Insightschanges-system-state

Troubleshooting No Endpoints Available Error for DTC Between Domain and Non-Domain SQL Servers

Use this when DTC between domain and non-domain SQL Servers fails with No Endpoints Available.

Insightschanges-system-state

Troubleshooting PostgreSQL Critical Autovacuum Permission Denied Errors and Server Crashes on Windows

PostgreSQL autovacuum permission denied errors on Windows can lead to server crashes. Ensuring proper permissions and configuration settings can resolve these issues.

Insightschanges-system-state

Troubleshooting PowerShell Get-ADUser Published Certificates Import Error

Use this when a PowerShell workflow reading published certificates from Get-ADUser returns import errors or empty values.

Insightssecurity-sensitive

Troubleshooting RustRover Remote Docker Connections over SSH

Use this when RustRover cannot connect to a remote Docker host over SSH.

Insightsreview-before-running

Troubleshooting SQL Server BACPAC Import Error: Foreign Key Constraint Conflict SQL72014 Msg 547

Use this when a SQL Server BACPAC import fails with SQL72014 Msg 547 and a foreign key constraint conflict.

Insightschanges-system-state

Troubleshooting Stuck Snapshots on Large Virtual Machines in VMware

A snapshot recovery checklist for large VMs, focused on storage pressure, snapshot chain health, consolidation, and safe validation.

Insightschanges-system-state

Troubleshooting Terraform Errors with Databricks RFA Access Request Destinations

Use this when Terraform fails on Databricks RFA access-request destinations because provider blocks or schema expectations do not match the target resource.

Insightschanges-system-state

Troubleshooting VSCode SSH Connection Issues to CentOS: Failed to Parse Remote Port from Server Output

Use this when VS Code Remote SSH reports that it failed to parse the remote port from server output.

Insightsreview-before-running

Troubleshooting Windows 11 Restore Recovery Failures

Use this when Windows 11 recovery or restore will not complete. Confirm hardware support and free disk space first, then try built-in repair tools or clean recovery media.

Insightsreview-before-running

Troubleshooting Zscaler ZCC VDI Intune Win32 App Command-Line Limit Failures

Use this when Zscaler Client Connector VDI deployments fail as Intune Win32 apps and the install command may be too long, malformed, or unstable under IME system context.

Insightsread-only

Validating File Migrations Before Cutover and Proving the Target Is Authoritative

Use this when you need a validation model that proves a migrated target is ready before users, apps, or cutover steps depend on it.

Toolchest

Toolchest assets for SQL & Data

ToolchestScriptSecurity and Exposure ChecksRead-only

Authenticated Users drive ACL scanner

PowerShell scanner that checks fixed local drives on Windows servers for root ACL entries where Authenticated Users have broad access. Produces console and CSV evidence so admins can review exposure before any ACL changes.

ToolchestTemplateHybrid Cloud OperationsRead-only

Azure Arc bulk onboarding CSV and logging starter

Reusable starter for Azure Arc onboarding waves using a host CSV, dry-run expectations, per-host logging, and repeatable result tracking suitable for tickets, change records, and post-wave reporting.

ToolchestChecklistHybrid Cloud OperationsRead-only

Azure Arc onboarding preflight checklist

Preflight checklist for onboarding Windows servers to Azure Arc. Confirms supported OS state, outbound connectivity, proxy/TLS behavior, local admin rights, target Azure placement, tagging, pilot scope, and rollback notes before any agent install.

ToolchestTemplateReporting and Evidence PacksRead-only

Azure Update Manager compliance workbook starter

Starter template for an Azure Workbook plus Resource Graph evidence pack that shows patch compliance, pending updates, unsupported coverage, and patch-group drift across Azure and Arc-enabled machines.

ToolchestTemplateHybrid Cloud OperationsRead-only

Azure Update Manager patch wave planning template

Operator-ready planning template for Azure Update Manager patch waves covering scope, maintenance windows, reboot tolerance, exclusions, soak periods, rollback contacts, and stop-go criteria before scheduled patching.

ToolchestTemplateBackup and RecoveryPlanning aid

Backup Restore Drill Evidence Checklist

A restore-drill evidence template for proving backups are usable, measuring recovery time, and turning failed assumptions into repair tasks before an outage.

ToolchestScriptWindows Server HealthRead-only

Disk space cleanup candidate report

A read-only disk pressure report that finds likely cleanup candidates without deleting logs, caches, dumps, or user data.

ToolchestTemplateReporting and Evidence PacksPlanning aid

HTML operations email reporting starter

Reusable template for infrastructure scripts that produce an HTML email report with summary tiles, per-host results, failure sections, runtime metadata, operator notes, and a plain log. Designed to give admins a repeatable evidence format for tickets, maintenance summaries, and validation drills without embedding unsafe credential handling.

ToolchestTemplateFile, Backup, and Storage OperationsChanges system state

Robocopy job template and log parser

A safer Robocopy job template with dry-run review, log capture, exit-code interpretation, and migration evidence.

ToolchestChecklistMigration and CutoverChanges system state

Robocopy migration cutover checklist and evidence pack

Operator checklist and evidence structure for file migration cutovers using Robocopy. Covers pre-copy checks, dry-run evidence, final sync readiness, exclusion review, validation samples, rollback details, and signoff artifacts suitable for tickets and change records.

ToolchestScriptWindows Server HealthRead-only

Scheduled task inventory and failure report

A read-only scheduled task inventory that highlights failed runs, missed runs, disabled tasks, and ownership gaps.

ToolchestRecommended toolFreeware Utilities Worth KeepingRead-only

Sysinternals first-response kit guide

A practical Sysinternals first-response map for process, file handle, startup, network, login, and registry symptoms.

ToolchestScriptWindows Server HealthRead-only

Windows server health snapshot

A read-only Windows Server snapshot for uptime, disk pressure, memory, stopped automatic services, and recent critical events.

ToolchestRecommended toolConnectivity and Network TriageReview before running

Wireshark packet capture triage guide

A packet-capture triage guide for DNS, TLS, DHCP, SMB, RDP, retransmissions, and sensitive-data handling.

Labs

Labs and build work for SQL & Data

LabsSelf-Hosted Services and ProductivityService Portals and MediaIntermediate