Presenting at SQLSaturday #16
I’ll be attending SQLSaturday #16 in South Florida on August 8th and doing two presentations, one on statistics and one...
2009-07-13
331 reads
I’ll be attending SQLSaturday #16 in South Florida on August 8th and doing two presentations, one on statistics and one...
2009-07-13
331 reads
I finished up reading Traffic: Why We Drive the Way We Do by Tom Vanderbilt last week and enjoyed it....
2009-07-10
366 reads
Part 2 of MVP Andy Warren's SQL School video on Instead of Triggers.
2009-07-09
5,252 reads
I was having a discussion with Brian Knight yesterday about whitepapers and thought I’d share some of it – from my...
2009-07-09
436 reads
If you haven’t seen the news yet we’ve got something new on the schedule this year – a 2 hour seminar...
2009-07-08
562 reads
If you have never used an instead of trigger, it's a great mechanism for evading table triggers in certain situations. MVP Andy Warren brings you part one of this SQL School video.
2009-07-07
7,522 reads
Russ Fustino from Microsoft just sent me the link to episode #3 that was filmed at SQLSaturday #14 in Pensacola....
2009-07-06
485 reads
Since the beginning of SQLSaturday I’ve covered most of the news here on my blog, beginning this week I’ll be...
2009-07-06
463 reads
Read the Declaration of Independence and then it’s time for fireworks and grilling, maybe some apple pie too!
2009-07-03
504 reads
Rolling Thunder ($7.99 @ Amazon) by John Varley is the third book in the series. I previously reviewed Red Thunder and...
2009-07-02
703 reads
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
Comments posted to this topic are about the item 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