Aaron Hoffman's Blog

AKA (for google-fu): asp.net mvc 5 web site administration tool asp.net mvc 5 web configuration tool asp.net mvc 5 identity asp.net mvc 5 membership I have missed the asp.net Web Site Administration Tool that used to be included with Visual Studio. I created an alternative for asp.net mvc 4 you can find here . For asp.net mvc 5, I created an  Azure Site Extension  to provide the same functionality. It can be run from VS on your local machine as well as installed as a site extension on Azure. Links: extension:  https://www.siteextensions.net/packages/AspNetUserMaintenanceAzureSiteExtension/ github repo:  https://github.com/Stonefinch/AspNetUserMaintenanceAzureSiteExtension Hope this helps, Aaron UPDATE These are now published to nuget.org  https://www.nuget.org/packages/AspNetUserMaintenanceAzureSiteExtension/

Often when working with a new data set I'll run these queries to learn more about each column of data. https://gist.github.com/aaronhoffman/eb30805ee2f5cafc64152dd1def800bd For example, you can run a single query to union together aggregate data on each numeric column. Result looks something like this: Hope this helps, Aaron

If you want to ensure you get line numbers in your Exception Stack Trace, you need to make sure your project is set up to provide "full" debug info on build. By default, for "Release" configuration, this is set to "pdb-only". Steps to enable: In Visual Studio... 1. Ensure your project is set to "Release" Solution Configuration (or whichever config you use for deployments) 2. Go to Project > Properties > Build 3. Click the Advanced Button in the bottom right. 4. Under Output > "Debug Info", choose "full" from the dropdown. 5. Save all settings and build your project. You will now see line numbers in Exception Stack Traces. Hope this helps, Aaron

We've been working with Azure WebJobs recently (more info: here and here ) and even though the built in logging to Azure Storage is great, it is difficult to query at times. In more recent version of the WebJobs SDK, the team exposed a TraceWriter collection via the JobHost configuration that allows consumers to write logs to a custom repository. The snippet linked below is a naive implementation of using that collection to write the logs to SQL Server. Feel free to adapt it to fit your needs (i.e. performance concerns, async, batching, etc.) Write Azure WebJob Logs to SQL: https://gist.github.com/aaronhoffman/3e319cf519eb8bf76c8f3e4fa6f1b4ae Hope this helps, Aaron

My google-fu wasn't the best when searching for a way to convert WGS84 to Web Mercator EPSG:3857, which is the common Google Maps and Bing Maps projection. If you have arrived here in search of an answer, the links to explain everything are below. Essential Background https://alastaira.wordpress.com/2011/01/23/the-google-maps-bing-maps-spherical-mercator-projection/ Take the EPSG WKT from article 1, and use it in the proj.net library http://blogs.u2u.be/diederik/post/2010/01/01/Converting-Spatial-Coordinates-with-ProjNET.aspx The definitive MSDN article https://msdn.microsoft.com/en-us/library/bb259689.aspx Code from MSDN article that doesn't use the proj.net Library https://gist.github.com/aaronhoffman/f53e1852ca289e4a806c062f97a18f05 Live Demo (in JavaScript): https://jsfiddle.net/aaronhoffman/L1kpdmgz/ And this next section is just to help others search and get here: Convert WGS84 to Web Mercator Convert WGS84 to Google Maps Convert WGS84 to Bing M...