.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Azure Function Logging
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
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.