PowerShell: Find & Replace SQL Server Stored Procedure/View/UDF/Trigger Code En Masse Based On Custom Criteria

Update April 19, 2019: Thanks to Tim (in comments), the updated script can also do find/replace in not just stored procedures but also views, UDF's and triggers. Today, a need came-up where a bunch of stored procedures had to be altered based on certain criteria. Easy way: Obviously, the easiest way would be to script …

Oracle – Fastest Way To Execute SQL Is? To, Not Execute It! – Query Result Cache – Part II

Before you read on, please check out my related post on "Function Result Cache". You may find it valuable in this context. Conversation sounds familiar? I am sure you have been privy to a conversation like this between an IT manager and a DBA: Manager:  My query is extremely slow. Can you make the query …

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 …

Oracle PL/SQL – Quantify Code Performance For Comparison Of Different Approaches – Tom Kyte’s “runstats”

Is my PL/SQL code going to perform better? I have rewritten my Oracle code. Now, how do I tell if my coding approach A is better than coding approach B? If someone were to ask you the above question, typically, you would give the following answers If one approach is faster than the other, that …

Oracle PL/SQL – Replace GOTO’s with LOOP’s

GOTO's should not be part of any modern programming language (IMHO). They are bad for so many reasons and should be avoided at all costs. I guess they were carried over from the Assembly and later the Basic language days. Good code (procedure/function/block) should have a single entry point and a single exit point to make it …