Azure Table Storage

Accessing Windows Azure Diagnostics Logs With LINQPad

Accessing Windows Azure Diagnostics Logs With LINQPad

If you are using Windows Azure Diagnostics with the DiagnosticMonitorTraceListener you will most likely have a table in your storage account called WADLogsTable with a ton of data in it. It can be a bit overwhelming. A colleague and I wanted to get two simple pieces of information: an event’s date and the corresponding message. Furthermore, we only wanted events that had happened today. Here’s what we came up with using LINQPad and the Azure Storage Driver.
LINQPad Driver for Azure Table Storage

LINQPad Driver for Azure Table Storage

I promise, this is the last you will see on this subject today (from my part, anyway). It’s for those who were not online yesterday and/or are in a different time zone and/or didn’t see my post from yesterday and/or don’t speak French. Azure Storage Explorer I’ve been working quite a bit with Windows Azure lately and particularly with Table Storage. I used to use SQL Server Mangement Studio to work with SQL Server and I found Azure Storage Explorer (screenshot on the left), which is actually pretty good for working with all three storage options: queues, tables and blobs.
Driver Azure Table Storage pour LINQPad

Driver Azure Table Storage pour LINQPad

Vous connaissez LINQPad ? Scott Hanselman le recommande systématiquement dans liste annuelle d’outils pour développeurs. En ce qui me concerne, je m’en sers pratiquement tous les jours—enfin, quand je développe. À la base, c’est un logiciel qui vous permet d’exécuter des requêtes Linq : Mais ça permet aussi d’exécuter des bouts de code arbitraires, juste pour voir ce que ça donne : La fonctionnalité que j’utilise le plus c’est définitivement celle-ci, mais ces derniers temps je travaille de plus en plus avec Windows Azure et notamment Table Storage.