Loading Models from Source Data with dbt
The data transformation tool dbt (data build tool) has become more and more popular over the past years. It focuses heavily on SQL, and it adds a bunch of interesting features into the mix, such as data lineage, automatic orchestration, reusable macros …
Influencing a Local AI
I set up a local AI LLM to run and then conducted some experiments. This post shows a bit about the experiments and a little code. The setup is on my blog using Docker to containerize an Ollama LLM, which you can read about. The Basic Setup If you read …
Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD
The post Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD appeared first on SQLServerCentral.
MySQL Shell and Basic Configuration Management (Part 2 – Memory and CPU)
Part 2 in the series: A Comprehensive Beginners Guide to Configuration with MySQL Shell. In the first part of the series article, we introduced MySQL Shell as a tool for managing and optimizing MySQL configurations. We discussed how to install the Shel …
Vector DB implementation using FAISS
Searching for relevant information in vast repositories of unstructured text can be a challenge. This article explains a Python-based approach to implementing an efficient document search system using FAISS (Facebook AI Similarity Search) for Vector DB …
Using Snyk for CI/CD Security Scanning
Security is important regardless of your industry, whether it’s finance, retail, e-commerce, or the broader world of IT. A little security oversight can have catastrophic impacts, leading to loss of money and unauthorized access to classified inf …
I’m Coming to Croatia!
A few things lined up perfectly for a European trip this summer. I’m on a European cruise in early June, then Data Saturday Croatia on June 14, and then SQL Bits on June 21. For Croatia, I’m teaching a one-day preconference workshop: Faster …
Fabric Copy Job: What’s new in it
At first sight, the new Copy Job may seem only one more redundancy: Why do we need this? We have Data Pipelines for the Copy Activity and also a Copy Assistant to help us configure it. What’s new about the Copy Job? Spoiler: It’s much more …
Does Separating Data and Log Files Make Your Server Faster?
I’ve already explained that no, it doesn’t make your database server more reliable – and in fact, it’s the exact opposite. But what about performance? The answer is going to depend on your hardware and workload, but let’s …
Announcing the 2025 Data Professional Salary Survey Results.
We’ve been running our annual Data Professional Salary Survey for almost a decade, and I was really curious to see what the results would hold this year. How would inflation and layoffs impact the database world? Download the raw data here and sl …
FinOps pour Microsoft Fabric
Version de l’article en Anglais sur LinkedIn : Le FinOps et Microsoft Fabric, deux sujets qui m’intéressent particulièrement, c’est probablement la raison pour laquelle l’article est plus long que prévu ! 1 – Introduction …
VIEW Objects
A view is a virtual table, created when it’s invoked by the < view name>. The goal we had in the standards is to make it behave as much like a base table as possible. Creating a View The syntax of course uses the CREATE keyword because it is pers …
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server
Introduction When working with T-SQL trigonometric functions in SQL Server, it’s important to be aware of potential pitfalls that can lead to incorrect results. These issues may not always be immediately apparent, but understanding their causes will he …
Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, Warehouses, and Pipelines
The post Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, Warehouses, and Pipelines appeared first on SQLServerCentral.
I Wrote a Book on How You Broke Your Database – Here’s Why You Should Read It
Preface If you are a frequent reader of Simple-Talk, it’s possible that you’ve come across blogs about optimizing all kinds of queries, tutorials on how to back up your database, tutorials on index internals, or even speaking at conferences. If you’re …