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

Cron Expression

https://en.wikipedia.org/wiki/Cron#CRON_expression Each line of a crontab file represents a job, and looks like this: Example Expression Schedule 0 0 1 1 * Run once a year at midnight of 1 January 0 0 1 * * Run once a month at midnight of the first day of the month 0 0 * * 0 Run... » read more

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

Azure Data Studio

Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux. Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. It’s engineered with the data platform user in mind, with built-in charting of query... » read more

Syncfusion Blazor SfUploader with Azure Storage

Windows Azure Storage SDK Need to download and install the Windows Azure Storage SDK first. Go to NuGet Package Manager and search for “WindowsAzure.Storage” Note: There is a new version of SDK “Azure.Storage.Blobs” but not all functions has been migrated over to the newer version. Example: Index.razor Note: The ID field must be “UploadFiles” to... » read more

Azure Blob Storage SDK

Get started with the Azure Blob Storage client library v12 for .NET. Azure Blob Storage is Microsoft’s object storage solution for the cloud. Follow steps to install the package and try out example code for basic tasks. Blob storage is optimized for storing massive amounts of unstructured data. Use the Azure Blob Storage client library... » read more

Azure App Service Custom Domain

Domain Registry Go to Subdomian setup of your domain name Subdomain Name Subdirectory / URL test.mydomain.com test.azurewebsites.net Go to DNS & Nameservers -> DNS Records Record Name Content CNAME test test.azurewebsites.net TXT test <azure id> Get <azure id> from within your Azure App Service properties. Azure App Service Go to Custom Domains in App Service... » read more

Sample App Service Plan Price

Plan ACU Memory Storage Cost B1 100 1.75 GB 10 GB $54.75/month B2 200 3.50 GB 10 GB $109.50/month Dev/Test Tier Included features Every app hosted on this App Service plan will have access to these features: Custom domains / SSL Configure and purchase custom domains with SNI SSL bindings Manual scale Up to 3... » read more

Sample Azure SQL Price

Plan DTUs ($1.50/DTU) Data Max Size Price Basic 5 2 GB $4.99/month Standard 10 250 GB $15.00/month Standard 20 250 GB $30.00/month Can adjust plan anytime. Service tiers in the DTU-based purchase model are differentiated by a range of compute sizes with a fixed amount of included storage, fixed retention period for backups, and fixed... » read more

Debug Azure Web App using Kudu

Using Kudu First, let’s launch Kudu. You can do this in a variety of ways. Here are a few: Launch Kudu manually from the address bar If your website is https://magicalunicorns.azurewebsites.net, the Kudu URL is https://magicalunicorns.scm.azurewebsites.net. Notice the appended “scm.” here. You’ll need to be signed in with an account with access to the App Service resource... » read more