There are a bunch of tools in the market to do the database comparisons for differences but if you want to do it for free (and programmatically) at a basic level, you could use the method outlined below. For me, this came about as a result of an user asking "So, what is different between … Continue reading SQL Server: Compare Database Tables/Indexes/Views/SP’s etc. For Differences Across Instances
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!
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
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