Can I Change a Primary Key Value? #SQLNewBlogger
I heard someone say recently that you can’t change a primary key value in a row. That’s not the case, so I decided to show a quick proof of...
2025-05-02 (first published: 2025-04-23)
521 reads
SQL Server Index Primer
Indexes 101: What, Why, and When? “What Is an Index?” I get this question a lot, especially from developers and sysadmins who’ve been handed a SQL Server and told,...
2025-05-12 (first published: 2025-04-23)
266 reads
Secure Azure SQL Server Backups Using Managed Identities
I do believe most people know about the ability to backup your SQL server databases to URL (from Azure VMs). If you recall you would use the storage key...
2025-05-09 (first published: 2025-04-23)
376 reads
Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell
As AI continues to evolve, many of us are looking for ways to leverage large language models (LLMs) without relying on cloud services. As we learned in my previous...
2025-05-07 (first published: 2025-04-22)
573 reads
Monday Monitor Tips: Finding the Hostname for Queries
I was chatting with a customer recently and they wanted to know which host was sending in queries that were causing problems in real time. This post looks at...
2025-05-05 (first published: 2025-04-21)
524 reads
Can AI Read Execution Plans?
Yeah, yeah, second AI post in a row. I promise not to make a habit of it. But I saw someone else mention that you can feed them XML...
2025-05-07 (first published: 2025-04-21)
557 reads
Streamline Dependency Management in Databases
In the intricate world of business, where precision and efficiency are paramount, managing database dependencies can often feel like navigating a labyrinth. Imagine having a tool that not only...
2025-05-05 (first published: 2025-04-21)
289 reads
A New Word: Immerensis
immerensis – n. the maddening inability to understand the reasons why someone loves you – almost as if you’re selling them a used car that you know has a...
2025-04-18
53 reads
Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault
In this post, I will guide you on how to deploy a dockerized simple flask-based TODO application to Azure Container Apps using Pulumi. You will Dockerize the Python application,...
2025-04-18
68 reads
Using a Local Large Language Model (LLM): Running Ollama on Your Laptop
You can now run powerful LLMs like Llama 3.1 directly on your laptop using Ollama. There is no cloud, and there is no cost. Just install, pull a model,...
2025-05-02 (first published: 2025-04-17)
438 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers