Tag: T-sql

Revisited: Sitecore path in SQL Query

A little over 2 years ago, when we all thought the pandemic might just be a 2-3 month ordeal, I wrote the first article of this blog about how to get Sitecore item paths when directly querying the (master) database. A lot has happened since then, let’s talk about it.

tags: Sitecore - T-sql - Back-end

---

UnitTesting T-SQL stored procs made easy

A while back I was tasked with making a complicated stored procedure that would run somewhere between two applications that were themselves in active development and not stable or live yet. It wasn’t feasible to have a human tester test just the stored procedure. In stead, it would be very nice to be able to UnitTest my T-SQL code, but how?

tags: T-sql

---

Sitecore path in SQL Query

When trouble-shooting Sitecore issues, sometimes you wanna dive directly into the SQL Database and query around in dbo.Items. But you might want to query an item’s Sitecore-path, like in the where clause. This recursive common table expression makes that very easy:

tags: Sitecore - T-sql - Back-end

---