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…

Fullstack and Jamstack architectures are common nowadays, but they can be quite intimidating if you are just getting started in the web development space. So many concepts, technologies and patterns to grasp. And so many alternatives! Well, thanks to @glaucia86 you now have a *full series* on the top-notch technologies…

Just six steps to get the job done — There are many ways in which an Azure SQL database can be created, and if you are new to the development all those different options can be quite intimidating. Let me show you, in just a few steps, how easy it is instead. …