Spending Time in the Office
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.
How to host an AI text embeddings model for SQL Server using Ollama
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 Explained: Page Splits, Logical Reads, and What to Do
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.
What is the Cloud?
Today Steve has a few thoughts on what the cloud is in 2026. See if you like his analogy.
How to Deploy SQL Server on Kubernetes running on Windows
Learn how to deploy SQL Server on Kubernetes using Docker Desktop on Windows. Unlock powerful capabilities for your database.
Why even the best teams struggle with cloud migrations
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.
Bad IT People
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.
Midjourney, Healthcare?
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 […]
Changes, Happiness, and a Few Tears
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.
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU CIREBON Telp.0817839777
WhatsApp-0817839777 Jl. Yos Sudarso No.27, Lemahwungkuk, Kec. Lemahwungkuk, Kota Cirebon, Jawa Barat 45111
Alamat BCA KCU SOEKARNO HATTA Telp.0817839777
WhatsApp-0817839777 Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung, Jawa Barat 40227
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers