Using merge to capture bulk insert identities in SQL Server On 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 Nodes Sorry 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 Server I 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 Graph In 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…
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…