Enable change tracking (CDC) on a MSSQL database when getting Msg 22830

Recently we received a request to enable change tracking on a database but kept getting an error even under a user with the SA role. Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 195 Could not update the metadata that indicates database DBNAME?is enabled for Change Data Capture. The failure occurred when executing the […]

Read More →

Azure website phpmyadmin site extension “No route registered for ‘/phpmyadmin/”

If you aren’t already aware there are some helpful tools for Azure websites found at https://YOUR-WEBSITE-NAME-HERE.scm.azurewebsites.net. For example if you website name in Azure websites is mikmeh than your scm URL would be?https://mikmeh.scm.azurewebsites.net. You’ll need to be logged in, or login to view the site. Lets assume you already know about this and you also […]

Read More →

Powershell script to collect a dump of a specific application pool

Procdump needs to be installed on the system. (procdump -i). [shell] Import-Module WebAdministration $apps = dir IIS:\AppPools\ | Select-Object -expand name Write-host "Application Pools on this server:" -foregroundcolor red -backgroundcolor yellow Write-Output $apps $appname = Read-Host "Enter AppPool Name" $apid = Get-WmiObject -NameSpace ‘root\WebAdministration’ -class ‘WorkerProcess’ -ComputerName ‘LocalHost’ | Where-Object {$_.AppPoolName -like "$appname"} | Select-Object […]

Read More →