Is it time for SQL Server to have Isolated Transactions?
SQL Server allows nesting of Transactions –in a sense. In truth, there is only one Transaction, with each ‘nested transaction’...
2009-03-10
789 reads
Arnie Rowland
MVP Summit 2009 -A Most Excellent Adventure
For many of us, one of the high points of being an MVP is attending the annual MVP Summit hosted...
2009-03-07
414 reads
You HAVE to Trust, you MUST Verify -and that may still not be enough!
In Brian Kelly's recent blog post, he makes an excellent case outlining why there are few options but to 'Trust' SQL...
2009-02-20
419 reads
What’s in a Name?
Why do folks continue to use outdated and unnecessary naming conventions? Specifically, the ridiculous ‘tbl’ prefix on tables, and the...
2008-10-23
1,384 reads
When Do You Know That You Know
Why, when you can help others, that's when!
In my role as a senior Moderator with the MSDN SQL Forums, I am often...
2008-10-17
455 reads
Through the Looking Glass: Elegant -or Not?
SQL Server as an EAV Database -Good Idea?
It seems like I am getting more and more inquires from potential clients...
2008-10-03
372 reads
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
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...
Forums
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
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
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