Daily Coping 5 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-05-05
26 reads
Blog Posts
SQL Prompt Fixes Always Have an Else
SQL Prompt is a fantastic coding aid, but it does more than format your code and provide intellisense. Over time, the team has enhanced SQL Prompt to also guide...
2020-05-05 (first published: 2020-04-22)
285 reads
Stacking Up Datasets in Azure Data Factory
(2020-Apr-24) Using UNION SQL operator is a very common practice to combine two or more datasets together, it helps to create a single result set from many sourcing ones. Azure Data...
2020-05-05 (first published: 2020-04-24)
425 reads
Daily Coping 4 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-05-04
44 reads
Database Fundamentals #24: More Filtering Data
In this Database Fundamentals post we continue discussing the functionality of the WHERE clause. We started with the basics of the logic using things like AND, OR and LIKE...
2020-05-04
117 reads
Decoded Statistics Names and More
Auto-generated statistics names can seem like they are entirely random, but there is a method to the madness. With a little effort and a bit of TSQL trickery, we...
2020-05-04 (first published: 2020-04-17)
630 reads
Improved Windows Terminal Setup
I’ve long been a Cmder/ConEmu user for Windows as it’s provided a much-needed improvement of the standard Windows terminal.
I’ve started trying to use the newer Windows Terminal project to...
2020-05-04 (first published: 2020-04-20)
372 reads
SQL Homework – May 2020 – Forum Lurking.
A few months ago I suggested writing blog post(s) as a great way to learn and document your progress (among ... Continue reading
2020-05-04
30 reads
Stairway to Microsoft Azure SQL Database Part 2 : Purchase Models DTU vs vCore
In the last post, we have discussed about different deployment options available with Azure SQL server. I hope you got a good understanding of various deployment models. In this...
2020-05-03
20 reads
Stairway to Microsoft Azure SQL Database Part 2 : Purchase Models DTU vs vCore
In the last post, we have discussed about different deployment options available with Azure SQL server. I hope you got a good understanding of various deployment models. In this...
2020-05-03
739 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Alamat BCA KCU Gading Serpong Tlp:08218154374
Hub Via Wa:628218154374 Alamat Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster...
Alamat BCA KCU Tangerang City Telp:08218154374
Hub Via Wa:628218154374 Alamat Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20,...
Alamat Kantor BCA KCU Serang Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Pangeran Diponegoro No.14, Kotabaru, Kec. Serang, Kota Serang, Banten...
Question of the Day
Backing Up a DMK
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