You're going to have to bear with me on this one because my thoughts aren't fully formed. As I'm sure I've mentioned, I'm a little elderly (and you thought I was going to talk about radios). As such, I've seen the death of a few technologies. I may not have shared this widely, but my […]
Spotting synchronization disconnects between a primary and a secondary data center in a distributed availability group configuration can be hard, so here are valuable tools to help you with it
The best way to improve your database performance is with better code. We all know that, but few of us actually end up making those changes.
Running Postgres in Docker is great for a quick test but what if you want it to behave like a proper, production-style setup with SSL encryption, certificate-based authentication, persistent volumes, and custom configurations? In this article, we’ll find out how
When you must rollback a deployment of changes, is that a failure of the process? The development effort? Or something else?
In this level of the Stairway to Azure SQL Hyperscale we learn about the read-only layer that speeds up queries.
Searching for a string in database tables has been discussed over the years. There are several approaches to the problem (see References at the end of the article). See how to use SQL to find a string in different types of SQL Server objects and data.
This article shows how you can find which objects in your database might not be valid after schema changes.
When should a DBA get fired? Steve Jones thinks it should be rare and gives you two cases.
SQL Server 2025 introduces a new sys.dm_os_memory_health_history view to make it easier for meatbags like you and robots like Copilot to know if the SQL Server has been under memory pressure recently.
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Yes, you’re reading that right, we’re going to download a report that cannot be...
Because we are NABL Accredited Laboratories, our personal care and cosmetics research center provides...
hi, need to known weather fast farwand cursor is faster than a while loop...
Comments posted to this topic are about the item Economics of AI: What is...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers