Daily Coping 10 Aug 2020

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...

Fixing Broken Pip

I’ve got Python 3.8 on my machine, and recently I got a note that my pip version was old. I tried to upgrade PIP recently with this command: c:python38python.exe...

How to Iterate Through A List of Objects with Terraform's for_each function

What I want to do
# create file local.users.yml
user:
- name: foobar1
email: foobar1@foobar.com
- name: foobar2
email: foobar2@foobar.com
- name: foobar3
email: foobar3@foobar.com

locals {
users_file = "local.users.yml"
users_file_content =...

Should I Transform My Data In My SQL Query?

Watch this week’s video on YouTube. Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values...

What you need to know About Azure SQL backup

Most of DBA are coming from On-premise Database Servers they know very well How we can manage SQL backup using SQL Server native backup or even using SQL Server...

Adding a FK to a Table–#SQLNewblogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One thing that helps ensure your data is...

Daily Coping 7 Aug 2020

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...

Proud to present at this year’s VMworld 2020 conference

I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is going online due to COVID-19. I’m presenting a new session called “Architecting SQL Server Workloads...

Social: Respecting Names

This is a non-technical post, and my opinion. If you don’t want to read it, please ignore future posts with “Social:” at the start of the title. My nickname...

Transforming JSON data with the help of Azure Data Factory - Part 5 - Comparing it with Databricks

(2020-July-29) There is a well known and broadly advertised message from Microsoft that Azure Data Factory (ADF) is a code-free environment to help you to create ...