(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)
441 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
131 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)
447 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,114 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,018 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)
723 reads
(2020-Sep-13) Array of arrays, in a JSON world, it’s a very common concept to have a set of sets of other elements in a dataset. Despite how strange it may...
2020-09-21 (first published: 2020-09-14)
16,321 reads
(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF) may be a trivial task, but it gets more interesting when those elements are Arrays....
2020-08-25 (first published: 2020-08-14)
9,907 reads
(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 ...
2020-08-07 (first published: 2020-07-29)
961 reads
(2020-June-22) It's a noble act to develop a very cool database solution that will bring value to your customers. In addition to this, you can help...
2020-07-07 (first published: 2020-06-22)
2,118 reads
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This...
Hi all, In my company we have many databases encrypted with TDE and there...
Comments posted to this topic are about the item Create Raw Zone Tables using...
Comments posted to this topic are about the item Database DevOps Metrics
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers