TSQL Sudoku
I am a big Sudoku fan. Typically if I need a break, I will break out a Sudoku puzzle from any of a number of different sources (Websudoku, Android...
2011-08-17
9 reads
Blog Posts
Writing Your Resume
There’s a lot of info out there about putting together a resume, and I probably can’t add a lot, but...
2011-08-17
787 reads
Announcing the upcoming Colorado GiveCamp
What is a GiveCamp?
GiveCamp is a weekend-long event where technology professionals from designers, developers and database administrators to marketers and...
2011-08-16
514 reads
Auditing SQL Logins Addendum
One thing that has come out of auditing successful logins is the number of applications called ".Net SqlClient Data Provider"....
2011-08-16
765 reads
Basic Computed Columns
I ran into an issue recently with a computed column, which I’ve rarely used, so I investigated them and wrote...
2011-08-16
1,963 reads
Calculate table size with existing data
Calculate the physical size of a SQL Server database table (data and indexes) , if rows exist . These steps present a...
2011-08-16
1,005 reads
Compiles and recompiles
I want to spend some time over the next few months looking at query compilation and the plan cache, and...
2011-08-16
3,696 reads
Going Big with SSDs
Nimbus Data just sold 100TB of SSDs to eBay
I found a report recently that eBay had implemented 100TB of SSD storage from Nimbus...
2011-08-16
933 reads
Splitting ID’s with commas, updating them, and then Slamming them back together
Unfortunately my company still uses
MS Access DBs. That's Access 97 folks! I've battled many challenges over the
last couple months with...
2011-08-16
1,247 reads
SQL MCM Training – Day 8
Today Paul talked the whole day about HA DR Strategies and Backup/Restore operations.
I've already known a lot about Backup/Restores, but...
2011-08-16
739 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