I came across another opportunity for using Powershell when setting up mirroring for a large database at our DR site. The database was over 73Gig. The problem arose when it took a very long time to copy the backup and transaction logs and run the database restore. By the time the copy had finished another …
Continue reading ‘Restore All SQL Transaction Logs using Powershell’ »
Don’t you just hate it when you open one of your server logs in Management Studio and then you have to wait forever to review it because it never stops reading? I’ve done it enough times and decided to put an end to it or at least greatly reduce the incidence. Using Powershell and a …
Continue reading ‘Cycle Those SQL Server Logs’ »
As a databases admin with a few dozen servers and a few hundred SQL Server database, I need to effectively build automated jobs to perform various administrative tasks such as backing up databases. I’m still new to PowerShell but I am beginning to see how immensely helpful it is to me and my work. I …
Continue reading ‘PowerShell Where Clause – Compare to a list of values’ »
This is a wonderful article which not only details the use of Compare-Object but also provides some very excellent examples on its use. Tips & Tricks Using Compare-Object – Dreaming in PowerShell – PowerShell.com I am very new to PowerShell but I am beginning to like using it considerably more each day. I recently had …
Continue reading ‘Tips & Tricks Using Compare-Object – Copy New Files’ »
I write very small console apps which run on different servers, some of which cannot yet be upgraded from .NET 1.1 to 2.0. Why Visual Studio targets only one version of the .NET Framework