Aaron Hoffman's Blog

Want your data to really pop ? Check out my latest project: Sizzle drag-and-drop interactive data visualization Sorting a Calculated field (or Value field) in Excel 2013 Pivot Tables may not be very clear.  Unlike the Row fields there is no option button in the column header allowing you to easily sort the column, but it is possible. In the example below, I have a Pivot Table with "ListItemAbv" as the Row and "Count of ListItemAbv" as a calculated field (there is also a filter on "RankOrder", but that is not relevant to the example) Notice that, by default, the Pivot Table is sorted by "ListItemAbv."  There is also an option button visible in the header column (A:3).  You can use that option button to easily sort the Pivot Table by "ListItemAbv." However, there is no option button available to sort the Pivot Table by the Calculated field "Count of ListItemAbv".  To sort by that calculated field, select

I recently purchased a Microsoft Arc Touch Mouse and wanted to turn off the middle button wheel scroll sound vibration. It is possible, however perhaps not obvious.  First you need to download the "Mouse and Keyboard Center" executable available on this page https://www.microsoft.com/accessories/en-us/products/mice/arc-touch-mouse/rvf-00052#techspecs-connect . (direct link Win10 x64: https://go.microsoft.com/fwlink/?linkid=849754  ) Run the executable and install the software.  After the software is installed, turn off "Vibration." See image below: Hope this helps, Aaron p.s.  Want to make that next report really pop ? Check out this new tool I'm working on : drag-and-drop interactive data visualization

---------------- The easy way: Azure Site Extension to Add/Edit Users and Roles:  http://aaron-hoffman.blogspot.com/2016/08/aspnet-mvc-5-user-admin.html https://www.nuget.org/packages/AspNetUserMaintenanceAzureSiteExtension/ (old:  https://www.siteextensions.net/packages/AspNetUserMaintenanceAzureSiteExtension/ ) ---------------- ---------------- TLDR: Search for this line in your project and update it: WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true); ---------------- There is a new Membership Provider in ASP.NET MVC 4 that can be used for Membership, Users, Passwords, Roles, Profile, Authentication and Authorization!  It is called the Simple Membership Provider .  It uses the WebMatrix WebData WebSecurity class as a facade. The Old Way You will no longer need to execute the old .NET 2.0 aspnet_regsql.exe like this: C:\Windows\Microsoft.NET\Framewor