PowerShell & SQL Server: Run In Parallel – Collect SQL Results With PRINT Output From Across Your SQL Farm – Fast!

If you have been working with PowerShell and SQL Server for a while now, you know that it is not difficult to capture the PRINT statement output as VERBOSE output (which can then be redirected to a variable or file). You also know that it is not too difficult to run SQL in parallel against … Continue reading PowerShell & SQL Server: Run In Parallel – Collect SQL Results With PRINT Output From Across Your SQL Farm – Fast!

Advertisements

PowerShell: Backup All SSAS Databases To A Network Share

I am working on downgrading SQL Server Enterprise Edition (EE) s/w to Standard Edition (SE) where EE features are not used (to save money on licensing). We have a big list of these to go through. That required all SSAS databases to be backed-up to the network and restored after the edition downgrade. I will … Continue reading PowerShell: Backup All SSAS Databases To A Network Share

Oracle – Enumerate tnsnames.ora Entries Without Parsing

Parsing tnsnames.ora using PowerShell I published a post on how to enumerate tnsnames.ora entries using PowerShell. Although it may work, that is not the correct way to do this. This is a re-post of my┬átip on CodeProject. This should be easy enough to convert to PowerShell. However, if your tnsnames.ora is not the one that … Continue reading Oracle – Enumerate tnsnames.ora Entries Without Parsing