The Change Failure Rate
The number of times that you have a failure when deploying changes is a good metric to watch.
2025-02-17 (first published: 2019-06-03)
1,302 reads
Editorials
Limits, Not Goals
I just saw one of "those" questions. You know the ones: 'We're hitting an error with a stored procedure. What is the maximum number of parameters you can have?" <sigh> Look, I get it. Breaking the land speed record is cool. Getting the most people into a phone booth (look it up), also cool. Fastest, […]
2025-02-15
115 reads
How Much Linux Do You Need?
With SQL Server on Linux becoming more popular, Steve asks if you think you need to know much about that OS.
2025-02-14
108 reads
2025-02-14 (first published: 2025-02-12)
764 reads
Extended Event Comfort
Steve wants to know if you're using Extended Events and what you think of it.
2025-02-10
125 reads
No End to Programmers
The idea of chat-oriented programming has led some people to think that AI LLMs will reduce the need for programmers. Steve disagrees.
2025-02-08
126 reads
Unreliable Narrators
Steve has a few thoughts on a interview with Grady Booch, an icon in our industry, who have a great quote on AI technology.
2025-02-07
102 reads
Building a Data Center
A data center is a complex beast. Is it worth building and maintaining your own? Steve has a few thoughts on a data center versus a cloud.
2025-02-05
151 reads
Words vs Data
Are you clear in your reporting. Steve notes that sometimes we might leave too much up to interpretation by the end user.
2025-02-03
90 reads
Throwing Iron at the Cloud and AI
As organizations move to the cloud, the once essential role of the Database Administrator (DBA) as the guardian of system optimization, has been overshadowed, often viewed as a bottleneck to innovation. Yet, as technology evolves, the one thing I know is history repeats itself, and optimization skills are once again emerging as a critical necessity. […]
2025-02-01
82 reads
Blogs
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
“SQL Server Is Slow” Part 4 of 4
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
Forums
visual studio seems to lose "provider" on pkg imports
hi, just to get this part out of the way, if my intended target...
ERD Tools recommendation
Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...
Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
Vector Datatype Dimensions
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers