One of the things I’ve tried hard to do in database development situations if ensure I could easily refresh dev and test environments on demand. In a small startup,...
2026-03-13 (first published: 2026-03-11)
13 reads
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as cloud adoption has matured, I’ve come to realise that building and running great systems isn’t...
2026-03-12
12 reads
In the realm of software development and content creation, the deployment pipeline serves as a crucial bridge between innovation and implementation. Whether you are fine-tuning code, testing new features,...
2026-03-11 (first published: 2026-03-03)
245 reads
Quite the title, so let me set the stage first. You have an Azure Data Factory instance (or Azure Synapse Pipelines) and you have a couple of linked services...
2026-03-11 (first published: 2026-03-03)
294 reads
This T-SQL Tuesday is hosted by the one and only James Serra – literally my go-to guy for data lakes and BI architecture. I am so tickled to be...
2026-03-10
10 reads
The T-SQL Tuesday topic this month comes James Serra. What career risks have you taken? I started my career as a preacher and ended it as a director in...
2026-03-10
18 reads
This month we have a new host, James Serra. I’ve been trying to find new hosts over the last few years to keep this party going and to expand...
2026-03-10
11 reads
A while ago I blogged about a use case where a pipeline fails during debugging with a BadRequest error, even though it validates successfully. If you’re wondering, this is...
2026-03-09 (first published: 2026-03-06)
54 reads
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today on Day 4 I would like to write about the Transformer architecture — the foundation...
2026-03-09 (first published: 2026-03-04)
11 reads
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7 we would learn about Vectors and Vector Databases. this is a place where AI data...
2026-03-09 (first published: 2026-03-07)
25 reads
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers