Oh Look, A Horseless Carriage
Never forget, we’re making buggy whips. And everybody we know drives little buggies and they need our buggy whips. We’ve...
2015-01-28
1,081 reads
The Scary DBA
My First Board Meeting
Parents, you know that feeling you get after you’ve brought home that brand new baby (or in my case, babies) where...
2015-01-30 (first published: 2015-01-26)
6,352 reads
Understand the True Source of Problems
There’s an old joke that goes, “Doctor, doctor, it hurts when I do this.” While the person in question swings...
2015-01-19
765 reads
Two Weeks on the PASS Board
The one absolute promise I made about serving on the PASS Board is that I would let you know what...
2015-01-16
529 reads
Common Table Expressions Are Not Tables
There’s power in naming things. Supposedly some types of magic are even based on knowing the correct names for things....
2015-01-20 (first published: 2015-01-14)
8,480 reads
I Am Grateful For
A while back I wrote about saying “Thank you” to people. Last night I was listening to NPR on my...
2015-01-09
691 reads
Execution Plans, Performance Tuning and Rum
This is me on the last cruise
In just a few more weeks I’ll be setting sail on the first of...
2015-01-06
1,082 reads
Speaker of the Month: January 2015
I love it that my first post of the new year is going to be Speaker of the Month. I’m...
2015-01-02
422 reads
“Pretty Plans vs. Performance” or “Grant Gets Pwned”
If you get an execution plan that looks like this:
I wouldn’t blame you for immediately thinking about query tuning. Especially...
2014-12-29 (first published: 2014-12-19)
6,158 reads
Speaker of the Month: December 2014
For the month of November I was at the PASS Summit and Live360, so I didn’t get to find new...
2014-12-08
551 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