Not Useless Features
There are some useless features in SQL Server, but Steve Jones wants to know which ones aren't and need investment.
2023-11-01 (first published: 2017-12-01)
318 reads
Editorial
Certifying Schools
Schools don't necessarily teach people how to code, but they could do a better job.
2017-11-30
90 reads
2017-11-29
186 reads
We Need DevOps for Performance
CosmosDB has ways to tune performance based on throttle metrics. We probably need some DevOps style feedback and adjustment for relational systems.
2017-11-28
68 reads
Practice Until You Don't Get It Wrong
We will all make mistakes, but practice can help reduce the errors we cause.
2025-11-03 (first published: 2017-11-27)
294 reads
A well-earned break from the database
Databases, like sheep, get get into some surprising scrapes. However, as long as you've planned for all the common mishaps, your conscience should be clear to take a well-earned holiday.
2017-11-27
68 reads
2017-11-24
73 reads
2017-11-23
45 reads
The Pressure to Perform
Steve Jones wonders how things might be different is developers were treated more like salespeople with quotas.
2017-11-22
75 reads
Avoiding Development Taxes
Anytime we adopt a new technology, framework, platform, language, etc., we will pay a tax in development output.
2017-11-21
68 reads
Blogs
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
Forums
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Designing Delta Tables with Liquid Clustering: Real-World Patterns for Data Engineers
Comments posted to this topic are about the item Designing Delta Tables with Liquid...
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers