Tag: SQL

Can attending a university in a foreign country impact one’s mental well-being? In 2018, a Japanese university with a diverse student body conducted a comprehensive survey. An ethically and regulatory approved study based on this research was published the subsequent year. The study’s...

Greetings everyone, As you know, we cannot install Sql Server directly on Macos. So we are looking for other ways to install it. Docker provides a radical solution to this problem. In order to use Sql Server on Macos, there are 3 components that we need to download. These are; 1- Docker D...

When I first learned SQL, my mind was kinda blown. In my first job I worked in Investment Banking, doing tons and tons of analytics using nothing other than excel. When I realised you could do this using something like SQL, I was amazed, so amazed that for the last 4 years I’ve been working in...

In this article it’s gonna be explained two different methods that can be used for upserting data from the Databricks lakehouse platform to Azure SQL DB. Code snippets can be found on my github: ssaenzf/databricksLearning: Repo with code from articles related with the Databricks lakehouse plat...

Change is hard. Change in software is even harder, so with any software project, engineers set up a process for change management using a series of tools such as Git, GitActions, AzureDevOps, Jenkins, CircleCI, Terraform, and many many more. However, missing from these toolsets is the core concept o...

Stored procedures are a powerful feature of SQL that allow you to encapsulate a set of SQL statements into a single named unit. This can make your code more reusable, maintainable, and performant. Dynamic SQL stored procedures take this a step further by allowing you to construct and execute SQL ...

One of the challenges of using LLMs (Large Language Models) in a business context is getting the model to answer factually and accurately about your company’s data. One possible solution is Retrieval Augmented Generation (RAG) using a vector database to populate the prompt context (see my post...