Why Standards are Important
Throughout my career I have seen arguments as to which IT standard in a particular area, is the one true standard. Searching any forum for discussions on standards reveals that these debates frequently become acrimonious and heated. In fact, the comb …
Pop Quiz, 2025 Edition: What Do These Things Cost Today?
Price check on Aisle 2025. My main consulting job is a 2-day SQL Critical Care® where I help turn around slow SQL Servers. Companies come to me because they’re not sure if it’s a hardware problem, a database configuration issue, bad app cod …
Nostalgic Memory Loss
Today’s topic pertains to 99.999% of all people, young, old, and all age ranges . I am also not talking about forgetting to pay a bill, backing up a database, or any task one can easily forget as we scurry through what feels like a million tasks each w …
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 …