Can You Become a More Productive Engineer?
Steve has a few thoughts on becoming more effective. This involves more than just becoming a better coder.
Oracle Architecture Overview
In this document I will share an overview of Oracle’s architecture that isn’t complete, but it will give you a basic understanding of how the architecture works, especially if you are coming from other database platforms.
The AI Budget Assistant
Most of us don't work on budgets, but we are affected by them. Is it a good idea for IT management to use AI to help plan their budgets? Steve has a few thoughts today.
Why Standards are Important
There is something in the tech mindset that simultaneously loves and loathes a standard. Having standards is important, what those standards are is less so.
How to Install SSIS in Visual Studio 2019
This tool has always been an integral part of the Visual Studio. However, the name of this tool as well as the method of its installation varies from version to version of Visual Studio (VS). In this article, we are going to illustrate how to install SSIS in Visual Studio 2019.
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 my blog, I downloaded an […]
Why Tools Can Help You Do Your Job
This editorial was originally published on May 18, 2019. It is being re-run as Steve is on holiday. Back in my days as a SQL server DBA, I didn't have many third-party tools at my disposal. I remember having a monitoring tool with licenses for only three or four SQL server instances. Whenever there was […]
Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD
This article covers examples of how some larger companies have successfully implemented CI/CD practices to transform their development processes.
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 and sentence embeddings, which can be useful in applications like chatbots, document retrieval, and natural language understanding. In this […]
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Building a RESTful API with FastAPI and PostgreSQL
Comments posted to this topic are about the item Building a RESTful API with...
The Journey to PostgreSQL (or anything)
Comments posted to this topic are about the item The Journey to PostgreSQL (or...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers