As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field for successful POC engagements, we must, at a minimum,...
2012-10-23
22 reads
Hello Dear Reader! Tomorrow at 12 noon eastern I’ll be presenting for the PASS DBA Virtual chapter, click here to...
2012-10-23
1,024 reads
All roads lead to Seattle!
If you are a SQLServer professional, then you don’t want to miss this event.
Over 190 technical...
2012-10-23
1,207 reads
For your convenience, below is a download link to get the presentation and relevant materials for the SSIS Tips & Tricks...
2012-10-23
857 reads
It may seem obvious, but I’ve heard more than one person suggest to me that statistics on a clustered index...
2012-10-22
1,160 reads
What do i mean by shell packages? You’re spot on – that’s an excellent question to begin with. For the purpose...
2012-10-22 (first published: 2012-10-16)
4,667 reads
I'll warn you straight off that this is an advanced technique for a fairly small use case - it is NOT...
2012-10-22
1,425 reads
I'll warn you straight off that this is an advanced technique for a fairly small use case - it is NOT a "try this for all data flow performance...
2012-10-22
58 reads
One thing lots of DBA teams, esp. the DBA managers, feel uncomfortable is that it is difficult to quantify/log DBA’s...
2012-10-22
1,829 reads
Don’t Be That PASS Summit Guy
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is just around the corner. Every year...
2012-10-22
1,204 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