How to Implement CI/CD in Azure Data Factory (ADF) (2023-03-10)

SQLServerCentral Newsletter for March 10, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [How to Implement CI/CD in Azure Data Factory (ADF)]( - [On-Demand Webinar - Monitoring: The ROI of Build vs. Buy]( - [SELECT DISTINCT SQL Command to Return a Unique List of Values]( - [From the SQL Server Central Blogs - Adding a Computed Column–#SQLNewBlogger]( - [From the SQL Server Central Blogs - SQL Saturday Atlanta 2023 Recap]( - [SQL Server 2022 Revealed: A Hybrid Data Platform Powered by Security, Performance, and Availability]( Question of the Day - [Locating the PVS]( The Voice of the DBA  Daily Coping Tip Notice three things you find beautiful in the outside world I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. How Normal Is Your World? The last three years have felt like a bit of a time warp. I'll run into someone or reach out to a friend, thinking that I haven't talked to them in a year or two. Then I realize that it's been 4 or 5 years because the 2020-2022 time frame felt like a year or less. A long year, but still, less than the three years that passed. Life is mostly back to normal for me, with travel, events, vacations, coaching, work, etc. all similar to the way things were in 2019. At the same time, I've changed and my life has changed. Some of this is aging, some is life moving on, but some is from the pandemic. Spending so much time remotely has me a little less patient or excited about small trips, even around town. I cook more and my family is more often at home. My adult kids enjoy spending time with my wife and me. I appreciate family and time off more, which was good. These are positives for me. Work is similar to 2019, but also different. Redgate is moving to a new, smaller office, and the culture of most people being there and eating lunch together is gone. We won't have our SQL Servery in the new building, so I'll be going out with friends, or bringing some sort of meal in when I'm at the office. I don't like that. I still get to visit customers, and more so this year than in prior years, but there are a lot more Zoom meetings and short, quick engagements than in the past. That's a good thing, and I find it exciting. At the same time, we have fewer events. Last year saw 18 SQL Saturdays, and we're on pace to exceed that this year, but we're far below the 100 a year from 2019, even adding in Data Saturdays and other events. Every event seems smaller than in the past, which is a bit disappointing for me. Some people still wear masks, signs from the pandemic are still posted, and I find people to both be better and worse. They are more enjoyable at times, but at other times displaying more anger, argument, and selfishness than before 2020. It's a weird mix, and I think the pandemic has people quicker to get upset at little things while being more tolerant in general. In general, the world feels normal to me, but slightly evolved from 2019. Is life back to normal for you? It mostly is for me, though with one big difference. I appreciate life more, the people, the trips, the time, it all means a bit more after spending a few years fairly isolated and limited in many ways. Let us know today. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [How to Implement CI/CD in Azure Data Factory (ADF)]( diponkar.paul from SQLServerCentral Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates. [External Article]( [On-Demand Webinar - Monitoring: The ROI of Build vs. Buy]( Additional Articles from Redgate Missed our recent webinar on ‘Monitoring: The ROI of Build vs Buy’? Catch up on demand and find out the pros and cons to building a monitoring system versus purchasing one. Watch now! [External Article]( [SELECT DISTINCT SQL Command to Return a Unique List of Values]( Additional Articles from MSSQLTips.com Learn about the SELECT DISTINCT SQL command to return a unique list of values from SELECT queries along with several examples. [Blog Post]( From the SQL Server Central Blogs - [Adding a Computed Column–#SQLNewBlogger]( Steve Jones - SSC Editor from The Voice of the DBA Recently I needed to add a computed column to a table and realized that I didn’t remember the syntax. This short post show how to do this. Another post... [Blog Post]( From the SQL Server Central Blogs - [SQL Saturday Atlanta 2023 Recap]( DataOnWheels from DataOnWheels This past weekend, I had the pleasure of attending and speaking at SQL Saturday Atlanta! If you’re in the area, I highly recommend connecting with the local user group... [SQL Server 2022 Revealed]( [SQL Server 2022 Revealed: A Hybrid Data Platform Powered by Security, Performance, and Availability]( Additional Articles from SQLServerCentral Know how to use the new capabilities and cloud integrations in SQL Server 2022. This book covers the many innovative integrations with the Azure Cloud that make SQL Server 2022 the most cloud-connected edition ever. The book covers cutting-edge features such as the blockchain-based Ledger for creating a tamper-evident record of changes to data over time that you can rely on to be correct and reliable.   Question of the Day Today's question (by Steve Jones - SSC Editor):  Locating the PVS In a new SQL Server 2022 database, I want to enable Accelerated Data Recovery (ADR) to speed up recovery time. If I run this, where is the Persistent Version Store (PVS) located? ALTER DATABASE VeryImportantDB SET ACCELERATED_DATABASE_RECOVERY = ON 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) Deterministic Encryption Operations In Always Encrypted, which of these operations are allowed with deterministic encryption? Answer: Equality (=), IN, GROUP BY, and DISTINCT only Explanation: You can use the equality, IN, GROUP BY, and DISTINCT operations with deterministic encryption. Ref: Always Encrypted Limitations - [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 2017 - Administration [Missing perf-MSSQLSERVERsqlctr.ini]( - I attempted to install the latest CU (31) for my SQL 2017 server but received an error message stating "Service Pack Failure: MissingRegistryKeyException" due to a missing registry key. It appears that our SQL server is missing certain performance counters as I was only able to retrieve 57 row records after executing the command "select […] SQL Server 2017 - Development [Transaction has no commit error]( - All, I have an unusual scenario. A developer sent me some code that has a BEGIN / COMMIT and a rollback right before the commit. It's all wrapped in a reasonable TRY...CATCH. The script builds some dynamic SQL INSERT statements using OPEN_QUERY, dynamic because the WHERE clause depends on some variables. The INSERT statements they […] SQL Server 2016 - Development and T-SQL [How to remove special chars?]( - Hi everyone, So I have a xml file from which I am trying to import data into my sql tables. I noticed there are some special characters inside the file due to which I am unable to import data properly. Look at the below screenshot: Can anyone tell me what are there square boxes and […] [Error trying to add columns to code]( - Hi there. Thanks for code from my previous post and so many good working options. Now I want to add 2 new columns and it gives an aggregation error. Appreciate any help. From this table, I have the code that selects the latest doctor visit record using the MAX function. If latest client record is […] SQL Server 2019 - Administration [SSMS is filling up our C: drive -- installed on E:]( - Good day. I didn't know where else to post this, so forgive my ignorance if this isn't the place. I have a situation that involves a single Windows Server with SSMS installed that has the only permissions to hit another organization for our Data Warehousing team. There may be as many as 4 BIDS plus […] [Trigger on update when changed only desired XML tag.]( - Hello! I have a task to configure for the Skype for business database logging of user status changes (Available/Away/Offline/etc). i found source for this data in XML field with content like: 15500 [To get a list of un-used columns in all tables in a database]( - I am looking to get a list of un-used columns in all tables in a database. I would like the output to look like something like this. DatabaseName, SchemaName, TableName, ColumnName, etc If anyone has a handy script or any link, please share. Thanks. [DBNETLIB] [ConnectionOpen (SECDoClientHandshake()).] SSL Security Error]( - Hi New server with SQL version 2019 has been created to host a DB for a Legacy App to use. This is working fine. The App has not changed. I need to get this working on a test Server. Test Server with 3 instances on it 1. Version 2014, Development edition uses port 1433 2. […] [Hash Match performance issue]( - Hi I have a stored proc that is performing badly. When I look at the execution plan I can see a couple of instances where there are a large number of rows inputted into a hash match but the output is estimated to be only 1 row. The inputs into the hash match below are […] SQL Server 2019 - Development [SQL Query to display having only values]( - I am having below -mentioned table1 and I would like to display it as shown in the below table Can someone help me with the query Thanks in advance [SELECT with computed values]( - From a huge and ever growing table (tbl_Values) I need to select all records which conform to rules defined in another table (tbl_Rules). Each record in tbl_Values has a time_stamp (datetime) and a fvalue (float); the rules defined in tbl_Rules have a WeekDay (int), a HourOfDay (int), a MinValue (float), a MaxValue (float). Records from […] Relational Theory [RIGHT-JOIN table not fetching all rows in WHERE clause]( - I'm trying to add an additional table (hrxoreturn) with RIGHT JOIN to return all records either with matching or no matched records to other tables. When i exclude "count(distinct hrxoissue.issuedte)as 'Total Count per RX'" , the fetched rows goes to 49 rows reading all the count in hrxoreturn table, but if i include count on […] SQL Server 2022 - Development [Case and When Query]( - Hi All, I want to rewrite the below query using the Case and When statement Query 1 update [SF_Title_Update] set [Title_Proper]='Human Resource Management System Manager' from [SF_Title_Update] where ( title like '%Human%' and title like '%Resource%' and title like '%Management%' or title like '%HRMS%' ) and (job_level='Manager Level' ) and( [Title_Proper]=' ' or [Title_Proper] is […] [Dynamic Query]( - Hi All, I have to generate a dynamic query for the below mentioned keywords to update them in Title_Update column Keywords Recruitment Employee Engagement Performance Management Training and Development Compensation and Benefits Human Resource Diversity and Inclusion Also it should have the below mentioned Job Level Chief Level Director Level Head Level Manager Level Managing […] [Use a flag, or calculate, to retrieve counts]( - I'm working on a Holiday Leave system (for typically several hundred or more personnel). Currently, a person may request leave (in the future) and each Leave request can have one of a number of Status values: Pending Approval Approved Declined Cancelled There is a report required to sum up these totals for an individual, broken […]   [RSS Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -