Many of us work remotely, lots of of hybrid, but some are in the office every day. Steve has a few thoughts on these models.
When we want to use AI-based comparisons of text, via vector search in SQL Server, we need to first generate embeddings for the text. An embedding is a numeric representation of meaning, usually represented by vectors. In this article, I’ll show you how to use Ollama to host a server locally that can be used to generate embeddings.
Index fragmentation can silently degrade your query performance over time. Learn what happens at the page level, how to measure it, and how to fix it.
Today Steve has a few thoughts on what the cloud is in 2026. See if you like his analogy.
Learn how to deploy SQL Server on Kubernetes using Docker Desktop on Windows. Unlock powerful capabilities for your database.
Grant Fritchey explains the concept of ‘unknown unknowns’, points out what to watch out for in a cloud migration, and offers proven strategies to help your migration go as smooth as possible.
What happens when you have bad IT people working in your company? Steve Jones says that they always will be around, but we might not want to enable them to continue in this business when we find them.
Certain announcements in AI tell you more about where an industry is heading than any earnings call or research paper ever could, and Midjourney just made one. The company that spent the last few years as the most recognizable name in image generation, the one whose pictures flooded everyone's feeds and defined what people saw […]
Change is unavoidable and always affects us. We can be both happy and sad about it as we move forward. A tribute today to Annabel, who retired from Redgate Software this week.
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp-0817839777 Jl. Yos Sudarso No.27, Lemahwungkuk, Kec. Lemahwungkuk, Kota Cirebon, Jawa Barat 45111
WhatsApp-0817839777 Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung, Jawa Barat 40227
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers