SQL Server – Running A Script Or SQL On Multiple Instances/Databases With PowerShell – Level 100

Today, I received a really simple request. There was an UPDATE statement that had to be run on quite a few databases in multiple instances. ¬†This was for a vendor software we use and the statement was sent to me by a Helpdesk professional who manages the product. You need to have the SQLPS (older) … Continue reading SQL Server – Running A Script Or SQL On Multiple Instances/Databases With PowerShell – Level 100

PowerShell – Copy SQL Server Tables – Structure, Data & Indexes To Another Database/Instance

  UPDATE Mar 25, 2021: I have created an updated version of the script with enhancements and sample usage that is available at my GitHub: https://github.com/SQLJana/PowerShell/blob/c6cbe1d5b4f97026d1b00df59403dcd1ed367065/Copy-SQLTable.ps1 Requirement: Recently I got a request from a user that he wanted to copy a specific set of tables and their indexes into a new database to ship to … Continue reading PowerShell – Copy SQL Server Tables – Structure, Data & Indexes To Another Database/Instance