Using Trigger to Log Row Insert and Delete
Log inserts and deletes of a table to a log table.
Azure Function Resources
https://docs.microsoft.com/en-us/azure/azure-functions/ https://docs.microsoft.com/en-us/samples/browse/?products=azure-functions&languages=csharp
Azure Function Data from HTTP Body
HTTP Body Code Result (HTTP POST) Hello, John Doe
Getting Started with Azure Function
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
TSQL Format Money
Sources:
SQL Server Email Alert with Table
Note: Need to enable email and setup mail profile first. Example 1 Example 2 uspConvertTableToHtml Stored Procedure Code that calls uspConvertTableToHtml Stored Procedure
SSIS Permissions
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
Display Line Number in SQL Server Management Studio (SSMS)
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.
AT TIME ZONE (Transact-SQL)
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
SSRS General Error
Error: An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors Fix: To determine the specific cause for this message, review the report server log files,... » read more