Golang and Databases - Part 3DetailsThis is a continuation from part2.I will cover applying some clean architecture to my prior postThis is not the final solution but a journey towards it and I will…
Golang and Databases - Part 2DetailsThis is a continuation from part1.I will cover converting the previous code into a simple http endpoint that executes and returns the output.This is not the final…
Golang and Databases - Part 1When I moved into the world of cloud, open source, big data etc. I quickly learned that a data engineer needs to be someone who can do just more than write advanced SQL…
Using merge to capture bulk insert identities in SQL ServerOn one occasion I encountered an interesting piece of code.There was a user table and the only unique identifier was the identity field…
Cypher Coalesce NodesSorry that i have been so late in writing this one. I've been working on doing a Kafka/Neo blog, and intend to bring something out soon. In the meantime, I'll share this little…
Loading auto generated daily partition in SQL ServerI have worked on the number of batch systems that have required partitioning for various reasons. I won't go into all of the reasons of why and…
Breadcrumb in SQl and GraphIn the past I have been involved in multiple projects that display a hierarchy of some sort. Whether that be an accounting book structure or a people reporting hierarchy…
SSIS - Oracle Destination via ODP.Net (Custom Destination Component)SSIS 2008 R2 Solution.I have created this custom destination component to allow ssis to write directly to an oracle table via the…
Many to Many (RDBMS to Graph)One of the systems that I am currently working on is a migration from an Oracle DB to Graph. The ER diagram is similar to what can be seen in the original database. An…
Coalesce vs IsNull (SQL Server)So, this is a bit of a fun short topic. In the past when I have interviewed for Senior SQL Server Developer roles, I have included the following question:What will the…
For 15 years my background was focused on relational databases. I had avoided any other type of technologies, and when my world did overlap with other technologies (mongo.. I'm looking at you), I…