The default SharePoint search topology gets you up and running quickly. For production farms, deliberate design choices around component placement, high availability, and crawl isolation are what turn a functional search deployment into a resilient one. This post explains all six search components, when to use a single SSA vs. dual SSA, and how to design the right topology before running a single script.
Author: Sudharsan K...
10 Lessons Learned from Migrating SharePoint 2019 to Subscription Edition
A production SharePoint 2019 to Subscription Edition migration reveals things no documentation warns you about — unknown databases, 312 undocumented workflows, and a firewall approval that took 11 days. These are the 10 lessons that shaped every script in this series.
Post-Migration Validation: Reports, Health Cards, and Compliance Checks for SharePoint Subscription Edition
The migration window is closed, but the project isn't. This post gives you the eight PowerShell scripts and three-level framework to validate every database, compliance setting, and stakeholder deliverable — and formally close the migration.
How to Set Up Search Architecture in SharePoint Subscription Edition After Migration
Search doesn't come with you after a SharePoint migration — the index cannot be moved, and everything must be re-crawled from scratch. This post walks through configuring the right SPSE search topology for your farm size, throttling the first crawl to protect farm performance, and remapping content sources using production-ready PowerShell scripts. All scripts are available in the Search Setup Bundle — a seven-script PowerShell toolkit for $49 on Gumroad, purpose-built for this exact migration moment.
Adding SharePoint Content Databases to a SQL Server Availability Group: The Correct Seeding Sequence
SQL Server Availability Groups are the only Microsoft-supported high-availability path for SharePoint Subscription Edition — and the seeding sequence is unforgiving. This post walks SQL DBAs and SharePoint architects through every prerequisite, the complete backup → NORECOVERY restore → AG join workflow, sync mode selection, and the two PowerShell scripts that automate the entire operation across 50+ content databases without a single manual T-SQL command.
The SharePoint Migration Cutover Playbook: Step by Step
A complete, minute-by-minute SharePoint 2019 → Subscription Edition cutover playbook. Covers the timed execution timeline from T-60 to T+60, all five PowerShell scripts with code and commentary, a GO/NO-GO decision table, and a step-by-step rollback sequence — everything your team needs to run the maintenance window without improvising.
Cut Your SharePoint Database Migration Window from 25 Hours to 4 Hours with Parallel Backup and Restore
Running 50 SharePoint content databases through a sequential backup-and-restore cycle takes roughly 25 hours — a migration window that doesn't fit any realistic production weekend. This post covers four PowerShell scripts that implement a throttled parallel execution pattern, compressing that window to under 4 hours without saturating your SQL Server or storage infrastructure. Includes the full orchestrator, a log shipping seeding variant, and a six-point performance tuning checklist for production environments.
SQL Log Shipping for SharePoint 2019 to Subscription Edition Migration: Step-by-Step Setup Guide
SQL Server log shipping is the database-layer engine that makes zero-downtime SharePoint migration possible — keeping your secondary SQL instance continuously synchronized while you prepare, so final cutover shrinks from hours to minutes. This post covers the full lifecycle: configuring log shipping across all SharePoint content databases using a CSV-driven PowerShell script, monitoring restore latency, simulating and repairing a log chain break, and cleanly disabling jobs at cutover. Production-ready scripts for 50+ databases are available in the SQL Migration Bundle.
Testing Port Connectivity and Firewall Rules for SharePoint Subscription Edition
SharePoint migrations fail at the firewall — not because admins skip the checklist, but because no one ran an actual test from the right source server to the right destination on the right port. This post provides a config-driven, role-aware PowerShell toolkit that tests every required port across your SPSE farm, remediates blocked paths automatically, and produces an HTML report your infrastructure and security teams can sign off before the cutover window opens.#sharepoint #microsoft #sp2019 #spse #migration
How to Audit SharePoint Workflows Before Migration (SP 2013 & Nintex)
SP 2013 workflows break silently after migration. Learn how to run a farm-wide audit with PowerShell — classify every workflow by platform and build your remediation plan before cutover day. #sharepoint #microsoft #sp2019 #spse