I've recently been engaged on several customer projects where file uploads to an Azure Storage account have to be scanned for malicious content. Usually, this functionality is needed to ingest data safely into an Azure-hosted research environment. In this post, I am describing a solution I designed to scan the uploads for malware using the … Continue reading On-Demand Malware Scanning for Azure Storage Blobs with VirusTotal
Update 2021-01-13 9:15 AM CST: Added additional resources at the end of the article Update 2021-03-23 2:31 PM CDT: Added additional firewall configuration for port 514 and additional SELinux configuration. Azure Sentinel is Microsoft's cloud-native SIEM/SOAR. While being cloud-native means that there is little to no configuration required to ingest a variety of log sources, … Continue reading End-to-End Configuring a RHEL 8 Common Event Format Forwarder for Sentinel
I thought about making the title of this blog post "Creating a uni-directional Azure Virtual Network Peering," but it would have been a bit too click-baity. Still, conceptually, what I am describing in this post is along those lines. Virtual Network Peering and the VirtualNetwork Service Tag When two Virtual Networks (VNets) are peered, the … Continue reading Defaulting Azure Virtual Network Peering from Allowing to Denying Traffic
TL;DR: No. I've been working with numerous customers on Windows Virtual Desktop (WVD) deployments since I started my position at Microsoft. During the process of manually* creating an image, it's common to take snapshots. I especially recommend taking snapshots before sysprepping the image. Once you sysprep an Azure VM, the VM itself is unusable; it … Continue reading Does Deleting an Azure Managed Disk Also Delete Snapshots?
My peers and I work with customers one-on-one, but we also provide "shared" resources. I thought it'd be helpful to share what these resources are. If you're an education IT pro and work with Azure, I am sure you'll find something on this list that will help you do your job more effectively.
End-to-end (E2E) encrypted communication is valuable and necessary. Many tools provide this. Recently, I’ve started using Keybase, not only because of its ability to provide E2E encrypted messaging but also because of its additional feature set. One key feature is the ability to link your identity on Keybase to your identity on other sites, including … Continue reading Importing a key or key pair in Keybase on Windows
In two days, October 31, 2019 at noon US Central time / 17:00 UTC, I will be presenting my talk "What's New in Azure SQL Database" for the PASS Cloud Virtual Group. If you'd like to attend, you can register at https://cloud.pass.org/MeetingDetails.aspx?EventID=14249. You'll need your PASS username and password. If you're not currently using Azure … Continue reading Presenting “What’s New in Azure SQL Database” Webinar for the PASS Cloud Virtual Group
Today, seemingly out of the blue, I was unable to connect to my MSSQLLocalDB instance of SQL Server Local DB. The error message I received indicated something went wrong during the login, purportedly with a trigger. Here's how I did some troubleshooting, research, and finally figured out a non-destructive way to get back in my … Continue reading Unable to Log In to SQL Server Local DB Due to Missing MDF File
I am writing this quick blog post because of a neat feature in Azure Data Studio that is currently undocumented in the official documentation: split terminal. Azure Data Studio, like VS Code which it's based on, supports an integrated terminal. You have a choice between PowerShell, cmd, or git bash. You can have multiple terminal … Continue reading Azure Data Studio: Split Terminal
This Saturday, the Atlanta SQL user group is organizing its annual SQL Saturday. After a hiatus last year, I will be presenting a brand new talk, titled The New Tool in Your Kit: Azure Data Studio.