Working with the Delete Activity in Azure Data Factory (2021-09-27)

SQLServerCentral Newsletter for September 27, 2021 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Working with the Delete Activity in Azure Data Factory]( - [SQL Server VM Best Practices]( - [Why pay for open-source software?]( - [From the SQL Server Central Blogs - #PowershellBasics: Running a .sql script file.]( - [From the SQL Server Central Blogs - My upcoming Online Trainings and Speaking Engagements]( Question of the Day - [Current Symmetric Key Algorithms]( Featured Script - [Import Multiple Packages to SSIS server]( The Voice of the DBA  Daily Coping Tip Experiment with a new healthy recipe today for a meal 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. Making Software Decisions I work for a company that builds software. At Redgate, we are constantly debating what to build and how, and more importantly, how to structure something that is easy for our customers to use. There's a lot that goes into the process of building software, way more than I thought was important a decade ago. Today, even when I don't like the decision or the final result in a product, I know our process often produces good results. Recently Netflix started [a new series on how they make decisions]( for their software. It's interesting in that they note that of all the ways they can make decisions, most of these involve few people. This leads towards their premise of using lots of A/B experimentation for helping to make decisions, and I look forward to future parts of the series that might explain the weight that they give to the results of A/B testing. How do you decide what decision makes the most sense for your business? I often see technology professionals being very passionate about how or why something should be implemented. I also think that sometimes we lend more weight to the passion and the arguer, rather than the merits of the particular thing being examined. It's easy to give in and go with the group, or not care, about many software decisions. For me, I've learned to try and give feedback, justify this with some rationale, and then trust the process. No matter how "right" I think I am, we are a team, and if the decision is made to go a different way, I support that. I've also learned that building software involves a lot of tradeoffs, especially with regard to the prioritization of work. There's always more work to do than can be completed by our staff, no matter what the size of the team. I find the process of building commercial software to be fascinating and I've learned a lot in the last few years about how to make the process successful. I've also learned what Netflix talks about. A small group has a very limited viewpoint and it's worth gathering more data whenever possible to ensure you make a decision that has a positive impact on your software. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Working with the Delete Activity in Azure Data Factory]( arindamxs from SQLServerCentral Introduction We can use the delete activity in Azure Data Factory to delete files from both on-premises and cloud storage. In this article, we will discuss the delete activity with the various options available for the file deletion. I will show the following operations with the Delete Activity: Delete files from a folder. Delete contents […] [SQL Server VM Best Practices]( Additional Articles from MSSQLTips.com In this article we look at some of the things you should be aware of when building a VM to run SQL Server, such as vCPUs, disks, memory and more. [Why pay for open-source software?]( Additional Articles from Redgate The very definition of open-source software means that developers can change the code, which means that exclusive, paid, licensing is not a part of the deal. In short, open-source is free. Free of licensing anyway. So, why might you choose to pay for an open-source software like Flyway? Grant Fritchey explores. From the SQL Server Central Blogs - [#PowershellBasics: Running a .sql script file.]( Kenneth.Fisher from SQLStudies As with all programming tasks there are a number of ways to do something, this is just one that I ... Continue reading From the SQL Server Central Blogs - [My upcoming Online Trainings and Speaking Engagements]( Klaus Aschenbrenner from Klaus Aschenbrenner Over the next few weeks I have again some online training and speaking engagements that I want to share with you today: On September 29, I’m speaking at the...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Current Symmetric Key Algorithms What symmetric key algorithms are supported in SQL Server 2019 for the CREATE SYMMETRIC KEY DDL at the SQL Server 2019 database compatibility level? 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) The OPENJSON return schema What items do I need to include in the WITH clause of OPENJSON() to define a schema? Answer: A name, data type, and JSON path are required Explanation: A name, datatype, and JSON path are needed. Ref: OPENJSON - [Discuss this question and answer on the forums](  Featured Script [Import Multiple Packages to SSIS server]( sagarSQLDBA from SQLServerCentral We cannot import multiple packages on the SSIS server. So, loading 100 packageS from file location will be a tedious task for a DBA. We can solve this issue by making use of the DTUTIL utility. The DTUTIL utility can also import one package at a time, but we can write the batch file using the […] cd C:Package_loacation FOR IN (*.dtsx) DO DTUTIL /FILE C:Package_loacation /COPY SQL;Folder_location_SSIS_serverni /QUIET [More »](  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 [Full Recovery Database restores as Simple Recovery]( - Ran into an issue that caused me some issues. It seems that when I backup a database that is in FULL recovery mode and restore it to a different server (just did a large migration to new servers), the database restores in to SIMPLE recovery mode. Before SQL 2017, I never saw this behavior, what […] SQL Server 2017 - Development [need help on query]( - Hi all, need help on below requirement. Thanks, Abhas SQL Server 2016 - Development and T-SQL [Reducing Temp Table Scans when joining two temp tables using OR conditions]( - Hi all. I have also posted this on DBA Stack Exchange, but I'm posting here because this community is pretty amazing. If this is not allowed, I will remove. I'm working on a complicated query that I have up to this point been able to refactor to reduce execution time as well as number of […] Development - SQL Server 2014 [Invalid cursor state]( - HI, Version : Microsoft SQL Server 2014 (SP3-CU4-GDR) (KB4583462) - 12.0.6433.1 (X64) I have a real basic stored proc that inset data to a table. application is calling it via ODBC. Sometime application receive following error sometime not. SQL Error: The statement could not be executed directly - [Microsoft][ODBC SQL Server Driver]Invalid cursor state I […] SQL 2012 - General [Can't attach MDF and LDF files]( - Hi All When I tried to attach my mdf and ldf file , I got error saying " The process cannot access the file because it is being used by another process. How do I solve this issue ? Your feedback is much appreciated.  SQL Server 2019 - Administration [question about username dbo]( - I have been asked to revoke access from a few developers in SQL Server - basically we want them to be able to read anything, but deny them access to alter objects or data. The users in question are granted access as part of an AD group. So my thought was to create a user […] [Turning ON TDE Encryption that previously had backups encrypted prior to TDE]( - In our environment we have been encrypting our backups for years. We now have a requirement to turn TDE on our Databases and I was trying to determine if turning on TDE would impact our encrypted database backups. I understand that in order to restore a TDE Enabled database to another server that the certificate […] SQL Server 2019 - Development [Problem with SUM and GROUP BY clause connection]( - Hello friends, I will appreciate if someone can help me to sum and later group fields correctly. I almost have the result that I need. However, i noticed that there are a couple of fields where for some reason two columns were not summed therefore not grouped. I was trying to research this topic online […] [The actual file SQLServerManager15.msc is missing from my computer]( - I did a fresh install of Windows 10 Pro and loaded SSMS on it. My database is on a different computer so I was going to connect through TCP/IP. I have done it before but I refreshed my memory by looking it up on Google. It told me that I had to find the file […] [Issue with the format of calculation]( - Hello friends, This issue is a little hard to explain, but I hope you will be able to understand what I am trying to ask. I believe my issue is that I format the formula in SQL incorrectly. I need to have such a calculation namely f.TOTHIST / (f.TOTFCST - f.TOTHIST) - 1 which will […] [SQL to display HTML for Dropdown]( - I have created a webpage with a form that allows people to register for an event. The event will occur on the same day at three different times, 10am, 1pm, 3pm. The event is limited to 10 people per time slot. I'm trying to write a query that generates the HTMLtag based on […] General Cloud Computing Questions [Difference between SaaS and web application?]( - I'm currently interested in self-hosting and I recognized that mostly it's about alternatives for SaaS. But not always classical SaaS are targeted (e.g. Home Assistant, IoT, Blogging Platforms). What is the difference between web applications and cloud? I'm not a tech-savvy maybe it's still possible someone could explain me the core differences. Thanks in advance. Azure Data Factory [Azure data factory tutorials]( - Hi all I was wondering if anyone knows where to go for help with azure data factory. I'm trying to use a derived column to create a column from data in another column. The problem is I don't know how to write the expression or where to look for help. The azure documentation isn't clear […] Powershell [Email send issue]( - I getting an error try to use this piece of code. Error: Send-MailMessage : An invalid character was found in the mail header: ','. Thanks. $messageParameters = @{ From = "xxxx@xxx.com" To = "xxx@xxx.com,yyy@yyy.com,zzz@zzz.com" Subject = "DBLocks " Body = "Job Status" SMTPServer = "xxxxxx" Attachments = $file.FullName} Send-MailMessage @messageParameters Suggestions [Page number in forum topic]( - Hi all. I’m not even sure if this is the right section to post this question but I have a small suggestion for the forum. Since we have a huge number of threads and topics that lead to multiple pages of threads, why can’t we be able to choose a specific page number among hundreds […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -