For generating IDs (primary keys) in application databases or surrogate keys in data warehouses, there are several approaches. GUIDs or numeric IDs are mostly used. GUIDs are mainly used in application databases and are generated, for example, using the NEWID() function. This has its advantages and disadvantages. The biggest disadvantage is poor SQL query performance… Read More »
Many have noticed that we are currently in a significant AI hype, with chatbots led by ChatGPT playing a prominent role. This article serves as an introductory guide to this tool with several practical usage examples. Although AI is still in its infancy from a development perspective and far from perfect, it can already assist… Read More »
In the previous article, we provided a brief introductory overview of the technology developed by OpenAI – ChatGPT. We discussed the basic version (3.5), its features, and limitations. We explored how this technology was created, its limitations, and the importance of prompt quality. The basic version of ChatGPT, which is available for free, is entirely… Read More »
Artificial Intelligence (AI) is a technological field that is rapidly advancing and finding applications in various aspects of human life. There are many types and focuses of artificial intelligence. Currently, one of the most talked-about is ChatGPT, which falls into the category of so-called generative AI (artificial intelligence). Below, you will find the definition of… Read More »
Aside from the standard method of installing SQL Server via the classic visual interface, there is also the option to install SQL Server from the command line or PowerShell. This is useful when you regularly perform multiple installations with similar configurations and want to dynamically define instance names, service accounts, or installation directories. Additionally, there… Read More »
Installation of MS SQL Server involves a lot of work before an IT specialist can actually start the installation process. Before we address the software and hardware requirements, we need to consider one thing: what edition of SQL Server we will actually need, depending on the features of SQL Server we intend to use. Hardware… Read More »
A data warehouse is a central information system designed to store data from one or more enterprise operational systems or other external sources such as Excel, SharePoint, and others. Data in the data warehouse is organized into schemas and undergoes a cleansing and structuring process before storage to make it understandable to users and easily… Read More »
Today, I attempted to install Mage.ai via Docker as part of my familiarization with Mage.ai. This is currently (as of 2024-01-26) the only scenario for running Dbt together with Mage.ai within pipelines natively. Of course, there is a possibility to run dbt model using custom python code anyway (in case you use pip/conda installed mage)… Read More »
![[Errno 2] No such file or directory](https://janzednicek.cz/wp-content/uploads/2024/01/Screenshot-2024-01-25-at-23.41.32.png)
Mage.ai is a great tool for data nerds, but it’s not completely done when it comes to user experience just yet. We might encounter some errors that are inherently of a primitive nature, making them sometimes challenging to identify. One of these errors is Error [Errno 2] No such file or directory, and today, I… Read More »
AdventureWorks databases from Microsoft are the most popular sample databases for developers, database administrators, or simply for students looking to learn something about SQL Server and database management. In this article, we will take a look at the available variants of Adventure Works databases, but more importantly, I want to highlight the possibility of connecting… Read More »