I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs. In this post, we’ll be taking a look at a very handy combination of dbatools...
2025-05-21 (first published: 2025-05-13)
365 reads
This is one of those blog posts you write so that 2 years later, you can look it up to remind yourself how to do something.
I found myself needing...
2025-05-14 (first published: 2025-04-28)
437 reads
This month, I am hosting T-SQL Tuesday for the very first time. T-SQL Tuesday is a monthly blog party originally created by Adam Machanic in 2009 and currently curated...
2025-05-06
19 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Erik Darling
(blog) asks us to produce a video
You can talk about whatever...
2025-04-08
12 reads
I received a sobering reminder this week of a lesson we all have learned or should have learned long ago. Something I said online came back around months later...
2025-03-26 (first published: 2025-03-17)
386 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Deborah Melkin
(blog) asks us to talk about our relationship with mentoring and...
2025-03-11
20 reads
It seems like no matter how long you work with a system beyond a trivial size, you’ll find something new every so often. A little while ago, I found...
2025-02-26 (first published: 2025-02-17)
387 reads
The week of PASS Data Community Summit 2024 (November 4-8), Bluesky seemed to reach critical mass with the data community as well as the tech community writ large. Over...
2024-11-12
4 reads
Sometimes, work tasks and questions that come up in the SQL Server Community Slack coincide.
A couple weeks ago, DrData asked
With SET STATISTICS IO ON, is there really no way...
2024-10-07 (first published: 2024-09-22)
291 reads
First Things First Thanks to every who came to my session, Asnwering the Auditor’s Call with Automation. Slides and scripts are posted to my Github.
The Event! This was Syracuse’s...
2024-09-08
14 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