(2021-Feb-15) This post a continuation of my personal experience working with arrays (or simply JSON structures) in Azure Data Factory (ADF). It just happened that the more I work with...
2021-02-23 (first published: 2021-02-15)
8,955 reads
(2021-Feb-07) "You've Got a Friend in Me" is a well-known song written by Randy Newman and featured in one of Disney's animated films. If I hadn't had a chance...
2021-02-15 (first published: 2021-02-07)
212 reads
(2021-Jan-31) Working on DIY home projects is always fun, choosing the right tools: whether I handle paperhanging scissors to cut my wallpapers, or create an opening and trim my drywall...
2021-02-10 (first published: 2021-02-01)
253 reads
(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach a crossroad with a large stone that had some directions written on it – turn...
2021-01-26 (first published: 2021-01-19)
220 reads
(2021-Jan-12) Small data that is hard to be noticed but in a long run makes the greatest impact, little things that are not well apricated but eventually become those final...
2021-01-20 (first published: 2021-01-12)
442 reads
(2020-Dec-31) PASS (formerly known as the Professional Association for SQL Server) is the global community for data professionals who use the Microsoft data platform. On December 17, 2020 PASS announced...
2020-12-31
134 reads
(2020-Dec-21) While working with Azure Functions that provide a serverless environment to run my computer program code, I’m still struggling to understand how it actually works. Yes, I admit, there...
2020-12-31 (first published: 2020-12-21)
450 reads
(2020-Oct-14) Ok, here is my problem: I have an Azure Data Factory (ADF) workflow that includes an Azure Function call to perform external operations and returns output result, which in...
2020-10-23 (first published: 2020-10-15)
1,121 reads
(2020-Oct-05) Adding a row number to your dataset could a trivial task. Both ANSI and Spark SQL have the row_number() window function that can enrich your data with a unique...
2020-10-12 (first published: 2020-10-05)
8,250 reads
(2020-Sep-26) Last week one of my Azure Data Factory (ADF) deployment pipelines failed with an error that it couldn’t find some of the deployment parameters that I try to override,...
2020-10-05 (first published: 2020-09-26)
741 reads
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
I wanted to try out the new JSON index which is for the moment...
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
Comments posted to this topic are about the item Learning a New Language
Hi, we have a few people who like to experiment on our prod sql...
Comments posted to this topic are about the item Guidelines and Requirements
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers