Home

Latest from the Blog

Impact of Automatic Index Compaction

Index work has almost always been a core task for database administrators. If indexes aren’t performing well, then your queries probably aren’t performing well. And if your queries aren’t performing well, you aren’t performing well, because users will be complaining. There isn’t one set way to manage indexes. Maybe you use Ola Hallengren scripts. Maybe…

Your Next Database Prank

An interesting discovery was made as it relates to OpenAI Codex and its system prompt. From this article: The system prompt for OpenAI’s Codex CLI contains a perplexing and repeated warning for the most recent GPT model to “never talk about goblins, gremlins, raccoons, trolls, ogres, pigeons, or other animals or creatures unless it is…

Bulk Loading Data with mssql-python

I’ve had some projects in the past that involved using Python to load data in SQL Server. It wasn’t unbearably slow, but it seemed like a process that could be faster. For that reason, a recent SQL Server blog post about bulk loading data with Python caught my eye. I decided to test out the…

Get new content delivered directly to your inbox.