I always struggle to remember OR find the right page\bookmark for the 100s of Azure AD pages. Below you can find some of the more commonly used ones in an easy-to-use shortcut format. Alternatively, you can view the complete list and access it via browser plugins. Here is how it [...]
When trying to import a local SQL database to an Azure SQL Database using SQL Enterprise Manager you can see this error. This is a know issue on Enterprise manager and nothing wrong with your database or connection. To resolve you need to use a different tool to migrate your [...]
Azure VMs and connectivity brings some interesting challenges to the fore. I have a scenario where I created 4 new VMs (3 x app and 1 x sql). The App servers are bare bone so did not have any SQL client tools. I found the method below the easiest way [...]
Now in public preview, Long-Term Retention (LTR) allows you to enable your databases to create weekly backups stored in your own Azure Backup vault and extend the retention period built into SQL Database from 35 days to up to 10 years. This drastically improves the functionality in Azure to serve [...]
Will be adding some Azure content just to try and keep myself sane with all the new features and updates rolled by MS. Temporal Tables: Nice new feature that enables versioning and history out the box for SQL databases, so no need to build your own archiving etc. Hit the [...]
To force HTTPS on an Azure site that is configured to run HTTPS and HTTP add the following to your web.config file: <?xml version=”1.0″ encoding=”utf-8″?> <configuration> <system.webServer> <rewrite> <rules> <rule name=”Redirect to HTTPS” stopProcessing=”true”> <match url=”(.*)” /> <conditions> <add input=”{HTTPS}” pattern=”^OFF$” /> </conditions> <action type=”Redirect” url=”https://{HTTP_HOST}/{R:1}” redirectType=”Permanent” /> </rule> </rules> [...]
If you are on the right track and started moving to Azure 🙂 then sooner or later you will need to move some of your databases to Azure. One option would be to spin up a VM in Azure and manage your own SQL Instance, which in my opinion bypasses [...]
