List all Error and Comment logging processes, that will be removed if we do not have an SQL server The current logging processes include transaction and error logs. These logs are stored in tables within the staging (stg) and Global Org (GL) databases. GL: Stg:
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
🔍 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
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
Role Assignment Role Permissions Bulk Credentials
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
In myBMT Table object Check table has Data Fields objects Mark Data Fields for Controller Snippet Create Data Mart controller Export Data Mart Controller snippet In VS-Code or SSMS Execute Upsert Check Data