Setting SQL Server Start-up Parameters across Multiple Instances
Hello Geeks, This is the first blog of the part of blogs set I am going to write for next few months. I have been working on a centralized approach for …
Read MoreTag: PowerShell
SQL Server Database Migration : DB-Migrate V 5.0 : PowerShell Module to Migrate Databases
SQL Server Database Migration between sql instances is a time taking and a tedious task which becomes even more complicated when one has more than 10-12 databases to migrate. This PowerShell module …
Read MoreSQL Server Database Migration : DB-Migrate V 4.0 : PowerShell Module to Migrate Databases
This is an update on DB-Migrate Module. The change log is mentioned below. Changes in SQL Server Database Migration PowerShell Module on 27th Dec 2012 Version Check. Move-Database function now checks for Source …
Read MoreSQL Server Database Migration : DB-Migrate V 3.0 : PowerShell Module to Migrate Databases
This is an update on SQL Server Database Migration PowerShell Module. The change log is mentioned below. Changes in DB-Migrate V3 on 25th Dec 2012 Reviewed by Aman Dhally – Powershell MVP. …
Read MoreSQL Server Copy table data from higher to lower SQL version using PowerShell
I came across a scenario where in I had to move database from SQL Server 2008R2 to SQL Server 2005. As most of you must be aware that Detach/Attach and Backup/Restore …
Read MoreSQL Server – Monitor SQL Server Services using Powershell
Last month on 26th June I delivered a webcastHow to Monitor SQL Servers using Powershell – Part 1 under Microsoft Lunch Time Banner. For those who don’t know about Lunch Time Series …
Read MoreSQL Server Parse DBCC MemoryStatus using Powershell
A few days back I was resolving a memory issue which caused sql server to stop responding. I was able to figure out the issue by looking into SQL Server Parse …
Read MoreSQL Server Using Powershell to Move databases between Instances
It’s sometime needed to move database between instances as in when migrating to a different instance. Let’s see how this can be achieved with powershell. This script assumes that both the …
Read MoreSQL Server Using Powershell to Move Logins between Instances
Moving logins between instances is one of the critical migration activities. Let’s see how it can be done in powershell with the help of SMO.When transferring logins, two things need to …
Read MoreSQL Server Using Powershell to Move Indexes to New File group
Recently I was involved in a project where in non-clustered indexes were to be moved to a different file group for the sake of performance benefit. It has to be done …
Read More