CRUD Operations
CRUD = Create, Read, Update and Delete In computer programming, create, read, update, and delete (CRUD) are the four basic operations of persistent storage.
.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Azure Storage Queue
Azure Queue Storage is a service for storing large numbers of messages. You access messages from anywhere in the world via authenticated calls using HTTP or HTTPS. A queue message can be up to 64 KB in size. A queue may contain millions of messages, up to the total capacity limit of a storage account.... » read more
Azure Function Get Environment Variable using local.settings.json
To get an environment variable or an app setting value, use System.Environment.GetEnvironmentVariable, as shown in the following code example: local.settings.json Note: Microsoft recommends this method because it works both locally with local.settings.json and in Azure. App settings can be read from environment variables both when developing locally and when running in Azure. When developing locally,... » read more
Run Timer Triggered Azure Function Locally
Gets or sets a value indicating whether the function should be invoked immediately on startup. After the initial startup run, the function will be run on schedule thereafter. Sources: https://stackoverflow.com/questions/46556621/what-is-the-simplest-way-to-run-a-timer-triggered-azure-function-locally-once
Reference System.Data.SqlClient not found
Microsoft has removed System.Data.SqlClient from the default installation of Visual Studio (.NET Core). In order to use it, you must install from NuGet as install-package System.Data.SqlClient. Once installed, this reference is available for use and code will compile. Sources: https://social.msdn.microsoft.com/Forums/en-US/ec2361a3-1931-4423-bf68-08b206ce67aa/reference-systemdatasqlclient-not-found?forum=netfxbcl
Azure SQL: Recover Deleted Records
Via Azure Portal, restore a copy of the database from a backup at specific point in time. Via SSMS, copy over deleted records from recovered database back to the original database. Note: In Azure Portal, go to the original database and select “Retore”. Select a point in time before the accidental delete occurred. Time is... » read more
Always On Automatic Failover Jobs
In addition to the automatic failover that occurs for Always On setup, these jobs also needs to be created on both the Primary and the Secondary server to help with the automatic failover. In the event of a failover, all user jobs should be disabled on the Secondary server and enabled on the Primary server... » read more
Add New Job Category
2 Options to add new Job Category via Script via GUI Via Script Via SSMS In Management Studio, the same process is exposed via a dialog located under the SQL Server Agent Jobs node in the Object Explorer as shown below: Right-click the highlighted item and you are presented with the Manage Job Categories dialog... » read more
Azure Function Setup Environment Configuration
You can setup Configuration Variables to store database connection strings or keys at the application level. You can get retrieve that value to be used in any of your functions. Azure Function -> Settings -> Configuration -> New application setting MyKey01 = “xxxxxxxxxxxxxxx”