SQL

Extended REST Semantics — In Simple Terms

by

Verb Meaning (Simple) Behaviour SQL/Data Analogy Use Case GET “Tell me about this.” Retrieves a resource or field SELECT * FROM table WHERE id = x Viewing a project status or employee detail POST “Here’s a new thing.” Creates a new resource INSERT INTO table … New project added, first metadata entry PUT “Replace the … Read more

How to Find the SQL Definition of a View in Oracle

by

🔍 When working with Oracle databases, it’s often helpful to retrieve the SQL definition of a view — especially when reverse engineering or documenting logic for reporting and data pipelines. ✅ View Definitions via USER_VIEWS If you own the view or have access to it within your schema, you can use the following query: 💡 … Read more

SSMS with SQLCMD Mode

by

Using SSMS with a master script is a reliable approach, especially with multiple scripts. By running in SQLCMD mode within SSMS, you can use a single master script to execute multiple scripts in sequence without manual intervention. Step-by-Step Guide for SSMS with SQLCMD Mode Notes and Tips Additional Notes

sp_who2

by

One of the first lines of defense in determining the causes of database slowdowns is to use sp_who2. sp_who2 shows all the sessions that are currently established in the database. These are denoted as SPID‘s, or Server process Id’s. Running sp_who2 is easy, all that is required is to type sp_who2 and execute it, however it’s … Read more