SQL Server Education (by the geeks, for the geeks)
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 …
Setting SQL Server Start-up Parameters across Multiple Instances Read MoreSQL 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 …
SQL Server Database Migration : DB-Migrate V 5.0 : PowerShell Module to Migrate Databases Read MoreThis 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 …
SQL Server Database Migration : DB-Migrate V 4.0 : PowerShell Module to Migrate Databases Read MoreThis 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. …
SQL Server Database Migration : DB-Migrate V 3.0 : PowerShell Module to Migrate Databases Read MoreI 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 …
SQL Server Copy table data from higher to lower SQL version using PowerShell Read MoreLast 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 …
SQL Server – Monitor SQL Server Services using Powershell Read MoreA 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 …
SQL Server Parse DBCC MemoryStatus using Powershell Read MoreIt’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 …
SQL Server Using Powershell to Move databases between Instances Read MoreMoving 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 …
SQL Server Using Powershell to Move Logins between Instances Read MoreRecently 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 …
SQL Server Using Powershell to Move Indexes to New File group Read More