What Counts for a DBA: Amnesia
Louis Davidson explains why DBAs often need a healthy dose of selective, enforced amnesia about the pain of previous failures.
2013-01-07
158 reads
Editorial
The $50,000 Laptop
The average value of a lost laptop has been found to be much more than you might expect. Steve Jones talks about a recent study.
2013-01-07
217 reads
DR Prep
This week Steve Jones asks how you might handle DR preparation or process differently in the new year.
2013-01-04
116 reads
All Flash
Should you think about using SSD storage in your SQL Server databases? Steve Jones thinks this might be something you should consider.
2013-01-03
223 reads
Hacked
Getting hacked is no fun. Today Steve Jones notes he's been hacked, in more ways than one and wants you to think about this at your workplace.
2017-03-28 (first published: 2013-01-02)
359 reads
2013-01-01
276 reads
2012-12-31
222 reads
'At-Rest Data-Leakage': The Euphemism
If you let working drives leave the building in a readable state, you’re unintentionally in the publishing business.
2012-12-31
94 reads
2013 Goals
For the last Friday poll of the year, Steve Jones looks ahead to 2013 and the goals you might set for your career.
2012-12-28
191 reads
2012-12-25
53 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
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
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
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