If you have many databases (maybe hundreds or even thousands), you need efficient ways to manage them. Using CloudShell (in the Azure Portal) you can easily automate maintenance tasks. In this post I will show how to run SQL scripts on multiple databases.
Ola Hallengren's SQL Server Maintenance Solution is a free set of scripts for database integrity checks, and index and statistics maintenance. It is used worldwide and has been voted as Best Free Tool in the SQL Server Magazine Awards. It is designed for on-premises SQL Server databases, but this blog post will describe how you can use it also for Azure SQL Databases.
A few months ago, I purchased a HP zBook laptop. Unfortunately it crashed randomly about once a week. I finally found the reason was a memory leak in HP Hotkey service. This article describes how I found it and how I solved it.
In Azure Active Directory, you can manage devices as well as user and groups. You may have noticed that devices can show up under different join types: Azure AD joined and Azure AD registered. Also there is a third category, Hybrid Azure AD joined. In this article we will talk about the differences.
More and more services offer you to login using your existing Microsoft, Google, Twitter or Facebook account. This is helpful because it simplifies your password management, but you also need to be careful to avoid security risks.
At Microsoft Ignite 2021 in November, Microsoft announced their new serverless container platform, Azure Container Apps (ACA). ACA runs on top of a hidden Azure Kubernetes Service (AKS) to provide an easy way run containers in a Kubernets environment without the complexity of managing the Kubernetes infrastructure.
Do you have problems with your Azure Web App not updating after you publish (from Visual Studio or other tool)? I had these problems with my Azure Linux ASP.NET Core Apps, but they can happen with any type of Azure Web App (or even Azure Functions). I will explain how I solved these problems and why they occured.
Two important settings in Azure Web Apps that you should really care about are WEBSITE_DYNAMIC_CACHE and WEBSITE_LOCAL_CACHE_OPTION. Being careless with them can lead to either website updating problems or unnecessary performance degradation. I will explain why, and how you should handle them.
Most people (including me) run into this common problem the first time they try to deploy a Linux Web App: Web deployment task failed. Could not connect to the remote computer ("linuxtest1.scm.azurewebsites.net"). This is easily solved. I will show you how.
Have you ever needed to read data from a SOAP API (web service) in your Azure Data Factory pipelines? I have, and I will here show you the trick how to do this. Azure Data Factory (ADF) doesn't currently come with any built-in SOAP connector. Instead you need to do a workaround.