What are ports needed to configure log shipping? A client in a locked-down network asked me, and here is the list of ports to open on the firewall.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Be Careful with Logon Triggers – Don’t use Host_Name
A reader used HOST_NAME() in a logon trigger to limit access. Here is why that is risky, and why Logon Triggers can lock everyone out if you are not careful.
SQL SERVER – Error: 1067 – Unable to Bring Analysis Service Online in Cluster
A client could not bring the Analysis Service online in a cluster, and the logs only said Error 1067. Here is the systematic approach that found the cause.
Faster Backups With BUFFERCOUNT and MAXTRANSFERSIZE, Measured
Measure faster backups by changing BUFFERCOUNT, MAXTRANSFERSIZE, and backup stripes one at a time while tracking speed and memory.
Disk Space Needed to Build a Clustered Index on a Big Table
A clustered index build holds the old table and the new index at the same time. Here is a small demo of that peak, and what to check first.
Migrate SQL Server Cluster Storage to New Disks
To migrate cluster storage for a SQL Server failover cluster, add the new disks to the SQL Server role, take the instance offline, copy the files with their permissions, give the new disks the old drive letters and bring the instance back. This post lists every step, the checks to run first, the quorum and MSDTC disks, and the T-SQL alternative that changes file paths.
Error 5511: FILESTREAM File System Log Record Is Corrupted
Error 5511 kept a production database offline after a SQL Server restart, because a FILESTREAM log record under the log folder was corrupted. We moved the corrupted file to another folder and the database came online. CHECKDB came out clean and the client saw no problems for weeks.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.