AWT Tech Notes

You know that feeling when your database is slow and you know indexes would help, but you have no idea where to start? Yeah, I’ve been there too many times. SQL Server actually keeps track of every time it wishes an index existed. It literally logs “man, I wish there was an index here” every… Read More »Find SQL Server Hidden Performance Gains with Indexing

Why? So, you want to know every single email address in a particular Office 365 tenant… How do you go about listing all of the users aliases, distribution lists, and other possible places to email? The following code will produce a CSV with all of the possible email addresses on the tenant, including DisplayName, RecipientType,… Read More »Listing All Email Addresses and Aliases in Office 365

Why? A client had a requirement for a Windows service to swap over its public IP to essentially change its outbound IP address at will, without impacting any existing connections or connectivity. This posed an interesting challenge, as essentially the idea would be to swap to the ‘next IP address’ in a list of already… Read More »Swapping Between Multiple Bound IPs with PowerShell

Cloning NSGs Recently, we were cloning a few virtual machines from test to production in Azure. One of the pain points while doing this with just NSGs (and without Network Manager) is cloning specific firewall rules to apply to your brand new NSG. PowerShell Performing this manually is a very annoying task. Through the magic… Read More »Cloning Azure Network Security Groups with PowerShell

What is an Anti-Feature? In the world of Managed Service Providers (MSPs), the term ‘anti-feature’ has emerged as a significant point of discussion. An anti-feature, simply put, is a feature in a software or service that doesn’t benefit the client but instead serves the interests of the provider or vendors. These features often lock users… Read More »Avoiding Anti-Features in IT Solutions