An instance of ILogger is passed as an argument to the function invocation. You can use extension methods from Microsoft.Extensions.Logging to log events using the log instance. run.csx Sources: https://www.serverlessnotes.com/docs/logging-with-ilogger-in-azure-functions
Log inserts and deletes of a table to a log table.
https://docs.microsoft.com/en-us/azure/azure-functions/ https://docs.microsoft.com/en-us/samples/browse/?products=azure-functions&languages=csharp
HTTP Body Code Result (HTTP POST) Hello, John Doe
Example 1: run.csx Hello, mike. This HTTP triggered function executed successfully. The URL parameter “code” is the function key that needs to be passed in order to run the function. Multiple trigger options, http or timer or a list of other methods. Each function have its own code and can be enabled/disabled. Example 2: Hello,... » read more
Sources:
Note: Need to enable email and setup mail profile first. Example 1 Example 2 uspConvertTableToHtml Stored Procedure Code that calls uspConvertTableToHtml Stored Procedure
SQL Server Integration Services provides certain fixed database-level roles to help secure access to packages that are stored in SQL Server. The available roles are different depending on whether you’re saving packages in the SSIS Catalog database (SSISDB) or in the msdb database. Roles in the SSIS Catalog database (SSISDB) The SSIS Catalog database (SSISDB)... » read more
SQL Server – Displaying line numbers in Query Editor – SSMS Step1: Go to Tools > Options. Step2: In the Options dialog box navigate to Text Editor > Transact-SQL > General. Step 3: Check “Line Numbers” and click on “OK” Now, when a query window is opened Line Numbers will be displayed.
Converts an inputdate to the corresponding datetimeoffset value in the target time zone. When inputdate is provided without offset information, the function applies the offset of the time zone assuming that inputdate is in the target time zone. If inputdate is provided as a datetimeoffset value, then AT TIME ZONE clause converts it into the target time zone using the time zone conversion rules. AT TIME ZONE implementation relies on... » read more