Final 2012 Learning Opportunity
There’s still a little time left in the year. I know some businesses have allocated training budgets and if they...
2012-11-21
1,111 reads
There’s still a little time left in the year. I know some businesses have allocated training budgets and if they...
2012-11-21
1,111 reads
No major updates at the moment. I still haven’t played with remoting through PowerShell. I’m just living with it.
Had an...
2012-11-19
993 reads
I sat the through the big announcements at the 2011 PASS Summit about the partnership between Microsoft and Hadoop. I...
2012-11-16
1,209 reads
The Windows RT operating system is not the same as Windows. After all the talk about the upcoming OS and...
2012-11-14
2,367 reads
Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.
2012-11-12
17,083 reads
I’ve been posting about the Surface over the last couple of weeks and I’ve tried really hard to be positive...
2012-11-12
997 reads
I’m a little over two weeks with the Surface at this point. I’ve been travelling all of that time, so...
2012-11-11
1,469 reads
Two quick points, I’m putting this blog together using the Surface.. ooh… and this isn’t a keynote, but a spotlight...
2012-11-09
1,444 reads
I’m attempting to push this thing. I want it to be a production device, not just a consumption device. Frankly,...
2012-11-09
865 reads
Welcome to Day 2 of the PASS Summit!
It’s been a very exciting event so far. Today I’m presenting two sessions,...
2012-11-08
1,001 reads
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
Comments posted to this topic are about the item Not Just an Upgrade
Comments posted to this topic are about the item Restoring On Top I
Comments posted to this topic are about the item Designing Delta Tables with Liquid...
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