If you’re a .NET developer, we’re excited to introduce a new resource that can help you learn about Azure: The Azure Quick Start Guide for .NET Developers!
(Export the db from the Azure Portal first). And the SQL Server Management studio 17.
Initially imported into SQL Express 2014 but got some warnings/errors regarding the import, so SQL 2016 works better.
1. Access to a bacpac file locally / on azure storage
2. Use the UI wizard in Management Studio. (See below)
- Connect to the instance of SQL Server, whether on-premise or in SQL Database.
- In Object Explorer, right-click on Databases, and then select the Import Data-tier Application menu item to launch the wizard.
- Complete the wizard dialogs: Introduction Page. Import Settings Page.
System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.
Solved the error by setting TrustServerCertificate=false in the connectionstring.
Login to azure portal
Goto your web app
Select the tab “Deployment credentials” and set username and password to be used for FTP access. (remember to save).
Goto the “Overview” tab (the top tab)
In the right column you find:
When using deployment slots in Azure Web Apps the appsettings and connectionsstrings are changed when swapping slots.
E.g. the production environment slot has the “production” version of appsettings and connectionstrings and the pre production slot has its own version of those settings in the web.config file.
This is default behaviour, unless you use the app settings in the Azure portal for the environments (overrides web.config file) or check the “Slot setting”. (setting will “stick” with the swap).
Read more here:
Configure web sites:
If you are using azure deployment profiles for Visual Studio you can find the deployment password here:
Login to portal, select the web app service, click the link “Get publish profile” to download. Open the xml file and find the password in element publishProfile attribute userPWD.
I had a problem with a web app service on Azure, the session state was not functioning properly.
2 instances where running for the website and the Session affinity cookie was set to Off, that was the problem, ARR makes sure that the user stays on the correct webserver for the duration of the session.
I had to turn it ON, see link below for where to find it.
Azure DevTest Labs is a way to easily spin up VMs being used as developer and test machines.
Here are a Microsoft ready made json template to spin up an Azure Selenium Grid (x number of Selenium node servers) allowing automated UI testing for web sites.
Azure BLOB storage is persistent Cloud data storage that serves a variety of purposes. Mike Wood shows the basics of how to use it, from start through to snapshots and metadata; both from .NET, and by using the free tool, Cerebrata Azure Explorer.
Setting up and using Azure Table Storage in a simple way:
For this next article in the series, were going to be looking at Microsoft’ Azure’s Table Storage service.