For the better part of 15 years, SQL Server Integration Services (SSIS) has been the go-to enterprise extract-transform-load (ETL) tool for shops running on Microsoft SQL Server. More recently,...
2020-07-28 (first published: 2020-07-16)
735 reads
I’ve 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...
2020-07-28
11 reads
In my last Management Studio tip, I demonstrated how you can drag and drop column names to a query window. The only part I do not like about that...
2020-07-28
29 reads
In my opinion, SQL Server 2019 is one of the greatest releases of the product that Microsoft has ever produced. The amount of improvements across the platform really allows...
2020-07-28 (first published: 2020-07-17)
1,088 reads
Again, still we have a lot of information we can spread our knowledge on it for Cosmos DB today I will talk about Cosmos DB API options and How...
2020-07-27
12 reads
One of the challenges I have at times is illustrating how I’d set up a particular system. Not the technical details, the visual ones. I can use boxes and...
2020-07-27
70 reads
I’ve 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...
2020-07-27
38 reads
I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way.
In this episode I share...
2020-07-27 (first published: 2020-07-16)
947 reads
I used to think that Docker Compose was used solely to spin up multiple containers, in fact I blogged about doing just that here. That opinion changed when I...
2020-07-27 (first published: 2020-07-17)
1,560 reads
Since SQL Server 2016 we could leverage Microsoft Azure to dynamically move “cold” portions of data away from on-premises storage for longer retention time periods. Whilst in theory being...
2020-07-27
45 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:628217555651 Alamat: Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd....
Hub Via Wa:628217555651 Alamat: Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec....
Hub Via Wa:628217555651 Alamat: Jl. Kisamaun No.57, RT.001/RW.006, Sukasari, Kec. Tangerang, Kota Tangerang, Banten...
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