Why Are Stored Procedures Too Hard?
Recently I was going through the buy or build process on a small segment of functionality needed for a project,...
2008-07-20
855 reads
Recently I was going through the buy or build process on a small segment of functionality needed for a project,...
2008-07-20
855 reads
A few months back I posted about our latest whiteboard and I thought I'd report back with an update. Initially...
2008-07-17
513 reads
Below is a list of various tools I use, some SQL related and some not. Follow the links to my...
2008-07-17
1,171 reads
Long time SSC participant Grant Fitchey has published a great book on reading/understanding execution plans. I finally had the chance...
2008-07-16
1,360 reads
The fourth annual Jacksonville Code Camp is set for August 23, 2008 and it looks like they are off to...
2008-07-15
467 reads
I ran across MentoringNet in a recent renewal flyer from ACM. I'm interesting in all things mentoring, so I went...
2008-07-14
1,004 reads
One of the things I use to identify how well a company is managed is by looking at how (well)...
2008-07-13
1,623 reads
My friend Steve Jones posted an article called What's an MVP on SSC that in turn led to a moderately...
2008-07-13
1,403 reads
SQLSaturday #5 in Olympia is progressing nicely. Greg, Russ, and team have locked in a venue and with registration just...
2008-07-11
408 reads
I did quite a bit of reading during a recent week off including two biographies. One was Boyd: The Fighter...
2008-07-10
390 reads
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...
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
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
Comments posted to this topic are about the item Designing Delta Tables with Liquid...
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