Last week, Kerry and I delivered a webinar with tips on how to set up your Data Factory. We discussed version control, deployment, naming conventions, parameterization, documentation, and more....
2021-09-24 (first published: 2021-09-16)
170 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-16
34 reads
As with all programming tasks there are a number of ways to do something, this is just one that I ... Continue reading
2021-09-27 (first published: 2021-09-16)
557 reads
It look like we had a little bug in sp_RestoreScript that was putting a rogue 0 after the backup file name. That’s now been fixed in 1.9. For information...
2021-09-16
80 reads
By Argenis Fernandez
This post is archived here. Pleae reach out to me, Anthony Nocentino if you have any questions.
I gotta admit, some of you are really hard to convince....
2021-09-15
45 reads
As long-time readers of this blog know, I’m a big fan of temporal tables, also known as system-versioned temporal tables. Until recently, temporal tables were synonymous with system-versioned tables,...
2021-09-15
282 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-15
37 reads
Over the next few weeks I have again some online training and speaking engagements that I want to share with you today: On September 29, I’m speaking at the...
2021-09-15
7 reads
Over the next few weeks I have again some online training and speaking engagements that I want to share with you today: On September 29, I’m speaking at the...
2021-09-15
5 reads
Over the next few weeks I have again some online training and speaking engagements that I want to share with you today: On September 29, I’m speaking at the...
2021-09-15
6 reads
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Hub Via Wa:62817825533 Alamat: Jl. Pantai Indah Kapuk Utara I Blok F, RT.6/RW.2, Kamal...
Hub Via Wa:62817825533 Alamat: ABC dan 11 H, Jl. Pangeran Tubagus Angke No.10, RT.14/RW.11,...
Hub Via Wa:62817825533 Alamat: Jl. Enggano No.22-23, RT.8/RW.16, Tj. Priok, Kec. Tj. Priok, Jkt...
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers