New Personal Site Launched !
Hey there folks. I finally was able to get my persona domain name from a squatter who has been holding...
2009-10-21
390 reads
Hey there folks. I finally was able to get my persona domain name from a squatter who has been holding...
2009-10-21
390 reads
My presentation and sample files from SQLSaturday in Orlando are now online for you to download. Check them out at...
2009-10-21
386 reads
When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow...
2009-09-16
5,791 reads
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-09-10
1,154 reads
Have you ever wondered where to go to get good information that will help you in your day to day...
2009-09-09
453 reads
Hey there Gang !
Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting...
2009-09-09
418 reads
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-09-08
3,599 reads
Have you ever received the following error when developing your ETL or working with data cleanup?
Msg 544, Level 16, State...
2009-09-08
585 reads
Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to...
2009-09-08
595 reads
Intellisense is one of my favorite features in SQL Server Management Studio and BIDS for 2008. A common frustration I...
2009-09-08
974 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