Where's that Snippet?
Phil Factor has tried many different ways to remember code and archive old code for reuse, but has yet to find the perfect solution. Does it exist?
2019-01-14
111 reads
Editorial
Do you have a security to-do list?
Security is important, and Steve wonders if any of us have a list of things we do that improve security.
2019-01-11
81 reads
2019-01-10
107 reads
Is Failure Allowed?
Failure is one of the ways we get better as software developers. Does that apply to DBAs?
2019-01-09
57 reads
2019-01-07
138 reads
The Giving Back Workload
Volunteering is a good thing for us to do, but it can be overwhelming at times.
2019-01-04
74 reads
Lack of Memory
It seems that many SQL Servers can be lacking memory. Adding more is one way to improve performance, but Steve has other ideas.
2019-01-03
127 reads
2019-01-02
168 reads
2019-01-01
77 reads
2018-12-31
78 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