An Introduction to Flowlets in Azure Data Factory (2024-02-19)

SQLServerCentral Newsletter for February 19, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [An Introduction to Flowlets in Azure Data Factory]( - [Tutorial: Using the hierarchyid Data Type]( - [From the SQL Server Central Blogs - Getting Started With SQL Server Always Encrypted]( - [From the SQL Server Central Blogs - Data Mesh Topologies]( - [Microsoft Power Platform Up and Running: Learn to Analyze Data, Create Solutions, Automate Processes, and Develop Virtual Agents with Low Code Programming]( Question of the Day - [Daylight Saving Time]( The Voice of the DBA  A Working Break on President's Day Today is [President's Day]( in the US, and it's a holiday for me. At least from Redgate. I'm actually working my other job, perhaps with some overtime. This is the end of a three-day weekend tournament up in Greeley, CO, where I've been coaching a 13-year old competitive volleyball team with my wife. We enjoy working with kids and we've been coaching in the spring for the last five years together. The [RMR Showdown]( is a fun event, and it's nice to get out of town. Hopefully we've had some success, but even if we haven't been winning, it's a good experience for the kids to grow, learn, and stress themselves across multiple days. Most of the time we do one-day local tournaments, so this is a chance for them to learn the eating well, hydrating, and sleeping are important. We've also had a pregnant coach in the 18s division, and it's entirely possible she can't coach this weekend. She was due around this time, so as I write this, my wife volunteered us to take over her team if she's giving birth. That means we'll be working a morning wave with our team, from around 7a-2p, and an afternoon wave from 3p-9p. There might be some long days for us, but they'll be fun. Despite the work, it's a recharging event for me in that I'm not doing anything with technology, and the time spent on this hobby is completely different than anything else in my life. It can be stressful during games, but it is very rewarding. I enjoy working with kids, and when it's over, it's over. The results of the competition are quickly forgotten, at least by me, but I see the lessons learned by players growing through the year. However, work starts again tonight. As soon as we're done, I'm heading to the airport for the [DevOps Airways tour](. No, I'm not flying a plane, but I am getting in one for our first stop tomorrow in San Jose. There are quite a few more, and I hope to see some of you at one of our events.   Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [An Introduction to Flowlets in Azure Data Factory]( arindamxs from SQLServerCentral Learn how you can re-use parts of your pipeline in Azure Data Factory. Save off some tasks as a flowlet for use in multiple pipelines. [External Article]( [Tutorial: Using the hierarchyid Data Type]( Additional Articles from Microsoft MSDN This tutorial is intended for users who are experienced with Transact-SQL, but are new to the hierarchyid data type. [Blog Post]( From the SQL Server Central Blogs - [Getting Started With SQL Server Always Encrypted]( Tim Radney from Tim Radney - Database Professional Azure SQL Database and SQL Server 2016 introduced a new security feature for SQL Server databases called Always Encrypted. Always Encrypted is a feature designed to protect sensitive data,... [Blog Post]( From the SQL Server Central Blogs - [Data Mesh Topologies]( James Serra from James Serra's Blog As a follow up to my blog Common Data Mesh exceptions, I wanted to discuss various types of data mesh topologies I am seeing being built. I put them... [Microsoft Power Platform Up and Running: Learn to Analyze Data, Create Solutions, Automate Processes, and Develop Virtual Agents with Low Code Programming]( Site Owners from SQLServerCentral The book begins with the basics, explaining what low-code and no-code are and showing how to maximize efficiency in creating business applications for one's organization. Next, the book describes the Microsoft Power Platform's foundation, as well as all its components and services. Readers will begin with practical exercises right away, beginning with provisioning a Power Platform environment. Next, the book delves deeper into the Power Platform components such as Power Apps, Power Automate, Power BI, and Power Virtual Agents. Towards the end, the book explains practical exercises for each feature or service where you will gradually build a small business solution for a fictitious organization, Project Wizards, Inc.   Question of the Day Today's question (by Alessandro Mortola):  Daylight Saving Time I have a Sql Server 2022 instance setup with '(UTC-05:00) Eastern Time (US & Canada)' as timezone and a PostgreSQL 16 cluster setup with 'America/New_York' as timezone; both of them have -05:00 as UTC offset. Given that in New York, in 2024 Daylight Saving Time will begin on Sunday, March 10, at 2 AM, what happens if I execute the following statements in their own environment? Sql Server: select dateadd(HOUR, 1, cast('20240310 01:00:00-05:00' as datetimeoffset(0))); PostgreSQL: select date_add('20240310 01:00:00-05:00'::timestamptz, '1 hour'::interval); Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Error_Severity() What is returned by the second SELECT when this is run? SELECT 1/0 SELECT ERROR_SEVERITY() Answer: NULL Explanation: A NULL is returned by ERORR_SEVERITY() outside of a CATCH block. Ref: ERROR_SEVERITY() - [ [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2012 - T-SQL [Row_Number issue....]( - Hi  I know I'm doing something wrong in my row_number logic, just not sure what.. My data looks like this coid    , caseoid   , date                     , RN 969284, 24066903, 2024-02-06 00:00:00.000, […] [Row_Number issue....]( - Hi  I know I'm doing something wrong in my row_number logic, just not sure what.. My data looks like this coid    , caseoid   , date                     , RN 969284, 24066903, 2024-02-06 00:00:00.000, […] [Row_Number issue....]( - Hi  I know I'm doing something wrong in my row_number logic, just not sure what.. My data looks like this coid    , caseoid   , date                     , RN 969284, 24066903, 2024-02-06 00:00:00.000, […] SQL Server 2019 - Administration [Additional Monitoring on RDS Sql Server]( - Hi,  Can someone let me know if we need to setup any additional monitoring on RDS Sql Server Instance. Enhanced monitoring is already enabled on this instance.  Thanks, [The audit file has not been deleted.]( - Hello I recently set up an audit on my server to track some connections. ,The audit works correctly without any problems. The only problem is that I get an error message like SQL Server can no longer delete This is how my audit configuration looks.he old audit file. Would anyone of you have an idea […] SQL Server 2019 - Development [How to import csv file]( - I'm trying to import this csv file but i am unsure how. The demo row has a bsu id and the rows below it are related to that id until another bsu id is shown. Any ideas on what I should do? I've been told it is similar to an 837 file.  I've attached […] [Can SSIS run C/C++ Script?]( - hi everyone I need a particular calculation done that is really hard to do in SS so I am using another program for it. The other program allows the code to be exported to C/C++ format. I know that SSIS can run C# code. Can it also run C/C++ code? thank you SQL Azure - Development [Working with views]( - Dears, Hope this message finds you well I would like to ask if there is any difference from a performance perspective between joining to make a View from two base tables, or if its better to create from each base table a like to like view and after, create the view which is a join […] Powershell [iterate through servers with drive names]( - $Drives = Get-PSDrive -PSProvider 'FileSystem' foreach($Drive in $drives) { #select largest file in given directory Get-ChildItem -Path $Drive.Root -Recurse -File -ErrorAction SilentlyContinue -Force | Sort-Object Length -Descending | #Select-Object -First 10 select -first 10 name, Length,fullname } ConvertTo-Html -Property Name,Length,FullName -Head $Header |Out-File E:\ServersL_$((Get-Date).ToString('MM-dd-yyyy_hh-mm-ss')).'html' Not creating a html file with data.Only empty html file. How […] [Code issue]( - A job step received an error at line 33 in a PowerShell script. The corresponding line is 'Get-WmiObject -ComputerName $serverName -query " '. Correct the script and reschedule the job. The error information returned by PowerShell is: 'Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) '. Process Exit Code -1. The step failed. The code […] Analysis Services [AAS models refresh through ADF Dynamically]( - Hi All, I am working on a solution to automate the Azure Analysis Service models (AAS models) through ADF. I will have json available either in a column of a tables or in a file. Currently i am testing with taking dynamic values from a table in ADF using Lookup activity and using those values […] [Passing dynamically changing Column values from one Power BI page to another]( - I have a report Page 1 in Power BI, where I have a table that has Load ID column. I have another page (Page 2), where I have a route map related to the Load ID selected on the slicer. The 2 Load IDs in these two pages come from 2 different SQL views, but […] SQL Server 2022 - Administration [CX WAITS - DOP SETTINGS]( - Hi I have a job that calls a stored proc. Every since we updated to SQL2022 (running in 140 compatibility mode) I've noticed that this and other similar procs produce a CX_PORT wait. They do this every time they run and if I check who is active there are no deltas records being moved at […] SQL Server 2022 - Development [Comparison of varchar data from two different tables]( - I need to find Generic_Code from the table. Data in Length_Min, Length_Max, and Length columns are varchar data. The query is not return any data. Length contains '00:15:18' so my query has to pick up Generic_Code = '3000623WVD'. I am wondering what am I doing wrong here. The first subquery returns all five rows instead […] [Query Performance Tuning]( - Dear all, Thank you for looking into my question. I have a table with 7.2 million records (table size 3 GB, Index size 1.6 GB). It has about 7 non-clustered indexes and a clustered index and the statistics are up-to-date. I wrote a query to have a foreign key lookup from the table above. The […]   [RSS Feed]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -