Choosing the right professional
I’m writing this blog post from my bed, you may think that’s a little too much information there is a...
2012-01-11
481 reads
Richard Douglas
2011 – The dissection
Blimey, doesn’t seem like a year since I wrote my last end of year review End of year review 2010...
2012-01-01
682 reads
Why I blog #Meme15
I’d seen various #meme tweets on twitter but it wasn’t until I saw this blog by John Sansom (Blog|Twitter) that...
2011-12-15
475 reads
T-SQL Tuesday #025 – How to view the size of all your databases – #TSQL2sDay
It’s that time of the month again, no not time, T-SQL time! If you have not heard of T-SQL Tuesday...
2011-12-13
868 reads
Speaking Engagements
It only seems like a couple of weeks ago since I wrote a post about new years resolutions which you...
2011-11-15
521 reads
Writing queries without data
Sometimes it’s not possible to have the data you need in order to create the most efficient queries possible. This...
2011-11-15
700 reads
Top 5 Third Party Quotes
Unless you’ve worked in a vacuum the likelyhood is that you either are a third company or you have many...
2011-11-09
490 reads
SQLRelay: The Final Sprint
The UK SQL community has never had so many events in such a short space of time. Last week there...
2011-10-06
421 reads
SQLRelay: The Third Leg
Feedback from the second leg of SQLRelay was very positive indeed. The attendees from my Maidenhead group were very impressed...
2011-10-05
675 reads
Blogs
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
Forums
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Designing Delta Tables with Liquid Clustering: Real-World Patterns for Data Engineers
Comments posted to this topic are about the item Designing Delta Tables with Liquid...
Question of the Day
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