I love going to SQLSaturday events because I’m always asked questions that make me think. I was just at SQLSaturday Indianapolis (a great event, if you weren’t there, you...
2019-09-09 (first published: 2019-08-19)
315 reads
It’s a running joke among the more experienced (read, older) Microsoft Data Platform specialists as to whether you’re #teamprofiler or #teamexevents. I’m very much #teamexevents, but I really don’t...
2019-08-28 (first published: 2019-08-19)
717 reads
I’m pleased as punch to be able to share with you the fact that I helped Tracy Boggiano write a whole new book on Query Store. It will be...
2019-08-12
32 reads
In just a couple of weeks, I’ll be presenting an all day session on DevOps for databases. It takes place on Friday, August 30th. You can click here now...
2019-08-07
4 reads
The more you work with containers, the more you just want to work with containers. However, there are still reasons to have a virtual machine for some types of...
2019-08-15 (first published: 2019-08-05)
324 reads
There is literally nothing I like better than working on automation. Before we had all the cool toys that we have now, I was working on automating database deployments....
2019-08-01
6 reads
I’ve said it before and I will repeat myself on this because it’s an important concept: DevOps is about culture and communication, not tools Now, that said, to implement...
2019-07-29
110 reads
I’ve always said if you’re running a script for the first time in a production environment, you’re doing it wrong. Testing is fundamental to technology, yet it is one...
2019-07-22
23 reads
In preparation for my upcoming DevOps training days (see the bottom of this post for details) and for some articles I’m working on, I’ve been building all new automation...
2019-08-02 (first published: 2019-07-15)
348 reads
In order to take advantage of R and Python (and Java in SQL Server 2019) directly from your SQL Server scripts, you’ll be using the function sp_execute_external_script. When you...
2019-07-23 (first published: 2019-07-08)
718 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