Category: Microsoft

Microphone not working, privacy setting off, “managed by your organization”

Windows don’t let to turn a microphone on because of “some settings are hidden or managed by your organization” . A PC is a  personal PC on home network. There are a few reasons for this:

Continue reading

PowerShell List Memory Usage by IIS Application Pools

If you need quick overview on RAM usage of you IIS application pools you can use the following Powershell command to retrieve the information:

Continue reading

SQL Reporting Services. HTTP Error 503 The service is unavailable

After I installed new certificate using SQL RS Configuration Manager upon opening any report I see the following: In comparison to this case the root cause is the same: when binding a certificate Configuration Manager creates shitty URL bindings like

Continue reading

MS SQL security audit: list all users and their permissions

When you need to find out your DB users and their permissions on DB objects use the following query to list all MS SQL users and their permissions on databases and views and get a report:

Continue reading

Difference between BACPAC and DACPAC

A data-tier application (DAC) is a self-contained unit of MS SQL Server database deployment that allows packing SQL Server objects into a portable artifact called a DAC package. It is also known as a DACPAC. BACPAC is simple to export a SQL Server database which will eventually require import to another server or even for …

Continue reading

IIS export import configuration

IIS

When using multiple IIS server in a Load Balanced Environment it will  be alot of work to create all your website twice with the same settings on each webserver. Therefor it is possible to export and import your configuration from one IIS webserver to the other. When you create a website in IIS a unique …

Continue reading

How to find unattached Public IPs in Azure

Finding the Unassociated IP Addresses Open the Azure Portal. Perform a search for Public IP addresses. Click on the +Add filter option. From the drop-down for Operator, select “==”. Select “–” for Value. Click Apply. After you complete these steps, you’ll have a list of unattached Azure public IP addresses. The next phase of the operation involves selecting and deleting the addresses …

Continue reading

How to resolve merge conflicts in Azure DevOps

There is a simple and effective extension that allows resolving Pull Requests merge conflicts directly in Azure DevOps: Pull Request Merge Conflict Extension

Continue reading

Auto-renew Letsencrypt certificates in Azure Automation Account with managed identity

system-managed-identity

Recently my Job for renewing Letsencrypt certificates in KeyVault has stopped working. Upon closer look I found that my Run As account certificate expired: I navigated to certificate’s properties to renew it as described in Microsoft documentation and thouhgt I have 1 minute work to fix that but no! There is no option to renew …

Continue reading

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database

SQLRS-error-occured-within-the-report-server-database

I had this issue due to having the Reporting Services databases in an Availability Group. When we failed over (for the first time) there were a bunch of permissions not correctly set, specifically the RSExecRole was not there. The reports worked, but not the subscriptions and we couldn’t edit any of the report settings. Upon …

Continue reading

Load more