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 […]
2025-01-20
1,802 reads
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 […]
2025-01-17
3,327 reads
Everybody’s coasting and looking back. Let’s kick our heels up, get comfortable, and talk big picture industry stuff.
2025-01-17
2024-12-13
112 reads
This tutorial will show how to use an AI model with Python to respond to queries.
2024-11-04
5,955 reads
Steve has a few thoughts on how AIs change the role of databases.
2024-10-14
332 reads
2024-09-14
91 reads
One of the strange side effects of AI might be junior staff struggle to get hired and get experience. Where does that leave the industry when senior staff retires?
2024-08-26
144 reads
As part of my work with Redgate, I wanted to do some testing on our subsetting and masking tools. Subsetting needs a big data set, and while Stack Overflow is big, it's kind of simple. I wanted something a little different. Since our engineers use Northwind to do a lot of demos, I decided to […]
2024-08-26
2,269 reads
Exploring Generative Adversarial Networks (GANs) for Butterfly Image Generation to gain some understanding of how this class of Artificial Intelligence technologies work.
2024-07-15
30,840 reads
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Quite the title, so let me set the stage first. You have an Azure...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers