Safely Dropping a Set of Views by Pattern (T‑SQL)
Bulk‑generate and (optionally) execute DROP VIEW statements for a subset of views in a given schema When to use this Safety checklist
Snippet
How to Move a File in Azure DevOps Git Repository While Preserving History
When working with Git repositories in Azure DevOps, you might need to move a file from one folder to another without losing its history. The best way to do this is by using the git mv command. This ensures Git recognizes the move as a rename and keeps the file’s commit history intact. Why Not … Read more
Gen2 Dataflow Pattern
SharePoint list → cleaned, flat, ISO-dated table A reusable Power Query (M) snippet for Dataflows Gen2 that: When to use: Landing SharePoint list data into a Bronze/Silver layer (Fabric/Synapse/SQL) where flat, predictable schemas, text-formatted dates, and stable column names are preferred. Full code (drop-in) Step-by-step Customisation points Validation checklist Troubleshooting Notes
🧩 Function: UrlEncode
Category: Utility Functions → String & EncodingAuthor: Data EngineeringLanguage: Power Query (M)Purpose: Converts a text string into a URL-safe format by encoding non-alphanumeric characters as percent-encoded hexadecimal values (%XX).Compatibility: Power BI, Excel Power Query, and Fabric Dataflows (Gen2) 📝 Description UrlEncode transforms text into a format suitable for inclusion in URLs or API query strings.All … Read more
List all Error and Comment logging processes, that will be removed if we do not have an SQL server
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:
Parse CODESSTRING in Power BI Using Power Query (M)
📘 Context The CODESSTRING field returned from Oracle contains serialised key-value pairs using non-printing ASCII characters: Example value: ✅ Goal Convert this encoded string into structured columns in Power BI, e.g.: ACCOUNT CODE_B CODE_C CODE_D CODE_E 10201 200 2011072 🛠️ Solution: Power Query Function Step 1: Create the Parsing Function Step 2: Apply the Function … Read more
Steps to implement FTE Logic in Power BI
✅ What You’ll Need 🛠️ Step-by-Step Power Query Approach Step 1: Load both tables into Power Query Step 2: Create a Cross Join (Employee × Month) Step 3: Add FTE Logic (Human Version in M) Now, for each row (i.e. employee × month), add a custom column to calculate the monthly FTE: 🧾 Final Step: … Read more
Monthly FTE Logic
Each month, we assess whether and how much an employee is active in their role, based on their employment dates, status, and working pattern. The output is a monthly FTE value that represents their contribution in that month. Here’s how it’s determined: 1️⃣ If the person is seconded or transferred out We calculate how much … Read more
Extended REST Semantics — In Simple Terms
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