Change the path of $list to the path of your text file with the domains. The domains need to be one per line in the text file. Change the?$exportPath to where you want to save the CSV file. Then copy and paste the code below into a .ps1 file and run from PowerShell. $list = […]
Read More →Category: Tech
Fix Certificate warning in Outlook for Mac
A secure connection cannot be established with the server <domain.com> because its intermediate or root certificate cannot be found. Do you want to continue? If you continue, the information that you view and send will be encrypted, but will not be secure. Microsoft has a suggestion for fixing this, issue a new certificate with the […]
Read More →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 →It’s Friday – Here is a pic of a SQL server with 1.5TB of RAM
If you’re a geek like me then this is pretty f’n cool. Kind of like being able to drive a really fast car. Another cool thing, there are three of these in production.
Read More →FTP access to Azure website with your publishingSettings file
Here is an easy way to gain FTP access to your Azure website. Download your publishing file from the website dashboard. Open FileZilla and from the dashboard paste the FTPS address into the address bar. (Always use FTPS when available). The location is on the right hand side. This is an image of mine, yours […]
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). First we import the webadmin module. Then list out the application pools on the server so you don’t need to open IIS or run appcmd list wps. Then it asks you for the name of the app pool which you can now copy and paste […]
Read More →Replace command prompt with Windows Powershell in Windows 10
I’m an early adopter, yay! Well, actually I have a 2 in 1 laptop so Windows 10 seemed to make sense and I decided to upgrade today after reading about it. It’s basically what Windows 8 should have been, although I like Win8 as well. Anywho, maybe this was availble in Win8 as well, but […]
Read More →How to remove all partitions from a disk
Here is an old one that I have been using for years and never thought to document here on my site. Btw, I use this blog a lot for my own documentation. Reason 1 to blog in IT. Want to get rid of everything on a drive? I mean everything, all partitions, data, EVERYTHING. So […]
Read More →Show classic ASP errors in Azure
Here is the web.config to show classic ASP (.asp files) in Azure, or in my case Windows Azure Pack with websites. I commented out detailed error messages. With that enabled it would not show the classic ASP errors.
Read More →