How Query execute
*This is my Opinion Whenever you execute any query…. Everything will be on Memory unless data is not available from...
2011-06-10
477 reads
Vinay Thakur
Isolation level and Locks
Before moving with next blog. We should be aware of some information about Isolation level. As the trasaction is depends...
2011-06-08
844 reads
Failure Cluster -General
We have discussed some basic high availability here. Yesterday we were discussing about Windows clustering (here on will say “Clustering”)...
2011-06-04
578 reads
SQL Server Migration Assistant v5.0
I bloog about mysql to sql server migration lastly here Today found very good migration tool Free Downloads: 1. SSMA...
2011-05-25
671 reads
Troubleshooting Performance -1
Whenever you get a call from user that they are facing any performance issue what would you do. As I...
2011-05-11
472 reads
Download: Powershell a Day -April 2011
I you liked my Powershell a day – april 2011, where every day I wrote a blog about powershell you can...
2011-04-30
1,540 reads
Powershell Day 30
Day 30 Best Practice Having good Security is first best practice for any language no exception with Powershell. Having that...
2011-04-30
1,451 reads
Powershell Day 29
Day 29 Advance Security As discussed in earlier blog about “Security” Day 7. Continue on that we will discuss here...
2011-04-29
1,444 reads
Powershell Day 28
Day 27 SQL Policy I highly recommand to go through the Policy –based management (BCM)’s official excellent site to learn...
2011-04-28
518 reads
Powershell Day 27
Day 27 Inventory As discussed ealier about wmi, wmi is a good for accessing inventory data from remote system as:...
2011-04-27
526 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