Temporary Tables
There is a feature of SQL I have not seen used much and probably with good reason. It’s the use of temporary tables. These are declared with the expected DDL. Since they were relatively easy to add to the language, they been around for a while. The bad …
Boosting Data Accuracy: Resolving Common Data Quality Issues Using SQL
Project Context and Data Presentation Challenges In our projects we have seen, data quality issues manifest in various forms, such as NULL values, incorrect formats, invalid characters, duplicate records, and non-ASCII characters to name a few. This ar …
[Video] Office Hours in My Vegas Backyard
I took 5 of your top-voted questions from https://pollgab.com/room/brento while hanging out in the backyard on my second gin & tonic. I, uh, might have lost my temper on the last one. Here’s what we covered: 00:00 Start 02:38 Frozt: are you f …
Azure SQL Serverless: Discover What’s new and Increase Your Savings
Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure SQL Serverless? The answer is simple: Save money. Considering my personal scenario, I can think about at least two different scenarios related to sa …
Navigating the Database Landscape in 2025 Livestream on Feb 12
The post Navigating the Database Landscape in 2025 Livestream on Feb 12 appeared first on SQLServerCentral.
Can AI Rewrite Bad Queries in Seconds? Kinda.
When I see horrific code, stuff that would take a lot of manual labor to fix, I like to lob it over to an LLM like ChatGPT just to see how it does. For example, on a call with a client, I opened up one of their slowest pieces of code to find that it wa …
How to Install SSIS in Visual Studio 2019
The post How to Install SSIS in Visual Studio 2019 appeared first on SQLServerCentral.
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 …