The Luhn Algorithm

The Luhn Algorithm

Checksums can be very helpful for validating that data is intact and free from simple mistakes. They are extremely fast to calculate, and computing power has made them all but trivial over the past few decades. Because of this, checksums often hide in plain sight. One of these is the Luhn Checksum, which is produced by the Luhn Algorithm. The Luhn Algorithm was invented by Hans Peter Luhn, a scientist at IBM. It's patent was granted in 1960, but has since expired and it is now in the public domain. The best place where you can find its handiwork? Your…
Read More
Updating the PowerShell Kernel in Azure Data Studio

Updating the PowerShell Kernel in Azure Data Studio

In my previous post, I discussed an issue I encountered where comments caused strange issues in a PowerShell notebook in Azure Data Studio. I opened an issue in GitHub about this, and got some very prompt feedback from a member of the team. It turns out I did not have the latest version of the PowerShell Kernel running on my machine. The latest version is currently 0.1.3, and I had 0.1.2. Upgrading appears to have solved this issue for me - yay! This solution also raises the issue that there is no notification from Azure Data Studio that a PowerShell…
Read More
Strange PowerShell Notebook Behavior When Comments Are Involved

Strange PowerShell Notebook Behavior When Comments Are Involved

This is not the blog post I was intending to write. I started off writing about a different topic, and had some code that I wanted to share in a PowerShell Notebook. Getting that notebook to behave like it should have, however, is another story entirely and worthy of its own post - this one. PowerShell Notebooks are a great new feature in Azure Data Studio, first becoming available in the November 2019 release. Like SQL notebooks, PowerShell notebooks are based on Jupyter Notebooks format, which are interactive documents containing text and executable code blocks. Having some working PowerShell code…
Read More
Upload Directly to Azure Blob Storage Archive Tier with PowerShell

Upload Directly to Azure Blob Storage Archive Tier with PowerShell

Last year I wrote about how to upload data to Azure Blob Storage Archive Tier, and included a PowerShell script to do so. It's something I use regularly, as I have hundreds of gigabytes of photos and videos safely (and cheaply!) stored in Azure Blob Storage using Archive Tier. Things Just Got Easier! Microsoft recently announced some enhancements to Azure Archive storage, one of which is the ability to upload directly to the access tier of your choice. Previously, you could only upload objects to your account's default tier (hot or cool), and then had to change each object to…
Read More
Archiving Data with Azure Blob Storage Archive Tier and PowerShell

Archiving Data with Azure Blob Storage Archive Tier and PowerShell

As a former DBA, it should be no surprise that I am a big fan of keeping data safe, and not just corporate data - this extends to my personal data as well. Early on I realized that the cloud was a great way to protect all my photos, videos, and other digital keepsakes that I absolutely could not stand to lose. As cloud offerings matured, products specific to archival were introduced that allowed for long-term storage at very low price points. The tradeoff for this lower storage cost is that should you need to retrieve the data, it is…
Read More