Listing Stored Procedures From Every Database
Recently I answered a question on AskSSC that I thought I would create a quick blog about. Someone had asked...
2011-07-04
735 reads
Recently I answered a question on AskSSC that I thought I would create a quick blog about. Someone had asked...
2011-07-04
735 reads
On June 8th we announced SQL Saturday 89. The call for speakers went out to all those who had submitted...
2011-07-01
424 reads
I spend a little time on AskSSC (that is the question and answer section on http://www.sqlservercentral.com). Quite often the question...
2011-06-28
869 reads
The official launch of SQL Saturday #89 was June 8th. Within the first week of the launch we have registered...
2011-06-15
507 reads
The topic came up at work awhile back with using various includes/excludes such as IN, NOT IN, and EXISTS. A...
2011-05-31
1,372 reads
My first real experience with SSIS began in late Feb of this year. I was upgrading a system from SQL...
2011-05-17
1,132 reads
I made a 700+ mile round trip down to Jacksonville FL where I was fortunate enough to get to speak...
2011-05-02
886 reads
I have blogged before about my appreciation for the SQL community mainly within the PASS organization as that is what...
2011-04-25
529 reads
I saw this quote on facebook last week and it really hit close to home. I had just started working...
2011-04-11
683 reads
This blog is long overdue about my journey to Columbia SC for SQL Saturday #70. I was very fortunate to...
2011-04-07
428 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