I was in a social media discussion the other day where someone said “Perfection isn’t real, but progress is.” This started me thinking, is there really no perfection? Can you not actually create a piece of software that is perfect? Of course you can. As long as your requirements are perfect, and the code does […]
2024-06-08
100 reads
Steve sees that poor database design is the reality of the world and we have to work around that.
2024-06-07
253 reads
What is an AI LLM useful for? Steve thinks a first draft is not a bad way to look at your AI results.
2024-06-05
218 reads
Microsoft is no longer supporting some uses for DBCC CLONEDATABASE. Read a few of Steve's thoughts on the change.
2024-06-03
116 reads
I had the opportunity last week to present a session at DataSaturdays Stockholm. I can't say enough nice things about the event and the organizers. I presented on Query Store in SQL Server. In my mind, it's an entry-level to middle tier presentation. Most of the room was already working with Query Store, some quite […]
2024-06-01
116 reads
2024-05-31
150 reads
Steve doesn't have a lot of concerns about AI models writing code and reusing algorithms, but others might not feel the same way.
2024-05-29
191 reads
Today Steve asks about your view of Managed Instance. He has found many people like the offering quite a bit.
2024-05-27
367 reads
Steve has had a good time sharing knowledge with others at events. He gives you a few thoughts on why you might join him at a future event.
2024-05-24
132 reads
Steve has a few thoughts on invisible downtime, a term he had never heard until recently.
2024-05-22
191 reads
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
hi, just to get this part out of the way, if my intended target...
Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers