SAP S/4HANA and Microsoft Azure SQL Integration and Hard Deletion Handling (2022-10-31)

SQLServerCentral Newsletter for October 31, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [SAP S/4HANA and Microsoft Azure SQL Integration and Hard Deletion Handling]( - [How SQL Monitor gives developers the information they need to develop faster and smarter]( - [SQL Cheat Sheet for Basic T-SQL Commands]( - [From the SQL Server Central Blogs - Granular Cost Management for Azure Data Factory]( - [From the SQL Server Central Blogs - Where did this database come from??]( Question of the Day - [The Scariest Data Type]( The Voice of the DBA  Daily Coping Tip Find a new perspective on a problem you face 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. A Scary Situation Today is [Halloween](, a holiday of costumes, candy, and scary movies. My family has enjoyed scary movies over the years, though not necessarily on this date. However, the theme has me thinking about the scary situations that you've encountered, or maybe those that worry you in your job. I don't worry about too many scary things in my job. I do get some anxiety before some presentations, and there are times I've been nervous before recordings, but it's helpful for me to remember that none of these things are likely to be remembered for long if I do. That didn't help me when I gave a keynote at the Rocky Mountain Tech Trifecta years ago. Most of the 600 people in the audience didn't bother me, but my wife was there to see me for the first time and that was scary. I had to talk to myself before I went on, reminding myself to relax and just deliver the talk I'd prepared. Fortunately, I didn't mess it up and she enjoyed it. As a developer, I haven't been too scared when writing or deploying code. I came into this business watching so many bugs get thrown over the wall and deployed that I rarely worried something I submitted would have bugs. I knew there would be bugs in some code, and it wouldn't be a big deal. Others would have reviewed my code and when a bug report came back, I'd just write new code that solved that bug (and hopefully didn't introduce others). As a DBA, the scariest times are when you actually have to restore a database that matters. I've had CEOs, VPs, CTOs, and plenty of managers in between staring over my shoulder, asking questions or commenting on the importance of the act. When you're bringing back a database with a bunch of log files, that creates some pressure and stress. Lucky for me, I've been able to perform well in those situations. If I hadn't, perhaps I'd have never started writing or built SQL Server Central. What are your scary stories today? What things make you nervous or create some anxiety? I think the scariest times I've had in a few jobs were when companies were reorganizing and looking to lay off a portion of their staff. Those are never good days, and while I usually survived, the stress before knowing the results was very scary. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [SAP S/4HANA and Microsoft Azure SQL Integration and Hard Deletion Handling]( Surendra Kumar Reddy Koduru from SQLServerCentral This article shows how one can use SSIS to find differences in SAP. [External Article]( [How SQL Monitor gives developers the information they need to develop faster and smarter]( Additional Articles from Redgate Leading Danish pharmaceutical company, Orifarm, has a mission to be 'Number 1 in making healthcare a better deal'. Find out why they chose SQL Monitor to give their whole IT team, developers included, the real-time metrics they need to highlight development issues and resolve them before they become problems. [External Article]( [SQL Cheat Sheet for Basic T-SQL Commands]( Additional Articles from MSSQLTips.com In this article, we cover some basic T-SQL commands that show you how to interact with a SQL Server database table. [Blog Post]( From the SQL Server Central Blogs - [Granular Cost Management for Azure Data Factory]( Koen Verbeeck from Koen Verbeeck A new feature has been launched that allows you to have more granular control over the execution costs of your pipelines. By enabling the feature, you have a cost... [Blog Post]( From the SQL Server Central Blogs - [Where did this database come from??]( gbargsley from GarryBargsley Happy Tuesday, blog reader. Have you ever come across a database you had not seen before or was in a different naming convention than you are used to seeing?...   Question of the Day Today's question (by Steve Jones - SSC Editor):  The Scariest Data Type What's the scariest data type in SQL Server? 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) Terraform Targets Someone asks me to use Terraform to define the types of infrastructure our organization needs in the cloud. With which cloud providers can I use Terraform scripts? Answer: Azure, AWS, Google Cloud Platform (GCP), and others Explanation: Terraform codifies the cloud APIs and works with any of the major cloud providers. Ref: - Terraform Basics - - Terrform Providers - [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 [Publish AWS RDS SQL Server Database]( - I am in the process of migrating an on-premises application to AWS. The on-premises app publishes a SQL Server db, subscribed to by a couple of other servers in our environment. I am struggling to find a way to replicate that functionality in AWS RDS SQL Server. Lots of guides on replicating into RDS, but […] [Get Read and Writes per a duration]( - Hello, I want to be able to view the number of read and writes for a database or (tables in the database) in a day or week or month. Currently, I am using the following query: SELECT name AS 'Database Name' ,SUM(num_of_reads) AS 'Number of Read' ,SUM(num_of_writes) AS 'Number of Writes' FROM sys.dm_io_virtual_file_stats(NULL, NULL) I […] SQL Server 2017 - Development [Update Column query]( - Hi All. Need help in implementing this logic. I have a table in below format. Currently, a new Config ID is generated for every item number- Revision combination. I want to take the config ID of minimum(Revision) for every item number and update it per item number. Expected Config ID is desired output. It is […] SQL Server 2016 - Administration [Patching AlwaysOn AG]( - Hello Everyone, I have Availability Group, one primary replica and one secondary replica. SQL Server version is 2012. It is configured for automatic failover and is in synchronous mode. I already googled but found different answers, so I want to know the correct procedure. How to do patching step by step. SQL Server 2016 - Development and T-SQL [Create table having a StartDate and EndDate for each week]( - I want to create a table that has a StartDate, EndDate, WeekNum for the year 2021 starting with the First Wednesday of January to the end of December ( I know the last week may land in 2022, that's fine). So in 2021, the first wednesday is January 6. So the table would start with […] [SQL server help]( - I need to show the total count for a particular field with my select statement. But this should be shown only once for each VID. I wrote the following to get the count, but it displays it for every record. Is there away to display it only in one row for a specific VID? I […] [SQL 8144. Error: Procedure \'InitiateLoad\' has too many arguments specified.]( - Hi Community, When I attempt to execute the following Procedure called InitiateLoad, I get the error: Sql error number: 8144. Error Message: Procedure or function InitiateLoad has too many arguments specified. Can someone take a look at the SQL Code and let me know where the problem is:  CREATE PROCEDURE Process.InitiateLoad (@Area VARCHAR(150), @Domain […] [SQL 8144. Error: Procedure 'InitiateLoad' has too many arguments specified.]( - Hi Community, When I attempt to execute the following Procedure called InitiateLoad, I get the error: Sql error number: 8144. Error Message: Procedure or function InitiateLoad has too many arguments specified. Can someone take a look at the SQL Code and let me know where the problem is:  CREATE PROCEDURE Process.InitiateLoad (@Area VARCHAR(150), @Domain […] [Capturing what calls a trigger]( - I have a DML trigger and I need to know where the action is being called from, whether it be a simple T-SQL command or a stored procedure. For example, if I have an insert trigger on Table A and that trigger runs, I want to know what code was executed that caused the trigger […] SQL Server 2019 - Development [How do I JOIN to a Linked Server in a VIEW without using a CTE]( - I need to create a VIEW that joins a table in the current database (SSMS2019 environment), to a table in a database on a different server (SSMS 2014 environment). The VIEW will be created in the 2019 environment server. To start, I created a Linked Server in my 2019 server called [REMOTE_SERVER_2014_ENV] which successfully connects […] SQL Azure - Development [What can we do about SSRS and SSIS in an Azure VM?]( - We have a third-party product which uses SQL Server 2016. It also uses both SSRS and SSIS. The network group wants to migrate the test version of this database into an Azure VM - basically a lift and shift approach. We asked the vendor of the application for their input as to the viability of […] SSRS 2016 [Drill down Action: one main report with two subreports]( - Hallo, i have to implement one main report with two sub reports. In the main report and the subreports the columns are closed. By a drill down action, the selected column in each of the three reports should open. How can I implement this drill down behaviour in all three reports? Thanks, duloran  General [When using Microsoft 365 tools, how do you backup your data?]( - Is there any easy way to automatically backup my data using the microsoft 365 tools, and it is possible to set schedules? and is there any option to retrieve my loss file?. Thanks by the way. Integration Services [How to keep For Loop Container continue on error?]( - Hi all, So I found a solution of a problem I was having with For Each Loop Container in my SSIS package. If error was received on any of the task inside container the package was failing instead of going to next iteration. The solution found here: is to create event handler on error and […] SQLServerCentral.com Website Issues [E-mail Notifications]( - I've noticed that I've received no alerts today. Are others experiencing this?   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -