Using a serverless, event-driven, fullstack architecture — As a developer, I often attend conferences to learn new skills and network with other professionals. However, conferences can be overwhelming, especially when they offer dozens of sessions on different topics. How can I decide which ones are worth my time and attention? That’s why I decided to use OpenAI…

Vector databases are gaining quite a lot of interest lately. Using text embeddings and vector operations makes extremely easy to find similar “things”. Things can be articles, photos, products…everything. As one can easily imagine, this ability is great to easily implement suggestions in applications. …

I’ve just finished watching the video from the @GuyInACube about Common Table Expressions and I noticed that in several comments there was the request to explain what the difference between Common Table Expressions, Views and Temp Tables is. This is quite a common question, and it is time to…

Last week I’ve been to the DevIntersection conference to present several sessions around Azure SQL and development (Modern Architecture Patterns with Azure SQL Database, The 10 things every developer must absolutely know about Azure SQL and Build a Jamstack solution in a day) so…yeah, I’m already falling behind with the…

Today’s Advent of Code challenge is really interesting. Somehow easy, but with a couple of interesting discussion points. Day 3: Rucksack Reorganization is about helping elves to organize and prioritize their supplies. I imported the input data as usual, by coping it from the website to my Azure Data Studio…

Day 4 — Camp Cleanup challenge is all about dealing with intervals. Intervals are trickier and more complex than one might think. No surprise the organizer of the Advent Of Code, included them in their challenges. I did a lot of research on intervals, and specifically time intervals in the…

The second challenge of the Advent of Code 2022 is pretty straightforward with SQL. In summary the task is to use some starting values and transform those into a numeric value using a lookup table, and then calculate the sum of all the values you get. …

The first challenge of the Advent of Code 2022 is out, and this year I decided to try to solve the proposed challenges only using T-SQL. I also want to share the solutions here, as I think they will provide a great learning experience for those who are new to…

Apply event-driven architectures to the database too — Event-Driven and reactive architectures (see the “Reactive Manifesto” if you’re new to the topic or interested to learn more about it) are extremely popular today. Events — and thus data — are pushed to services so that integration can happen faster and more efficiently. With Azure SQL database it is…