NOSQL and RDBMSs
NOSQL and RDBMS are evolving and absorbing ideas from each other. Is this necessarily a good thing? Perhaps we should think again
2024-06-14 (first published: 2015-08-27)
868 reads
Editorials
What Write Ahead Logging Is and Why It Matters
Kendra Little talks about write ahead logging in SQL Server, one of the basic concepts that developers and DBAs should understand.
2024-06-12 (first published: 2020-01-20)
4,875 reads
2024-06-10 (first published: 2020-01-23)
523 reads
Is Perfect Software Attainable?
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
110 reads
Poor Database Design Realities
Steve sees that poor database design is the reality of the world and we have to work around that.
2024-06-07
295 reads
Using AI for the First Draft
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
243 reads
DBCC CLONEDATABASE is Semi-Discontinued
Microsoft is no longer supporting some uses for DBCC CLONEDATABASE. Read a few of Steve's thoughts on the change.
2024-06-03
140 reads
On Being an "Expert"
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
125 reads
2024-05-31
171 reads
Common Algorithm Concerns
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
208 reads
Blogs
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers