.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Database Partition and Performance
A partitioned table is one where the data is separated into smaller physical structures based on the value for a specific column (called the partitioning column, which is defined in the partition function). If you want to separate data by year, you might use a column called DateSold as the partitioning column, and all data... » read more
Restore Database From 2008 Backup to 2019
Restore a SQL Server 2008 R2 SP3 (10.50.6560) database to SQL Server 2019 (15.0.2000.5). Note: After restore, the database files are same size as original files.
Azure Function Blob Trigger
Convert to JSON object…
C# Object to XML
C# Object to XML
JSON to Object
JSON Object to C# Object
Error: input is not a valid Base-64 string
Error: Get the following error when trying to process a json object within Azure Function. System.Private.CoreLib: Exception while executing function: xxxxxxxx. Microsoft.Azure.WebJobs.Host: Exception binding parameter 'myQueueItem'. System.Private.CoreLib: The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters.... » read more
Azure Function Queue Trigger Retry
Azure functions with Storage Queue trigger has a built in retry logic based on the dequeue count of the message in the queue. You can configure the frequency of the retry in the bindings either through code or host.json. After the max number of retry, the message will be placed in the <queue-name>-poison queue. visibilityTimeout property... » read more
Queue Trigger Azure Function Example
Example 1: Display queue message. Example 2: Place queue item in Blob container. Sources: https://www.c-sharpcorner.com/article/blob-triggers-and-queue-storage-trigger-azure-functions/
Azure Storage Queue Examples
Install Install following from Nuget Package Manager Azure.StorageQueues Add following reference… Add Message To Queue Note: Call to queue is not supported in Blazor Web Assembly. You will get this error message if you try to create a message. System.Security.Cryptography.Algorithms is not supported on this platform. Sources: https://docs.microsoft.com/en-us/azure/storage/queues/storage-dotnet-how-to-use-queues?tabs=dotnet https://docs.microsoft.com/en-us/dotnet/api/overview/azure/storage.queues-readme-pre