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 …

PowerShell: Save Millions By Downgrading Your SQL Server Edition & Partially Automate It!

This is one of those fresh ideas I wish I had but in reality it did not occur to me until it came down to me for execution from above me. Good job managers! Kudos. Sorry, I did not come-up with this! Execution: "I can do really well and you have got the best". I …

Oracle PL/SQL – Fastest Way To Execute Code Is? To, Not Execute It! – Function Result Caches – Part I

What is the fastest way to execute a PL/SQL function? If you paid attention to the title, your answer would be “to not execute it at all”. In fact, that is the correct answer and Oracle provides the means to do it. The magic is possible because of an Oracle feature called result cache which […]

SQL Server SSMS Templates – Get A Jump Start On Queries/Code

You are a developer or a DBA. You run queries – a lot of them. This blog post shows you how you can simplify reuse of your queries and use already pre-built ones for which you just have to pass in the specific parameter values. Frequently run queries (without SSMS templates): You run some queries …

Merging CSV Files Fast Using DOS COPY Command (or any type of file)

Why not PowerShell? PowerShell might be the new and recommended way to do everything in the Windows command-line (and I am a hard-core PowerShell fan) but this is so easy and handy that it will probably even work in Windows 3.11 (Windows for workgroups)! Besides, I doubt that any current method in PowerShell is as …